±Û¾´ÀÌ :°Á¤È 2000³â 5¿ù 08ÀÏ 21:01:07
µ¥½Ã¸Ö Æ÷¸äÀ» ÀÌ¿ëÇؼ ±Ý¾×Çü½ÄÀ¸·Î Ãâ·ÂÇÏ°íÀÚ Çϴµ¥....
¾Æ·¡¿¡ ÁÖ¼®ºÎºÐó·³ Çߴµ¥ ¿¡·¯°¡ ÀÚ²Ù³ª³×¿ä....
±×·¸´Ù°í ¿¡·¯¸Þ¼¼Áö·Î´Â °¨À̾ʿÀ°í
ºÎŹµå¸³´Ï´Ù.
<%@ language="java" import="java.sql.*,java.io.*, mc.URLEncoder,java.text.DecimalFormat, com.ibm.servlet.connmgr.*;" %>
<%
char mark = '\u0022';
String sasq = " " + request.getParameter("SASQ");
sasq=sasq.trim();
String query;
String saam = "";
String dung = "";
String gong = "";
String chei = "";
String mknm = "";
String mdnm = "";
String mdnd = "";
int bunho = 3960;
int anjun = 19200;
int jungji = 2000;
double total = 0;
double Ichei = 0;
double Idung = 0;
double Igong = 0;
int Ichei1 = 0;
int Idung1 = 0;
int Igong1 = 0;
int total1 = 0;
IBMConnMgr connMgr = null;
IBMConnSpec spec = null; // the spec
String DbName = "PID400M"; // database name
String Db = "db2"; // JDBC subprotocol for DB2
String poolName = "JdbcDb2"; // from Webmaster
String jdbcDriver = "com.ibm.db2.jdbc.app.DB2Driver";
String url = "jdbc:"+Db+"://"+DbName;
String user = "AUTO"; // user and password could
String password = "AUTO"; // come from HTML form
String owner = null; // table owner
String CONFIG_BUNDLE_NAME = "login";
// ****************************************************************
// * Initialize servlet when it is first loaded *
try
{
spec = new IBMJdbcConnSpec
(poolName, // pool name from Webmaster
true, // waitRetry
jdbcDriver, // Remaining four
url, // parameters are
user, // specific for a
password); // JDBC connection.
connMgr = IBMConnMgrUtil.getIBMConnMgr();
}
catch(Exception e)
{
System.out.println("set connection spec, get connection manager: " +
e.getMessage());
}
IBMJdbcConn cmConn = null;
Connection dataConn = null;
try
{
cmConn = (IBMJdbcConn)connMgr.getIBMConnection(spec);
dataConn = cmConn.getJdbcConnection();
Statement stmt = dataConn.createStatement();
query = new String("SELECT * FROM MCATDTA.SINCAR WHERE SISASQ = "+sasq+" ");
ResultSet rs = stmt.executeQuery(query);
while(rs.next())
{
mknm = " "+ rs.getString("SIMKNM");
mdnm = " "+ rs.getString("SIMDNM");
mdnd = " "+ rs.getString("SIMDND");
saam = " "+ rs.getString("SISAAM");
dung = rs.getString("SIDUNG");
chei = rs.getString("SICHEI");
gong = " "+ rs.getString("SIGONG");
}
mknm = mknm.trim();
mdnm = mdnm.trim();
mdnd = mdnd.trim();
saam = saam.trim();
gong = gong.trim();
if(chei.length() != 0)
{
if(chei.equals("2")) Ichei = Integer.parseInt(saam)*0.018182;
if(chei.equals("0")) Ichei = Integer.parseInt(saam)*0;
}
if(dung.length() != 0)
{
if(dung.equals("2")) Idung = Integer.parseInt(saam)*0.018182;
else if(dung.equals("3")) Idung = Integer.parseInt(saam)*0.0272728;
else if(dung.equals("5")) Idung = Integer.parseInt(saam)*0.045455;
else Idung = Integer.parseInt(saam)*0;
}
if(gong.length() != 0)
{
if(gong.equals("4")) Igong = (Integer.parseInt(saam)*0.0375)*0.3;
else if(gong.equals("9")) Igong = (Integer.parseInt(saam)*0.08082)*0.3;
else if(gong.equals("12")) Igong = (Integer.parseInt(saam)*0.1085)*0.3;
else if(gong.equals("20")) Igong = (Integer.parseInt(saam)*0.1811)*0.3;
else if(gong.equals("5")) Igong = (Integer.parseInt(saam)*0.045455)*0.3;
else if(gong.equals("195")) Igong = 195000;
else if(gong.equals("390")) Igong = 390000;
else if(gong.equals("650")) Igong = 650000;
else if(gong.equals("1300")) Igong = 1300000;
else if(gong.equals("100")) Igong = 100000;
else Igong = Integer.parseInt(saam)*0;
}
Ichei1=(int) Ichei;
Idung1=(int) Idung;
Igong1=(int) Igong;
//========================================================
//
// DecimalFormat form = new DecimalFormat("#,###,###");
//
//String Dchei;
//String Dchei = form.format(Ichei1);
//
//
//À̺κп¡¼Dchei º¯¼ö°¡ Á¤ÀÇ µÇÁö ¾Ê¾Ò´Ù´Â ¸Þ¼¼Áö°¡ ¶â´Ï´Ù.
//==========================================================
total = Idung1+Ichei1+Igong1+jungji+anjun+bunho;
total1 = (int) total;
rs.close();
stmt.close();
}
catch(Exception e)
{
out.println("get connection, process statement: "+e.getMessage());
}
finally
{
if(cmConn != null)
{
try
{
cmConn.releaseIBMConnection();
}
catch(IBMConnMgrException e)
{
out.println("release connection: " + e.getMessage());
}
}
}
%>
<body >
<html>
<head>
<title>¸ðÅÍŬ·´ Â÷·®µî·Ïºñ¿ë(½ÅÂ÷)</title>
</head>
<body>
<table width="400">
<tr>
<td align="center" height=30 bgcolor="#9e001a">
<font color="white"><%=mknm %> <%=mdnm %> <%=mdnd %> </font>
</td>
</tr>
</table>
<br>
<table border="2" cellpadding="2" cellspacing="2" border cellspacing="2" width="400" bgcolor="#E1E8EA"
bordercolor="black">
<tr height="25">
<td width="100" nowrap bgcolor="#CC6666"><font color="white">Â÷·®°¡°Ý</font></td>
<td align="right" width="270" bgcolor="#FDFFFF"> <%=saam %> ¿ø </td>
</tr>
<tr height="18">
<td width="100" nowrap bgcolor="#CC6666"><font color="white">Ãëµæ¼¼</font></td>
<td align="right" width="270" bgcolor="#FDFFFF"> <%=Dchei %> ¿ø </td>
</tr>
<tr height="18">
<td width="100" nowrap bgcolor="#CC6666"><font color="white">µî·Ï¼¼</font></td>
<td align="right" width="270" bgcolor="#FDFFFF"><%= Idung1%> ¿ø </td>
</tr>
<tr height="18">
<td width="100" nowrap bgcolor="#CC6666"><font color="white">°øä</font></td>
<td align="right" width="270" bgcolor="#FDFFFF">(30% ÇÒÀÎÀ²) <%=Igong1 %> ¿ø </td>
</tr>
<tr height="18">
<td width="100" nowrap bgcolor="#CC6666"><font color="white">¾ÈÀüÇùȸºñ</font></td>
<td align="right" width="270" bgcolor="#FDFFFF"><%= anjun %> ¿ø </td>
</tr>
<tr height="18">
<td width="100" nowrap bgcolor="#CC6666"><font color="white">¼öÀÔÁõÁö</font></td>
<td align="right" width="270" bgcolor="#FDFFFF"><%= jungji %> ¿ø </td>
</tr>
<tr height="18">
<td width="100" nowrap bgcolor="#CC6666"><font color="white">¹øÈ£ÆÇ</font></td>
<td align="right" width="270" bgcolor="#FDFFFF"><%=bunho %> ¿ø </td>
</tr>
<tr height="25" bgcolor="#dee7f7">
<td width="100" nowrap bgcolor="#CC6666"><font color="white">µî·Ïºñ¿ë</td>
<td align="right" width="270" bgcolor="#FDFFFF"><%= total1 %> ¿ø </td>
</tr>
</table>
<br>
<table width="400">
<tr><td><font color="darkred">* µî·Ï¼¼´Â µî·Ï½Ã ½Å°í³³ºÎ, Ãëµæ¼¼´Â ÃëµæÀÏ·Î ºÎÅÍ 30ÀÏ À̳» ³³ºÎ</font></td></tr>
<tr><td><font color="darkred">* »ó±â ºñ¿ë»êÃâÀº ºñ»ç¾÷¿ë±âÁØÀÔ´Ï´Ù.</font></td></tr>
<tr><td><font color="darkred">* Ãëµæ¼¼, µî·Ï¼¼ ¸éÁ¦´ë»ó: ±¹°¡À¯°øÀÚ¿Í Àå¾ÖÀÎ1~3±Þ</font></td></tr>
<tr><td><font color="darkred">* µî·Ïºñ¿ë »êÃâ½Ã Â÷·®°¡°ÝÀº Ź¼Û·á, ¸ÞÀÌÄ¿ DC±Ý¾× ¹ÌÀû¿ë ±Ý¾×À¸</font></td></tr>
<tr><td><font color="darkred"> ·Î Àû¿ë½Ã Â÷ÀÌ°¡ ³¯ ¼ö ÀÖ½À´Ï´Ù.</font></td></tr>
<tr><td><font color="darkred">*°øäÇÒÀηü¿¡ µû¶ó »êÃâ°¡°ÝÀÌ Â÷ÀÌ ³¯ ¼ö ÀÖ½À´Ï´Ù.</font></td></tr>
<tr><td><font color="darkred">*º¸Á¶ ¹øÈ£ÆǺñ º°µµ(3000~10,000¿ø)</font></td></tr>
</table>
</body></html>