Java源码社

基于java的Swing+MySQL学生宿舍管理系统(java+swing+mysql)

更新于

运行环境

Java≥8、MySQL≥5.7

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

251923172708

261923172708

271923172708

基于java的Swing+MySQL学生宿舍管理系统(java+swing+mysql)

登录：
admin 12346

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
		});

		this.setSize(660, 510);// 885 715
		this.setLocation(((int) (ds.getWidth()) - 660) / 2, ((int) (ds.getHeight()) - 510) / 2);
		this.setVisible(true);
		this.setResizable(false);
	}

	void updateInfo() {
		StudentDao dao = new StudentDao();
		Student student = new Student();
		student.setId(id);
		student.setCode(code.getText());
		student.setName(name.getText());
		student.setGender(gender.getSelectedItem().toString());
		student.setPhone(phone.getText());
		student.setCollege(college.getText());
		student.setMajor(major.getText());
		student.setGrade(grade.getText());
		student.setArea(area.getText());
		student.setBuilding(building.getText());
		student.setDormitory(dormitory.getText());
		dao.update(student);
	}
}



1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

public void setGender(String gender) {
	this.gender = gender;
}

public String getPhone() {
	return phone;
}

public void setPhone(String phone) {
	this.phone = phone;
}

public String getCollege() {
	return college;
}

public void setCollege(String college) {
	this.college = college;
}

public String getMajor() {
	return major;
}

public void setMajor(String major) {
	this.major = major;
}

public String getGrade() {
	return grade;
}

public void setGrade(String grade) {
	this.grade = grade;
}

public String getArea() {
	return area;
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
phone.setBounds(150, 250, 150, 30);	
college.setBounds(150, 300, 150, 30);	

major.setBounds(420, 100, 150, 30);
grade.setBounds(420, 150, 150, 30);
area.setBounds(420, 200, 150, 30);
building.setBounds(420, 250, 150, 30);
dormitory.setBounds(420, 300, 150, 30);

lab0.setBounds(60, 100, 90, 30);
lab1.setBounds(60, 150, 90, 30);
lab2.setBounds(60, 200, 90, 30);
lab3.setBounds(60, 250, 90, 30);
lab4.setBounds(60, 300, 90, 30);

lab5.setBounds(330, 100, 90, 30);
lab6.setBounds(330, 150, 90, 30);
lab7.setBounds(330, 200, 90, 30);
lab8.setBounds(330, 250, 90, 30);
lab9.setBounds(330, 300, 90, 30);
but1.setBounds(500, 380, 120, 30);
but2.setBounds(360, 380, 120, 30);


lab0.setFont(new Font("华文仿宋",Font.BOLD,18));
lab1.setFont(new Font("华文仿宋",Font.BOLD,18));
lab2.setFont(new Font("华文仿宋",Font.BOLD,18));
lab3.setFont(new Font("华文仿宋",Font.BOLD,18));
lab4.setFont(new Font("华文仿宋",Font.BOLD,18));
lab5.setFont(new Font("华文仿宋",Font.BOLD,18));
lab6.setFont(new Font("华文仿宋",Font.BOLD,18));
lab7.setFont(new Font("华文仿宋",Font.BOLD,18));
lab8.setFont(new Font("华文仿宋",Font.BOLD,18));
lab9.setFont(new Font("华文仿宋",Font.BOLD,18));

but1.setFont(new Font("宋体",Font.BOLD,18));
but2.setFont(new Font("宋体",Font.BOLD,18));

this.add(lab0);
this.add(lab1);
this.add(lab2);
this.add(lab3);
this.add(lab4);
this.add(lab5);
this.add(lab6);
this.add(lab7);
this.add(lab8);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
		StudentDao dao = new StudentDao();
		Student student = new Student();
		student.setId(id);
		student.setCode(code.getText());
		student.setName(name.getText());
		student.setGender(gender.getSelectedItem().toString());
		student.setPhone(phone.getText());
		student.setCollege(college.getText());
		student.setMajor(major.getText());
		student.setGrade(grade.getText());
		student.setArea(area.getText());
		student.setBuilding(building.getText());
		student.setDormitory(dormitory.getText());
		dao.update(student);
	}
}




public class AddFrame extends JDialog{
	
	public int tempnum = 1;

