本文实例为大家分享了java学生信息管理系统源码的具体代码，供大家参考，具体内容如下
1、studetmanage类（主界面）
|
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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
|
package com.sms3;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
public class studentmanage extends jframe implements actionlistener
{
/**
* @param args
*/
public static void main(string[] args)
{
// todo auto-generated method stub
new studentmanage();
}
//========面板控件
private jlabel querylab = null;
private jtextfield querytxt = null;
private jbutton querybtn = null;
private jbutton allbtn = null;
private jtable resulttb = null;
private jscrollpane jsp = null;
private jbutton addbtn = null;
private jbutton deletebtn = null;
private jbutton updatebtn = null;
private jpanel top = null;
private jpanel bottom = null;
//========
private stumodel sm = null;
//构造函数
public studentmanage()
{
/***************************初始化面板控件***********************/
//========查询栏
querylab = new jlabel("请输入姓名:");
querytxt = new jtextfield(10);
querybtn = new jbutton("查询");
allbtn = new jbutton("全部");
//......添加查询栏监听
querybtn.addactionlistener(this);
querybtn.setactioncommand("query");
allbtn.addactionlistener(this);
allbtn.setactioncommand("all");
//========增删改栏
addbtn = new jbutton("添加");
deletebtn = new jbutton("删除");
updatebtn = new jbutton("修改");
//......添加增删改栏监听
addbtn.addactionlistener(this);
addbtn.setactioncommand("add");
deletebtn.addactionlistener(this);
deletebtn.setactioncommand("delete");
updatebtn.addactionlistener(this);
updatebtn.setactioncommand("update");
//========创建窗口整体布局
//......顶层查询栏
top = new jpanel();
top.add(querylab);
top.add(querytxt);
top.add(querybtn);
top.add(allbtn);
//......底层增删改栏
bottom = new jpanel();
bottom.add(addbtn);
bottom.add(deletebtn);
bottom.add(updatebtn);
//......中间层显示栏
sm = new stumodel();
string sql = "select * from stu";
sm.querystu(sql, null);
resulttb = new jtable(sm);
jsp = new jscrollpane(resulttb);
//......构建整体布局
this.add(top,borderlayout.north);
this.add(jsp,borderlayout.center);
this.add(bottom,borderlayout.south);
//========设置窗口属性
this.setsize(400, 300);
this.setdefaultcloseoperation(jframe.exit_on_close);
this.setvisible(true);
this.setresizable(false);
}
//监听
@override
public void actionperformed(actionevent e)
{
// todo auto-generated method stub
if(e.getactioncommand().equals("query")) {
/*********************查询***********************/
//========获取输入学生的姓名
string name = querytxt.gettext().trim();
if(name.length() != 0) {
//========姓名输入有效时，执行查询
//......定义参数
string sql = "select * from stu where stuname=?";
string []paras = {name};
//......更新模型
jtableupdate(sql, paras);
} else {
//========姓名为空时，设置提醒
joptionpane.showmessagedialog(this, "姓名输入不能为空");
}
} else if(e.getactioncommand().equals("add")) {
/*********************添加***********************/
new stuadddialog(this, "添加学生信息", true);
string sql = "select * from stu";
jtableupdate(sql, null);
} else if(e.getactioncommand().equals("all")) {
/*********************全部显示***********************/
string sql = "select * from stu";
jtableupdate(sql, null);
} else if(e.getactioncommand().equals("delete")) {
/*********************删除***********************/
//========获取选择行号
int rownum = this.resulttb.getselectedrow();
if(rownum == -1) {
joptionpane.showmessagedialog(this, "请选择一行");
return ;
}
//========获取学生id号
string stuid = (string)sm.getvalueat(rownum, 0);
//========删除学生
string sql = "delete from stu where stuid=?";
string []paras = {stuid};
stumodel tmp = new stumodel();
tmp.cudstu(sql, paras);
//========更新模型
sql = "select * from stu";
jtableupdate(sql, null);
} else if(e.getactioncommand().equals("update")) {
/*********************修改***********************/
//========获取选择行号
int rownum = this.resulttb.getselectedrow();
if(rownum == -1) {
joptionpane.showmessagedialog(this, "请选择一行");
return ;
}
new stuupdatedialog(this, "修改学生信息", true, sm, rownum);
string sql = "select * from stu";
jtableupdate(sql, null);
}
}
//========更新jtable内数据
public void jtableupdate(string sql, string[] paras)
{
//......创建模型
sm = new stumodel();
sm.querystu(sql, paras);
//......更新显示
resulttb.setmodel(sm);
}
}
|
2、stumodel类（学生数据库模型）
|
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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
|
package com.sms3;
import java.sql.resultset;
import java.util.vector;
import javax.swing.table.abstracttablemodel;
public class stumodel extends abstracttablemodel{
private vector columnnames;
private vector rowdates;
//
public stumodel()
{
string sql = "select * from stu";
string []paras = {};
}
//========增删改学生
public boolean cudstu(string sql, string []paras)
{
return new sqlhelper().cudexecute(sql, paras);
}
//========查询学生
public void querystu(string sql, string []paras)
{
sqlhelper sqlhelper = null;
//========初始化jtable信息
columnnames = new vector();
rowdates = new vector();
columnnames.add("学号"); columnnames.add("名字");
columnnames.add("性别"); columnnames.add("年龄");
columnnames.add("籍贯"); columnnames.add("系别");
try {
sqlhelper = new sqlhelper();
resultset rs = sqlhelper.queryexecute(sql, paras);
while(rs.next()) {
vector row = new vector();
row.add(rs.getstring(1));
row.add(rs.getstring(2));
row.add(rs.getstring(3));
row.add(rs.getstring(4));
row.add(rs.getstring(5));
row.add(rs.getstring(6));
rowdates.add(row);
}
} catch (exception e) {
// todo: handle exception
} finally {
sqlhelper.close();
}
}
@override
public int getcolumncount() {
// todo auto-generated method stub
return this.columnnames.size();
}
@override
public int getrowcount() {
// todo auto-generated method stub
return this.rowdates.size();
}
@override
public object getvalueat(int row, int col) {
// todo auto-generated method stub
if(!rowdates.isempty())
return ((vector)this.rowdates.get(row)).get(col);
else
return null;
}
@override
public string getcolumnname(int column) {
// todo auto-generated method stub
return (string)this.columnnames.get(column);
}
}
|
3、stuadddialog类（添加学生信息子界面）
|
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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
|
package com.sms3;
import java.awt.borderlayout;
import java.awt.dialog;
import java.awt.frame;
import java.awt.gridlayout;
import java.awt.event.actionevent;
import java.awt.event.actionlistener;
import javax.swing.*;
public class stuadddialog extends jdialog implements actionlistener{
//=========面板控件
//......左侧标题栏
private jlabel idlab,namelab,sexlab,agelab,jglab,deptlab;
//......右侧信息选择填写栏
private jtextfield idtxt,nametxt,sextxt,agetxt,jgtxt,depttxt;
//......添加和取消按钮
private jbutton addbtn,cancelbtn;
//......布局控件
private jpanel left,center,bottom;
//构造函数
public stuadddialog(frame owner, string title, boolean modal)
{
//========重写父类方法
super(owner, title, modal);
//========左侧标签栏
idlab = new jlabel("学号: ");
namelab = new jlabel("姓名: ");
sexlab = new jlabel("性别: ");
agelab = new jlabel("年龄: ");
jglab = new jlabel("籍贯: ");
deptlab = new jlabel("系别: ");
//========右侧信息填写栏
idtxt = new jtextfield();
nametxt = new jtextfield();
sextxt = new jtextfield();
agetxt = new jtextfield();
jgtxt = new jtextfield();
depttxt = new jtextfield();
//========添加和取消按钮
addbtn = new jbutton("添加");
cancelbtn = new jbutton("取消");
//......添加监听
addbtn.addactionlistener(this);
addbtn.setactioncommand("add");
cancelbtn.addactionlistener(this);
cancelbtn.setactioncommand("cancel");
//========创建布局
//......创建左边栏
left = new jpanel();
left.setlayout(new gridlayout(6, 1));
left.add(idlab); left.add(namelab);
left.add(sexlab); left.add(agelab);
left.add(jglab); left.add(deptlab);
//......创建右边栏
center = new jpanel();
center.setlayout(new gridlayout(6, 1));
center.add(idtxt); center.add(nametxt);
center.add(sextxt); center.add(agetxt);
center.add(jgtxt); center.add(depttxt);
//========底层添加和取消按钮
bottom = new jpanel();
bottom.add(addbtn);
bottom.add(cancelbtn);
//========整体布局
this.add(left,borderlayout.west);
this.add(center,borderlayout.center);
this.add(bottom,borderlayout.south);
//========设置窗口属性
this.setsize(300, 250);
this.setresizable(false);
this.setvisible(true);
}
@override
public void actionperformed(actionevent e)
{
// todo auto-generated method stub
if(e.getactioncommand().equals("add")) {
/***********************添加学生信息**************************/
stumodel tmp = new stumodel();
string sql = "insert into stu values(?,?,?,?,?,?)";
string []paras = {idtxt.gettext(),nametxt.gettext(),sextxt.gettext(),
agetxt.gettext(),jgtxt.gettext(),depttxt.gettext()};
if(!tmp.cudstu(sql, paras))
joptionpane.showmessagedialog(this, "添加学生信息失败");
//========关闭窗口
this.dispose();
} else if(e.getactioncommand().equals("cancel")) {
//========关闭窗口
this.dispose();
}
}
}
|
4、stuupdatedialog类（修改学生信息子界面）
|
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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
|
package com.sms3;
import java.awt.borderlayout;
import java.awt.frame;
import java.awt.gridlayout;
import java.awt.event.actionevent;
import java.awt.event.actionlistener;
import javax.swing.jbutton;
import javax.swing.jdialog;
import javax.swing.jlabel;
import javax.swing.joptionpane;
import javax.swing.jpanel;
import javax.swing.jtextfield;
import javax.swing.table.abstracttablemodel;
public class stuupdatedialog extends jdialog implements actionlistener{
//=========面板控件
//......左侧标题栏
private jlabel idlab,namelab,sexlab,agelab,jglab,deptlab;
//......右侧信息选择填写栏
private jtextfield idtxt,nametxt,sextxt,agetxt,jgtxt,depttxt;
//......添加和取消按钮
private jbutton addbtn,cancelbtn;
//......布局控件
private jpanel left,center,bottom;
//构造函数
public stuupdatedialog(frame owner, string title, boolean modal, stumodel sm, int rownum)
{
//========重写父类方法
super(owner, title, modal);
//========左侧标签栏
idlab = new jlabel("学号: ");
namelab = new jlabel("姓名: ");
sexlab = new jlabel("性别: ");
agelab = new jlabel("年龄: ");
jglab = new jlabel("籍贯: ");
deptlab = new jlabel("系别: ");
//========右侧信息填写栏
idtxt = new jtextfield();
idtxt.settext((string)sm.getvalueat(rownum, 0));
idtxt.seteditable(false);
nametxt = new jtextfield();
nametxt.settext((string)sm.getvalueat(rownum, 1));
sextxt = new jtextfield();
sextxt.settext((string)sm.getvalueat(rownum, 2));
agetxt = new jtextfield();
agetxt.settext((string)sm.getvalueat(rownum, 3));
jgtxt = new jtextfield();
jgtxt.settext((string)sm.getvalueat(rownum, 4));
depttxt = new jtextfield();
depttxt.settext((string)sm.getvalueat(rownum, 5));
//========添加和取消按钮
addbtn = new jbutton("修改");
cancelbtn = new jbutton("取消");
//......添加监听
addbtn.addactionlistener(this);
addbtn.setactioncommand("update");
cancelbtn.addactionlistener(this);
cancelbtn.setactioncommand("cancel");
//========创建布局
//......创建左边栏
left = new jpanel();
left.setlayout(new gridlayout(6, 1));
left.add(idlab); left.add(namelab);
left.add(sexlab); left.add(agelab);
left.add(jglab); left.add(deptlab);
//......创建右边栏
center = new jpanel();
center.setlayout(new gridlayout(6, 1));
center.add(idtxt); center.add(nametxt);
center.add(sextxt); center.add(agetxt);
center.add(jgtxt); center.add(depttxt);
//========底层添加和取消按钮
bottom = new jpanel();
bottom.add(addbtn);
bottom.add(cancelbtn);
//========整体布局
this.add(left,borderlayout.west);
this.add(center,borderlayout.center);
this.add(bottom,borderlayout.south);
//========设置窗口属性
this.setsize(300, 250);
this.setresizable(false);
this.setvisible(true);
}
@override
public void actionperformed(actionevent e) {
// todo auto-generated method stub
if(e.getactioncommand().equals("update")) {
/***********************修改学生信息**************************/
stumodel tmp = new stumodel();
string sql = "update stu set stuname=?,stusex=?,stuage=?,stujg=?,studept=? where stuid=?";
string []paras = {nametxt.gettext(),sextxt.gettext(),agetxt.gettext(),
jgtxt.gettext(),depttxt.gettext(),idtxt.gettext()};
if(!tmp.cudstu(sql, paras))
joptionpane.showmessagedialog(this, "修改学生信息失败");
//========关闭窗口
this.dispose();
} else if(e.getactioncommand().equals("cancel")) {
//========关闭窗口
this.dispose();
}
}
}
|
5、sqlhelper类（最底层数据库类）
|
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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
|
package com.sms3;
import java.sql.*;
public class sqlhelper {
//========数据库
private connection ct = null;
private preparedstatement ps = null;
private resultset rs = null;
private string driver = "com.microsoft.sqlserver.jdbc.sqlserverdriver";
private string url = "jdbc:sqlserver://127.0.0.1:1433;database=studentman";
private string user = "sa";
private string passwd = "****";
//========查询
public resultset queryexecute(string sql, string []paras)
{
try {
//========1、加载驱动
class.forname(driver);
//========2、连接
ct = drivermanager.getconnection(url, user, passwd);
//========3、创建preparedstatement
ps = ct.preparestatement(sql);
//========4、给问号赋值
if(paras != null) {
for(int i = 0; i < paras.length; i++) {
ps.setstring(i + 1, paras[i]);
}
}
//========5、执行
rs = ps.executequery();
} catch (exception e) {
// todo: handle exception
e.printstacktrace();
} finally {
//this.close();
}
//========返回值
return rs;
}
//========增删改
public boolean cudexecute(string sql, string []paras)
{
boolean b = true;
try {
//========1、加载驱动
class.forname(driver);
//========2、连接
ct = drivermanager.getconnection(url, user, passwd);
//========3、创建preparedstatement
ps = ct.preparestatement(sql);
//========4、给问号赋值
for(int i = 0; i < paras.length; i++) {
ps.setstring(i + 1, paras[i]);
}
//========5、执行
if(ps.executeupdate() != 1) b = false;
} catch (exception e) {
// todo: handle exception
b = false;
e.printstacktrace();
} finally {
this.close();
}
//========返回值
return b;
}
//========关闭资源
public void close()
{
try {
if(rs!=null) rs.close();
if(ps!=null) ps.close();
if(ct!=null) ct.close();
} catch (exception e2) {
// todo: handle exception
e2.printstacktrace();
}
}
}
|
主界面
添加学生信息界面
修改学生信息界面
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持服务器之家。
原文链接：http://blog.csdn.net/xsc_c/article/details/12526963