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（）;
	
	}
*/
}
	
	
	

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2011-05-19?23:31??本書源程序\
?????目錄???????????0??2011-05-19?23:31??本書源程序\05\
?????目錄???????????0??2011-05-19?23:31??本書源程序\05\5.4\
?????文件?????????243??2009-12-27?20:28??本書源程序\05\5.4\本章實例源代碼.txt
?????目錄???????????0??2011-05-19?23:31??本書源程序\05\5.5\
?????文件?????????565??2009-12-27?20:32??本書源程序\05\5.5\上機實踐源代碼.txt
?????目錄???????????0??2011-05-19?23:31??本書源程序\06\
?????目錄???????????0??2011-05-19?23:31??本書源程序\06\6.5\
?????文件????????1403??2009-12-27?20:42??本書源程序\06\6.5\本章實例源代碼.txt
?????目錄???????????0??2011-05-19?23:31??本書源程序\06\6.6\
?????文件????????1936??2009-12-27?20:46??本書源程序\06\6.6\上機實踐源代碼.txt
?????目錄???????????0??2011-05-19?23:31??本書源程序\07\
?????目錄???????????0??2011-05-19?23:31??本書源程序\07\7.4\
?????文件????????1647??2009-12-27?20:56??本書源程序\07\7.4\本章實例源代碼.txt
?????目錄???????????0??2011-05-19?23:31??本書源程序\07\7.5\
?????文件?????????953??2009-12-27?20:59??本書源程序\07\7.5\上機實踐源代碼.txt
?????目錄???????????0??2011-05-19?23:31??本書源程序\08\
?????目錄???????????0??2011-05-19?23:31??本書源程序\08\8.7\
?????文件????????1325??2009-12-28?10:27??本書源程序\08\8.7\本章實例源代碼.txt
?????目錄???????????0??2011-05-19?23:31??本書源程序\08\8.8\
?????文件????????1195??2009-12-28?10:29??本書源程序\08\8.8\上機實踐源代碼.txt
?????目錄???????????0??2011-05-19?23:31??本書源程序\09\
?????目錄???????????0??2011-05-19?23:31??本書源程序\09\9.5\
?????文件????????1669??2009-12-28?10:34??本書源程序\09\9.5\本章實例源代碼.txt
?????目錄???????????0??2011-05-19?23:31??本書源程序\09\9.6\
?????文件????????1046??2009-12-28?10:36??本書源程序\09\9.6\上機實踐源代碼.txt
?????目錄???????????0??2011-05-19?23:31??本書源程序\10\
?????目錄???????????0??2011-05-19?23:31??本書源程序\10\10.1-10.8\
?????文件?????????486??2009-12-28?20:34??本書源程序\10\10.1-10.8\computer_stu表.txt
?????文件?????????385??2009-12-28?20:23??本書源程序\10\10.1-10.8\department表.txt
?????文件?????????453??2009-12-28?19:44??本書源程序\10\10.1-10.8\employee表.txt
............此處省略120個文件信息