java - 如何在mysql中一次性执行7条select准备语句？

Question

private void view(HttpServletRequest request , HttpServletResponse response) throws ServletException, IOException{

        String logined_email = (String) session.getAttribute("e-mail");
        data = dbconn.viewMyData(logined_email);
        request.setAttribute("mydata", data);
        RequestDispatcher rd = request.getRequestDispatcher("myData.jsp");
        rd.forward(request, response);
}
public void dbconn() {

        try {
            String JDBC_Driver = "com.mysql.cj.jdbc.Driver";
            Class.forName(JDBC_Driver);
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/connectiondb?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC", "root", "");
        } catch (Exception ex) {
            System.out.println(ex);
        }
    }

public void viewMyData(String login_email_addr){

    dbconn();
    String sql1 = "SELECT * From art_culture WHERE email = ? ";
    String sql2 = "SELECT * From education WHERE email =  ? ";
    String sql3 = "SELECT * From fashion_beauty WHERE email = ? ";
    String sql4 = "SELECT * From food_travel WHERE email = ? "; 
    String sql5 = "SELECT * From health_fitness WHERE email = ? ";
    String sql6 = "SELECT * From literature WHERE email = ? ";
    String sql7 = "SELECT * From nature_wildlife WHERE email = ? ";

}

条件中的电子邮件值对于所有查询都是相同的。view 方法位于 servlet 中，充当 Controller 。viewMyData和dbconn是dbConnection文件中的方法。我在 viewMyData 方法中有这 7 个 sql 准备好的语句，我想执行它们，并且我想在成功执行查询后从数据库获取数据，并将结果发送到 servlet 页面，然后从 servlet 输出将显示在JSP 页面。我该怎么做？

Answer 1

connection.setAutoCommit(false)

停用自动提交，使您能够发送一批所有这些准备好的语句，然后只需创建一个对数据库执行所有这些查询的方法，并在finally block 中将自动提交设置为true。

默认情况下，自动提交使每个事务立即保存在数据库中，通过这种行为，您可以安全地将所有这些查询作为一个原子单元运行