HSQLDB入门

public class HSQLTest {Connection con = null;@Beforepublic 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);}}@Testpublic 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 blocke.printStackTrace();}}try{String file = "C:/test";//输出file:/C:/testSystem.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");}@Afterpublic void closeServer () {if(con!= null){try {con.close();} catch (SQLException e) {e.printStackTrace();}}}}