Discuss / Java / executeBatch只能用于更新操作(插入更新删除),不能用于查询吧?

executeBatch只能用于更新操作(插入更新删除),不能用于查询吧?

Topic source

如题

Joker.fu_95

#2 Created at ... [Delete] [Delete and Lock User]

无语

因为查询也不需要用Batch啊。比如查询所有名字以“李”开头的。

比如我从一个学生基本信息表里查询所有姓李的学生:

// 查询所有姓李的学生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

Reply