HSQLDB入门

public class HSQLTest {
	Connection con = null;
	@Before
	public void connectServer (){
		//Connection con = null;
		try{
			Class.forName("org.hsqldb.jdbcDriver");
			//如下方式需要启动hsqldb服务器
			//con = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost/ex", "sa", "");
			//直接以文件的方式访问
			con = DriverManager.getConnection("jdbc:hsqldb:file:/F:/software/Lucence/solr/apache-solr-3.6.1/example/example-DIH/hsqldb/ex", "sa", "");
		}catch (Exception e) {
			System.out.println(e);
		}
	}
	
	@Test
	public void testHSQL(){
		Statement stmt = null;
		try{
			stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery("select * from item");
			
			while(rs.next()){
				String name = rs.getString("name");
				System.out.println(name);
			}
			
			//stmt.close();
		}catch (Exception e) {
			System.out.println(e);
		}finally{
			try {
				stmt.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
		try{
			String file = "C:/test";
			//输出file:/C:/test
			System.out.println(new File(file).toURI().toURL());
			//数据库不存在，创建数据库
			Connection c = DriverManager.getConnection(
		          "jdbc:hsqldb:file:/F:/software/HSQLDB/hsqldb-2.2.9/dbcreatebyjava;ifexists=false", "SA", "");
			stmt = c.createStatement();
			//ResultSet rs = stmt.execute(create table)executeQuery("select * from item");
		}catch(Exception e){
			System.err.println(e);
		}finally{
			
		}
		System.out.println("ee");
	}
	@After
	public void closeServer () {
		if(con!= null){
			try {
				con.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}