package example;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

/**
 * 使用Advanced module中的 db.h2.H2Initer 来初始化数据库
 * 或者,直接执行 Advanced module中的 db.h2.H2Initer 下的 Init.sql
 */
public class H2DbHelper {
 public static final String H2_DRIVER = "org.h2.Driver";
 public static final String JDBC_URL = "jdbc:h2:~/h2/h2demo;AUTO_SERVER=TRUE";

 Connection connection;

 public Connection getConnection() throws SQLException {
 if (connection == null || connection.isClosed()) {
 try {
 Class.forName(H2_DRIVER);
 } catch (ClassNotFoundException e) {
 e.printStackTrace();
 }
 connection = DriverManager.getConnection(JDBC_URL, "sa", "");
 }
 return connection;
 }
}