一个java嵌入数据库hsql 的web自启动部署

web.xml

============================================

<context-param>
  <param-name>hsql.dbPath</param-name>
  <param-value>/apps/db/</param-value>
 </context-param>

 <context-param>
  <param-name>hsql.dbName</param-name>
  <param-value>mydb</param-value>
 </context-param>

 <context-param>
  <param-name>hsql.port</param-name>
  <param-value>9999</param-value>
 </context-param>

 <listener>
  <listener-class>
   cn.scorpionsoft.distributor.HSQLDBStartListener
  </listener-class>
 </listener>

============================================

HSQLDBStartListener.java

package cn.scorpionsoft.distributor;

import org.hsqldb.Server;

import javax.servlet.ServletContextEvent;
import javax.servlet.ServletContextListener;
import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

/**
 * 自动开启 HSQLDB 服务
 *
 * @author 抽支烟
 *
 */
public class HSQLDBStartListener implements ServletContextListener {

 /**
  * 初始化
  */
 public void contextInitialized(ServletContextEvent sce) {
  String dbName = sce.getServletContext().getInitParameter("hsql.dbName");
  String path = sce.getServletContext().getInitParameter("hsql.dbPath");
  int port = -1;

  try {
   port = Integer.parseInt(sce.getServletContext().getInitParameter(
     "hsql.port"));
  } catch (Exception e) {
   port = 9999;
  }

  if (dbName == null || dbName.equals("")) {
   System.out
     .println("Cant' get hsqldb.dbName from web.xml Context Param");
   return;
  }

  File dbDir = new File(path);

  if (!dbDir.exists()) {
   if (!dbDir.mkdirs()) {
    System.out.println("Can not create DB Dir for Hsql:" + dbDir);
    return;
   }
  }

  if (!path.endsWith("/")) {
   path = path + "/";
  }

  File scriptFile = new File(path + dbName + ".script");
  File propertiesFile = new File(path + dbName + ".properties");

  if (propertiesFile.exists()) {
   this.startServer(path, dbName, port);
   
  } else {
   System.out
     .println("Connect failed:Connect Hsqldb error or database files not exits!");
  }
  
  
 }

 /**
  * 启动 Hsqldb 服务的方法。
  *
  * @param dbPath
  *            数据库路径
  * @param dbName
  *            数据库名称
  * @param port
  *            端口号
  */
 private void startServer(String dbPath, String dbName, int port) {

  Server server = new Server();// 它可是hsqldb.jar里面的类啊。

  server.setDatabaseName(0, dbName);
  server.setDatabasePath(0, dbPath + dbName);

  if (port != -1) {
   server.setPort(port);
  }

  server.setSilent(true);

  server.start();

  System.out.println("HSQLDB started...");
  
 }

/**
  * Listener 销毁方法，在 Web 应用终止的时候执行"shutdown"命令关闭数据库.
  */
 public void contextDestroyed(ServletContextEvent arg0) {
 
  Connection conn = null;
  try {
   Class.forName("org.hsqldb.jdbcDriver");
   conn = DriverManager.getConnection(
     "jdbc:hsqldb:hsql://localhost:9999/mydb", "sa", "");
   Statement stmt = conn.createStatement();
   stmt.executeUpdate("SHUTDOWN;");
  } catch (Exception e) {
   ;
  }
 }
}