package?dao;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.List;

import?entities.manage;
import?staticvalues.StaticValues;

/**
?*?數據庫處理代碼
?*?*/
public?class?managedao?{
	public?managedao（）?throws?ClassNotFoundException?{Class.forName（“com.mysql.cj.jdbc.Driver“）;/*加載數據庫引擎*/}
	//查詢班級信息
	public??List?Select1（）throws?SQLExceptionClassNotFoundException{
			List?lists?=?new?ArrayList（）;
			????????//?1.建立連接
					Connection?con?=?DriverManager.getConnection（StaticValues.urlStaticValues.userStaticValues.pwd）;
					//?2.定義Sql語句
					String?sql?=?“select?deptcnametnametphone?from?manage“;
					Statement?ps?=?con.createStatement（）;
					ResultSet?rs?=?ps.executeQuery（sql）;
					while（rs.next（））
					{
						manage?oneClass?=?new?manage（）;	
						oneClass.setDept（rs.getString（“dept“））;
						oneClass.setCname（rs.getString（“cname“））;
						oneClass.setTname（rs.getString（“tname“））;
						oneClass.setTphone（rs.getString（“tphone“））;												
						lists.add（oneClass）;			
					}		
					rs.close（）;
					con.close（）;
					System.out.println（“加載完成！“）;
					return?lists;
		}
		//查詢學生信息
	public??List?Select2（）throws?SQLExceptionClassNotFoundException{
			List?lists?=?new?ArrayList（）;
			????????//?1.建立連接
					Connection?con?=?DriverManager.getConnection（StaticValues.urlStaticValues.userStaticValues.pwd）;
					//?2.定義Sql語句
					String?sql?=?“select?snonamesexcnamedept?from?manage“;
					Statement?ps?=?con.createStatement（）;
					ResultSet?rs?=?ps.executeQuery（sql）;
					while（rs.next（））
					{
						manage?oneClass?=?new?manage（）;
						oneClass.setSno（rs.getString（“sno“））;
						oneClass.setName（rs.getString（“name“））;
						oneClass.setSex（rs.getString（“sex“））;
						oneClass.setCname（rs.getString（“cname“））;
						oneClass.setDept（rs.getString（“dept“））;						
						lists.add（oneClass）;			
					}		
					rs.close（）;
					con.close（）;
					System.out.println（“加載完成！“）;
					return?lists;
		}
		//查詢課程信息
	public??List?Select3（）throws?SQLExceptionClassNotFoundException{
			List?lists?=?new?ArrayList（）;
			???????//?1.建立連接
					Connection?con?=?DriverManager.getConnection（StaticValues.urlStaticValues.userStaticValues.pwd）;
					//?2.定義Sql語句
					String?sql?=?“select?cnamecourseterm?from?manage“;
					Statement?ps?=?con.createStatement（）;
					ResultSet?rs?=?ps.executeQuery（sql）;
					while（rs.next（））
					{
						manage?oneClass?=?new?manage（）;
						oneClass.setCname（rs.getString（“cname“））;
						oneClass.setCourse（rs.getString（“course“））;
						oneClass.setTerm（rs.getString（“term“））;						
						lists.add（oneClass）;			
					}		
					rs.close（）;
					con.close（）;
					System.out.println（“加載完成！“）;
					return?lists;
		}
		//查詢成績信息
	public??List?Sel

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????375??2019-01-09?15:18??Manage\.classpath
?????文件?????????382??2019-01-09?15:18??Manage\.project
?????目錄???????????0??2019-01-11?14:48??Manage\.settings\
?????文件?????????161??2019-01-11?01:17??Manage\.settings\org.eclipse.core.resources.prefs
?????文件?????????598??2019-01-09?15:18??Manage\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2019-01-11?14:48??Manage\bin\
?????目錄???????????0??2019-01-11?14:48??Manage\bin\dao\
?????文件????????3798??2019-01-10?21:54??Manage\bin\dao\managedao.class
?????目錄???????????0??2019-01-11?14:48??Manage\bin\dialog\
?????文件????????5177??2019-01-11?10:53??Manage\bin\dialog\Add.class
?????文件????????5877??2019-01-11?13:51??Manage\bin\dialog\Update.class
?????目錄???????????0??2019-01-11?14:48??Manage\bin\entities\
?????文件????????3266??2019-01-11?13:42??Manage\bin\entities\countModel.class
?????文件????????3511??2019-01-11?13:01??Manage\bin\entities\infoModel.class
?????文件????????3223??2019-01-09?20:23??Manage\bin\entities\manage.class
?????文件????????3706??2019-01-11?13:02??Manage\bin\entities\updateModel.class
?????目錄???????????0??2019-01-11?14:48??Manage\bin\info\
?????文件????????2405??2019-01-11?10:41??Manage\bin\info\About.class
?????文件?????????773??2019-01-11?01:38??Manage\bin\info\Classinfo$1.class
?????文件????????3498??2019-01-11?01:38??Manage\bin\info\Classinfo.class
?????文件?????????781??2019-01-11?01:38??Manage\bin\info\Courseinfo$1.class
?????文件????????3391??2019-01-11?01:38??Manage\bin\info\Courseinfo.class
?????文件???????63932??2019-01-11?08:49??Manage\bin\info\img.jpg
?????文件????????6982??2019-01-11?13:50??Manage\bin\info\ManageSystem.class
?????文件?????????322??2019-01-10?21:46??Manage\bin\info\Mytable.class
?????文件????????4293??2019-01-11?13:46??Manage\bin\info\ScoreCount.class
?????文件?????????773??2019-01-11?01:39??Manage\bin\info\Scoreinfo$1.class
?????文件????????3536??2019-01-11?01:39??Manage\bin\info\Scoreinfo.class
?????文件?????????789??2019-01-11?01:39??Manage\bin\info\Studentinfo$1.class
?????文件????????3494??2019-01-11?01:39??Manage\bin\info\Studentinfo.class
?????目錄???????????0??2019-01-11?14:48??Manage\bin\staticvalues\
............此處省略45個文件信息