jdbcutil.java

java电信经典-学习例子源代码

package netctoss.jdbc;

/**
 * @author tiantian
 *
 * Jun 11, 2008 10:53:42 PM
 */

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

/**
 *	Jdbc工具包
 */
public class JdbcUtil {
	//1加载
	private static Properties prop;
	   static{
		    prop = new Properties();
			try {
				InputStream in = new JdbcUtil().getClass().getClassLoader().getResourceAsStream("dbinfo.prop");
//				InputStream in = new FileInputStream("dbinfo.prop");
				prop.load(in);
			} catch (FileNotFoundException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
	     
	   }
	   //2连接数据库
	   public static Connection getConnection(){
		   Connection con = null;
		   try {

				Class.forName(prop.getProperty("driver"));
				con = DriverManager.getConnection(prop.getProperty("url"), prop
						.getProperty("user"), prop.getProperty("pwd"));
			} catch (ClassNotFoundException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			return con;

		}
	
	   //3释放数据库资源
	   public static void release(ResultSet rs,Statement stmt,Connection con){
	     if(rs!=null){
		   try{
			 rs.close();
		   }catch(SQLException e){
		     e.printStackTrace();
		   }
		 }
		 if(stmt!=null){
		   try{
			 stmt.close();
		   }catch(SQLException e){
		     e.printStackTrace();
		   }
		 }
	     if(con!=null){
		   try{
			 con.close();
		   }catch(SQLException e){
		     e.printStackTrace();
		   }
		 }
	   }
	   public static void release(Object o){
	     if(o instanceof ResultSet){
		   try{
		      ((ResultSet)o).close();
		   }catch(SQLException e){
		      e.printStackTrace();
		   }
		 }else if(o instanceof Statement){
		   try{
		      ((Statement)o).close();
		   }catch(SQLException e){
		      e.printStackTrace();
		   }
		 }else if(o instanceof Connection){
		   try{
		      ((Connection)o).close();
		   }catch(SQLException e){
		      e.printStackTrace();
		   }
		 }
	   }
	  
}