package?db;
import?java.sql.Connection;
import?java.sql.Statement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.DriverManager;
//import?java.io.*;
public?class?DB?{
	private?Connection?conn=null;
	private?Statement?stat=null;
????public?ResultSet?rs=null;

	public?void?connectMySQL（）?
	{
		String?url=“jdbc:mysql://localhost:3306/school“;
		String?user=“root“;
		String?psd=“1511226“;
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;
		????conn?=?DriverManager.getConnection（“jdbc:mysql:“
		????		+?“//localhost:3306/school?useUnicode=true&characterEncoding=utf8“user?psd）;
		????stat?=?conn.createStatement（）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
	}
	
	
	public?ResultSet?query（String?sql）?throws?SQLException
	{
		if（s

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

?????文件???????1234??2017-05-02?21:57??School\.classpath

?????文件????????312??2010-01-07?14:53??School\.mymetadata

?????文件???????1749??2017-05-18?17:19??School\.project

?????文件????????522??2017-05-02?21:53??School\.settings\.jsdtscope

?????文件????????341??2017-05-02?21:53??School\.settings\com.genuitec.eclipse.migration.prefs

?????文件????????364??2017-05-02?21:52??School\.settings\org.eclipse.jdt.core.prefs

?????文件????????551??2017-05-18?17:19??School\.settings\org.eclipse.wst.common.component

?????文件????????362??2017-05-02?21:53??School\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2017-05-02?21:53??School\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2017-05-02?21:53??School\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件?????????66??2017-05-02?21:53??School\.tern-project

?????文件???????2146??2017-05-19?17:50??School\src\db\DB.java

?????文件?????????40??2017-05-02?21:53??School\src\meta-INF\MANIFEST.MF

?????文件???????1352??2010-01-13?00:10??School\src\servlet\deleteGrade.java

?????文件???????1355??2010-01-13?00:10??School\src\servlet\deleteHealth.java

?????文件???????1422??2010-01-13?00:10??School\src\servlet\deleteLicense.java

?????文件???????2068??2017-05-19?16:44??School\src\servlet\deleteStudent.java

?????文件???????1979??2010-01-13?00:11??School\src\servlet\insertGrade.java

?????文件???????2439??2010-01-13?00:12??School\src\servlet\insertHealth.java

?????文件???????2102??2017-05-19?15:37??School\src\servlet\insertLicense.java

?????文件???????2801??2017-05-18?17:27??School\src\servlet\insertStudent.java

?????文件???????1861??2010-01-13?00:14??School\src\servlet\modifyGrade.java

?????文件???????2277??2010-01-13?00:15??School\src\servlet\modifyHealth.java

?????文件???????1701??2010-01-13?00:15??School\src\servlet\modifyLicense.java

?????文件???????2259??2010-01-08?09:59??School\src\servlet\modifyPasswd.java

?????文件???????2300??2010-01-13?00:15??School\src\servlet\modifyStudent.java

?????文件???????1826??2010-01-13?00:16??School\src\servlet\queryGrade.java

?????文件???????1444??2010-01-13?00:16??School\src\servlet\queryHealth.java

?????文件???????2248??2010-01-13?00:16??School\src\servlet\queryLicense.java

?????文件???????2751??2017-05-05?11:34??School\src\servlet\queryStudent.java

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