📄 problempost.java
字号:
import java.io.*;
import java.sql.*;
import java.util.Date;
import javax.servlet.*;
import javax.servlet.http.*;
public class problemPost extends HttpServlet
{
public problemPost()
{
}
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");
st=con.createStatement();
st1 = 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
{ PrintWriter printwriter = httpservletresponse.getWriter();
String s = "";
String s2 = "";
String s4 = "";
String s6 = "";
String s7 = "";
String s8 = "";
String s10 = "";
String s12 = "";
String s14 = "";
httpservletresponse.setContentType("text/html");
HttpSession httpsession = httpservletrequest.getSession(true);
try
{
Date date = new Date();
String s1 = httpservletrequest.getParameter("select1");
String s3 = httpservletrequest.getParameter("select2");
String s5 = httpservletrequest.getParameter("TEXTAREA1");
String s9 = httpservletrequest.getParameter("day");
String s11 = httpservletrequest.getParameter("month");
String s13 = httpservletrequest.getParameter("year");
String s16 = s9 + "/" + s11 + "/" + s13;
Date date1 = new Date(s16);
System.out.println(" cureent date : " + date);
System.out.println(" report date : " + date1);
/*if(date1.before(date))
{
httpservletresponse.sendRedirect("./postproblemd.html");
}*/
int i = Integer.parseInt(s9);
int j = Integer.parseInt(s13);
String s15 = i + "/" + s11 + "/" + j;
System.out.println(s15);
System.out.println("repdate.before(curdate) " + date1.before(date));
httpsession.putValue("catid1", s1);
httpsession.putValue("modid1", s3);
System.out.println("before select nvl");
rs = st.executeQuery("select max(ticket) from problemrequest");
System.out.println("result set");
int k;
if(!rs.next())
k =1;
else
k=rs.getInt(1)+1;
System.out.println(k);
String s17 = "null";
String s18 = "unfinished";
String s19 = "";
String s20 = "";
String s21 = "";
//String sql="insert into problemrequest(TICKET,CATEGORYID,MODULEID,PROBLEMDESCRIPTION,LASTSOLUTION,USER_ID,PROBLEMREPORTDATE) values (" + k + ",'" + s1 + "','" + s3 + "','" + s5 + "','" + s17 + "','" + s6 + "','" + s15 + "')";
// int l = st1.executeUpdate(sql);
int l=st1.executeUpdate("insert into problemrequest values(" + k + ",'" + s1 + "','" + s3 + "','" + s5 + "','" + s17 + "','" + s6 + "','" + s15 + "','"+s20+"','"+s21+"')");
System.out.println(l);
if(l == 1)
{
int i1 = st.executeUpdate(" insert into problemhistory values(" + k + ",'" + s15 + "','" + s5 + "','" + s19 + "','" + s20 + "','" + s21 + "','" + s18 + "')");
printwriter.println("<HTML>");
printwriter.println("<HEAD><TITLE></TITLE>");
printwriter.println("<script language = 'JavaScript'>");
printwriter.println("</script>");
printwriter.println("<BODY>");
printwriter.println("<form name=f1 action='./corporateclientview.html' target='_parent'>");
printwriter.println("<P> </P>");
printwriter.println("<P> </P>");
printwriter.println("<P><STRONG> </STRONG></P>");
printwriter.println("<P align=center style='COLOR: forestgreen'><STRONG> ");
printwriter.println("<U>Ticket Confirmation</U></STRONG></P>");
printwriter.println("<P align=center> </P>");
printwriter.println("<P><STRONG> ");
printwriter.println("<TABLE border=0 cellPadding=1 cellSpacing=1 width=75% align=center>");
printwriter.println("<TR>");
printwriter.println("<TD></TD>");
printwriter.println("<TD></TD></TR>");
printwriter.println("<TR>");
printwriter.println("<TD>");
printwriter.println(" <P align=left><STRONG>Problem is posted and your ");
printwriter.println(" Ticket Number is :</STRONG></P></TD>");
printwriter.println(" <TD>" + k + "</TD></TR>");
printwriter.println(" <TR>");
printwriter.println(" <TD>");
printwriter.println(" <P align=left><STRONG> ");
printwriter.println(" </STRONG></P></TD>");
printwriter.println(" <TD></TD></TR>");
printwriter.println(" <TR>");
printwriter.println(" <TD> ");
printwriter.println("<INPUT id=submit1 name=submit1 type=submit value='Ok'></TD>");
printwriter.println(" <TD>");
printwriter.println(" <P> </P>");
printwriter.println(" <P> </P></TD></TR></TABLE> </STRONG></P>");
printwriter.println("<P><STRONG> </STRONG></P>");
printwriter.println("<P><STRONG> </STRONG></P>");
printwriter.println("<P><STRONG> ");
printwriter.println("</STRONG></P>");
printwriter.println("<P><STRONG> </STRONG></P></form>");
printwriter.println("</BODY></HTML>");
}
System.out.println("i value is : " + l);
}
catch(Exception exception)
{
printwriter.println(exception.getMessage());
}
}
c
Connection con;
Statement st;
Statement st1;
ResultSet rs;
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -