pwdupdatesubaction.java

功能是公安和学校的管理系统,用struts+hibernate+spring等匡架组成,在eclepse就能编译

package com.comingnet.action;
import com.comingnet.bean.UserInfor;
import com.comingnet.intercepter.UserSessionAware;
import com.opensymphony.xwork2.ActionSupport;
import com.db.*;
import java.sql.*;
public class PwdUpdateSubAction extends ActionSupport implements UserSessionAware{
	private UserInfor userSession=null;
	private String auid_test;
	private String newpwd;
	private String oldpwd;
	private String msg;
	
	public String getMsg() {
		return msg;
	}
	public void setMsg(String msg) {
		this.msg = msg;
	}
	public String getAuid_test() {
		return auid_test;
	}
	public void setAuid_test(String auid_test) {
		this.auid_test = auid_test;
	}
	public String getNewpwd() {
		return newpwd;
	}
	public void setNewpwd(String newpwd) {
		this.newpwd = newpwd;
	}
	public String getOldpwd() {
		return oldpwd;
	}
	public void setOldpwd(String oldpwd) {
		this.oldpwd = oldpwd;
	}
	public UserInfor getUserSession() {
		return userSession;
	}
	public void setUserSession(UserInfor userSession) {
		this.userSession = userSession;
	}
	   
	public String execute()
	{
        String flag=ERROR;
		Connection conn=null;
        PreparedStatement stmt=null;
        ResultSet rs=null;
		UserInfor userinfor=getUserSession();
		int userid=userinfor.getUserid();
		String userclass=userinfor.getUserclass();
        try
        { 
           String sqlStr="";
           String pwd_data="";
           conn=DBUtils.getConnection();
           if(userclass.equals("1"))
              sqlStr="select jsmm from m_teacher where jsid=? and jsmm=?";
           else if(userclass.equals("2"))
        	  sqlStr="select xsmm from m_student where xsid=? and xsmm=?";
           stmt=conn.prepareStatement(sqlStr);
           stmt.setInt(1,userid);
           stmt.setString(2,getOldpwd()); 
           rs=stmt.executeQuery();
           if(rs.next())
           {
        	  pwd_data=rs.getString(1); 
           }else 
           {
        	   msg="原来的密码不正确！";
        	   setMsg(msg);
        	   flag=INPUT;
           }
           DBUtils.closeResultSet(rs);
           DBUtils.closeStatement(stmt); 
           if(!pwd_data.equals(""))
           {
        	   if(userclass.equals("1"))
        	       sqlStr="update m_teacher set jsmm=? where jsid=?";
        	   else if(userclass.equals("2"))
        		   sqlStr="update m_student set xsmm=? where xsid=?";
        	   stmt=conn.prepareStatement(sqlStr);
        	   stmt.setString(1,getNewpwd());
        	   stmt.setInt(2,userid);
        	   stmt.executeUpdate();
        	   flag=SUCCESS;
           }
           
        }catch(Exception e)
        {
        	System.out.println("PwdUpdateSubAction:"+e);
        }finally
        {
        	DBUtils.closeResultSet(rs);
        	DBUtils.closeStatement(stmt);
        	DBUtils.closeConnection(conn);
        }
		return flag;
	}
}