基于java+swing+sql的学生成绩管理系统_学生成绩管理系统java和sql

一，项目简介

基于java+swing+sql的学生成绩管理系统，分为教师端和学生端，学生仅有查看操作，教师具有增删改查操作。

二，实体信息

分为学生成绩，学生学习，用户三个实体类

学生成绩实体类：

public class StudentImformAtion {
    
	private String Sno;
	private String Name;
	private String Sex;
	private String Dept;
	private String Address;
	private String Grade;
	private String Tep;
	public StudentImformAtion(String dept, String grade) {
		super();
		Dept = dept;
		Grade = grade;
	}
	public String getSno() {
		return Sno;
	}
	public void setSno(String sno) {
		Sno = sno;
	}
	public StudentImformAtion() {
		super();
		// TODO 自动生成的构造函数存根
		Dept="";
		Grade="";
	}
	public StudentImformAtion(String sno, String name, String sex, String dept, String address, String grade,
			String tep) {
		super();
		Sno = sno;
		Name = name;
		Sex = sex;
		Dept = dept;
		Address = address;
		Grade = grade;
		Tep = tep;
	}
	public String getName() {
		return Name;
	}
	public void setName(String name) {
		Name = name;
	}
	public String getSex() {
		return Sex;
	}
	public void setSex(String sex) {
		Sex = sex;
	}
	public String getDept() {
		return Dept;
	}
	public void setDept(String dept) {
		Dept = dept;
	}
	public String getAddress() {
		return Address;
	}
	public void setAddress(String address) {
		Address = address;
	}
	public String getGrade() {
		return Grade;
	}
	public void setGrade(String grade) {
		Grade = grade;
	}
	public String getTep() {
		return Tep;
	}
	public void setTep(String tep) {
		Tep = tep;
	}
}

学生信息实体类：

 
public class StudentScore {
 
	private int id;
	private String Sno;
	private String Grade;
	public StudentScore(String sno, String grade) {
		super();
		Sno = sno;
		Grade = grade;
	}
	private String Subject;
	private float Score;
	private String Show;
	private float  Uaual;
	private  float Test;
	private float Credit;
	public StudentScore(String sno,String grade, String subject) {
		super();
		Sno = sno;
		Grade = grade;
		Subject = subject;
	}
	public StudentScore(String sno, String grade, String subject, float score, String show, float uaual, float test,
			float credit) {
		super();
		Sno = sno;
		Grade = grade;
		Subject = subject;
		Score = score;
		Show = show;
		Uaual = uaual;
		Test = test;
		Credit = credit;
	}
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getShow() {
		return Show;
	}
	public void setShow(String show) {
		Show = show;
	}
	public float getUaual() {
		return Uaual;
	}
	public void setUaual(float uaual) {
		Uaual = uaual;
	}
	public float getTest() {
		return Test;
	}
	public void setTest(float test) {
		Test = test;
	}
	public float getCredit() {
		return Credit;
	}
	public void setCredit(float credit) {
		Credit = credit;
	}
	public StudentScore() {
		super();
		// TODO 自动生成的构造函数存根
	}
	public String getSno() {
		return Sno;
	}
	public void setSno(String sno) {
		Sno = sno;
	}
	public String getGrade() {
		return Grade;
	}
	public void setGrade(String grade) {
		Grade = grade;
	}
	public String getSubject() {
		return Subject;
	}
	public void setSubject(String subject) {
		Subject = subject;
	}
	public float getScore() {
		return Score;
	}
	public void setScore(float score) {
		Score = score;
	}
}

用户实体类：

public class User {
	public User() {
		super();
		// TODO 自动生成的构造函数存根
	}
	public User(String userName, String passWord) {
		super();
		this.userName = userName;
		this.passWord = passWord;
	}
	private int id;
	private String userName;
	private String passWord;
	//alt+shift+s
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getUserName() {
		return userName;
	}
	public void setUserName(String userName) {
		this.userName = userName;
	}
	public String getPassWord() {
		return passWord;
	}
	public void setPassWord(String passWord) {
		this.passWord = passWord;
	}
	
	
}

结果展示

登陆界面

学生端功能部分展示

 教师端部分功能展示