smbms密码修改实现

一、UserDao修改

增加修改用户密码的类描述

    //修改用户密码
    public user updatePwd(Connection connection, int id,int passWord) throws SQLException;

二、UserDaoImpl修改

完成修改用户密码的类实现

    // 修改用户密码
    public int updatePwd(Connection connection, int id, int passWord) throws SQLException {
        PreparedStatement pstm = null;
        int execute = 0;

        if(connection != null){
            String sql = "update  smbms_user set userpassword = ? where id = ?";
            Object params[] = {passWord,id};
            execute = BaseDao.execute(connection,sql,params,pstm);
            BaseDao.closeResource(connection,pstm,null);
        }
        return execute;
    }

三、UserService层修改

增加修改密码类

    // 根据用户id修改用户密码
    public boolean updatePwd(int id, int passWord);

四、UserServiceImpl修改

增加修改密码类实现

   //修改密码service层实现类
    @Override
    public boolean updatePwd(int id, int passWord) {
        Connection connection = null;
        connection = BaseDao.getConnection();
        boolean flag = false;

        try {
            connection = BaseDao.getConnection();
            if(userDao.updatePwd(connection,id,passWord) > 0){
                flag = true;
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            BaseDao.closeResource(connection,null,null);
        }
        return flag;
    }