本文共 3131 字，大约阅读时间需要 10 分钟。

package bdqn.newsMange.Dao.Impl;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;import bdqn.newsMange.Dao.BaseDao;import bdqn.newsMange.Dao.UserDao;import bdqn.newsMange.entity.User;public class UserDaoImpl extends BaseDao implements UserDao {	//查询全部	public List
   
     getAllUesr() {		// TODO Auto-generated method stub		List
    
      userlist=new ArrayList
     
      ();		String sql="select userId,userName,userPassword,uRole from [users]";		try {			ResultSet rs=executeQurey(sql, null);			while(rs.next()){				User user=new User();				user.setUserId(rs.getInt(1));				user.setUserName(rs.getString(2));				user.setUserPassword(rs.getString(3));				user.setuRole(rs.getString(4));				userlist.add(user);			}		} catch (ClassNotFoundException e) {			// TODO Auto-generated catch block			e.printStackTrace();		} catch (SQLException e) {			// TODO Auto-generated catch block			e.printStackTrace();		}finally{			closeAll();		}		return userlist;	}	//添加（注册）	public int addUser(User user) {		int rel=0;		String sql="insert users (userName,userPassword,uRole)values(?,?,'普通用户')";		List