hsqldb使用
标签：
hsqldb使用
static void main(String[] args) throws SQLException {
try {
Class.forName("org.hsqldb.jdbc.JDBCDriver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Connection conn = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost/my", "sa", "");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select id, firstname, lastname from customer");
while (rs.next()) {
System.out.println("id: " + rs.getInt("id"));
System.out.println("firstname: " + rs.getString("firstname"));
System.out.println("lastname: " + rs.getString("lastname"));
}
}
/*
id: 1
firstname: Asn
lastname: Judy
*/