package?JavaBean;

import?java.io.PrintWriter;
import?java.sql.*;

public?class?DB_Conn{
	//JDBC驅動程序名
	private?String?driverName=“com.mysql.jdbc.Driver“;
	//數據庫用戶名
	private?String?userName=“root“;
	private?String?userPwd=“110109“;
	//數據庫名
	private?String?dbname=“shop“;
	//數據庫連接字符串
	private?String?url=“jdbc:mysql://localhost/“+dbname+“?user=“+userName+“&password=“+userPwd;
	//數據庫連接對象
	private?Connection?conn=null;
	//數據庫語句對象
	public?Statement?sm=null;
	private?PrintWriter?out?=null;
	//建立數據庫連接函數
	public?void?ConnectDB（）{
		try{
			Class.forName（driverName）.newInstance（）;//實例化
			conn=DriverManager.getConnection（url）;//獲取數據庫連接
			sm=conn.createStatement（）;
		}
		catch（Exception?e）{
			e.printStackTrace（）;
			out.print（“數據庫連接失敗！“）;
		}
	}
	public?void?closeDB（）{
		try{
			if（sm!=null）{
				sm.close（）;
			}
			conn.close（）;
		}
		catch（SQLException?SqlE）{
			SqlE.printStackTrace（）;
			out.print（“數據庫連接失敗！“）;
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????8019??2010-07-02?02:48??Mgory\ch15\check_out.jsp

?????文件???????3663??2010-07-02?01:34??Mgory\ch15\confagain.jsp

?????文件???????6554??2010-07-02?01:26??Mgory\ch15\confirm.jsp

?????文件?????676693??2009-11-29?16:30??Mgory\ch15\data\mysqljdbc5.1.5.jar

?????文件????9966033??2009-11-29?16:56??Mgory\ch15\data\mysql圖形界面.rar

?????文件????????542??2010-07-02?23:13??Mgory\ch15\data\readme.txt

?????文件??????14514??2010-07-02?22:43??Mgory\ch15\data\shop.sql

?????文件???????2676??2010-07-01?17:08??Mgory\ch15\goods_list.jsp

?????文件???????2588??2010-03-23?19:30??Mgory\ch15\goods_manage\add_goods.jsp

?????文件????????837??2010-03-23?19:30??Mgory\ch15\goods_manage\delete_confirm.jsp

?????文件????????360??2010-03-23?19:30??Mgory\ch15\goods_manage\delete_goods.jsp

?????文件????????642??2010-03-23?19:30??Mgory\ch15\goods_manage\finish_order.jsp

?????文件???????1852??2010-03-23?19:30??Mgory\ch15\goods_manage\modify_goods.jsp

?????文件????????385??2010-03-23?19:30??Mgory\ch15\goods_manage\public.jsp

?????文件???????4339??2010-07-01?21:56??Mgory\ch15\goods_manage\query_goods_list.jsp

?????文件???????3248??2010-03-23?19:30??Mgory\ch15\goods_manage\query_result.jsp

?????文件???????2451??2010-03-23?19:30??Mgory\ch15\goods_manage\submit_infor.jsp

?????文件???????1971??2010-04-22?21:31??Mgory\ch15\goods_manage\submit_mod.jsp

?????文件???????4889??2010-07-01?23:46??Mgory\ch15\goods_query\combo_query.jsp

?????文件??????10439??2010-07-02?00:05??Mgory\ch15\goods_query\combo_query_do.jsp

?????文件???????3679??2010-07-02?00:01??Mgory\ch15\goods_query\fuzzy_query.jsp

?????文件???????6528??2010-07-02?00:01??Mgory\ch15\goods_query\fuzzy_query_do.jsp

?????文件????????385??2010-03-23?19:30??Mgory\ch15\goods_query\public.jsp

?????文件???????2076??2010-03-23?19:30??Mgory\ch15\goods_query\Random.jsp

?????文件???????6468??2010-07-02?02:47??Mgory\ch15\goods_show.jsp

?????文件???????1439??2010-03-23?19:30??Mgory\ch15\goods_sort\add_type.jsp

?????文件????????849??2010-03-23?19:30??Mgory\ch15\goods_sort\delete_confirm_type.jsp

?????文件????????350??2010-03-23?19:30??Mgory\ch15\goods_sort\delete_tye.jsp

?????文件???????1093??2010-03-23?19:30??Mgory\ch15\goods_sort\modify_type.jsp

?????文件????????385??2010-03-23?19:30??Mgory\ch15\goods_sort\public.jsp

............此處省略365個文件信息