代码如下:
else if (action.equalsIgnoreCase("update")) {//修改操作
//String USERID =(String) httpServletRequest.getSession().getAttribute("USERID");
String sql = "update BIZ_SYS_MANAGER set USERID=" ;
sql += "'" + managerForm.getUSERID() + "'"+",";
sql += "USERNAME='" + managerForm.getUSERNAME() + "'" + ",";
//sql += "ALIAS='" + managerForm.getALIAS() + "'" ;
sql += " where USERID = '" +USERID + "'";
ManagerBean managerbean = new ManagerBean();
managerbean.update(sql);
return actionMapping.findForward("returnlist");
运行结果update BIZ_SYS_MANAGER set USERID='1',USERNAME='', where USERID = '' 为什么WHERE后面的USERID=''啊
这段代码哪里出错,劳驾高手指点
else if (action.equalsIgnoreCase("update")) {//修改操作
//String USERID =(String) httpServletRequest.getSession().getAttribute("USERID");
String sql = "update BIZ_SYS_MANAGER set USERID=" ;
sql += "'" + managerForm.getUSERID() + "'"+",";
sql += "USERNAME='" + managerForm.getUSERNAME() + "'" + ",";
//sql += "ALIAS='" + managerForm.getALIAS() + "'" ;
sql += " where USERID = '" +USERID + "'";
ManagerBean managerbean = new ManagerBean();
managerbean.update(sql);
return actionMapping.findForward("returnlist");
运行结果update BIZ_SYS_MANAGER set USERID='1',USERNAME='', where USERID = '' 为什么WHERE后面的USERID=''啊
这段代码哪里出错,劳驾高手指点
比如说:String str = "";
str = "a" + "b" + "c" + "" + "d";这样是没什么毛病的.
但是:
str = "a";
str += "b";
str += "c";
str += "d";
这样就不太好,因为每次加的时个都会为str开发一块新的内存空间.-------------------
else if (action.equalsIgnoreCase("update")) {//修改操作
String USERID =(String) httpServletRequest.getSession().getAttribute("USERID");StringBuffer sql = new StringBuffer("update BIZ_SYS_MANAGER set USERID=");
sql.append("'" + managerForm.getUSERID() + "'"+",");
sql.append"USERNAME='" + managerForm.getUSERNAME() + "'" + ",");
//sql += "ALIAS='" + managerForm.getALIAS() + "'";
sql.append" where USERID = '" +USERID + "'");
ManagerBean managerbean = new ManagerBean();
managerbean.update(sql.toString());return actionMapping.findForward("returnlist");