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来访问