package?org.pan.util;

import?java.sql.*;

/**
?*?title:???????????l???????
?*?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?=?“sa“;
????private?String?password?=?“sa“;

????private?String?driverName=“com.microsoft.jdbc.sqlserver.SQLServerDriver“;
????private?String?url?=?“jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=salary“;
?
????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.println（rs.getString（1））;
				??System.out.println（rs.getString（2））;
				??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‘???粿‘）“）;		????//*/

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

?????文件????????552??2010-12-10?20:57??salary\.classpath

?????文件????????291??2010-12-10?20:50??salary\.mymetadata

?????文件???????1224??2010-12-11?01:25??salary\.project

?????文件???????2479??2010-12-11?01:25??salary\src\org\pan\util\DBConnectionManager.java

?????文件???????2869??2010-12-10?20:50??salary\src\org\pan\util\strFormat.java

?????文件???????1391??2010-12-11?10:37??salary\src\org\pan\web\Database.java

?????文件???????2968??2010-12-11?10:37??salary\src\org\pan\web\employee.java

?????文件??????16239??2010-12-11?10:37??salary\src\org\pan\web\employeeManage.java

?????文件???????1887??2010-12-11?10:37??salary\src\org\pan\web\leave.java

?????文件??????10273??2010-12-11?10:36??salary\src\org\pan\web\leaveManage.java

?????文件???????1306??2010-12-11?10:36??salary\src\org\pan\web\login.java

?????文件???????3368??2010-12-11?10:41??salary\src\org\pan\web\salary.java

?????文件??????14909??2010-12-11?10:46??salary\src\org\pan\web\salaryManage.java

?????文件???????5714??2010-12-11?10:13??salary\WebRoot\employeeAdd.jsp

?????文件???????6179??2010-12-11?10:09??salary\WebRoot\employeeManage.jsp

?????文件???????6404??2010-12-11?10:25??salary\WebRoot\employeeModify.jsp

?????文件????????945??2010-12-11?10:08??salary\WebRoot\index.jsp

?????文件???????4071??2010-12-11?10:49??salary\WebRoot\leaveAdd.jsp

?????文件???????6108??2010-12-11?10:30??salary\WebRoot\leaveManage.jsp

?????文件???????4659??2010-12-11?10:26??salary\WebRoot\leaveModify.jsp

?????文件???????2215??2010-12-11?10:04??salary\WebRoot\login.jsp

?????文件???????2318??2010-12-10?20:50??salary\WebRoot\login.jsp.bak

?????文件????????164??2010-12-10?20:50??salary\WebRoot\logout.jsp

?????文件?????????39??2010-12-10?20:50??salary\WebRoot\meta-INF\MANIFEST.MF

?????文件???????5349??2010-12-11?10:27??salary\WebRoot\salaryAdd.jsp

?????文件???????6819??2010-12-11?10:29??salary\WebRoot\salaryManage.jsp

?????文件???????6348??2010-12-11?10:28??salary\WebRoot\salaryModify.jsp

?????文件???????4166??2010-12-11?10:28??salary\WebRoot\showemployee.jsp

?????文件???????4561??2010-12-11?10:28??salary\WebRoot\showSalary.jsp

?????文件???????2612??2010-12-11?10:05??salary\WebRoot\WEB-INF\classes\org\pan\util\DBConnectionManager.class

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