hsqldb

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;




public class HSQLDB {


	public static void main(String[] args) {

		 try {   
		        Class.forName("org.hsqldb.jdbcDriver" );   
		    } catch (Exception e) {   
		        System.out.println("ERROR: failed to load HSQLDB JDBC driver.");   
		        e.printStackTrace();   
		        return;   
		    }   
		  
		    try {
				Connection conn = DriverManager.getConnection("jdbc:hsqldb:mem:mydb", "sa", "");
				
				conn.createStatement().execute("CREATE TABLE hsql(NAME VARCHAR(30),CODE VARCHAR(6))");
				
				PreparedStatement pstmt = conn.prepareStatement("insert into hsql (NAME,CODE) values('jizhong1','hehe')");

				pstmt.executeUpdate();
				Statement  st = conn.createStatement();      
	            ResultSet  rs = st.executeQuery("select * from hsql");   
	            while(rs.next()){
	            	String s1=rs.getString("name");        
	                System.out.println(s1);    
	            }    
	            st.close();        
//	            st = conn.createStatement();        
//	            st.execute("SHUTDOWN");        
	            conn.close(); 
	                  

				
				
				
			} catch (SQLException e) {
				e.printStackTrace();
			}  
		
	}

}

 

 

 

服务模式：

 

java代码：

 

Connection conn = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost:9001/refresh", "sa", "");

 

建立数据库：

 

 

该模式下HSQLDB跟其他数据库服务器一样，以服务器的形式被启动。

 

通过java -cp ../lib/hsqldb.jar org.hsqldb.Server -database.0 mydb -dbname.0 myDbName之类的命令启动HSQLDB守护进程。

 

jdbc:hsqldb:hsql://localhost:9001/myDbName来访问