package?org.pan.util;

import?java.sql.*;

/**
?*?title:???????數據庫連接管理器
?*?Description:
?*?Copyright:????Copyright?（c）?2003
?*?@author:		?linlin
?*?@version?1.0
?*/

public?class?DBConnectionManager?{
//????private?String?driverName?=?“com.microsoft.jdbc.sqlserver.SQLServerDriver“;??//“oracle.jdbc.driver.OracleDriver“;
//????private?String?url?=?“jdbc:microsoft:sqlserver://localhost:1433“;??//“jdbc:oracle:thin:@127.0.0.1:1521:oracle“;
????private?String?user?=?“bookshop“;
????private?String?password?=?“bookshop“;

????private?String?driverName=“sun.jdbc.odbc.JdbcOdbcDriver“;
????private?String?url?=?“jdbc:odbc:BookShopDB“;
?
????public?void?setDriverName（String?newDriverName）?{
????????driverName?=?newDriverName;
????}
????public?String?getDriverName（）?{
????????return?driverName;
????}
	
????public?void?setUrl（String?newUrl）?{
????????url?=?newUrl;
????}
????public?String?getUrl（）?{
????????return?url;
????}
????public?void?setUser（String?newUser）?{
????????user?=?newUser;
????}
????public?String?getUser（）?{
????????return?user;
????}
????public?void?setPassword（String?newPassword）?{
????????password?=?newPassword;
????}
????public?String?getPassword（）?{
????????return?password;
????}

????public?Connection?getConnection（）?{
????????try?{
????????????Class.forName（driverName）;
????????//????return?DriverManager.getConnection（url?user?password）;
????????????return?DriverManager.getConnection（url）;
????????}
????????catch?（Exception?e）?{
????????????e.printStackTrace（）;
????????????return?null;
????????}
????}

????public?static?void?main（String[]?args）?{
???????//?DBConnectionManager?DBConnectionManager1?=?new?DBConnectionManager（）;


		??try{
		
			??DBConnectionManager?dcm?=?new?DBConnectionManager（）;
			??Connection	conn?=?dcm.getConnection（）;
		????Statement?stmt=conn.createStatement（）;
		????ResultSet?rs=stmt.executeQuery（“select?*?from?my_BookAdminuser“）;
		????
			
		//	stmt?=?conn.createStatement（）;

		????while（rs.next（））{
				??System.out.print（“名稱:?“+rs.getString（2））;
				??System.out.print（“\tpassword:?“+rs.getString（3））;
				??System.out.println（）;
		????}
			//stmt.executeUpdate（?“insert?into?my.txt?values?（‘Ruby‘27‘網絡部‘）“）;		????//*/
		??}catch（Exception?e）{
		????e.printStackTrace（）;
		??}
????}
}		//stmt.executeUpdate（?“insert?into?my.txt?values?（‘Ruby‘27‘網絡部‘）“）;		????//*/

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-06-02?17:48??基本javabean技術的網絡書店系統\
?????目錄???????????0??2012-06-09?23:27??基本javabean技術的網絡書店系統\bookshop\
?????文件????????5738??2012-06-10?20:11??基本javabean技術的網絡書店系統\bookshop\bookdatabase.sql
?????文件????????7280??2012-06-03?19:19??基本javabean技術的網絡書店系統\bookshop\booklist.jsp
?????文件??????????56??2012-06-05?21:36??基本javabean技術的網絡書店系統\bookshop\books.css
?????文件????????1984??2012-06-07?15:03??基本javabean技術的網絡書店系統\bookshop\bookshop.ldb
?????文件??????630784??2012-06-09?09:40??基本javabean技術的網絡書店系統\bookshop\bookshop.mdb
?????文件?????????320??2012-06-03?21:15??基本javabean技術的網絡書店系統\bookshop\errorpge.jsp
?????目錄???????????0??2012-06-05?06:46??基本javabean技術的網絡書店系統\bookshop\images\
?????文件???????14683??2012-06-06?15:04??基本javabean技術的網絡書店系統\bookshop\images\baners.gif
?????文件???????12352??2012-06-09?02:45??基本javabean技術的網絡書店系統\bookshop\images\baners2.gif
?????文件????????7555??2012-06-02?06:36??基本javabean技術的網絡書店系統\bookshop\images\baobei[1].gif
?????文件????????7491??2012-06-10?16:51??基本javabean技術的網絡書店系統\bookshop\images\hjh_120x60[1].gif
?????文件????????5713??2012-06-07?17:40??基本javabean技術的網絡書店系統\bookshop\images\Img20625.jpg
?????文件????????3563??2012-06-03?14:24??基本javabean技術的網絡書店系統\bookshop\images\it_button_3.gif
?????文件????????2806??2012-06-01?19:30??基本javabean技術的網絡書店系統\bookshop\images\javabeans.gif
?????文件????????4906??2012-06-07?17:46??基本javabean技術的網絡書店系統\bookshop\images\nba12060.gif
?????文件????????3433??2012-06-02?22:09??基本javabean技術的網絡書店系統\bookshop\images\qrjbutton.gif
?????文件?????????683??2012-06-10?20:02??基本javabean技術的網絡書店系統\bookshop\images\v3_sun_logo.gif
?????文件????????5353??2012-06-02?11:15??基本javabean技術的網絡書店系統\bookshop\index.jsp
?????文件????????3441??2012-06-08?08:19??基本javabean技術的網絡書店系統\bookshop\login.jsp
?????目錄???????????0??2012-06-02?08:53??基本javabean技術的網絡書店系統\bookshop\manage\
?????文件????????5525??2012-06-01?15:06??基本javabean技術的網絡書店系統\bookshop\manage\addbook.jsp
?????文件????????5050??2012-06-04?03:03??基本javabean技術的網絡書店系統\bookshop\manage\booklist.jsp
?????文件??????????54??2012-06-09?09:21??基本javabean技術的網絡書店系統\bookshop\manage\books.css
?????文件?????????896??2012-06-02?14:24??基本javabean技術的網絡書店系統\bookshop\manage\error.htm
?????文件????????5587??2012-06-08?09:44??基本javabean技術的網絡書店系統\bookshop\manage\indentlist.jsp
?????文件????????2759??2012-06-07?20:40??基本javabean技術的網絡書店系統\bookshop\manage\login.jsp
?????文件??????????91??2012-06-10?11:54??基本javabean技術的網絡書店系統\bookshop\manage\logout.jsp
?????文件????????4003??2012-06-10?19:26??基本javabean技術的網絡書店系統\bookshop\manage\main.jsp
?????文件????????6480??2012-06-01?17:13??基本javabean技術的網絡書店系統\bookshop\manage\modibook.jsp
............此處省略58個文件信息