狂神说java超市管理系统dao层用户功能

接口

package dao.LoginDao;
import po.user;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Date;
import java.util.List;

public interface LoginDao {
    //用户登入接口
    public user LoginUser(Connection conn, String UserName) throws SQLException;
    //修改密码接口
    public  int UpPwd(Connection conn,int id,String password) throws SQLException, ClassNotFoundException;
    //获取用户数量
    public  int CountName(Connection conn,String Username,int RuId) throws SQLException;
    //用户列表
    public List<user> UerList(Connection conn,String UserName, int id, int a, int b) throws SQLException, ClassNotFoundException;
    // 添加用户
    public  boolean adduser(Connection conn,user user) throws SQLException;
    //出现账号是否存在
    public  int ecuser(Connection conn,String usercode) throws SQLException;
    //删除用户
    public  int deluser(Connection conn,int id) throws SQLException;
    //根据用户ID 显示条件
    public  user selectuser(Connection conn,int id)throws SQLException;
    //更新用户信息
    public  int updatauser(Connection conn,user user);
}

实现类

package dao.LoginDao;
import com.mysql.jdbc.StringUtils;
import dao.BaseDao;
import org.apache.taglibs.standard.lang.jstl.StringLiteral;
import po.user;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
//登入
public class LoginDaoImpl implements LoginDao {
    public user LoginUser(Connection conn, String UserName) throws SQLException {
        String sql = "select * from smbms_user where userCode = ?";
            ResultSet rs = null;
            PreparedStatement pr = null;
            po.user user = null;
            Object[] params = {UserName};
            rs = BaseDao.ExEc((com.mysql.jdbc.Connection) conn, sql, params, pr);
            if (rs.next()) {
                user = new user();
                user.setId(rs.getInt("id"));
                user.setUserCode(rs.getString("userCode"));
                user.setUserName(rs.getString("UserName"));
                user.setUserPassword(rs.getString("userPassword"));
                user.setGender(rs.getString("Gender"));
                user.setBirthday(rs.getDate("Birthday"));
                user.setPhone(rs.getString("Phone"));
                user.setAddress(rs.getString("Address"));
                user.setUserRole(rs.getString("UserRole"));
                user.setCreatedBy(rs.getString("CreatedBy"));
                user.setCreationDate(rs.getDate("CreationDate"));
                user.setModifyBy(rs.getString("ModifyBy"));
                user.setModifyDate(rs.getString("ModifyDate"));
            }
            BaseDao.ConnClose(null, rs, null);
            return user;
    }
    //修改用户名密码
    public int UpPwd(Connection conn, int id, String password) throws SQLException, ClassNotFoundException {
            int start = 0;
            if(conn!=null){
            String sql="UPDATE smbms_user SET userPassword = ? WHERE id = ?";
            Object[] partm = {password,id};
            start =  BaseDao.QuDel((com.mysql.jdbc.Connection) conn,sql,partm,null);
            BaseDao.ConnClose((com.mysql.jdbc.Connection) conn,null,null);
        }
        return start;
    }
    //统计多少用户
    public int CountName(Connection conn,String Username, int RuId) throws SQLException {
        StringBuffer sql = new StringBuffer();
        PreparedStatement pr =null;
        ResultSet rs = null;
        int c=0;
        ArrayList<Object> List = new ArrayList<Object>();
        if(conn!=null) {
            sql.append("SELECT COUNT(1) AS C FROM smbms_user AS u,smbms_role AS r WHERE u.userRole = r.id");
        }
        if(Username!=null){
            List.add("%"+Username+"%");
            sql.append(" AND u.userName LIKE ?");
        }
           if(RuId!=0){
            List.add(RuId);
            sql.append(" AND r.id =?");
        }
        Object[] parm = List.toArray();
            rs =BaseDao.ExEc((com.mysql.jdbc.Connection) conn,sql.toString(),parm,pr);
            if(rs.next()){
                c=rs.getInt("C");
            }
            BaseDao.ConnClose(null,rs,pr);
          return c;
    }
    //用户列表
    public List<user> UerList(Connection conn, String UserName, int id, int a, int b)  throws SQLException, ClassNotFoundException {
        ArrayList<user> UserArrlist = new ArrayList<user>();
        ArrayList<Object> objects = new ArrayList<Object>();
        StringBuffer sql = new StringBuffer();
        ResultSet rs = null;
        PreparedStatement pr = null;
        int pagecount;
        if(conn!=null){
            sql.append("SELECT u.* FROM smbms_user AS u,smbms_role AS r WHERE u.userRole = r.id");
        }
        if(UserName!=null){
            objects.add("%"+ UserName +"%");
            sql.append(" AND u.userName LIKE ?");
        }
        if(id!=0){
            objects.add(id);
            sql.append(" AND r.id =?");
        }
        sql.append(" ORDER BY U.userRole ASC LIMIT ?,?");
        //当前页
　　　　　//0，5
　　　　　//5,5
　　　　　// 当前页-1*页面大小

        pagecount = (a-1)*b;
        objects.add(pagecount);
        objects.add(b);
        Object[] pstm = objects.toArray();
        conn = BaseDao.GetConn();
        rs = BaseDao.ExEc((com.mysql.jdbc.Connection) conn,sql.toString(),pstm,pr);
        while (rs.next()){
            user  user= new user();
            user.setId(rs.getInt("id"));
            user.setUserCode(rs.getString("userCode"));
            user.setUserName(rs.getString("UserName"));
            user.setUserPassword(rs.getString("userPassword"));
            user.setGender(rs.getString("Gender"));
            user.setBirthday(rs.getDate("Birthday"));
            user.setPhone(rs.getString("Phone"));
            user.setAddress(rs.getString("Address"));
            user.setUserRole(rs.getString("UserRole"));
            user.setCreatedBy(rs.getString("CreatedBy"));
            user.setCreationDate(rs.getDate("CreationDate"));
            user.setModifyBy(rs.getString("ModifyBy"));
            user.setModifyDate(rs.getString("ModifyDate"));
            UserArrlist.add(user);
        }
        BaseDao.ConnClose(null,rs,pr);
        return UserArrlist;
    }
    //添加用户
    public boolean adduser( Connection conn,user user) throws SQLException {
        String sql=null;
        Date date = new Date();
        boolean flag = false;
        int a=0;
        Object[] pstm = {user.getUserCode(),user.getUserName(),user.getUserPassword(),user.getGender(),user.getBirthday(),user.getPhone(),user.getAddress(),user.getUserRole(),user.getCreationDate()};
        PreparedStatement pr=null;
                if(conn!=null) {
                 sql = "INSERT INTO `smbms`.`smbms_user` (`userCode`, `userName`, `userPassword`, `gender`, `birthday`, `phone`, `address`, `userRole`, `creationDate`) VALUES (?,?,?,?,?,?,?,?,?)";
                    a= BaseDao.QuDel((com.mysql.jdbc.Connection) conn, sql, pstm, pr);
                    BaseDao.ConnClose(null,null,pr);
                    if(a>0){
                        flag=true;
                    }else{
                        flag=false;
                    }
                }else{
                    flag = false;
                }
        return flag;
    }
    //删除用户
    public int deluser(Connection conn, int id) throws SQLException {
        int flag = 0;
        String sql = "DELETE FROM smbms_user WHERE id = ?";
        Object[] past = {id};
        PreparedStatement pr=null;
                if(conn!=null){
                    flag =  BaseDao.QuDel((com.mysql.jdbc.Connection) conn,sql,past,pr);
                }else
                {
                    flag = 0;
                }
                    BaseDao.ConnClose(null,null,pr);
        return flag;
    }
  //查询用户是否存在
    public int ecuser(Connection conn, String usercode) throws SQLException {
        int flag = 1;
        Object[] past = {usercode};
        PreparedStatement pr = null;
        ResultSet rs=null;
        String sql = "SELECT COUNT(1) AS B FROM smbms_user AS u WHERE u.userCode LIKE ?";
        if(conn!=null){
            rs = BaseDao.ExEc((com.mysql.jdbc.Connection) conn, sql, past, pr);
            if(rs.next()){
                flag =    rs.getInt("B");
            }
        }
        else{
            flag = 1;
        }
        BaseDao.ConnClose(null,rs,pr);
        return flag;
    }
 //根据用户ID 显示用户信息
    public user selectuser(Connection conn, int id) throws SQLException {
        String sql = "SELECT * FROM `smbms_user` WHERE id = ?";
        Object[] psat = {id};
        PreparedStatement pr = null;
        ResultSet rs = null;
        user user = null;
        if (conn != null) {
            rs = BaseDao.ExEc((com.mysql.jdbc.Connection) conn, sql, psat, pr);
            if (rs.next()) {
                user = new user();
                user.setId(rs.getInt("id"));
                user.setUserCode(rs.getString("userCode"));
                user.setUserName(rs.getString("UserName"));
                user.setUserPassword(rs.getString("userPassword"));
                user.setGender(rs.getString("Gender"));
                user.setBirthday(rs.getDate("Birthday"));
                user.setPhone(rs.getString("Phone"));
                user.setAddress(rs.getString("Address"));
                user.setUserRole(rs.getString("UserRole"));
                user.setCreatedBy(rs.getString("CreatedBy"));
                user.setCreationDate(rs.getDate("CreationDate"));
                user.setModifyBy(rs.getString("ModifyBy"));
                user.setModifyDate(rs.getString("ModifyDate"));
            }
        }
        BaseDao.ConnClose((com.mysql.jdbc.Connection) conn, rs, pr);
        return user;
    }
//更新用户信息
    public int updatauser(Connection conn,user user) {
        int a=0;
        PreparedStatement pr=null;
        if(conn!=null){
            String sql = "UPDATE smbms_user SET userName= ? ,userPassword= ? ,gender= ? ,birthday = ? ,phone= ? ,address= ? ,userRole= ? WHERE id = ?";
            Object[]  pstm = {user.getUserName(),user.getUserPassword(),user.getGender(),user.getBirthday(),user.getPhone(),user.getAddress(),user.getUserRole(),user.getId()};
            try {
                a = BaseDao.QuDel((com.mysql.jdbc.Connection) conn,sql,pstm,pr);
            } catch (SQLException e) {
                e.printStackTrace();
            }finally {
                BaseDao.ConnClose(null,null,pr);
            }
        }
        else{
            a=0;
        }
        return a;
    }
}

 

.