package?org.pan.util;

import?java.sql.*;

/**
?*?title:???????數據庫連接管理器
?*?Description:
?*?Copyright:????Copyright?（c）?2003
?*?Company:??????多智能網絡有限公司
?*?@author:		?siny?pan
?*?@version?1.0
?*/

public?class?DBConnectionManager?{
????
	//Oracle
	/*
????private?String?driverName?=?“oracle.jdbc.driver.OracleDriver“;?
????private?String?url?=?“jdbc:oracle:thin:@localhost:1521:book“;??
????private?String?user?=?“book“;
????private?String?password?=?“book“;
	*/


	//SQLServer
	/*
	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“;
	*/
	
	//MySql
????private?String?driverName?=?“oracle.jdbc.driver.OracleDriver“;?
????private?String?url?=?“jdbc:oracle:thin:@localhost:1521:dbhouse“;??
????private?String?user?=?“book“;
????private?String?password?=?“book“;

????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）;
????????}
????????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（1））;
				System.out.print（“\tpassword:?“+rs.getString（2））;
				System.out.println（）;
		????}
			//stmt.executeUpdate（?“insert?into?my.txt?values?（‘Ruby‘27‘網絡部‘）“）;		????//*/
		}catch（Exception?e）{
		????e.printStackTrace（）;
		}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-05-19?19:54??book\
?????文件????????7341??2005-02-04?22:15??book\booklist.jsp
?????文件??????????56??2003-02-20?09:11??book\books.css
?????目錄???????????0??2013-05-05?15:20??book\dbfile\
?????文件????????8192??2005-03-28?22:32??book\dbfile\book.dmp
?????文件????????3660??2005-03-28?22:32??book\dbfile\bookdatabase.sql
?????文件?????????322??2003-02-18?10:26??book\errorpge.jsp
?????目錄???????????0??2013-05-05?17:02??book\images\
?????文件???????14683??2003-02-13?08:48??book\images\baners.gif
?????文件???????12352??2003-02-13?08:49??book\images\baners2.gif
?????文件????????7555??2003-02-13?08:48??book\images\baobei[1].gif
?????文件???????57543??2008-11-04?18:39??book\images\header.jpg
?????文件????????7491??2003-02-13?09:09??book\images\hjh_120x60[1].gif
?????文件????????6442??2003-02-13?08:48??book\images\Img20625.jpg
?????文件????????2432??2003-02-13?08:48??book\images\it_button_3.gif
?????文件????????2806??2003-02-13?09:30??book\images\javabeans.gif
?????文件????????6881??2003-02-13?08:48??book\images\nba12060.gif
?????文件????????5019??2003-02-13?08:48??book\images\qrjbutton.gif
?????文件???????35840??2005-02-04?19:49??book\images\Thumbs.db
?????文件?????????683??2003-02-13?09:30??book\images\v3_sun_logo.gif
?????文件????????5440??2013-05-05?17:04??book\index.jsp
?????文件????????3542??2005-02-04?22:15??book\login.jsp
?????目錄???????????0??2013-05-05?15:20??book\manage\
?????文件????????5622??2005-02-04?22:15??book\manage\addbook.jsp
?????文件????????5158??2005-02-04?22:15??book\manage\booklist.jsp
?????文件??????????54??2003-02-19?15:38??book\manage\books.css
?????文件????????1003??2003-02-23?17:24??book\manage\error.htm
?????文件????????5694??2005-02-04?22:15??book\manage\indentlist.jsp
?????文件????????2869??2005-02-04?22:15??book\manage\login.jsp
?????文件??????????91??2003-02-23?16:54??book\manage\logout.jsp
?????文件????????4120??2005-02-04?22:15??book\manage\main.jsp
............此處省略76個文件信息