글쓴이 :강정화 2000년 3월 31일 16:56:49
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=euc-kr">
<title>Untitled Document</title>
<style type="text/css">
</style>
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red" topmargin="10"
leftmargin="15">
<p><a name="top"><img src="atoz/atozlogo.gif" width="120" height="23" border="0">
</a>
<table border="0" cellpadding="3" width="630">
<tr>
<td width="200" align="center" valign="top"><table border cellpadding="3"
cellspacing="0" width="100%" bordercolordark="white" bordercolorlight="#666666">
<tr>
<td height="25" align="center" colspan="2" bgcolor="#000099"><p><font
color="white">소 개</font></td>
</tr>
<tr>
<td></td>
</tr>
</table>
<p><br> <img src="atoz/atozmaineuropa.gif" width="201" height="121"
border="0"> <br> <br> <a href="#1">외관</a> | <a href="#2">내관</a>
| <a href="#3">성능</a> | <a href="#4">안전장치</a></td>
<td valign="top"><table border cellpadding="0" cellspacing="0" bordercolor="gray"
bordercolordark="white">
<%@ language="java" import="java.sql.*,java.io.*, java.util.Date" %>
<%
Connection con = null;
// String mdnd = request.getParameter(" MAMDND");
String pageS = request.getParameter("PAGE");
String mdno = request.getParameter("MDNO");
String check = request.getParameter("CHECK");
String sasq = request.getParameter("SASQ");
String pic1 ="";
check = check.trim();
int pagecount = 0;
int querycount = 0;
int totalpage = 0;
int totalcount = 0;
Vector sasqList = new Vector();
Vector mdndList = new Vector();
Vector mcprList = new Vector();
Vector saamList = new Vector();
Vector cybeList = new Vector();
if (pageS == null ) pagecount = 1;
else pagecount = Integer.parseInt(pageS);
String query = "";
char mark = '\u0022';
try
{
if (con != null)
{
try { con.close(); } catch (Exception e) {}
}
java.sql.DriverManager.registerDriver (new com.ibm.db2.jdbc.app.DB2Driver ());
con = java.sql.DriverManager.getConnection("jdbc:db2://" +"PID400M" + ";naming=sql;errors=full;date format=iso","AUTO", "AUTO");
} catch(Exception e){
System.out.println("Error : "+e.getMessage());
}
try
{
Statement stmt = con.createStatement();
query = new String("SELECT SIPIC1 FROM MCATDTA.SINCAR WHERE SISASQ = "+sasq+" ");
ResultSet rs = stmt.executeQuery(query);
while(rs.next())
{
pic1 = rs.getString(1);
}
query = new String("SELECT SISASQ, SIMDND, SISAAM, SIMCPR, SICYBE FROM MCATDTA.SINCAR WHERE SISASQ = '"+sasq+"' ORDER BY SISASQ ASC ");
//out.println(query +"<br>");
rs = stmt.executeQuery(query);
while(rs.next())
{
sasqList.addElement(rs.getString(1));
mdndList.addElement(rs.getString(2));
saamList.addElement(rs.getString(3));
mcprList.addElement(rs.getString(4));
cybeList.addElement(rs.getString(5));
}
querycount = sasqList.size();
totalpage = querycount / 15 + 1;
if(pagecount <= 0) pagecount = 1;
else if(pagecount > totalpage) pagecount = totalpage;
if(querycount == 15 ) totalpage = 1;
rs.close();
stmt.close();
}
catch(SQLException ex)
{
out.println("<hr>*** SQLException caught ***<p>");
while(ex != null)
{
out.println("SQLState : " + ex.getSQLState() + "<br>");
out.println("Message : " + ex.getMessage() + "<br>");
out.println("Vendor : " + ex.getErrorCode() + "<br>");
ex = ex.getNextException();
}
}
%>
<table border="0" cellspacing="1" width="100%">
//--아래의 saamlost.elementAt(i)와 나머지것들이 금액이어서 서브스트링을 이용하여 콤마를 넣고싶은데 방법을 모르겠습니다.
<tr>
<td width="180" height="25" align="center" bgcolor="#000099"><p><font
color="white">세부차종</font></td>
<td width="82" align="center" bgcolor="#000099"><p><font
color="white">차량가격</font></td>
<td width="75" align="center" bgcolor="#000099"><p><font
color="white">할인가격</font></td>
<td width="70" align="center" bgcolor="#000099"><p><font
color="white">사이버머니</font></td></tr>
<%
int j = 0;
if (querycount < 15)
j = 0;
else
j = (pagecount-1)*15;
int count = 1;
if( totalpage <= 1)
count = querycount;
else
if(pagecount*15 > querycount)
count = querycount;
else
count = pagecount*15;
for(int i = j; i < count; i++) {
%>
//--아래의 saamlost.elementAt(i)와 나머지것들이 금액이어서 서브스트링을 이용하여 콤마를 넣고싶은데 방법을 모르겠습니다.
<tr>
<td width="200" height="20" align="left" bgcolor="#E7E7E7"><p><font face="Arial"
size="2" color="black"><a href="newcar3.jsp?SASQ=<%= sasqList.elementAt(i) %>">
<%= mdndList.elementAt(i) %></a></font></td>
<td height="20" align="right" bgcolor="#FDFFFF"><p><font
face="Arial" size="2"><%= saamList.elementAt(i) %> </font></td>
<td height="20" align="right" bgcolor="#FFEBE1"><p><font face="Arial"
size="2" color="black"><%= mcprList.elementAt(i) %></font></td>
<td height="20" align="right" bgcolor="#FFECEC"><p><font face="Arial"
size="2" color="black"><%= cybeList.elementAt(i) %></font></td>
</tr>
<% } %>
</table> </td>
</tr>
</table>
</body>
</html>