Java JDBC 工具类：简化数据库操作

以下是一个简单的JDBC工具类的示例：\n\njava\nimport java.sql.Connection;\nimport java.sql.DriverManager;\nimport java.sql.PreparedStatement;\nimport java.sql.ResultSet;\nimport java.sql.SQLException;\n\npublic class JDBCUtils {\n private static final String URL = "jdbc:mysql://localhost:3306/database_name";\n private static final String USERNAME = "username";\n private static final String PASSWORD = "password";\n\n public static Connection getConnection() {\n Connection connection = null;\n try {\n Class.forName("com.mysql.jdbc.Driver");\n connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);\n } catch (ClassNotFoundException | SQLException e) {\n e.printStackTrace();\n } \n return connection;\n }\n\n public static void closeConnection(Connection connection, PreparedStatement preparedStatement, ResultSet resultSet) {\n try {\n if (resultSet != null) {\n resultSet.close();\n }\n if (preparedStatement != null) {\n preparedStatement.close();\n }\n if (connection != null) {\n connection.close();\n }\n } catch (SQLException e) {\n e.printStackTrace();\n }\n }\n}\n\n\n使用该工具类，您可以获取数据库连接和关闭连接。示例如下：\n\njava\nConnection connection = JDBCUtils.getConnection();\nPreparedStatement preparedStatement = connection.prepareStatement("SELECT * FROM table_name");\nResultSet resultSet = preparedStatement.executeQuery();\n\nwhile (resultSet.next()) {\n // 处理结果集\n}\n\nJDBCUtils.closeConnection(connection, preparedStatement, resultSet);\n\n\n请注意，您需要将URL，USERNAME和PASSWORD替换为您自己的数据库连接信息。