dbconnection.java

模仿腾讯QQ的

package com.softfz.jn0708.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.softfz.jn0708.util.Tools;


/**
 *   数据库连接操作类
 */

public class DBConnection{	
	

	  private static Connection con = null;//连接对象	  
	  
	  public static Connection Connect(){
		  
		/**
		 * 数据库连接函数，回返一个Connection对象
		 */
			Tools tools = new Tools();
			String url = Tools.properties.getProperty("URL").trim();
			try{
				
				Class.forName(tools.properties.getProperty("Driver").trim());			
				con = DriverManager.getConnection(url, tools.properties
						.getProperty("UName").trim(), tools.properties
						.getProperty("UPwd").trim());

			} catch (ClassNotFoundException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			} catch (SQLException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
			
			return con;		
	  
       }	  
	  /**
	   * 关闭connection连接
	   */
		public static void Close(Connection con) {
			if (con != null) {
				try {
					con.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
				con = null;
			}

		}
		/**
		 * 关闭PreparedStatement对象
		 * @param ps PreparedStatement对象
		 */
		public static void Close(PreparedStatement ps) {
			if (ps != null) {
				try {
					ps.close();
				} catch (SQLException e) {
					// TODO 自动生成 catch 块
					e.printStackTrace();
				}
				ps = null;
			}
		}
		/**
		 * 关闭resultset
		 * @param rs 结果集
		 */
		public static void Close(ResultSet rs) {
			if (rs != null) {
				try {
					rs.close();
				} catch (SQLException e) {
					// TODO 自动生成 catch 块
					e.printStackTrace();
				}
				rs = null;
			}
		}
		
				
}