package?com;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;

public?class?DBConnection?{
	
	/**
	?*?獲得連接
	?*?@return?conn
	?*/
	public?static?Connection?getConnection（）?{
		Connection?conn?=?null;
		try?{
			//?裝載驅動
			Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;
			//?定義數據庫連接所需的URL地址
			String?url=“jdbc:sqlserver://localhost:1433;DatabaseName=TMSDB“;
			//獲得連接
			conn?=?DriverManager.getConnection（url“sa““123“）;
			
		}?catch?（ClassNotFoundException?e）?{
			//?當裝載驅動錯誤時產生異常信息
			System.out.println（“裝載驅動錯誤“）;
			e.printStackTrace（）;
			
		}?catch?（SQLException?e）?{
			//?當創建數據庫連接錯誤時產生異常信息
			System.out.println（“創建數據庫連接錯誤“）;
			e.printStackTrace（）;
			
		}
		return?conn;
	}
	
	/**
	?*?獲取Access數據庫連接
	?*?@return?conn
	?*/
	public?static?Connection?getConnectionToAccess（）?{
		Connection?conn?=?null;
		try?{
			//?裝載驅動
			Class.forName（“sun.jdbc.odbc.JdbcOdbcDriver“）;
			//?定義數據庫連接所需的URL地址
			String?url=“jdbc:odbc:Driver={Microsoft?Access?Driver?（*.mdb）};DBQ=db/JdbcDemoDB.mdb“;
			//獲得連接
			conn?=?DriverManager.getConnection（url）;
			
		}?catch?（ClassNotFoundException?e）?{
			//?當裝載驅動錯誤時產生異常信息
			System.out.println（“裝載驅動錯誤“）;
			e.printStackTrace（）;
			
		}?catch?（SQLException?e）?{
			//?當創建數據庫連接錯誤時產生異常信息
			System.out.println（“創建數據庫連接錯誤“）;
			e.printStackTrace（）;
			
		}
		return?conn;
	}
	
	/**
	?*?獲取MySQL數據庫連接
	?*?@return?conn
	?*/
	public?static?Connection?getConnectionToMySQL（）?{
		Connection?conn?=?null;
		try?{
			//?裝載驅動
			Class.forName（“com.mysql.jdbc.Driver“）;
			//?定義數據庫連接所需的URL地址
			String?url?=?“jdbc:mysql://localhost:3306/TMSDB“;
			//獲得連接
			conn?=?DriverManager.getConnection（url?“root“?“cstp“）;
			
		}?catch?（ClassNotFoundException?e）?{
			//?當裝載驅動錯誤時產生異常信息
			System.out.println（“裝載驅動錯誤“）;
			e.printStackTrace（）;
			
		}?catch?（SQLException?e）?{
			//?當創建數據庫連接錯誤時產生異常信息
			System.out.println（“創建數據庫連接錯誤“）;
			e.printStackTrace（）;
			
		}
		return?conn;
	}
	
	/**
	?*?獲取SQLserver連接
	?*?@return?conn
	?*/
	public?static?Connection?getConnectionToSQLserver（）?{
		Connection?conn?=?null;
		try?{
			//?裝載驅動
			Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;
			//?定義數據庫連接所需的URL地址
			String?url?=?“jdbc:sqlserver://localhost:1433;DatabaseName=JdbcDemoDB“;
			//獲得連接
			conn?=?DriverManager.getConnection（url?“sa“?“cstp“）;			
			
		}?catch?（ClassNotFoundException?e）?{
			//?當裝載驅動錯誤時產生異常信息
			System.out.println（“裝載驅動錯誤“）;
			e.printStackTrace（）;
			
		}?catch?（SQLException?e）?{
			//?當創建數據庫連接錯誤時產生異常信息
			System.out.println（“創建數據庫連接錯誤“）;
			e.printStackTrace（）;
			
		}
		return?conn;
	}
	
	/**
	?*?根據輸入的字符串參數連接相應的數據庫
	?*??字符串參數說明：
	?*???Access：Access連接
	?*???MySQL：MySQL連接
	?*???SQLserver：SQLserver連接
	?*?@param?DatabaseName
	?*?@return?conn
	?*/
	public?stat

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

?????文件????????394??2010-12-07?08:52??testdemo\test\.classpath

?????文件????????282??2011-06-22?08:13??testdemo\test\.mymetadata

?????文件???????1221??2010-12-07?11:21??testdemo\test\.project

?????文件????????330??2010-12-09?10:52??testdemo\test\.settings\org.eclipse.jdt.core.prefs

?????文件?????583286??2010-12-07?08:52??testdemo\test\lib\sqljdbc.jar

?????文件???????5991??2010-12-07?08:54??testdemo\test\src\com\DBConnection.java

?????文件??????13635??2010-12-30?12:50??testdemo\test\src\dao\StudentDao.java

?????文件??????13933??2010-12-30?14:51??testdemo\test\src\dao\TeacherDao.java

?????文件???????3612??2010-12-30?17:23??testdemo\test\src\dao\UserDao.java

?????文件???????1205??2010-12-30?11:06??testdemo\test\src\dto\StudentDto.java

?????文件???????1838??2010-12-30?14:04??testdemo\test\src\dto\TeacherDto.java

?????文件????????475??2010-12-30?17:19??testdemo\test\src\dto\UserDto.java

?????文件???????2390??2010-12-09?15:06??testdemo\test\src\servlet\DeleteServlet.java

?????文件???????3271??2010-12-29?11:18??testdemo\test\src\servlet\LoginServlet.java

?????文件???????2429??2010-12-29?09:02??testdemo\test\src\servlet\RegisterServlet.java

?????文件???????2439??2010-12-30?12:21??testdemo\test\src\servlet\studendeletetservlet.java

?????文件???????2342??2010-12-29?11:00??testdemo\test\src\servlet\studentregisterservlet.java

?????文件???????3551??2010-12-30?12:23??testdemo\test\src\servlet\studentservlet.java

?????文件???????2818??2010-12-30?15:04??testdemo\test\src\servlet\studentupdateservlet.java

?????文件???????3050??2011-01-03?21:49??testdemo\test\src\servlet\teacherupdateservlet.java

?????文件???????3196??2010-12-30?17:26??testdemo\test\src\servlet\userservlet.java

?????文件????????961??2010-12-28?15:59??testdemo\test\WebRoot\index.jsp

?????文件????????914??2010-12-28?16:01??testdemo\test\WebRoot\loginError.jsp

?????文件???????2281??2011-06-22?08:31??testdemo\test\WebRoot\loginSuccess.jsp

?????文件?????????39??2010-12-07?08:43??testdemo\test\WebRoot\meta-INF\MANIFEST.MF

?????文件???????1333??2010-12-30?16:00??testdemo\test\WebRoot\register.jsp

?????文件???????1223??2011-06-29?08:19??testdemo\test\WebRoot\studentlogin.jsp

?????文件???????1160??2011-06-29?08:17??testdemo\test\WebRoot\studentloginok.jsp

?????文件???????1341??2010-12-30?16:15??testdemo\test\WebRoot\studentregister.jsp

?????文件???????1983??2010-12-31?18:53??testdemo\test\WebRoot\studentupdate.jsp

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