package?org.pan.util;

import?java.sql.*;

/**
?*?title:???????數(shù)據(jù)庫連接管理器
?*?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?=?“WageManager“;
????private?String?password?=?“WageManager“;

????private?String?driverName=“sun.jdbc.odbc.JdbcOdbcDriver“;
????private?String?url?=?“jdbc:odbc:WageSystem“;
?
????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?admin“）;
		????
			
		//	stmt?=?conn.createStatement（）;

		????while（rs.next（））{
				??System.out.print（“登陸帳號:?“+rs.getString（0））;
				??System.out.print（“\tpassword:?“+rs.getString（1））;
				??System.out.println（）;
		????}
			//stmt.executeUpdate（?“insert?into?my.txt?values?（‘Ruby‘27‘網(wǎng)絡(luò)部‘）“）;		????//*/
		??}catch（Exception?e）{
		????e.printStackTrace（）;
		??}
????}
}		//stmt.executeUpdate（?“insert?into?my.txt?values?（‘Ruby‘27‘網(wǎng)絡(luò)部‘）“）;		????//*/

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

?????文件?????315392??2008-07-14?17:05??WagesManageSystem\data\WageManage.mdb

?????文件???????5885??2008-07-13?07:29??WagesManageSystem\employeeAdd.jsp

?????文件???????6344??2008-07-13?11:48??WagesManageSystem\employeeManage.jsp

?????文件???????6490??2008-07-14?10:31??WagesManageSystem\employeeModify.jsp

?????文件???????1915??2008-07-14?11:13??WagesManageSystem\index.jsp

?????文件???????4243??2008-07-15?12:23??WagesManageSystem\leaveAdd.jsp

?????文件???????6280??2008-07-14?10:17??WagesManageSystem\leaveManage.jsp

?????文件???????4825??2008-07-15?12:35??WagesManageSystem\leaveModify.jsp

?????文件???????2307??2008-07-14?16:47??WagesManageSystem\login.jsp

?????文件???????2318??2008-07-14?16:46??WagesManageSystem\login.jsp.bak

?????文件????????164??2008-07-14?11:11??WagesManageSystem\logout.jsp

?????文件???????5521??2008-07-14?10:37??WagesManageSystem\salaryAdd.jsp

?????文件???????6991??2008-07-14?11:23??WagesManageSystem\salaryManage.jsp

?????文件???????6520??2008-07-14?11:03??WagesManageSystem\salaryModify.jsp

?????文件???????4182??2008-07-13?07:11??WagesManageSystem\showemployee.jsp

?????文件???????4577??2008-07-14?11:02??WagesManageSystem\showSalary.jsp

?????文件???????2159??2008-07-11?18:08??WagesManageSystem\WEB-INF\classes\org\pan\util\DBConnectionManager.class

?????文件???????1321??2008-07-11?18:08??WagesManageSystem\WEB-INF\classes\org\pan\util\strFormat.class

?????文件???????1673??2008-07-13?12:18??WagesManageSystem\WEB-INF\classes\org\pan\web\Database.class

?????文件???????2501??2008-07-12?19:42??WagesManageSystem\WEB-INF\classes\org\pan\web\employee.class

?????文件???????9480??2008-07-14?10:29??WagesManageSystem\WEB-INF\classes\org\pan\web\employeeManage.class

?????文件???????1712??2008-07-13?20:52??WagesManageSystem\WEB-INF\classes\org\pan\web\leave.class

?????文件???????7694??2008-07-13?22:03??WagesManageSystem\WEB-INF\classes\org\pan\web\leaveManage.class

?????文件???????1693??2008-07-13?12:17??WagesManageSystem\WEB-INF\classes\org\pan\web\login.class

?????文件???????2991??2008-07-13?19:33??WagesManageSystem\WEB-INF\classes\org\pan\web\salary.class

?????文件??????10544??2008-07-14?11:20??WagesManageSystem\WEB-INF\classes\org\pan\web\salaryManage.class

?????文件???????2436??2008-07-11?15:50??WagesManageSystem\WEB-INF\java_src\org\pan\util\DBConnectionManager.java

?????文件???????2869??2007-12-24?10:29??WagesManageSystem\WEB-INF\java_src\org\pan\util\strFormat.java

?????文件???????1528??2008-07-13?12:18??WagesManageSystem\WEB-INF\java_src\org\pan\web\Database.java

?????文件???????3112??2008-07-13?12:26??WagesManageSystem\WEB-INF\java_src\org\pan\web\employee.java

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