java程序对学生成绩_Eclipse+Java+Swing实现学生成绩管理系统的实例代码

一、系统介绍

本系统实现了用户登录，实现了对学生成绩的增删改查，实现了用户修改密码功能，采用MD5加密算法，数据库使用Mysql8.0.13，界面良好。

二、系统展示

1.登录页

2.主页面

3.查询学生成绩

4.修改学生成绩

5.添加学生成绩

6.修改系统密码

三、系统实现 Student.java

package com.sjsq.model;

import java.util.ArrayList;

import java.util.List;

/**

* 学生实体类

* @author shuijianshiqing

*

*/

public class Student {

// 学号

private String sId;

// 姓名

private String sName;

// 性别

private String sSex;

// 学院

private String sCollege;

private String sC;

private String sMath;

private String sEnglish;

private String sChinese;

private String sJava;

public Student() {

super();

}

public Student(String sId, String sName, String sSex, String sCollege, String sC, String sMath,

String sEnglish, String sChinese, String sJava) {

super();

this.sId = sId;

this.sName = sName;

this.sSex = sSex;

this.sCollege = sCollege;

this.sC = sC;

this.sMath = sMath;

this.sEnglish = sEnglish;

this.sChinese = sChinese;

this.sJava = sJava;

}

public static List students=new ArrayList();

public String getsId() {

return sId;

}

public void setsId(String sId) {

this.sId = sId;

}

public String getsName() {

return sName;

}

public void setsName(String sName) {

this.sName = sName;

}

public String getsSex() {

return sSex;

}

public void setsSex(String sSex) {

this.sSex = sSex;

}

public String getsCollege() {

return sCollege;

}

public void setsCollege(String sCollege) {

this.sCollege = sCollege;

}

public String getsC() {

return sC;

}

public void setsC(String sC) {

this.sC = sC;

}

public String getsMath() {

return sMath;

}

public void setsMath(String sMath) {

this.sMath = sMath;

}

public String getsEnglish() {

return sEnglish;

}

public void setsEnglish(String sEnglish) {

this.sEnglish = sEnglish;

}

public String getsChinese() {

return sChinese;

}

public void setsChinese(String sChinese) {

this.sChinese = sChinese;

}

public String getsJava() {

return sJava;

}

public void setsJava(String sJava) {

this.sJava = sJava;

}

@Override

public String toString() {

return "Student [sId=" + sId + ", sName=" + sName + ", sSex=" + sSex + ", sCollege=" + sCollege + ", sC="

+ sC + ", sMath=" + sMath + ", sEnglish=" + sEnglish + ", sChinese=" + sChinese + ", sJava="

+ sJava + "]";

}

}

StudentDao.java

package com.sjsq.dao;

import java.io.FileInputStream;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.InputStream;

import java.io.OutputStream;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.Iterator;

import java.util.List;

import com.sjsq.model.Student;

import com.sjsq.util.DBUtil;

public class StudentDao {

public static int progress;

// private final String FILE_PATH="d:\\student.xls";

public static StudentDao getInstance() {

StudentDao studentDao;

return stu