example.java

手写的连接池类,实现了数据库的连接池,提高了操作数据库的效率.

package com.cn.test;

import java.util.Hashtable;

import com.cn.db.oracle.DbFactory;

public class Example {
	public static void main(String args[]){
		
		examoracle();
	}
	
	public static void examoracle(){
		
		String sql="select * from bbsmember order by membername";
		//执行为DbFactory.exxcute(sql);return true or false;
		Hashtable[] result=DbFactory.getHashQuery(sql);
		String demo="";
		
		for(int i=0;i<result.length;i++){
			
			demo=(String)result[i].get("MEMBERNAME");
			System.out.println("demo is "+demo);
		}
		System.out.println("result length is"+result.length);
		
	}
}