import java.sql.Connection;
import java.sql.DriverManager;
public class DBHelper {
private static final String driver = "com.mysql.jdbc.Driver";//数据库驱动
private static final String url = "jdbc:mysql://localhost:3306/gumysql?useUnicon=true&characterEncoding=UTF-8";
private static final String username = "root";
private static final String password = "root";
static
{
try
{
Class.forName(driver);
}
catch (Exception e)
{
e.printStackTrace();
}
}
private static Connection conn = null;
//单例模式返回数据库连接
public static Connection getConnection() throws Exception
{
if(conn == null)
{
conn = DriverManager.getConnection(url, username, password);
return conn;
}
else
{
return conn;
}
}
}import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
public class ReadDBPage {
/**
* @param pageNo 表示第几页
* @param pageSize 表示每页的数量
* @return
*/
public List query(int pageNo, int pageSize) {
//计算起始值,比如假如每页条数为5,第一页是0 - 4,第二页是5 - 9;。。。。
int pageStart = (pageNo - 1) * pageSize;
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
String sql = " select * from compare limit ?,?; ";
List mapList = new ArrayList();
try {
conn = DBHelper.getConnection();
stmt = conn.prepareStatement(sql);
//把参数设置到 ?号里面
stmt.setInt(1, pageStart);
stmt.setInt(2, pageSize);
rs = stmt.executeQuery();
while (rs.next()) {
mapList.add(rs.getString("id"));
}
return mapList;
} catch (Exception e) {
e.printStackTrace();
return null;
} finally {
if (rs != null) {
try {
rs.close();
rs = null;
} catch (Exception e) {
e.printStackTrace();
}
}
if (stmt != null) {
try {
stmt.close();
stmt = null;
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
}import java.util.List;
public class Bootstrap {
public static void main(String args[]){
ReadDBPage read = new ReadDBPage();
//查询第1页的数据,每页数据为5条
List strList = read.query(1,5);
//查询第2页的数据,每页数据为5条
List strList2 = read.query(2,5);
//查询第2页的数据,每页数据为4条
List strList3 = read.query(2,4);
System.out.println(strList);
System.out.println(strList2);
System.out.println(strList3);
}
}
还拿你昨天的数据库举例
运行结果为