从数据库中取出数据，然后进行分页显示

Page实体类

public class Page {
public int index;//当前是多少页
public int size;//每页显示的条数
public int pageCount;//总页数
public int count;//一共有多少条数
public int code;//表示是否请求成功 200(成功)
public Object obj;// 返回的数据内容
public int getIndex() {
return index;
}
public void setIndex(int index) {
this.index = index;
}
public int getSize() {
return size;
}
public void setSize(int size) {
this.size = size;
}
public int getPageCount() {
return pageCount;
}
public void setPageCount(int pageCount) {
this.pageCount = pageCount;
}
public int getCount() {
return count;
}
public void setCount(int count) {
this.count = count;
}
public int getCode() {
return code;
}
public void setCode(int code) {
this.code = code;
}
public Object getObj() {
return obj;
}
public void setObj(Object obj) {
this.obj = obj;
}
}

User实体类

public class User {
public User(){}
private Integer user_id;//用户id
private String user_name;//用户姓名
private String password;//密码
private Integer age;//年龄
private String phone_num;//手机号码
private String code;//身份证号码
private String address;//家庭住址
private int codeMsg;//请求后的返回 200成功
private Object msg;//请求得到的消息
public Object getMsg() {
return msg;
}
public void setMsg(Object msg) {
this.msg = msg;
}
public int getCodeMsg() {
return codeMsg;
}
public void setCodeMsg(int codeMsg) {
this.codeMsg = codeMsg;
}
public Integer getUser_id() {
return user_id;
}
public void setUser_id(Integer user_id) {
this.user_id = user_id;
}
public String getUser_name() {
return user_name;
}
public void setUser_name(String user_name) {
this.user_name = user_name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
public String getPhone_num() {
return phone_num;
}
public void setPhone_num(String phone_num) {
this.phone_num = phone_num;
}
public String getCode() {
return code;
}
public void setCode(String code) {
this.code = code;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
@Override
public String toString() {
return “User [user_id=” + user_id + “, user_name=” + user_name
+ “, password=” + password + “, age=” + age + “, phone_num=”
+ phone_num + “, code=” + code + “, address=” + address + “]”;
}
}

UserDao(接口中的方法)

User login(User user);//登录
int addUser(User user);//注册用户
List<User> getUserList();//得到所有的用户
int deleteUser(String delete_id);//删除用户
int updateUser(User user);//修改用户
User getUser(int user_id);//根据用户的id查找出对应的用户
List<User> getPageList(Page p);//分页
int getCount();//得到数据库里面的数据的条数

UserDaoImpl（接口实现类代码）

/**
* 得到所有的用户
*/
public List getUserList() {
String sql=“select * from tbl_user”;
Result result=JDBCUtil.getQuery(sql);
Map[] map=result.getRows();
List list=new ArrayList();
User user=null;
for(Map item:map){
user=new User();
user.setUser_id(Integer.valueOf(item.get(“user_id”).toString()));
user.setUser_name(item.get(“user_name”).toString());
user.setPassword(item.get(“password”).toString());
user.setAge(Integer.valueOf(item.get(“age”).toString()));
user.setPhone_num(item.get(“phone_num”).toString());
user.setCode(item.get(“code”).toString());
user.setAddress(item.get(“address”).toString());
list.add(user);
}
return list;
}

/**
 * 删除用户
 */
public int deleteUser(String delete_id) {
	String sql="delete from tbl_user where user_id=?";
	int rerult=JDBCUtil.excuteSql(sql, delete_id);
	return rerult;
}

/**
 * 根据用户的id查找出对应的用户
 */
public User getUser(int user_id) {
	String sql="select * from tbl_user where user_id=?";
	Result result=JDBCUtil.getQuery(sql, user_id);
	Map[] map=result.getRows();
	User user=null;
	for(Map item:map){
		user=new User();
		user.setUser_id(Integer.valueOf(item.get("user_id").toString()));
		user.setUser_name(item.get("user_name").toString());
		user.setPassword(item.get("password").toString());
		user.setAge(Integer.valueOf(item.get("age").toString()));
		user.setPhone_num(item.get("phone_num").toString());
		user.setCode(item.get("code").toString());
		user.setAddress(item.get("address").toString());
	}
	return user;
}

/**
 * 修改用户
 */
public int updateUser(User user) {
	String sql="update tbl_user set user_name=?,password=?,age=?,phone_num=?,code=?,address=? where user_id=?";
	int result=JDBCUtil.excuteSql(sql, user.getUser_name(),user.getPassword(),user.getAge()+"",user.getPhone_num(),user.getCode(),user.getAddress(),user.getUser_id()+"");
	return result;
}

/*
 * 注册用户(non-Javadoc)
 * @see com.dao.UserDao#addUser(com.pojo.User)
 */
public int addUser(User user) {
	String sql="insert into tbl_user(user_name,password,age,phone_num,code,address) values(?,?,?,?,?,?)";
	int user_id=JDBCUtil.excuteSqlGetId(sql, user.getUser_name(),user.getPassword(),user.getAge()+"",user.getPhone_num(),user.getCode(),user.getAddress());
	return user_id;
}

/**
 * 分页
 */
public List<User> getPageList(Page p) {
	String sql="select * from tbl_user limit ?,?";
	Result rst=JDBCUtil.getQuery(sql,(p.index-1)*p.size,p.size);
	Map[] map=rst.getRows();
	List<User> list=new ArrayList<User>();
	User user=null;
	for(Map item:map){
		user=new User();
		user.setAddress(item.get("address").toString());
		user.setAge(Integer.valueOf(item.get("age").toString()));
		user.setUser_id(Integer.valueOf(item.get("user_id").toString()));
		user.setUser_name(item.get("user_name").toString());
		user.setPassword(item.get("password").toString());
		user.setPhone_num(item.get("phone_num").toString());
		user.setCode(item.get("code").toString());
		list.add(user);
	}
	return list;
}

/**
 * 得到数据库里数据的总条数
 */
public int getCount() {
	String sql="select count(1) as count from tbl_user";
	Result rst=JDBCUtil.getQuery(sql);
	Map[] map=rst.getRows();
	Long count=new Long(0);
	count=Long.valueOf(map[0].get("count").toString());
	return count.intValue();
}

/**
 * 登录
 */
public User login(User u) {
	String sql="select * from tbl_user where user_name=? and  password=?";
	Result result=JDBCUtil.getQuery(sql,u.getUser_name(),u.getPassword());
	Map[] map=result.getRows();
	User user=null;
	for(Map item:map){
		user=new User();
		user.setAddress(item.get("address").toString());
		user.setAge(Integer.valueOf(item.get("age").toString()));
		user.setUser_id(Integer.valueOf(item.get("user_id").toString()));
		user.setUser_name(item.get("user_name").toString());
		user.setPassword(item.get("password").toString());
		user.setPhone_num(item.get("phone_num").toString());
		user.setCode(item.get("code").toString());
	}
	return user;
}

UserServer业务逻辑层代码

• UserDao dao=new UserDaoImpl();
  public User login(User user){
  return dao.login(user);
  }

  /*

  • 得到所有的用户
    /
    public List gatUserList(){
    return dao.getUserList();
    }
    /

  • 删除用户
    /
    public int deleteUser(String delete_id) {
    return dao.deleteUser(delete_id);
    }
    /

  • 得到单个的用户
    /
    public User getUser(int user_id){
    return dao.getUser(user_id);
    }
    /

  • 修改用户信息
    /
    public int updateUser(User user){
    return dao.updateUser(user);
    }
    public int addUser(User user){
    return dao.addUser(user);
    }
    /*

  • 分页查询逻辑处理

  • @param p

  • @return
    */
    public List getList(Page p){
    UserDao dao=new UserDaoImpl();
    //查询总条数
    p.count=dao.getCount();

    //总页数 ceil向上取证
    p.pageCount=(int)Math.ceil(p.count/(double)p.size);

    //查询当前页的数据
    return dao.getPageList§;
    }

jsp页面代码

首页 上一页 下一页 尾页 一共有条数据 一共有页 当前第页 跳转到页

<table id="select"></table>