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

xredman

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();}}}