executeBatch只能用于更新操作(插入更新删除),不能用于查询吧?
Topic source比如我从一个学生基本信息表里查询所有姓李的学生:
// 查询所有姓李的学生String sql = "SELECT * FROM student_base_info WHERE name LIKE '李%'";// 获取PreparedStatement对象PreparedStatement ps = conn.prepareStatement(sql);// 执行SQL语句ResultSet rs = ps.executeQuery();// 遍历结果集while (rs.next()) { System.out.println(rs.getInt("student_id") + " " + rs.getString("name"));}
上面的格式有点乱,整理一下格式
// 查询所有姓李的学生
String sql = "SELECT * FROM student_base_info WHERE name LIKE '李%'";
// 获取PreparedStatement对象
PreparedStatement ps = conn.prepareStatement(sql);
// 执行SQL语句
ResultSet rs = ps.executeQuery();
// 遍历结果集
while (rs.next()) {
System.out.println(rs.getInt("student_id") + " " + rs.getString("name"));
}
- 1
錯別∕"字
如题