这里的高手请过来看看吧!在线等候!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
以下代码编译通过,但是不能修改数据,tomcat控制台根本没有相关提示信息?
请问高手,这个代码哪里有问题,帮我找出来,50分立刻奉上!
package net.cjhelp.servlets;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
public class ReUpdateServlet extends HttpServlet {
private static final String CONTENT_TYPE = "text/html;charset=GBK";
/**Initialize global variables*/
public void init() throws ServletException {
String sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println( e.getMessage());
}
}
public int executeUpdate(String sql) {
String sConnStr = "jdbc:microsoft:sqlserver://localhost:1433;databasename=ti
mecount";
String user = "guest";
String password = "";
Connection connect = null;
int row =0;
try {
connect = DriverManager.getConnection(sConnStr,user,password);
Statement stmt = connect.createStatement();
row = stmt.executeUpdate(sql);
}
catch(SQLException ex) {
System.err.println(ex.getMessage());
}
return row;
}
public String getStr(String str){
try
{
String temp_p=str;
byte[] temp_t=temp_p.getBytes("ISO8859-1");
String temp=new String(temp_t);
return temp;
}
catch(Exception e){
System.err.println(e.getMessage());
}
return "null";
}
/**Process the HTTP Get request*/
public void doGet(HttpServletRequest request, HttpServletResponse response) th
rows ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head><title>UpdateServlet</title></head>");
out.println("<body>");
out.println("<p>The servlet has received a GET. This is the reply.</p>");
out.println("</body></html>");
}
/**Process the HTTP Post request*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
String rq,xm,dfl,nr,cgwm1,sl1,cgwm2,sl2,cgwm3,sl3,bz,kssj,jssj,zdsj,jsj,sql;
rq = request.getParameter("rq");
xm = getStr(request.getParameter("xm"));
dfl= getStr(request.getParameter("dfl"));
nr = getStr(request.getParameter("nr"));
kssj = request.getParameter("kssj");
jssj = request.getParameter("jssj");
zdsj = request.getParameter("zdsj");
jsj = request.getParameter("jsj");
cgwm1 =getStr(request.getParameter("cgwm1"));
sl1 = request.getParameter("sl1");
cgwm2 =getStr(request.getParameter("cgwm2"));
sl2 = request.getParameter("sl2");
cgwm3 =getStr(request.getParameter("cgwm3"));
sl3 = request.getParameter("sl3");
bz =getStr(request.getParameter("bz"));
sql="update timecount set Project_id='"+xm+"',dfl='"+dfl+"',nr='"+nr+"',kssj
='"+kssj;
sql=sql+"',jssj='"+jssj+"',zdsj='"+zdsj+"',jsj='"+jsj+"',cgwm1='"+cgwm1+"',s
l1='"+sl1+"',cgwm2='"+cgwm2;
sql=sql+"',sl2='"+sl2+"',cgwm3='"+cgwm3+"',sl3='"+sl3+"',bz='"+bz+"' where r
q='"+rq+"'";
try
{
executeUpdate(sql);
}
catch(Exception e1)
{
out.println(e1.getMessage());
}
out.println("<html>");
out.println("<head>");
out.println("<title>");
out.println("Update for Final");
out.println("</title>");
out.println("<meta content=\"cjhelp.net\" name=\"cjhelp\">");
out.println("</head>");
out.println("<BODY text=#0000ff vLink=#800000 aLink=#ff0000 link=#0000ff bgPr
operties=fixed bgColor=#cccc99>");
out.println("<div> </div>");
out.println("<div> </div>");
out.println("<div> </div>");
out.println("<center><h3><font face=\"MS Sans Serif\">The Result For Operated
Database.</font></h3></center>");
out.println("<p align=center><font size=2>感谢您新的递交!<p><br>");
out.println("<div align=center>");
out.println("<a href=\"http://cjhelp:8080/cn/jsp/tcview.jsp\" target=_self>查看当前工时登陆数据!</a></td>");
out.println("<a href=\"javascript:window.close()\">关闭窗口</a>");
out.println("</BODY>");
out.println("</html>");
}
/**Clean up resources*/
public void destroy(){}
}