HSQL的测试
TestHSQLConn.java
package org.test;
import java.sql.Connection;
import java.sql.DriverManager;
import org.apache.log4j.Logger;
public class TestHSQLConn {
public static Logger log = Logger.getLogger(TestHSQLConn.class);
public static Connection Conn() {
Connection connection = null;
String[] hsqlInfo = ReadProperties.getHSQLINFO();
try {
Class.forName(hsqlInfo[2]);
connection = DriverManager.getConnection(hsqlInfo[3], hsqlInfo[0], hsqlInfo[1]);
connection.setAutoCommit(false);
} catch (Exception e) {
log.error("ERROR: failed to load HSQLDB JDBC driver."+e);
}
return connection;
}
}
TestHSQLQuery.java
package org.test;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class TestHSQLQuery {
public static void query() {
Connection conn = TestHSQLConn.Conn();
String selSQL = "select ID,FIRSTNAME,LASTNAME,STREET,CITY from CUSTOMER ";
try {
PreparedStatement pstmt = conn.prepareStatement(selSQL);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
System.out.println(rs.getString(1) + " " + rs.getString(2)
+ " " + rs.getString(3) + " " + rs.getString(4) + " "
+ rs.getString(5));
}
rs.close();
pstmt.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/**
*
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
query();
}
}