?? categories2.java
字號:
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class categories2 extends HttpServlet
{
public categories2()
{
}
public void init(ServletConfig servletconfig)
throws ServletException
{
super.init(servletconfig);
try
{
System.out.println("inside init");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:ecare","ecare","ecare");
//Class.forName("oracle.jdbc.driver.OracleDriver");
//con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:project","ecare","ecare");
st=con.createStatement();
st1 = con.createStatement();
System.out.println("statement is created");
}
catch(Exception exception)
{
System.out.println("init method" + exception);
}
}
public void service(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
throws ServletException, IOException
{
System.out.println("inside service");
PrintWriter printwriter = httpservletresponse.getWriter();
httpservletresponse.setContentType("text/html");
try
{
System.out.println("inside try");
rs = st.executeQuery("select * from categoryies");
printwriter.println("<html>");
printwriter.println("<head>");
printwriter.println("<style>");
printwriter.println("a{ Text-Decoration:none;}");
printwriter.println("</style>");
printwriter.println("</head>");
printwriter.println("<body>");
printwriter.println("<form > ");
printwriter.println("<TABLE border=0 cellPadding=1 cellSpacing=1 width=75% align=center>");
printwriter.println("<P>");
printwriter.println(" <TR>");
printwriter.println(" <TD></TD>");
printwriter.println(" <TD></TD>");
printwriter.println("<TD>");
printwriter.println("<P align=left style='COLOR: forestgreen'><FONT size=5><STRONG><U>HD Categories</U></STRONG></FONT></P></TD></TR>");
printwriter.println("<P align=center> </P>");
printwriter.println("<P align=center>");
printwriter.println("<TABLE border=0 cellPadding=1 cellSpacing=1 style='HEIGHT: 130px; WIDTH: 431px'");
printwriter.println("width=75%>");
printwriter.println("<TR>");
printwriter.println("<TD><STRONG>CategoryId</STRONG></TD>");
printwriter.println("<TD><STRONG> CategoryName</STRONG></TD>");
printwriter.println("<TD><STRONG> Status </STRONG></TD>");
printwriter.println("</TR>");
System.out.println("after rs");
String s2;
for(; rs.next(); printwriter.println(" <TD> " + s2 + " </TD> "))
{
System.out.println("INSIDE RS");
String s = rs.getString(1);
System.out.println("code is " + s);
String s1 = rs.getString(2);
System.out.println("name is " + s1);
s2 = rs.getString(3);
System.out.println("status1 is " + s2);
printwriter.println(" <TR> ");
printwriter.println(" <TD><a href='./module2?mod=" + s + "'>" + s + "</a> </TD> ");
printwriter.println(" <TD> " + s1 + " </TD> ");
}
printwriter.println("<TR>");
printwriter.println("<TD></TD>");
printwriter.println("<TD> </TD></TR>");
printwriter.println("<TR>");
printwriter.println("<TD></TD>");
printwriter.println("<TD></TD>");
printwriter.println("</TR>");
printwriter.println("</P> ");
printwriter.println("</form>");
printwriter.println("</body>");
printwriter.println("</html>");
}
catch(Exception exception)
{
System.out.println(exception);
}
}
Connection con;
Statement st;
Statement st1;
ResultSet rs;
ResultSet rs1;
}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -