预编译版本
package PagingQuery;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class testPaging1 {
public static void main(String[] args) {
list(0, 2);
}
public static void list(int start, int count) {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
//sql语句
String sql = "select * from user limit ?,?";
try (
Connection c = DriverManager.getConnection(
"jdbc:mysql://127.0.0.1:3306/Hero?characterEncoding=UTF-8",
"root",
"123");
//填入SQL语句
PreparedStatement ps = c.prepareStatement(sql);
)
{ //limit 0,5 表示第0条数据开始查询五条包括第0条数据
ps.setInt(1, 0);
ps.setInt(2, 2);
//执行语句
ps.execute();
//得到结果集
ResultSet rs = ps.getResultSet();
while(rs.next()) {
int i = rs.getInt("id");
String name = rs.getString("name");
System.out.printf("%d : %s%n",i,name);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
非预编译版本
package PagingQuery;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class testPaging1 {
public static void main(String[] args) {
list(0, 2);
}
public static void list(int start, int count) {
try {
//
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try (
Connection c = DriverManager.getConnection(
//这是固定格式 数据库名字Hero
"jdbc:mysql://127.0.0.1:3306/Hero?characterEncoding=UTF-8",
"root",
"123");
//非预编译形式
Statement s = c.createStatement();
)
{ //limit 0,5 表示第0条数据开始查询五条包括第0条数据
//sql语句
String sql = "select * from user limit "+start+","+count;
//执行语句
s.execute(sql);
//得到结果集
ResultSet rs = s.getResultSet();
while(rs.next()) {
int i = rs.getInt("id");
String name = rs.getString("name");
System.out.printf("%d : %s%n",i,name);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}