JavaWeb中增删改的优化方式

MYSQL增删改查重复代码简化

1.使用 @Before @After 将重复代码聚合

 private  Connection connection;
    private  String sql;
    @Before
    public void into() throws Exception {
        connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/bailiban","root","123456");
    }

    @Test
    public void testAdd() throws Exception {

        sql = "insert into bailiban.hero VALUES (null,'哈哈','男',16)";
    }
 @Test
    public void testUpdate() throws SQLException {

            sql = "update bailiban.hero set age = 13 where name = '露娜'";
        }
 @Test
    public void testDelete() throws SQLException {

         sql ="delete from bailiban.hero where id = 3";

    }
   @After
    public  void end() throws Exception {

       Statement statement = connection.createStatement();
       int i = statement.executeUpdate(sql);
       System.out.println(i);

       statement.close();
       connection.close();

   }

}

2.创建工具类

 public static void main(String[] args) throws Exception {
      
    }


    public static void upDate(String sql) throws Exception {

        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bailiban", "root", "123456");
        Statement stat = conn.createStatement();
        int i = stat.executeUpdate(sql);
        System.out.println(i);

        stat.close();
        conn.close();


    }
    public static void queryOne(String sql) throws Exception {

        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bailiban", "root", "123456");
        Statement stat = conn.createStatement();
        ResultSet query = stat.executeQuery(sql);
        if (query.next()){
            String id = query.getString("id");
            String name = query.getString("name");
            String sex = query.getString("sex");
            String age = query.getString("age");
            System.out.println(id+"--"+name+"--"+sex+"--"+age);
        }
        System.out.println(query.next());
        stat.close();
        conn.close();
    }

    public static void queryMore(String sql) throws Exception {

        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bailiban", "root", "123456");
        Statement stat = conn.createStatement();
        ResultSet query = stat.executeQuery(sql);
        while (query.next()){
            String id = query.getString("id");
            String name = query.getString("name");
            String sex = query.getString("sex");
            String age = query.getString("age");
            System.out.println(id+"--"+name+"--"+sex+"--"+age);
        }
        System.out.println(query.next());
        stat.close();
        conn.close();
    }
}