jdbc连接

    @Test
    public void testH2Jdbc() {
        String DRIVER_CLASS = "org.h2.Driver";
        // oracle : jdbc:oracle:thin:127.0.0.1:port:dbname
        // mysql : jdbc:mysql://127.0.0.1:port:dbname
        // h2 : jdbc:h2:~/test
        String JDBC_URL = "jdbc:h2:~/test";
        String USER = "root";
        String PASSWORD = "Changeme_123";

        Connection conn = null;
        // 防止sql注入
        PreparedStatement stmt = null;
        try {
            // 1.加载数据驱动加载H2数据库驱动
            Class.forName(DRIVER_CLASS);
            // 2.获得数据库连接，根据连接URL，用户名，密码获取数据库连接
            conn = DriverManager.getConnection(JDBC_URL, USER, PASSWORD);
            // 3.创建语句
            String deleteSql2 = "SELECT id,name,age FROM USER_INFO WHERE id = ?";
            // 4.返回一个执行sql的句柄,预编译对象
            stmt = conn.prepareStatement(deleteSql2);
            // 5.执行查询sql,并注入sql条件
            stmt.setInt(1, 1);
            ResultSet resultSet = stmt.executeQuery();
            //遍历结果集
            while (resultSet.next()) {
                System.out.println(
                        resultSet.getString("id") + ","
                                + resultSet.getString("name")
                                + "," + resultSet.getString("age"));
            }
        } catch (ClassNotFoundException | SQLException e) {
            log.error("testH2Jdbc execute failed");
        } finally {
            // 6.释放资源
            if (conn != null) {
                try {
                    conn.close();
                    stmt.close();
                } catch (SQLException e) {
                    log.error("conn close error");
                }
            }
        }
    }