一、题目需求
实现总共分三页,每页展示三条数据
1.1 原始表
二、代码展示
@Test
public void query() throws SQLException {
Connection c = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb","root","");
Statement s = c.createStatement();
for (int i = 0; i <3; i++) {
String sql=String.format("SELECT emp.`name` FROM emp ORDER BY id asc LIMIT %d,3",(i+1)*3-3);
// String sql=String.format("SELECT emp.`name` FROM emp ORDER BY id asc LIMIT 3");
ResultSet rs = s.executeQuery(sql);
System.out.println("第"+(i+1)+"页");
while (rs.next()){
String name1 = rs.getString("name");
System.out.println(name1);
}
System.out.println();
}
}
三、运行结果展示