testexecutequerymethod.java

JDBC封装之connectionFactory

package com.passedbylove.database.core.test;

import java.sql.ResultSet;
import java.sql.SQLException;

import static com.passedbylove.database.core.util.Print.println;
import static com.passedbylove.database.core.util.Print.print;
import com.passedbylove.database.core.DBOperationAdapter;

public class TestexecuteQueryMethod {
   /** @param argc */
   public static void main(String[] argc) {
   	DBOperationAdapter dbtools=DBOperationAdapter.getInstance();
   	TestexecuteInsertMethod.main(null);
   	System.out.println("userinfo表中的信息如下");
   	try {
   		ResultSet rs=dbtools.executeQuery("select * from userinfo");
   		while(rs.next()){
   			print(rs.getInt(1)+"\t");
   			print(rs.getString(2)+"\t");
   			print(rs.getString(3)+"\t");
   			print(rs.getDate(4)+"\t");
   			println(rs.getString(5));
   		}
   	} catch (SQLException e) {
   		e.printStackTrace();
   	}
   }

}