先看效果:
本人数据库:数据库名bookclass, 列名有:BookClassID,BookClassMC。请大家修改对应的数据库
下面开始教程:(项目名:Paging)
第一步:
1.在pom.xml中加入依赖:
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.22</version>
</dependency>
2.写一个实体类entity 封装定义的要查询的字段:
package com.sve.dao;
public class entity {
public static final int PAGE_SIZE = 5;//每页显示的条数
private int bookid;
private String boookname;
public int getBookid() {
return bookid;
}
public void setBookid(int bookid) {
this.bookid = bookid;
}
public String getBoookname() {
return boookname;
}
public void setBoookname(String boookname) {
this.boookname = boookname;
}
}
第二步:
写一个dao类 PagDao:
package com.sve.dao;
import java.sql.Connection;
import java.sql.Driver