📄 solforwardto.java
字号:
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class solforwardto extends HttpServlet
{
public solforwardto()
{
fid = "F001";
ffrom = "f001";
fto = "";
status = "";
level = "";
}
public void init(ServletConfig servletconfig)
throws ServletException
{
super.init(servletconfig);
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");
System.out.println("inside forward to Connection is created");
st = con.createStatement();
System.out.println("statement is created");
}
catch(Exception exception)
{
System.out.println(exception.getMessage());
}
}
public void service(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
throws ServletException, IOException, NumberFormatException
{
PrintWriter printwriter = httpservletresponse.getWriter();
httpservletresponse.setContentType("text/html");
String s = httpservletrequest.getParameter("ftickno");
int j = Integer.parseInt(s);
level = httpservletrequest.getParameter("levelsel");
fto = httpservletrequest.getParameter("user");
try
{
i = st.executeUpdate("insert into forward values('" + j + "','" + ffrom + "','" + fto + "','" + status + "')");
printwriter.println("<html>");
printwriter.println("<body>Succesfully eI Val is " + i);
printwriter.println("PROBLEM WITH TICKET ID " + j + " IS FORWARDED TO " + fto + " IN LEVEL NO :" + level);
printwriter.println("</body></html>");
}
catch(Exception exception)
{
exception.printStackTrace();
}
}
Connection con;
Statement st;
Statement st1;
ResultSet rs;
ResultSet rs1;
String fid;
String ffrom;
String fto;
String status;
String level;
int i;
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -