学生信息管理系统源码+mysql数据库

学生信息管理系统源码+mysql数据库

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个文件信息