properties的读取及HSQL的学习（二）

 

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();

    }

 

}