package?Database;

import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.Statement;
public?class?DBcon?{
	public?static?final?String?DBDRIVER?=?“com.mysql.jdbc.Driver“?;
	//?定義MySQL數(shù)據(jù)庫的連接地址
	public?static?final?String?DBURL?=?“jdbc:mysql://localhost:3306/studentdb?useUnocode=true&characterEncodeing=UTF-8“?;
	//?MySQL數(shù)據(jù)庫的連接用戶名
	public?static?final?String?DBUSER?=?“root“?;
	//?MySQL數(shù)據(jù)庫的連接密碼
	public?static?final?String?DBPASS?=?“root“?;
	java.sql.Connection?con=null;
	Statement?stmt;
	public?DBcon（）{
		try{
			jbInit（）;
		}catch?（Exception?e）?{
			e.printStackTrace（）;
		}
	}
	private?void?jbInit（）?throws?Exception{
		Class.forName（“com.mysql.jdbc.Driver“）;
		con?=DriverManager.getConnection（DBURLDBUSERDBPASS）;//連接數(shù)據(jù)庫
		stmt=?con.createStatement（）;//創(chuàng)建語句對象
	}
	public?Statement?getStatement（）{
		return?stmt;
	}
	//用以執(zhí)行查詢的SQL語句
	public?ResultSet?query（String?SELECT_USER_SQL）throws?Exception{
		return?stmt.executeQuery（SELECT_USER_SQL）;
	}
	//用以執(zhí)行更新的SQL語句
	public?void?update（String?UPDATE_SQL）throws?Exception{
		?stmt.executeUpdate（UPDATE_SQL）;
	}
	//用以執(zhí)行增加的SQL語句
	public?void?add（String?ADD_SQL）throws?Exception{
		?stmt.executeUpdate（ADD_SQL）;
	}
	//用以執(zhí)行刪除的SQL語句
	public?void?delete（String?DELETE_SQL）throws?Exception{
		?stmt.executeUpdate（DELETE_SQL）;
	}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-06-22?22:43??TheStudentSystem\
?????文件?????????523??2017-06-20?19:34??TheStudentSystem\.classpath
?????文件?????????392??2017-06-15?09:45??TheStudentSystem\.project
?????目錄???????????0??2017-06-22?22:43??TheStudentSystem\.settings\
?????文件?????????598??2017-06-15?09:45??TheStudentSystem\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2017-06-22?22:43??TheStudentSystem\bin\
?????目錄???????????0??2017-06-22?22:43??TheStudentSystem\bin\Database\
?????文件????????1914??2017-06-21?09:58??TheStudentSystem\bin\Database\DBcon.class
?????文件????????1786??2017-06-21?01:45??TheStudentSystem\bin\Database\Service.class
?????目錄???????????0??2017-06-22?22:43??TheStudentSystem\bin\Dialog\
?????文件????????4705??2017-06-22?09:05??TheStudentSystem\bin\Dialog\AddStudentDialog.class
?????文件????????4480??2017-06-22?09:05??TheStudentSystem\bin\Dialog\AddTeacherDialog.class
?????文件????????4947??2017-06-22?09:05??TheStudentSystem\bin\Dialog\DeleteStudentDialog.class
?????文件????????4839??2017-06-22?09:06??TheStudentSystem\bin\Dialog\DeleteTeacherDialog.class
?????文件????????5842??2017-06-22?09:06??TheStudentSystem\bin\Dialog\Query1StudentScore.class
?????文件????????5249??2017-06-22?09:06??TheStudentSystem\bin\Dialog\Query1TeacherDialog.class
?????文件????????5243??2017-06-22?09:07??TheStudentSystem\bin\Dialog\Query2StudentDialog.class
?????文件????????5845??2017-06-22?09:07??TheStudentSystem\bin\Dialog\Query2StudentScore.class
?????文件????????5350??2017-06-22?09:08??TheStudentSystem\bin\Dialog\QueryStudentDialog.class
?????文件????????5845??2017-06-22?09:08??TheStudentSystem\bin\Dialog\QueryStudentScore.class
?????文件????????4523??2017-06-22?09:09??TheStudentSystem\bin\Dialog\QueryTeacherDialog.class
?????文件????????3174??2017-06-22?09:11??TheStudentSystem\bin\Dialog\StudentScore$TableChangeListener.class
?????文件????????7785??2017-06-22?09:11??TheStudentSystem\bin\Dialog\StudentScore.class
?????文件????????5302??2017-06-22?09:11??TheStudentSystem\bin\Dialog\TeacherDialog.class
?????文件????????4621??2017-06-22?09:12??TheStudentSystem\bin\Dialog\Update1PassDilog.class
?????文件????????4269??2017-06-22?09:12??TheStudentSystem\bin\Dialog\UpdateInputPower.class
?????文件????????4635??2017-06-22?09:12??TheStudentSystem\bin\Dialog\UpdatePassDilog.class
?????文件????????5365??2017-06-22?09:13??TheStudentSystem\bin\Dialog\UpdateStudentDialog.class
?????目錄???????????0??2017-06-22?22:43??TheStudentSystem\bin\main\
?????文件????????9453??2017-06-20?19:03??TheStudentSystem\bin\main\123.jpg
?????文件????????5435??2017-06-22?09:04??TheStudentSystem\bin\main\LoginSystem.class
............此處省略79個(gè)文件信息