package?com.db;

import?java.sql.*;

public?class?DBConnection?{
	private?static?final?String?DRIVERCLASS=“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	private?static?final?String?URL=“jdbc:sqlserver://localhost:1433;databasename=Students“;
	private?static?final?String?USERNAME=“sa“;
	private?static?final?String?PASSWORD=“123“;
	static{
		//加載驅動
		try{
		?Class.forName（DRIVERCLASS）;
		}catch（ClassNotFoundException?e）{
			e.printStackTrace（）;
		
		}
	}
?public?static?Connection?getConn（）{
	?Connection?conn=null;
	?try{
	?conn=DriverManager.getConnection（URLUSERNAMEPASSWORD）;
	?}catch（SQLException?e）{
		?e.printStackTrace（）;
	?}
?return?conn;
?}
?
?
?public?static?void?close（ResultSet?rsPreparedStatement?psConnection?conn）{
	?try{
		?if（rs!=null）?rs.clos

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

?????文件?????584207??2018-12-04?14:22??student??成功\sqljdbc4-4.0.jar

?????文件????????292??2018-12-17?08:51??student??成功\SQLQuery1.sql

?????文件????????621??2018-12-17?08:41??student??成功\studentSystem\.classpath

?????文件????????312??2018-12-17?08:20??student??成功\studentSystem\.mymetadata

?????文件???????1756??2018-12-10?08:58??student??成功\studentSystem\.project

?????文件????????500??2018-12-10?08:21??student??成功\studentSystem\.settings\.jsdtscope

?????文件?????????99??2018-12-17?08:20??student??成功\studentSystem\.settings\com.genuitec.eclipse.j2eedt.core.xml

?????文件????????364??2018-12-10?08:21??student??成功\studentSystem\.settings\org.eclipse.jdt.core.prefs

?????文件????????477??2018-12-10?08:21??student??成功\studentSystem\.settings\org.eclipse.wst.common.component

?????文件????????126??2018-12-17?08:20??student??成功\studentSystem\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2018-12-10?08:22??student??成功\studentSystem\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2018-12-10?08:22??student??成功\studentSystem\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????938??2018-12-10?18:01??student??成功\studentSystem\src\com\db\DBConnection.java

?????文件???????1020??2018-12-11?14:31??student??成功\studentSystem\src\com\db\Student.java

?????文件???????1838??2018-12-10?08:57??student??成功\studentSystem\WebRoot\AddStudent.jsp

?????文件???????1837??2018-12-11?14:57??student??成功\studentSystem\WebRoot\AddStudentData.jsp

?????文件???????1189??2018-12-17?09:10??student??成功\studentSystem\WebRoot\DeleteStudent.jsp

?????文件???????1405??2018-12-17?08:37??student??成功\studentSystem\WebRoot\DeletetidentDdata.jsp

?????文件??????49248??2018-12-11?14:10??student??成功\studentSystem\WebRoot\image\top.jpg

?????文件???????3273??2018-12-11?15:36??student??成功\studentSystem\WebRoot\LookUpdateStudent.jsp

?????文件?????????36??2018-12-10?08:21??student??成功\studentSystem\WebRoot\meta-INF\MANIFEST.MF

?????文件???????2330??2018-12-11?14:57??student??成功\studentSystem\WebRoot\SelectStudent.jsp

?????文件???????1390??2018-12-11?14:09??student??成功\studentSystem\WebRoot\StuAdmin.jsp

?????文件???????1134??2018-12-11?14:57??student??成功\studentSystem\WebRoot\UpdateStudent.jsp

?????文件???????1980??2018-12-11?15:30??student??成功\studentSystem\WebRoot\UpdateStudentData.jsp

?????文件???????1660??2018-12-17?08:41??student??成功\studentSystem\WebRoot\WEB-INF\classes\com\db\DBConnection.class

?????文件???????1542??2018-12-17?08:41??student??成功\studentSystem\WebRoot\WEB-INF\classes\com\db\Student.class

?????文件??????49248??2018-12-11?14:08??student??成功\studentSystem\WebRoot\WEB-INF\image\top.jpg

?????文件????????404??2018-12-10?08:21??student??成功\studentSystem\WebRoot\WEB-INF\web.xml

?????文件??????49248??2018-12-11?14:05??student??成功\top.jpg

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