day05 jdbc封装

最新推荐文章于 2022-03-06 22:16:44 发布

~_～

最新推荐文章于 2022-03-06 22:16:44 发布

阅读量133

点赞数

本文链接：https://blog.csdn.net/ISTUC/article/details/98966138

版权

JDBC工具类

连接

    public final static String qudong = "com.mysql.jdbc.Driver";
    public final static String url = "jdbc:mysql://localhost/ningda?user=root&password=root";
    public static Connection getConnection(String qudong , String url) throws Exception{
        Class.forName(qudong);
        Connection connection = DriverManager.getConnection(url);
        return connection;
    }

关闭连接

    public static void close(ResultSet resultSet, PreparedStatement preparedStatement ,Connection connection) {
        try {
            if (resultSet != null) {
                resultSet.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        try {
            if (preparedStatement != null) {
                preparedStatement.close();
            }

        } catch (SQLException e) {
            e.printStackTrace();
        }
        try {
            if (connection == null) {

            }else {
                connection.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }