依賴

<dependency><groupId>org.glassfish.hk2</groupId><artifactId>hk2</artifactId><version>3.0.3</version></dependency>

注：內(nèi)置了JDBC

連接數(shù)據(jù)庫

public static final String DRIVER_CLASS = "org.h2.Driver";public static final String JDBC_URL = "jdbc:h2:D:/log/h2";public static final String USER = "root";public static final String PASSWORD = "root";Class.forName(DRIVER_CLASS);Connection connection = DriverManager.getConnection(JDBC_URL, USER, PASSWORD);

執(zhí)行基本操作

public static final String DRIVER_CLASS = "org.h2.Driver";public static final String JDBC_URL = "jdbc:h2:D:/log/h2";public static final String USER = "root";public static final String PASSWORD = "root";public void simpleCase() {try {log.info("start");Class.forName(DRIVER_CLASS);Connection connection = DriverManager.getConnection(JDBC_URL, USER, PASSWORD);Statement statement = connection.createStatement();statement.execute("drop table if exists user_info");statement.execute("create table user_info(id integer primary key, name VARCHAR(100), SEX varchar(2))");statement.executeUpdate("insert into user_info values(1,'jsq','女')");statement.executeUpdate("insert into user_info values(2,'ad','女')");statement.executeUpdate("insert into user_info values(3,'sddf','男')");statement.executeUpdate("insert into user_info values(4,'sfrfe','男')");ResultSet resultSet = statement.executeQuery("select * from user_info");while (resultSet.next()) {log.info("id is {}, name is {}, sex is {}", resultSet.getInt("id"), resultSet.getString("name"), resultSet.getString("sex"));}statement.close();connection.close();} catch (ClassNotFoundException | SQLException e) {log.info("have a exception, which is {}", e.getMessage());}}

創(chuàng)建數(shù)據(jù)庫連接池

public static final String DRIVER_CLASS = "org.h2.Driver";public static final String JDBC_URL = "jdbc:h2:D:/log/h2";public static final String USER = "root";public static final String PASSWORD = "root";Class.forName(DRIVER_CLASS);JdbcConnectionPool pool = JdbcConnectionPool.create(JDBC_URL, USER, PASSWORD);Connection connection = pool.getConnection();

數(shù)據(jù)庫連接池執(zhí)行SQL語句

public static final String DRIVER_CLASS = "org.h2.Driver";public static final String JDBC_URL = "jdbc:h2:D:/log/h2";public static final String USER = "root";public static final String PASSWORD = "root";public void useConnectionPool() {try {log.info("start");Class.forName(DRIVER_CLASS);JdbcConnectionPool pool = JdbcConnectionPool.create(JDBC_URL, USER, PASSWORD);Connection connection = pool.getConnection();Statement statement = connection.createStatement();statement.execute("drop table if exists user_info");statement.execute("create table user_info(id integer primary key, name VARCHAR(100), SEX varchar(2))");String[] inserts = {"insert into user_info values(1,'jsq','女')", "insert into user_info values(2,'ad','女')", "insert into user_info values(3,'sddf','男')","insert into user_info values(4,'sfrfe','男')"};for (int i = 0; i < 4; i++) {Connection conn = pool.getConnection();conn.createStatement().executeUpdate(inserts[i]);}ResultSet resultSet = pool.getConnection().createStatement().executeQuery("select * from user_info");while (resultSet.next()) {log.info("id is {}, name is {}, sex is {}", resultSet.getInt("id"), resultSet.getString("name"), resultSet.getString("sex"));}} catch (ClassNotFoundException | SQLException e) {log.info("have a exception, which is {}", e.getMessage());}}

總結(jié)

以上是生活随笔為你收集整理的h2数据库学习----h2数据库基本使用的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。