【Java开源代码栏目提醒】:网学会员鉴于大家对Java开源代码十分关注,论文会员在此为大家搜集整理了“modiUserAction.java”一文,供大家参考学习
package action;
import java.sql.Connection;
import java.sql.PreparedStatement;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionMessage;
/**
* @author dengziyun
* 增加一名用户的Action类
*/
public class modiUserAction extends Action{
/**
* 在此方法中处理HTTP请求,并作响应
*/
public ActionForward execute(ActionMapping arg0, ActionForm arg1,
HttpServletRequest request, HttpServletResponse reponse) throws Exception {
ActionErrors errors=new ActionErrors();
//------接收请求参数------
String oaUserId=request.getParameter("oaUserId");
String oaUserName=request.getParameter("oaUserName");
String oaUserPassword=request.getParameter("oaUserPassword");
String oaUserTrueName=request.getParameter("oaUserTrueName");
String department=request.getParameter("department");
//------构造SQL语句------
String
sqlStr=new String("update oaUser set oaUserName=?,"+
"oaUserPassword=?,oaUserTrueName=?,departmentId=? where "+
"oaUserId=?");
//------插入数据------
try{
//------得到数据库连接------
Context initCtx = new InitialContext();
Context ctx = (Context) initCtx.lookup("java:comp/env");
Object obj = (Object) ctx.lookup("jdbc/sqlserver");
DataSource ds = (javax.sql.DataSource)obj;
Connection conn = ds.getConnection();
//------将数据更新到数据库------
PreparedStatement preSQLupdate=conn.prepareStatement(sqlStr);
oaUserName=new String(oaUserName.getBytes("ISO-8859-1"));
preSQLupdate.setString(1,oaUserName);
oaUserPass
word=new String(oaUserPassword.getBytes("ISO-8859-1"));
preSQLupdate.setString(2,oaUserPassword);
oaUserTrueName=new String(oaUserTrueName.getBytes("ISO-8859-1"));
preSQLupdate.setString(3,oaUserTrueName);
preSQLupdate.setInt(4,Integer.parseInt(department));
preSQLupdate.setInt(5,Integer.parseInt(oaUserId));
preSQLupdate.executeUpdate();
//------关闭数据库连接------
if(conn!=null)
conn.close();
}catch(Exception e){
e.printStackTrace();
errors.add("DBOPError",new ActionMessage("DBOPError"));
saveErrors(request,errors);
System.out.println(e);
}
arg1.reset(arg0,request);
return arg0.findForward("modiUserSuccess
JSP");
}
}