package?connDB;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.SQLException;
public?class?connJXDB1?{
private?Connection?conn?=?null;
	
	/***?創(chuàng)建連接??***/
	/***?無參連接?****/
	private?void?createConn（）
	{		
		String?driver?=?“oracle.jdbc.driver.OracleDriver“;
		String?url=“jdbc:oracle:thin:@210.35.205.10:1521:jxdb1“;
		String?userName?=?“g0310“;
		String?passWord?=?“p888888“;
		if?（conn?==?null）
		{
			try?{
				Class.forName（driver）;
				conn=DriverManager.getConnection（urluserNamepassWord）;?				
				System.out.println（“數(shù)據(jù)庫連接成功！“）;
			????}?
			catch?（ClassNotFoundException?e）?{
				e.printStackTrace（）;
			????}?
			catch?（SQLException?e）?{
				System.out.println（“數(shù)據(jù)庫連接失敗！“）;
				e.printStackTrace（）;
			????}??
		}		
	}
	/***?帶參數(shù)連接****/
	/*?private?void?createConn（String?userString?pass）
	{			
		String?driver?=?“oracle.jdbc.driver.OracleDriver“;
		String?url=“jdbc:oracle:thin:@192.168.11.4:1521:shopDB“;
		if?（conn?==?null）
		{
			try?{
				Class.forName（driver）;
				conn?=?DriverManager.getConnection（urluserNamepassWord）;
				System.out.println（“數(shù)據(jù)庫連接成功！“）;
			????}?
			catch?（ClassNotFoundException?e）?{
				e.printStackTrace（）;
			????}?
			catch?（SQLException?e）?{
				System.out.println（“數(shù)據(jù)庫連接失敗！“）;
				e.printStackTrace（）;
			????}??
		}??*/
	
	/***獲取連接***/
	public?Connection?getConn（）{
		if?（conn?==?null）?{
			createConn（）;
			System.out.println（“鏈接成功“）;
		}
		return?conn;
	}

????/***?提交事務(wù)?***/
	?public?void?commitConn（）
	?{
		try?{
			conn.commit（）;			
		}?catch?（SQLException?e）{
			System.out.println（“提交異常！“）;
		}
	?}
	?
	?/***?回滾事務(wù)?***/
	?public?void?rollbackConn（）
	?{
		try?{
			conn.rollback（）;			
		}?catch?（SQLException?e）{
			System.out.println（“提交異常！“）;
		}
	?}
	?
	?/***?關(guān)閉連接?***/
	?public?void?closeConn（）
	?{
		try?{
			conn.close（）;
			conn?=?null;
		}?catch?（SQLException?e）{
			e.printStackTrace（）;
		}
	?}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-05-03?16:53??PRJg0310\
?????文件?????????431??2011-02-10?08:07??PRJg0310\.classpath
?????目錄???????????0??2013-05-17?12:01??PRJg0310\.myeclipse\
?????文件?????????288??2013-05-05?09:04??PRJg0310\.mymetadata
?????文件????????1411??2013-04-10?11:32??PRJg0310\.project
?????目錄???????????0??2013-05-03?16:53??PRJg0310\.settings\
?????文件?????????500??2013-04-10?11:31??PRJg0310\.settings\.jsdtscope
?????文件?????????330??2013-04-10?11:31??PRJg0310\.settings\org.eclipse.jdt.core.prefs
?????文件??????????49??2013-04-10?11:31??PRJg0310\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2013-04-10?11:31??PRJg0310\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2013-05-08?23:34??PRJg0310\WebRoot\
?????目錄???????????0??2013-05-03?16:53??PRJg0310\WebRoot\BDMESSAGE\
?????文件????????2484??2013-02-01?11:21??PRJg0310\WebRoot\BDMESSAGE\frmBDMESSAGE.jsp
?????文件????????1938??2013-02-14?14:46??PRJg0310\WebRoot\BDMESSAGE\frmBDMESSAGEDel.jsp
?????文件????????2836??2013-02-14?14:46??PRJg0310\WebRoot\BDMESSAGE\frmBDMESSAGEIns.jsp
?????文件????????1140??2013-05-09?18:55??PRJg0310\WebRoot\BDMESSAGE\frmBDMESSAGEPub.jsp
?????文件????????2844??2013-02-14?14:47??PRJg0310\WebRoot\BDMESSAGE\frmBDMESSAGEUpt.jsp
?????目錄???????????0??2013-05-03?16:53??PRJg0310\WebRoot\BDMESSAGERERLY\
?????文件????????2541??2013-04-26?10:43??PRJg0310\WebRoot\BDMESSAGERERLY\frmBDMESSAGERERLY.jsp
?????文件????????1974??2013-04-26?10:37??PRJg0310\WebRoot\BDMESSAGERERLY\frmBDMESSAGERERLYDel.jsp
?????文件????????3176??2013-02-14?14:52??PRJg0310\WebRoot\BDMESSAGERERLY\frmBDMESSAGERERLYIns.jsp
?????文件????????1294??2013-05-09?18:55??PRJg0310\WebRoot\BDMESSAGERERLY\frmBDMESSAGERERLYPub.jsp
?????文件????????3175??2013-04-26?10:34??PRJg0310\WebRoot\BDMESSAGERERLY\frmBDMESSAGERERLYUpt.jsp
?????目錄???????????0??2013-05-03?16:53??PRJg0310\WebRoot\CUSTOMER\
?????文件????????2475??2013-05-03?08:37??PRJg0310\WebRoot\CUSTOMER\frmCUSTOMER.jsp
?????文件????????1933??2013-05-03?10:07??PRJg0310\WebRoot\CUSTOMER\frmCUSTOMERDel.jsp
?????文件????????3839??2013-05-03?08:57??PRJg0310\WebRoot\CUSTOMER\frmCUSTOMERIns.jsp
?????文件????????1405??2013-05-09?19:05??PRJg0310\WebRoot\CUSTOMER\frmCUSTOMERPub.jsp
?????文件????????3862??2013-05-03?08:57??PRJg0310\WebRoot\CUSTOMER\frmCUSTOMERUpt.jsp
?????目錄???????????0??2013-05-09?15:34??PRJg0310\WebRoot\FOOD\
?????文件????????2439??2013-04-28?08:39??PRJg0310\WebRoot\FOOD\frmFOOD.jsp
............此處省略1679個文件信息