我写的servlet处理更新数据的问题,完成后显示处理是否成功的提示框,但更新完成后不能提示
解决方案 »
- 大神们开始找错啦!!org.hibernate.exception.SQLGrammarException: could not execute query
- 使用hibernite问下关于数据库设计的一个问题
- 基于FTP的web版断点续传问题,求大牛
- 前台jsp网页需要在tomcat控制台下按下键之后才显示页面,怎么解决
- jsp
- 救命啊!今天搞不定就被开除!没饭吃啦!求求各位啦!救命啊!
- <bean:message key="mms.<%=request.getParameter("serviceid")%>.title"/>动态bean输出怎么实现不了啊
- Tomcat问题
- JSP servlet查询显示问题求助
- JSP里的xml文件
- 问一个JAVA编译的问题
- jsf中如何嵌套一个动态生成的图象?
package sjxx;import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
import Bean.DatabaseBean;
import com.jspsmart.upload.*;public class Change extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=GBK2312"; String Record,xh,kskcdm="";
String kch,xn,xqdm,kcjbm="";
int Records=0;
String sql1,sql2,sql3="";
String sql4,sql5,sql6="";
String sjbh,dtbh,xtbh,df="";
String driver="";
String source="";
String name="";
String pass="";
ResultSet rs2,rs3=null;
ResultSet rs4,rs5,rs6=null;
ServletConfig config;
ServletContext application = null;
public void init(ServletConfig config) throws ServletException {
super.init(config);
this.config = config;
} //Process the HTTP Get request
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
} //Process the HTTP Post request
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //PrintWriter out = response.getWriter();
SmartUpload su = new SmartUpload();
DatabaseBean con=new DatabaseBean();
driver=application.getInitParameter("dbdriver");
source=application.getInitParameter("dbsource");
name=application.getInitParameter("username");
pass=application.getInitParameter("password");
con.setjdbcDriver(driver);
con.setDatabaseURL(source);
con.setuser(name);
con.setpassword(pass);
//javax.servlet.http.HttpServlet Servletconfig;
try{ su.initialize(config, request, response);
su.setMaxFileSize(5 * 1024 * 1024);
su.setTotalMaxFileSize(100 * 1024 * 1024);
//su.setAllowedFilesList("jpeg");
su.upload();
}catch(Exception e)
{
e.printStackTrace();
}
Record=su.getRequest().getParameter("RecordsNum");
Records=Integer.parseInt(Record);
xh=su.getRequest().getParameter("xh");
kskcdm=su.getRequest().getParameter("kskcdm");
kch=su.getRequest().getParameter("kch");
xn=su.getRequest().getParameter("xn");
xqdm=su.getRequest().getParameter("xqdm");
kcjbm=su.getRequest().getParameter("kcjbm");
sjbh=su.getRequest().getParameter("sjbh");
try{
con.connect();
//Class.forName("oracle.jdbc.driver.OracleDriver");
//java.sql.Connection con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.88.36:1521:work","szsj","szsj");
for(int i=0;i<Records;i++){
dtbh=su.getRequest().getParameter("dtbh"+i);
xtbh=su.getRequest().getParameter("xtbh"+i);
df=su.getRequest().getParameter("df"+i);
sql1="update szsj.xssjdfb set df='"+df+"' where xh='"+xh+"' and kch='"+kch+"'";
sql1+=" and xn='"+xn+"' and xqdm='"+xqdm+"' and kcjbm='"+kcjbm+"' and kskcdm=";
sql1+="'"+kskcdm+"' and sjbh='"+sjbh+"' and dtbh='"+dtbh+"' and xtbh='"+xtbh+"'";
con.update(sql1);
}
con.disconnect();
//String b1="操作提示";
request.setAttribute("ResultNumber","002");
//request.setAttribute("pageName","javascript:history.back()");
//String nextPage="ProcessResult.jsp";
RequestDispatcher rd=request.getRequestDispatcher("/logicError.jsp");
rd.forward(request,response);
}catch(Exception e){
e.printStackTrace();
String b1="错误提示";
request.setAttribute("ResultNumber","001");
request.setAttribute("pageName","javascript:history.back()");
String nextPage="ProcessResult.jsp";
RequestDispatcher rd=request.getRequestDispatcher(nextPage);
rd.forward(request,response);
}
}
//Clean up resources
public void destroy() {
}
}
rd.forward(request,response);
报错