¾Æ·¡ ÂüÁ¶ÇÒ ¼Ò½ºÀÔ´Ï´Ù.


[ ´ÙÀ½ ±Ûµé ] [ À̾ ±Û¿Ã¸®±â(´äÇϱâ) ] [ ÀÚ¹Ù ¹¯°í ´äÇϱâ ]

±Û¾´ÀÌ :À¯±æ¼º 2000³â 5¿ù 24ÀÏ 11:41:12

import java.io.*;
import java.lang.*;
import java.util.*;
import java.text.DateFormat;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;


public class ListCategory extends HttpServlet
{


public void doGet (HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException {
Connection conn = null;
ResultSet rs = null;
String sqlstmt = null;
String inRef=null,inName=null,inName1=null,tStr=null;
String tImsi=null;
int i = 1, ifmt = 1;
response.setContentType("text/html; charset=euc-kr");
PrintWriter out = new PrintWriter(new
OutputStreamWriter(response.getOutputStream(), "KSC5601"));


inName = request.getParameter("name");
inName1 = new String(inName.getBytes("8859_1") ,"KSC5601");


inRef = request.getParameter("key"); //inRef °´Ã¼»ý¼º
/* HTML Head Á¤º¸¸¦ Ãâ·ÂÇÔ */
out.println("<HTML>");
out.println("<HEAD>");
out.println("<title>Ä«Å×°í¸® °Ë»ö</title>");
out.println("<META content=\"text/html; charset=euc-kr\"
http-equiv=Content-Type><LINK href=\"http://www.bizclick.net:8071/biz1.css\"
rel=styleSheet type=text/css>");
out.println("<META content=\"MSHTML 5.00.2314.1000\"
name=GENERATOR>");
out.println("</HEAD>");
out.println("<BODY>");
out.println("<IMG SRC=\"/LEFT/menu_02a.gif\"><BR>");
out.println(" <TABLE border=\"0\" width=\"520\">");
out.println(" <TR> ");
out.println(" <TD> ");
out.println(" <TABLE border=\"0\" width=\"100%\">");
out.println(" <TR>");
out.println(" <TD height=15></TD>");
out.println(" </TR>");
out.println(" <TR align=\"center\"> ");
out.println(" <TD> ");
out.println(" <FORM method=GET
action=\"/servlet/aSrch\">");
/* http://172.20.241.114:8089/servlet/aSrch?where= &query= °ªÀ» ³Ö¾îã´Â´Ù.*/
out.println(" <TABLE border=0>");
out.println(" <TR>");
out.println(" <TD>");
out.println(" <select name=\"where\">");
out.println(" <option value=\"1\">ȸ»ç¸í
");
out.println(" <option value=\"2\">Á¦Ç°¸í
"); //ȸ»ç¸í,Á¦Ç°¸íÁß ¼±ÅÃ
out.println(" </select>");
out.println(" </TD>");
out.println(" <TD> ");
out.println(" <input type=\"text\"
name=\"query\" size=\"20\">");
out.println(" </TD>");
out.println(" <TD> ");
out.println(" <input type=\"submit\"
value=\"°Ë»ö\">");
out.println(" </TD>");
out.println(" </TR>");
out.println(" </TABLE>");
out.println(" </FORM>");
out.println(" </TD>");
out.println(" </TR> ");
out.println(" <TR align=LEFT>");
out.println(" <TD colspan=3 height=\"22\">");
out.println("<HR width=\"510\" size=\"1\">");
// out.println("<b>"+inName1+">></b><br>");
// /WEBMAIN/MARKET/apache_DSO/servlets ÆÄÀÏÀ§Ä¡
out.println("<a href=\"/servlet/ListAllProd\"><b>Àüü Á¦°ø»óÇ°</a>
>>"+inName1+"</b><br>");

out.println("<HR width=\"510\" size=\"1\">");
out.println(" </TD>");
out.println(" </TR>");
out.println(" </TABLE>");
//out.println(" ");
out.println(" </TD>");
out.println(" </TR>");
out.println("</TABLE>");
out.println("<table border=\"0\" cellspacing=4 cellpadding=8>");
/*catalogref */
sqlstmt =
"SELECT RTRIM(crefitem), RTRIM(category) "+
"FROM ECPRODUCTS.CATEGORIES "+
"WHERE catalogref="+inRef+" "+
"ORDER BY category";


try {
Class.forName ("oracle.jdbc.driver.OracleDriver");
// DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
conn =
DriverManager.getConnection
("jdbc:oracle:thin:@172.20.241.113:1521:MARKET", "system","manager");

Statement stmt = conn.createStatement ();
ResultSet rset = stmt.executeQuery (sqlstmt);
while (rset.next ()){
if (i == 1) {
ifmt = 4;
}
else ifmt = 1;
out.println("<tr>");
out.println("<td width=\""+ifmt+"\"></td>");
//tStr = inName1 + " >>"+rset.getString(2);
tStr = inName1 + "X" + inRef;
tImsi = rset.getString(2);
out.println("<td valign=\"top\"><a
href=\"/servlet/ListProduct?key="+rset.getString(1)+"&name1="+tStr+"&name2="+tImsi+"\"
>");
//out.println("<td valign=\"top\"><a
href=\"/servlet/ListProduct?key="+rset.getString(1)+"&name="+tStr+"\">");
out.println("<b>"+rset.getString(2)+"</b></a></td>");
if(rset.next()) {
tStr = inName1 + "X" + inRef;
tImsi = rset.getString(2);
out.println("<td valign=\"top\"><a
href=\"/servlet/ListProduct?key="+rset.getString(1)+"&name1="+tStr+"&name2="+tImsi+"\"
>");
/*
tStr = inName1 + " >>"+rset.getString(2);
out.println("<td valign=\"top\"><a
href=\"/servlet/ListProduct?key="+rset.getString(1)+"&name="+tStr+"\">");
*/
out.println("<b>"+rset.getString(2)+"</b></a></td>");
}
if(rset.next()) {
tStr = inName1 + "X" + inRef;
tImsi = rset.getString(2);
out.println("<td valign=\"top\"><a
href=\"/servlet/ListProduct?key="+rset.getString(1)+"&name1="+tStr+"&name2="+tImsi+"\"
>");
/*
tStr = inName1 + " >>"+rset.getString(2);
out.println("<td valign=\"top\"><a
href=\"/servlet/ListProduct?key="+rset.getString(1)+"&name="+tStr+"\">");
*/
out.println("<b>"+rset.getString(2)+"</b></a></td>");
}
out.println("</tr>");
i++;
}
} // 1st try
catch (ClassNotFoundException e1) {
out.println("Couldn't load database driver : " + e1.getMessage());
}
catch (SQLException e2) {
out.println("SQLException caught : " + e2.getMessage());
}
catch (Exception e3) {
out.println("SQLException caught : " + e3.getMessage());
}
finally {
try {
conn.close();
}
catch (SQLException ignored) {}
} // finally
if (i == 1) {
out.println("°Ë»öµÈ Ç׸ñÀÌ ¾øÀ¾´Ï´Ù.<br>");
}
out.println("</TABLE>");
//out.println("</CENTER>");
out.println("</BODY></HTML>");
out.close();
}
}




´ÙÀ½ ±Ûµé:



À̾ ±Û¿Ã¸®±â(´äÇϱâ)

À̸§:
E-Mail:
Á¦¸ñ:
³»¿ë:
HTML ÅÂ±× Æ÷ÇÔ ¿©ºÎ: HTML ¹®¼­ÀÏ °æ¿ì üũ
°ü·Ã URL(¼±ÅÃ):
URL Á¦¸ñ(¼±ÅÃ):
°ü·Ã À̹ÌÁö URL:


[ ´ÙÀ½ ±Ûµé ] [ À̾ ±Û¿Ã¸®±â(´äÇϱâ) ] [ ÀÚ¹Ù ¹¯°í ´äÇϱâ ]