java课程设计 | 学生管理系统

内容简介：

写一个学生管理系统，实现学生信息的增删改查。

效果展示：

主页面

 密码登陆界面

 管理员界面

 学生界面

 代码展示：

AdminDao（对数据库进行操作的内容）

package dao;
import domain.Student;
import domain.UserInformation;
import utils.JDBCUtils;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

public class AdminDao {

    ArrayList<Student> list = new ArrayList<Student>();
    ArrayList<UserInformation> list1=new ArrayList<UserInformation>();
//    查找全部学生信息
public ArrayList<Student> queryAllStudent(){
    try {
        Connection con= JDBCUtils.getConnection();//获得连接
        Statement stat=con.createStatement();//声明
        String sql="SELECT * FROM student";//数据库的操作语句
        ResultSet rs=stat.executeQuery(sql);
        //处理结果集
        while(rs.next()){
            Student student=new Student();
            student.setSid(rs.getString("Sid"));
            student.setSname(rs.getString("Sname"));
            student.setSage(rs.getInt("Sage"));
            student.setSsex(rs.getString("Ssex"));
            student.setCallNumber(rs.getString("CallNumber"));
            student.setIdentityID(rs.getString("IdentityID"));
            list.add(student);
        }
        JDBCUtils.release(stat,con,rs);

    } catch (Exception e) {
        e.printStackTrace();
    }
    return list;
}


//    添加组件
public boolean addStudent(Student student){
    try {
        Connection con=JDBCUtils.getConnection();//获得连接
        Statement stat=con.createStatement();//获取执行者对象
        String sql="INSERT INTO student VALUES('"+student.getSid()+"','"+student.getSname()+"','"+student.getSage()+"','"+student.getSsex()+"','"+student.getCallNumber()+"','"+student.getIdentityID()+"')";
//        System.out.println(sql);
        int i=stat.executeUpdate(sql);
        JDBCUtils.release(stat,con);
        if(i==0){
            return false;
        }else{
            return true;
        }
    } catch (Exception e) {
        e.printStackTrace();
    }
    return false;
}
//    删除组件
public int deleteStudent(String Sid){
    int flag=0;
    try {
        Connection con=JDBCUtils.getConnection();//获得连接
        Statement stat=con.createStatement();//获取执行者对象
        String sql="DELETE FROM student WHERE Sid="+Sid;
        int i=stat.executeUpdate(sql);
        JDBCUtils.release(stat,con);
        if(i==1){
            System.out.println("删除成功");
            return flag = 1;
        }else{
            System.out.println("删除失败");
            return flag = 0;
        }
    } catch (Exception e) {
        e.printStackTrace();
    }
    return flag;
}

//    修改组件
public boolean changeStudent(Student student){
    try {
        Connection con=JDBCUtils.getConnection();//获得连接
        Statement stat=con.createStatement();//获取执行者对象
        String sql="UPDATE student SET Sname='"+student.getSname()+"',Sage="+student.getSage()+",Ssex='"+student.getSsex()+"',CallNumber='"+student.getCallNumber()+"',IdentityID='"+student.getIdentityID()+"' WHERE Sid='"+student.getSid()+"';";
        System.out.println(sql);
        int i=stat.executeUpdate(sql);
        JDBCUtils.release(stat,con);
        if(i==0){
            return false;
        }else{
            return true;
        }
    } catch (Exception e) {
        e.printStackTrace();
    }
    return false;
}
public ArrayList<UserInformation>  queryAllStudentInformation(){

    try {
        Connection con= JDBCUtils.getConnection();//获得连接
        Statement stat=con.createStatement();//声明
        String sql="SELECT * FROM studentinformation";//数据库的操作语句s
        ResultSet rs=stat.executeQuery(sql);
        //处理结果集
        while(rs.next()){
            UserInformation studentInformation=new UserInformation();
            studentInformation.setLoginSname(rs.getString("Sname"));
            studentInformation.setLoginSpassword(rs.getString("Spassword"));
            list1.add(studentInformation);
        }
        JDBCUtils.release(stat,con,rs);
    } catch (Exception e) {
        e.printStackTrace();
    }
    return list1;
}
}

 domain（学生类和用户信息类）

package domain;

public class Student {
    private String Sid;//学号
    private String Sname;//姓名
    private Integer Sage;//年龄
    private String Ssex;//性别
    private String CallNumber;
    private String IdentityID;

    public String getSid() {
        return Sid;
    }

    public void setSid(String sid) {
        Sid = sid;
    }

    public String getSname() {
        return Sname;
    }

    public void setSname(String sname) {
        Sname = sname;
    }

    public Integer getSage() {
        return Sage;
    }

    public void setSage(Integer sage) {
        Sage = sage;
    }

    public String getSsex() {
        return Ssex;
    }

    public void setSsex(String ssex) {
        Ssex = ssex;
    }

    public String getCallNumber() {
        return CallNumber;
    }

    public void setCallNumber(String callNumber) {
        CallNumber = callNumber;
    }

    public String getIdentityID() {
        return IdentityID;
    }

    public void setIdentityID(String identityID) {
        IdentityID = identityID;
    }

    @Override
    public String toString() {
        return "Student{" +
                "Sid=" + Sid +
                ", Sname='" + Sname + '\'' +
                ", Sage=" + Sage +
                ", Ssex='" + Ssex + '\'' +
                ", CallNumber='" + CallNumber + '\'' +
                ", IdentityID='" + IdentityID + '\'' +
                '}';
    }
}

package domain;

public class UserInformation {
    private String loginSname;
    private String loginSpassword;

    public String getLoginSname() {
        return loginSname;
    }

    public void setLoginSname(String loginSname) {
        this.loginSname = loginSname;
    }

    public String getLoginSpassword() {
        return loginSpassword;
    }

    public void setLoginSpassword(String loginSpassword) {
        this.loginSpassword = loginSpassword;
    }

    @Override
    public String toString() {
        return "StudentInformation{" +
                "loginSname='" + loginSname + '\'' +
                ", loginSpassword='" + loginSpassword + '\'' +
                '}';
    }
}

 JDBCUtils（对数据库的连接）

package utils;

import java.sql.*;
//获得连接和释放资源
public class JDBCUtils {
        //TODO:获得连接
        public static Connection getConnection() throws Exception {
            //进行驱动
            Class.forName("com.mysql.jdbc.Driver");
            //输入端口的地址和你的用户信息
            String url = "jdbc:mysql://localhost:3306/jdbc";
            String passWord = "520825";
            String userName = "root";
            //获得连接
            Connection con= DriverManager.getConnection(url,userName,passWord);
            return con;
        }
        //TODO:释放资源
        public static void release(Statement stat, Connection con, ResultSet rs){