服务器之家:专注于服务器技术及软件下载分享
分类导航

PHP教程|ASP.NET教程|Java教程|ASP教程|编程技术|正则表达式|C/C++|IOS|C#|Swift|Android|VB|R语言|JavaScript|易语言|vb.net|

服务器之家 - 编程语言 - Java教程 - java+SQL server2008学生信息管理系统源码

java+SQL server2008学生信息管理系统源码

2021-03-23 14:15蔡金平 Java教程

这篇文章主要为大家详细介绍了java+SQL server2008学生信息管理系统源码,具有一定的参考价值,感兴趣的小伙伴们可以参考一下

本文实例为大家分享了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();
    }
  }
   
}

主界面

java+SQL server2008学生信息管理系统源码

添加学生信息界面

java+SQL server2008学生信息管理系统源码

修改学生信息界面

java+SQL server2008学生信息管理系统源码

以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持服务器之家。

原文链接:http://blog.csdn.net/xsc_c/article/details/12526963

延伸 · 阅读

精彩推荐