package?admin2Manager;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.Statement;

import?javax.swing.JOptionPane;

public?class?Admin2Dao?{
	private?String?driverName=“com.mysql.jdbc.Driver“;
????private?String?url=“jdbc:mysql://localhost:3306/student_information?useUnicode=true&serverTimezone=UTC&characterEncoding=utf8“;
????private?String?user=“root“;
????private?String?password=“123456“;
????private?Connection?con=null;
????private?Statement?st=null;
????private?ResultSet?rs=null;
????public?String?getDriverName（）?{
????????return?driverName;
????}
????public?void?setDriverName（String?driverName）?{
????????this.driverName?=?driverName;
????}
????public?String?getUrl（）?{
????????return?url;
????}
????public?void?setUrl（String?url）?{
????????this.url?=?url;
????}
????public?String?getUser（）?{
????????return?user;
????}
????public?void?setUser（String?user）?{
????????this.user?=?user;
????}
????public?String?getPassword（）?{
????????return?password;
????}
????public?void?setPassword（String?password）?{
????????this.password?=?password;
????}
????public?Connection?getCon（）?{
????????return?con;
????}
????public?void?setCon（Connection?con）?{
????????this.con?=?con;
????}
????public?Statement?getSt（）?{
????????return?st;
????}
????public?void?setSt（Statement?st）?{
????????this.st?=?st;
????}
????public?ResultSet?getRs（）?{
????????return?rs;
????}
????public?void?setRs（ResultSet?rs）?{
????????this.rs?=?rs;
????}
???//完成連接數據庫操作，并生成容器返回
????public?Statement?getStatement（）{
????????try{
????????????Class.forName（getDriverName（））;
????????????con=DriverManager.getConnection（getUrl（）?getUser（）?getPassword（））;
????????????return?con.createStatement（）;
????????}catch（Exception?e）{
????????????e.printStackTrace（）;
????????????message（“無法完成數據庫的連接或者無法返回容器，請檢查getStatement（）方法！“）;
????????????return?null;
????????}
????}
????public?ResultSet?selectAdmin2（）{
????????try{
????????????String?sql=“select?*?from?admin“;
????????????st=getStatement（）;
????????????return?st.executeQuery（sql）;
????????}catch（Exception?e）{
????????????e.printStackTrace（）;
????????????message（“無法查詢管理員信息，請檢查selectAdmin（）方法！“）;
????????????return?null;
????????}
????}
????//查詢要修改的學生信息
????public?ResultSet?selectUpdateAdmin2（String?NO）{
????????try{
????????????String?sql=“select?*?from?admin?where?ad_no=‘“+NO+“‘“;
????????????st=getStatement（）;
????????????return?st.executeQuery（sql）;
????????}catch（Exception?e）{
????????????e.printStackTrace（）;
????????????message（“無法查詢到要修改管理員的信息，請檢查輸入管理員號！“）;
????????????return?null;
????????}
????}
????//修改學生信息
????public?boolean?updateAdmin2（String?adminNumberString?adminNameString?adminRankString?adminPassword）{
????????try{
????????	
????????	String?sql=“update?admin?set?ad_no=‘“+adminNumber+“‘ad_name=‘“+adminName+“‘ad_rank=‘“+adminRank+“‘ad_password=‘“+adminPassword+“‘?where?ad_no=“+adminNumber

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-12-05?17:39??student_information\
?????文件?????????888??2019-12-01?20:46??student_information\.classpath
?????文件?????????919??2019-11-30?18:04??student_information\.project
?????目錄???????????0??2019-12-05?17:31??student_information\.settings\
?????文件?????????567??2019-11-30?18:04??student_information\.settings\.jsdtscope
?????文件??????????82??2019-12-05?17:31??student_information\.settings\org.eclipse.core.resources.prefs
?????文件????????7568??2019-11-30?23:15??student_information\.settings\org.eclipse.jdt.core.prefs
?????文件?????????509??2019-11-30?18:04??student_information\.settings\org.eclipse.wst.common.component
?????文件?????????305??2019-12-01?20:46??student_information\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2019-11-30?18:04??student_information\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2019-11-30?18:04??student_information\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2019-12-05?13:10??student_information\WebContent\
?????目錄???????????0??2019-12-05?12:40??student_information\WebContent\meta-INF\
?????文件??????????39??2019-11-30?18:04??student_information\WebContent\meta-INF\MANIFEST.MF
?????文件????????2303??2019-12-03?22:48??student_information\WebContent\TextCon.jsp
?????目錄???????????0??2019-12-05?12:40??student_information\WebContent\WEB-INF\
?????目錄???????????0??2019-12-05?12:40??student_information\WebContent\WEB-INF\lib\
?????文件?????2330539??2019-09-08?02:09??student_information\WebContent\WEB-INF\lib\mysql-connector-java-8.0.18.jar
?????文件?????????665??2019-12-01?22:19??student_information\WebContent\WEB-INF\lib\web.xml
?????目錄???????????0??2019-12-05?12:56??student_information\WebContent\ad_Manage\
?????目錄???????????0??2019-12-05?12:40??student_information\WebContent\ad_Manage\role_ad_junior\
?????文件????????2150??2019-12-03?15:23??student_information\WebContent\ad_Manage\role_ad_junior\UpdateAdmin2.jsp
?????文件????????1510??2019-12-02?22:00??student_information\WebContent\ad_Manage\role_ad_junior\lookAdmin2.jsp
?????文件?????????817??2019-12-02?21:43??student_information\WebContent\ad_Manage\role_ad_junior\lookUpdateAdmin2.jsp
?????文件?????????505??2019-12-02?21:43??student_information\WebContent\ad_Manage\role_ad_junior\message22.jsp
?????目錄???????????0??2019-12-05?12:40??student_information\WebContent\ad_Manage\role_ad_senior\
?????文件????????2045??2019-12-02?20:49??student_information\WebContent\ad_Manage\role_ad_senior\UpdateAdmin.jsp
?????文件????????1798??2019-12-02?19:31??student_information\WebContent\ad_Manage\role_ad_senior\addAdmin.jsp
?????文件?????????276??2019-10-28?20:37??student_information\WebContent\ad_Manage\role_ad_senior\bottom.jsp
?????文件?????????742??2019-12-02?10:33??student_information\WebContent\ad_Manage\role_ad_senior\left.jsp
?????文件????????1465??2019-12-02?22:02??student_information\WebContent\ad_Manage\role_ad_senior\lookAdmin.jsp
............此處省略263個文件信息