?? steam1.java
字號:
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class steam1 extends HttpServlet
{
public steam1()
{
}
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");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:project","ecare","ecare");
*/
Statement st=con.createStatement();
st1 = con.createStatement();
System.out.println("statement is created");
}
catch(Exception exception)
{
exception.printStackTrace();
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");
String s1 = "";
String s3 = "";
try
{
System.out.println("inside try");
System.out.println("kkkkkkkkkkkkkkkk");
String s4 = httpservletrequest.getParameter("mod1");
System.out.println("mod1 :"+s4);
rs=st.executeQuery("select *from supportteam where moduleid='M1'");
//rs=st.executeQuery("select * from supportteam where moduleid='"+s4+"'");
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 SupportTeam Members</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> SupportId </STRONG></TD>");
printwriter.println("<TD><STRONG> SupportTeamName </STRONG></TD>");
printwriter.println("<TD>");
printwriter.println("</TR>");
System.out.println("after rs");
while(rs.next())
{
System.out.println("INSIDE RS");
String s = rs.getString(1);
System.out.println("supportteamcode is " + s);
String s2 = rs.getString(4);
System.out.println("support team name is " + s2);
printwriter.println(" <TR> ");
printwriter.println(" <TD> " + s + " </TD> ");
printwriter.println(" <TD> " + s2 + " </TD> ");
printwriter.println(" <TD> ");
printwriter.println("</TR>");
}
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("<TD><STRONG>Click here to >></STRONG></TD>");
printwriter.println("<TD> <a href='./cat1'>Go Back</a></TD></TR>");
printwriter.println("</P> ");
printwriter.println("</form>");
printwriter.println("</body>");
printwriter.println("</html>");
}
catch(Exception exception)
{
exception.printStackTrace();
System.out.println(exception);
}
}
Connection con;
Statement st;
Statement st1;
ResultSet rs;
ResultSet rs1;
}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -