package?com.billzsoft.dbHelper;

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

/**
?*?@description?外網(wǎng)mas數(shù)據(jù)庫映射地址
?*?@class?DbConnection
?*?@author?YHZ
?*?@date?2013-6-24
?*/
public?class?WDbConnection?{

	protected?Connection?conn?=?null;
	protected?PreparedStatement?pst?=?null;
	protected?Statement?st?=?null;
	protected?ResultSet?rs?=?null;
	private?String?username?=?“root“;
	private?String?pwd?=?“root“;
	private?String?jdbcDriver?=?“com.mysql.jdbc.Driver“;
	private?String?dbUrl?=?“jdbc:mysql://61.183.175.17:3306/massi?useUnicode=true&characterEncoding=utf-8“;

	/**
	?*?創(chuàng)建Connection
	?*?
	?*?@return?Connection
	?*/
	public?Connection?getConnection（）?{
		try?{
			Class.forName（jdbcDriver）;
			//?myDB為數(shù)據(jù)庫名
			conn?=?DriverManager.getConnection（dbUrl?username?pwd）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?conn;
	}
	
	/**
	?*?關(guān)閉所有連接
	?*?
	?*?@param?rs
	?*????????????ResultSet
	?*?@param?pst
	?*????????????PreparedStatement
	?*?@param?conn
	?*????????????Connection
	?*/
	public?void?closeAll（ResultSet?rs?PreparedStatement?pst?Connection?conn）?{
		try?{
			if?（rs?!=?null）?{
				rs.close（）;
				rs?=?null;
			}
			if?（pst?!=?null）?{
				pst.close（）;
				pst?=?null;
			}
			if?（conn?!=?null?&&?!conn.isClosed（））?{
				conn.close（）;
				conn?=?null;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}
	
	/**
	?*?關(guān)閉所有連接
	?*?
	?*?@param?rs
	?*????????????ResultSet
	?*?@param?st
	?*????????????Statement
	?*?@param?conn
	?*????????????Connection
	?*/
	public?void?closeAll（ResultSet?rs?Statement?st?Connection?conn）?{
		try?{
			if?（rs?!=?null）?{
				rs.close（）;
				rs?=?null;
			}
			if?（st?!=?null）?{
				st.close（）;
				st?=?null;
			}
			if?（conn?!=?null?&&?!conn.isClosed（））?{
				conn.close（）;
				conn?=?null;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-06-28?02:00??billzPortWR-master\
?????文件?????????528??2013-06-28?02:00??billzPortWR-master\.classpath
?????文件?????????387??2013-06-28?02:00??billzPortWR-master\.project
?????目錄???????????0??2013-06-28?02:00??billzPortWR-master\bin\
?????目錄???????????0??2013-06-28?02:00??billzPortWR-master\bin\com\
?????目錄???????????0??2013-06-28?02:00??billzPortWR-master\bin\com\billzsoft\
?????目錄???????????0??2013-06-28?02:00??billzPortWR-master\bin\com\billzsoft\dbHelper\
?????文件????????2202??2013-06-28?02:00??billzPortWR-master\bin\com\billzsoft\dbHelper\WDbConnection.class
?????目錄???????????0??2013-06-28?02:00??billzPortWR-master\bin\com\billzsoft\read\
?????目錄???????????0??2013-06-28?02:00??billzPortWR-master\bin\com\billzsoft\read\model\
?????文件????????1547??2013-06-28?02:00??billzPortWR-master\bin\com\billzsoft\read\model\SmsServerOut.class
?????目錄???????????0??2013-06-28?02:00??billzPortWR-master\bin\com\billzsoft\send\
?????文件?????????656??2013-06-28?02:00??billzPortWR-master\bin\com\billzsoft\send\WR_frame$1.class
?????文件????????5869??2013-06-28?02:00??billzPortWR-master\bin\com\billzsoft\send\WR_frame.class
?????目錄???????????0??2013-06-28?02:00??billzPortWR-master\bin\com\billzsoft\send\dao\
?????文件????????2645??2013-06-28?02:00??billzPortWR-master\bin\com\billzsoft\send\dao\WDbHelper.class
?????目錄???????????0??2013-06-28?02:00??billzPortWR-master\bin\com\billzsoft\send\model\
?????文件????????2977??2013-06-28?02:00??billzPortWR-master\bin\com\billzsoft\send\model\SmsOutBox.class
?????文件?????????187??2013-06-28?02:00??billzPortWR-master\bin\config.properties
?????文件????????1059??2013-06-28?02:00??billzPortWR-master\bin\gson.txt
?????文件?????????171??2013-06-28?02:00??billzPortWR-master\bin\jdbc.properties
?????目錄???????????0??2013-06-28?02:00??billzPortWR-master\lib\
?????文件???????28043??2013-06-28?02:00??billzPortWR-master\lib\comm.jar
?????文件??????315805??2013-06-28?02:00??billzPortWR-master\lib\commons-lang3-3.1.jar
?????文件??????189285??2013-06-28?02:00??billzPortWR-master\lib\gson-2.2.2.jar
?????文件?????????467??2013-06-28?02:00??billzPortWR-master\lib\javax.comm.properties
?????文件??????709922??2013-06-28?02:00??billzPortWR-master\lib\mysql-connector-java-5.1.7-bin.jar
?????目錄???????????0??2013-06-28?02:00??billzPortWR-master\resource\
?????文件?????????187??2013-06-28?02:00??billzPortWR-master\resource\config.properties
?????文件????????1059??2013-06-28?02:00??billzPortWR-master\resource\gson.txt
?????文件?????????171??2013-06-28?02:00??billzPortWR-master\resource\jdbc.properties
............此處省略14個文件信息