package?com.dao;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.SQLException;

public?class?DBManager?{
	public?static?Connection?getConnection（）?{

		try?{
			Class.forName（“org.gjt.mm.mysql.Driver“）.newInstance（）;
		}?catch?（InstantiationException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（IllegalAccessException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}

		String?url?=?“jdbc:mysql://localhost/coursedesign“;

		Connection?conn;
		try?{
			conn?=?DriverManager.getConnection（url?“root“?“123456“）;
			return?conn;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
			return?null;
		}

	}

	public?static?void?closeConnection（Connection?conn）?{
		if?（conn?!=?null）?{
			try?{
				conn.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
	}

}

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

?????文件????????439??2011-01-02?19:55??studentInformationSystem\.classpath

?????文件????????345??2011-01-02?18:35??studentInformationSystem\.mymetadata

?????文件???????1242??2011-01-02?20:28??studentInformationSystem\.project

?????文件???????1050??2011-01-02?21:15??studentInformationSystem\src\com\dao\DBManager.java

?????文件????????148??2011-01-02?20:42??studentInformationSystem\src\com\manager\AdminLogin.java

?????文件????????865??2011-01-02?21:06??studentInformationSystem\src\com\manager\AdminLoginImpl.java

?????文件????????371??2011-01-02?19:40??studentInformationSystem\src\com\manager\StudentManager.java

?????文件???????4166??2011-01-03?07:53??studentInformationSystem\src\com\manager\StudentManagerImpl.java

?????文件???????1634??2011-01-02?23:50??studentInformationSystem\src\com\servlets\addStudentServlet.java

?????文件???????1184??2011-01-02?21:23??studentInformationSystem\src\com\servlets\AdminLoginServlet.java

?????文件???????1087??2011-01-03?07:58??studentInformationSystem\src\com\servlets\deleteStudentServlet.java

?????文件???????1143??2011-01-02?23:18??studentInformationSystem\src\com\servlets\SelectAllStudentServlet.java

?????文件???????1268??2011-01-02?23:39??studentInformationSystem\src\com\servlets\SelectStudentByIdServlet.java

?????文件???????1187??2011-01-02?23:40??studentInformationSystem\src\com\servlets\SelectStudentByNameServlet.java

?????文件???????1626??2011-01-03?07:42??studentInformationSystem\src\com\servlets\UpdateStudentServlet.java

?????文件????????312??2011-01-02?20:14??studentInformationSystem\src\com\studentBeans\Admin.java

?????文件???????1083??2011-01-02?19:12??studentInformationSystem\src\com\studentBeans\Student.java

?????文件????????891??2011-01-02?22:40??studentInformationSystem\WebRoot\addStudent.jsp

?????文件????????892??2011-01-02?23:54??studentInformationSystem\WebRoot\adminManager.jsp

?????文件????????583??2011-01-03?07:57??studentInformationSystem\WebRoot\deleteStuInfoById.jsp

?????文件???????1066??2011-01-02?21:29??studentInformationSystem\WebRoot\index.jsp

?????文件?????????39??2011-01-02?18:35??studentInformationSystem\WebRoot\meta-INF\MANIFEST.MF

?????文件????????580??2011-01-02?22:51??studentInformationSystem\WebRoot\selectStuInfoById.jsp

?????文件????????584??2011-01-02?22:51??studentInformationSystem\WebRoot\selectStuInfoByName.jsp

?????文件???????1226??2011-01-02?23:33??studentInformationSystem\WebRoot\showAllStuInfo.jsp

?????文件???????1221??2011-01-02?23:36??studentInformationSystem\WebRoot\showStuInfoByName&Id.jsp

?????文件????????926??2011-01-03?00:00??studentInformationSystem\WebRoot\updateStudent.jsp

?????文件????????587??2011-01-03?00:01??studentInformationSystem\WebRoot\updateStuInfoById.jsp

?????文件???????1468??2011-01-02?21:15??studentInformationSystem\WebRoot\WEB-INF\classes\com\dao\DBManager.class

?????文件????????187??2011-01-02?20:42??studentInformationSystem\WebRoot\WEB-INF\classes\com\manager\AdminLogin.class

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