	JLabel lab0 = new JLabel("学      号:");	
	JLabel lab1 = new JLabel("姓      名:");
	JLabel lab2 = new JLabel("性      别:");
	JLabel lab3 = new JLabel("手 机 号:");
	JLabel lab4 = new JLabel("学      院:");
	JLabel lab5 = new JLabel("专      业:");
	JLabel lab6 = new JLabel("班      级:");
	JLabel lab7 = new JLabel("宿 舍 区:");
	JLabel lab8 = new JLabel("楼      栋:");
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
JLabel lab2 = new JLabel("性      别:");
JLabel lab3 = new JLabel("手 机 号:");
JLabel lab4 = new JLabel("学      院:");
JLabel lab5 = new JLabel("专      业:");
JLabel lab6 = new JLabel("班      级:");
JLabel lab7 = new JLabel("宿 舍 区:");
JLabel lab8 = new JLabel("楼      栋:");
JLabel lab9 = new JLabel("宿 舍 号:");
JTextField code = new JTextField();
JTextField name = new JTextField();

JComboBox gender = null;
JTextField phone = new JTextField();
JTextField college = new JTextField();
JTextField major = new JTextField();
JTextField grade = new JTextField();
JTextField area = new JTextField();
JTextField building = new JTextField();
JTextField dormitory = new JTextField();

JButton but1 = new JButton("保存");
JButton but2 = new JButton("取消");
Dimension ds = Toolkit.getDefaultToolkit().getScreenSize();

private int id = 0;

public UpdateFrame(Student stu) throws ClassNotFoundException, SQLException {
	String tempsex[] = { "男", "女" };
	gender = new JComboBox(tempsex);
	this.setLayout(null);
	code.setBounds(150, 100, 150, 30);
	name.setBounds(150, 150, 150, 30);
	gender.setBounds(150, 200, 150, 30);
	phone.setBounds(150, 250, 150, 30);
	college.setBounds(150, 300, 150, 30);

	major.setBounds(420, 100, 150, 30);
	grade.setBounds(420, 150, 150, 30);
	area.setBounds(420, 200, 150, 30);
	building.setBounds(420, 250, 150, 30);
	dormitory.setBounds(420, 300, 150, 30);

	lab0.setBounds(60, 100, 90, 30);
	lab1.setBounds(60, 150, 90, 30);
	lab2.setBounds(60, 200, 90, 30);
	lab3.setBounds(60, 250, 90, 30);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
JLabel lab5 = new JLabel("专      业:");
JLabel lab6 = new JLabel("班      级:");
JLabel lab7 = new JLabel("宿 舍 区:");
JLabel lab8 = new JLabel("楼      栋:");
JLabel lab9 = new JLabel("宿 舍 号:");
JTextField code = new JTextField();
JTextField name = new JTextField();
JComboBox gender = null;
JTextField phone = new JTextField();
JTextField college = new JTextField();
JTextField major = new JTextField();
JTextField grade = new JTextField();
JTextField area = new JTextField();
JTextField building = new JTextField();
JTextField dormitory = new JTextField();

JButton but1 = new JButton("保存");
JButton but2 = new JButton("取消");
Dimension ds = Toolkit.getDefaultToolkit().getScreenSize();
public AddFrame() throws ClassNotFoundException, SQLException{
	String tempsex[] ={"男","女"}; 
	gender = new JComboBox(tempsex);
	this.setLayout(null);
	code.setBounds(150, 100, 150, 30);	
	name.setBounds(150, 150, 150, 30);	
	gender.setBounds(150, 200, 150, 30);	
	phone.setBounds(150, 250, 150, 30);	
	college.setBounds(150, 300, 150, 30);	
	
	major.setBounds(420, 100, 150, 30);
	grade.setBounds(420, 150, 150, 30);
	area.setBounds(420, 200, 150, 30);
	building.setBounds(420, 250, 150, 30);
	dormitory.setBounds(420, 300, 150, 30);
	
	lab0.setBounds(60, 100, 90, 30);
	lab1.setBounds(60, 150, 90, 30);
	lab2.setBounds(60, 200, 90, 30);
	lab3.setBounds(60, 250, 90, 30);
	lab4.setBounds(60, 300, 90, 30);
	
	lab5.setBounds(330, 100, 90, 30);
	lab6.setBounds(330, 150, 90, 30);
	lab7.setBounds(330, 200, 90, 30);
	lab8.setBounds(330, 250, 90, 30);
	lab9.setBounds(330, 300, 90, 30);

项目链接：
https://javayms.github.io?id=241923172708201cg
https://javayms.pages.dev?id=241923172708201cg