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/drivingschool“;
		String?user=“root“;
		String?psd=“root“;
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;
		????conn?=?DriverManager.getConnection（url?user?psd）;
		????stat?=?conn.createStatement（）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
	}
	
	
	public?ResultSet?query（String?sql）?throws?SQLException
	{
		if（sql==null||sql.equals（““））
		{
			return?null;
		}
		rs?=?stat.executeQuery（sql）;
		return?rs;
	}
	
	public?int?update（String?sql）?throws?SQLException
	{		
		int?i;
		if（sql==null||sql.equals（““））
		{
			return?0;
		}
		i=stat.executeUpdate（sql）;	
		return?i;
	}
	
	public?ResultSet?executeSQL（String?sql）?throws?SQLException{
		
		boolean?t;
		if（sql==null||sql.equals（““））
		{
			return?null;
		}
		t=stat.execute（sql）;
		if（t）{
			rs?=?stat.getResultSet（）;
			return?rs;
		}
		else{
			return?null;
		}		
	}
	
	public?void?closeDB（）?throws?SQLException
	{
		if（rs!=null）
		{
			rs.close（）;
			rs=null;
		}
		if（stat!=null）
		{
			stat.close（）;
			stat=null;
		}
		if（conn!=null）
		{
			conn.close（）;
			conn=null;
		}
	}
	
/*	
	public??static?void?main（String?arg[]）?throws?SQLExceptionIOException?InstantiationException?IllegalAccessException?ClassNotFoundException{
	?
		String?sql=“select?*?from?user“;
		
		DB?d=new?DB（）;
		
		d.connectMySQL（）;
		
		ResultSet?rs=d.query（sql）;
		
		if（rs!=null）{
		System.out.println（“success“）;
		while（rs.next（））{
			
			String?i=rs.getString（“username“）;
			System.out.println（i）;
			String?j=rs.getString（“password“）;
			System.out.println（j）;
			}
		}
		else{
			System.out.println（“Fail“）;
		}
		d.closeDB（）;
	
	}
*/
}
	
	
	

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

?????文件????????413??2012-04-16?09:44??DrivingSchool\.classpath

?????文件????????312??2012-04-16?09:44??DrivingSchool\.mymetadata

?????文件???????1231??2012-04-16?09:44??DrivingSchool\.project

?????文件???????2080??2012-04-16?09:44??DrivingSchool\src\db\DB.java

?????文件??????????0??2012-04-16?08:54??DrivingSchool\src\db\test.java

?????文件???????1352??2012-04-16?09:44??DrivingSchool\src\servlet\deleteGrade.java

?????文件???????1355??2012-04-16?09:44??DrivingSchool\src\servlet\deleteHealth.java

?????文件???????1422??2012-04-16?09:44??DrivingSchool\src\servlet\deleteLicense.java

?????文件???????1457??2012-04-16?09:44??DrivingSchool\src\servlet\deleteStudent.java

?????文件???????1979??2012-04-16?09:44??DrivingSchool\src\servlet\insertGrade.java

?????文件???????2439??2012-04-16?09:44??DrivingSchool\src\servlet\insertHealth.java

?????文件???????1993??2012-04-16?09:44??DrivingSchool\src\servlet\insertLicense.java

?????文件???????2720??2012-04-16?09:44??DrivingSchool\src\servlet\insertStudent.java

?????文件???????1861??2012-04-16?09:44??DrivingSchool\src\servlet\modifyGrade.java

?????文件???????2277??2012-04-16?09:44??DrivingSchool\src\servlet\modifyHealth.java

?????文件???????1701??2012-04-16?09:44??DrivingSchool\src\servlet\modifyLicense.java

?????文件???????2259??2012-04-16?09:44??DrivingSchool\src\servlet\modifyPasswd.java

?????文件???????2300??2012-04-16?09:44??DrivingSchool\src\servlet\modifyStudent.java

?????文件???????1826??2012-04-16?09:44??DrivingSchool\src\servlet\queryGrade.java

?????文件???????1444??2012-04-16?09:44??DrivingSchool\src\servlet\queryHealth.java

?????文件???????2248??2012-04-16?09:44??DrivingSchool\src\servlet\queryLicense.java

?????文件???????2751??2012-04-16?09:44??DrivingSchool\src\servlet\queryStudent.java

?????文件???????1765??2012-04-16?09:44??DrivingSchool\src\servlet\userLogin.java

?????文件???????9797??2012-04-16?09:44??DrivingSchool\WebRoot\insertGrade.jsp

?????文件??????11754??2012-04-16?09:44??DrivingSchool\WebRoot\insertHealth.jsp

?????文件???????9750??2012-04-16?09:44??DrivingSchool\WebRoot\insertLicense.jsp

?????文件??????12143??2012-04-16?09:44??DrivingSchool\WebRoot\insertStudent.jsp

?????文件???????6377??2012-04-16?09:44??DrivingSchool\WebRoot\left.jsp

?????文件???????2116??2012-04-16?09:44??DrivingSchool\WebRoot\login.jsp

?????文件????????499??2012-04-16?09:44??DrivingSchool\WebRoot\LoginError.html

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