Java通用JDBC SQL查询策略在单元测试中的使用HSQLDB和运行时使用MySQL

<dependency>
    <groupId>org.hsqldb</groupId>
    <artifactId>hsqldb</artifactId>
    <version>2.5.1</version>
    <scope>test</scope>
</dependency>

Connection connection = DriverManager.getConnection("jdbc:hsqldb:mem:testdb", "sa", "");
Statement statement = connection.createStatement();
statement.execute("CREATE TABLE users (id INT, name VARCHAR(100))");
statement.execute("INSERT INTO users (id, name) VALUES (1, 'John')");

Connection connection = DriverManager.getConnection("jdbc:hsqldb:mem:testdb", "sa", "");
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("SELECT * FROM users");
// 处理查询结果

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.26</version>
</dependency>

Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");
Statement statement = connection.createStatement();

ResultSet resultSet = statement.executeQuery("SELECT * FROM users");
// 处理查询结果