?? deletesupportteam.java
字號:
import java.io.IOException;
import java.io.PrintStream;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class deletesupportteam extends HttpServlet
{
public deletesupportteam()
{
}
public void init(ServletConfig servletconfig)
throws ServletException
{
super.init(servletconfig);
try
{
System.out.println("inside try");
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();
System.out.println("statement is created");
}
catch(Exception exception)
{
System.out.println(exception);
}
}
public void service(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
throws ServletException, IOException
{
String s = "";
String s1 = "";
String s2 = "";
String s3 = "";
String s4 = "";
String s5 = "";
String s6 = "";
String s7 = "";
java.io.PrintWriter printwriter = httpservletresponse.getWriter();
httpservletresponse.setContentType("text/html");
String s8 = httpservletrequest.getParameter("s");
System.out.println("Support team id is " + s8);
String s9 = httpservletrequest.getParameter("m");
System.out.println("Module code is " + s9);
String s10 = httpservletrequest.getParameter("c");
System.out.println("Category code is " + s10);
String s11 = httpservletrequest.getParameter("n");
System.out.println("Support team name is " + s11);
System.out.println("before try");
System.out.println("Code is " + s);
System.out.println("Code is " + s1);
System.out.println("Name is " + s2);
System.out.println("status is " + s3);
try
{
int i = st.executeUpdate("delete from supportteam where supportid='" + s8 + "'");
System.out.println("deleted:" + i);
httpservletresponse.sendRedirect("./categories");
}
catch(Exception exception)
{
System.out.println(exception);
}
}
Connection con;
Statement st;
ResultSet rs;
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -