package?db;

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

import?java.sql.DriverManager;
import?java.util.ArrayList;?

public?class?ConnDb?{

	private?static?Connection?con?=?null;
	private?static?Statement?stmt?=?null;
	private?static?ResultSet?rs?=?null;

	public?static?void?startconn（）?{?//?連接數據庫
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		try?{
			con?=?DriverManager.getConnection（
					“jdbc:mysql://localhost:3306/test?characterEncoding=utf-8“
					“root“?“root“）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}

	}

	public?static?void?endconn（）?throws?SQLException?{?//?關閉連接

		if?（rs?!=?null）?{
			rs.close（）;
			rs?=?null;
		}

		if?（stmt?!=?null）?{
			stmt.close（）;
			stmt?=?null;
		}

		if?（con?!=?null）?{

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

?????文件????????452??2013-07-02?17:23??jsp_curd\.classpath

?????文件????????297??2013-07-02?17:15??jsp_curd\.mymetadata

?????文件???????1226??2013-07-02?17:16??jsp_curd\.project

?????文件????????330??2013-07-02?17:15??jsp_curd\.settings\org.eclipse.jdt.core.prefs

?????文件???????1654??2013-07-02?17:49??jsp_curd\src\db\ConnDb.java

?????文件????????451??2013-07-02?17:46??jsp_curd\src\db\Student.java

?????文件????????872??2013-07-02?18:33??jsp_curd\test.sql

?????文件????????556??2013-07-02?18:15??jsp_curd\WebRoot\add.jsp

?????文件????????703??2013-07-02?18:17??jsp_curd\WebRoot\addInfo.jsp

?????文件????????491??2013-07-02?18:25??jsp_curd\WebRoot\delete.jsp

?????文件???????1717??2013-07-02?18:11??jsp_curd\WebRoot\index.jsp

?????文件?????????39??2013-07-02?17:15??jsp_curd\WebRoot\meta-INF\MANIFEST.MF

?????文件???????1073??2013-07-02?18:32??jsp_curd\WebRoot\update.jsp

?????文件????????761??2013-07-02?18:31??jsp_curd\WebRoot\updateInfo.jsp

?????文件???????2518??2013-07-02?17:49??jsp_curd\WebRoot\WEB-INF\classes\db\ConnDb.class

?????文件????????860??2013-07-02?17:46??jsp_curd\WebRoot\WEB-INF\classes\db\Student.class

?????文件?????775688??2012-07-26?10:56??jsp_curd\WebRoot\WEB-INF\lib\mysql-connector-java-5.1.14.jar

?????文件????????381??2013-07-02?17:15??jsp_curd\WebRoot\WEB-INF\web.xml

?????目錄??????????0??2013-07-02?17:46??jsp_curd\WebRoot\WEB-INF\classes\db

?????目錄??????????0??2013-07-02?17:23??jsp_curd\WebRoot\WEB-INF\classes

?????目錄??????????0??2013-07-02?17:22??jsp_curd\WebRoot\WEB-INF\lib

?????目錄??????????0??2013-07-02?17:46??jsp_curd\src\db

?????目錄??????????0??2013-07-02?17:15??jsp_curd\WebRoot\meta-INF

?????目錄??????????0??2013-07-02?17:15??jsp_curd\WebRoot\WEB-INF

?????目錄??????????0??2013-07-02?17:15??jsp_curd\.myeclipse

?????目錄??????????0??2013-07-02?17:15??jsp_curd\.settings

?????目錄??????????0??2013-07-02?17:21??jsp_curd\src

?????目錄??????????0??2013-07-02?18:25??jsp_curd\WebRoot

?????目錄??????????0??2013-07-02?18:33??jsp_curd

-----------?---------??----------?-----??----

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