使用hsql内存数据库的一个简单示例

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
/**
 * 参考文章：http://blog.csdn.net/kampan/archive/2008/11/13/3291769.aspx
 * @author Xredman
 *
 */
public class T {

	public static void main(String[] args) {
		try {
			//加载HSQL DB的JDBC驱动
			Class.forName("org.hsqldb.jdbcDriver");
			//在内存中建立数据库idb,用户名为sa,密码为空
			Connection conn = DriverManager.getConnection("jdbc:hsqldb:mem:idb","sa","");
			System.out.println("Link is OK.");
			
			Statement stat = conn.createStatement();
			//新建数据表
			stat.executeUpdate("create table tb1(ID INTEGER, NAME VARCHAR(20))");
			System.out.println("Create is OK!");
			
			//插入数据
			stat.executeUpdate("INSERT INTO tb1 VALUES(1,'Xredman')");
			stat.executeUpdate("INSERT INTO tb1 VALUES(2,'neil')");
			System.out.println("Insert OK!");
			
			//查询数据
			PreparedStatement pstmt = conn.prepareStatement("SELECT * FROM tb1");
			ResultSet rs = pstmt.executeQuery();
			while(rs.next()) {
				String s = null;
				s = rs.getString(1) + " : " + rs.getString(2);
				System.out.println(s);
			}
			System.out.println("SELECT IS OK!");
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}