在应用程序中嵌入数据库功能

package lius.demo.hsqldb;
/* 
 * Created on 2003-10-5 by Liudong 
 * /
import java.io.*;
import java.sql.*;
import org.hsqldb.*;
/** 
 * HSQLDB数据库引擎测试类 
 * @author Liudong 
 */
 
public class HsqldbDemo {
  //数据库名称
  public final static String DATABASE_NAME = "hsqltest";
  //数据库端口缺省为9001	
  public final static int PORT = 9001;
	
  /**	 
   * 测试程序入口	 
   * @param args	 
   * @throws Exception	 
   */
   
  public static void main(String[] args) throws Exception {
    String path = "data";
    File f = new File(path);
    if(!f.exists())
      f.mkdirs();
    HsqlDBManager hsqldb = new HsqlDBManager(path);
    hsqldb.setDatabaseName(DATABASE_NAME);
    hsqldb.setPort(PORT);
    new Thread(hsqldb).start();
    System.out.println("数据库服务已启动");
		
    //开始测试
    Connection conn = null;
    PreparedStatement ps = null;
    ResultSet rs = null;
    String sql = null;
    try{
      //连接数据库
      Class.forName("org.hsqldb.jdbcDriver");
      conn = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost","sa","");
      //创建表
      sql = "CREATE TABLE USER(ID INTEGER,NAME VARCHAR(50),MOBILE CHAR(12))";
      ps = conn.prepareStatement(sql);
      ps.executeUpdate();
      //插入数据
      sql = "INSERT INTO user VALUES(?,?,?)";
      ps = conn.prepareStatement(sql);
      ps.setInt(1, 1);
      ps.setString(2, "Winter Lau");
      ps.setString(3,"13912345678");
      ps.executeUpdate();
      //查询数据	
      ps = conn.prepareStatement("SELECT * FROM user");
      rs = ps.executeQuery();
      while(rs.next()){
        System.out.println("ID:"+rs.getInt("id"));
        System.out.println("NAME:"+rs.getString("name"));
	System.out.println("MOBILE:"+rs.getString("mobile"));
      }
    }
    finally{
      if(rs!=null)
        rs.close();
      if(ps!=null)
        ps.close();
      if(conn!=null)
        conn.close();
    }
		
    //退出程序
    System.exit(0);
  }
}
/** 
 * 数据库服务线程 
 * @author Liudong 
 */
class HsqlDBManager implements Runnable {
  String dataPath;
  String databaseName = "test";
  int port = -1;
  
  /**	 
   * 构造函数，需要一个数据路径的参数	 
   * 该参数必须为物理存在的路径	 
   * @param dataPath	 
   */
 
  public HsqlDBManager(String dataPath) {	
    this.dataPath = dataPath;
    if(!this.dataPath.endsWith(File.separator))
      this.dataPath += File.separator;
    this.dataPath += databaseName;
  }
  /
   * 线程入口	 
   * @see java.lang.Runnable#run()	 
   */
 
  public void run() {
    String[] args = null;
    if(port!=-1)
      args = new String[]{"-database",dataPath,"-port",port+""};
    else
      args = new String[]{"-database",dataPath};
  
    //调用HSQLDB的服务入口
    Server.main(args);
  }
	
  public String getDatabaseName() {
    return databaseName;
  }
  public String getDataPath() {
    return dataPath;
  }
	
  public void setDatabaseName(String string) {	
    databaseName = string;
  }
	
  public void setDataPath(String string) {
    dataPath = string;
  }
	
  public int getPort() {
    return port;
  }
	
  public void setPort(int i) {	
    port = i;
  }
}

数据库服务已启动
server.properties not found, using command line or default properties
Opening database: data\\test
HSQLDB server 1.7.1 is running
Use SHUTDOWN to close normally. Use [Ctrl]+[C] to abort abruptly
Tue Oct 14 10:34:52 CST 2003 Listening for connections ...
ID:1
NAME:Winter Lau
MOBILE:13912345678