《学生学籍管理系统含java源代码.docx》由会员分享，可在线阅读，更多相关《学生学籍管理系统含java源代码.docx（24页珍藏版）》请在三一文库上搜索。
1、学生学籍管理详细设计学号：姓名：班级：一、设计题目：学生学籍管理二：设计内容：设计GUI学生学籍管理界面，用户可以加入学生信息，并对基本信息进行修 改，添加，查询，删除。三：设计要求：进行简单的学生信息管理。四：总体设计(1)登陆界面的设计(2) 主窗体的设计(3) 添加学生信息窗体(4) 查询学生信息窗体(5) 修改学生信息窗体(6) 删除学生信息窗体(7) 事件响应的处理五：具体设计(1)程序结构的说明：A. 入 口程序：student.java;B. 登陆界面程序：mainframe.java;C. 主窗体程序：interfac.java;D. 添加信息窗口程序：tj.java;E. 修
2、改信息窗口程序：xg.java;F. 查询信息窗口程序：cx.java;G. 删除信息窗口程序：sc.java;H. 程序数据连接：DatabaseConn.java;（2）程序代码及分析说明A. 程序源代码（已提交）B. Student.java是程序的入口。使登录窗口位于窗口中间，并且不可改变窗口大小。C. mainframe.java 是程序的登陆窗体。输入用户名和密码（用户名和密码在数 据库的password表中）点击“进入系统”，然后登陆界面消失；出现要操作的界 面（屏幕左上角）。D. tj.java是添加信息界面。添加基本信息后，点击“添加信息”按钮，将信息加入xinxi 表中。E
3、. xg.java 是修改信息界面。输入要修改的学号或姓名（两者数其一或全部输 入），并输入所有信息，点击“修改信息”按钮（如果数据库中不存在此学号， 则弹出对话框“无此学生信息”），若有则修改。F. sc.java是删除信息界面。输入要删除的学生的学号，点击“删除信息”按钮, 弹出确认删除对话框，即可删除该生信息。G. cx.java是查询信息界面。输入要查询的学生学号，点击“信息查询”按钮， 在相应的文本区里显示查询的信息。H:源代码/student.java: 程序的入口。初始化界面，使主界面位于屏幕中间，且用户不 能改变大小/功能：完成程序的执行顺序 import javax.swin
4、g.UIManager;import java.awt.*;import java.sql.*;/import screenpublic class studentboolean packFrame=false;/JFrame frame=new JFrame();public student()mainframe frame=new mainframe();if(packFrame)frame.pack();else frame.validate();DimensionscreenSize=Toolkit.getDefaultToolkit().getScreenSize();Dimensi
5、on frameSize=frame.getSize();if(frameSize.height>screenSize.height)(frameSize.height=screenSize.height;if(frameSize.width>screenSize.width)(frameSize.width=screenSize.width;frame.setLocation(screenSize.width-frameSize.width)/2,(screenSize.height-frameSize.height)/2);frame.setVisible(true);publ
6、ic static void main(String args)(try(UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName( );catch(Exception e)(e.printStackTrace();new student();/数据库连接/package sql.database;import java.sql.*;public class DatabaseConn(private static String user="”;private static String password=&quo
7、t;”;private Connection conn=null;private Statement stmt=null;private ResultSet rs=null;static(tryClass.forName("sun.jdbc.odbc.JdbcOdbcDriver");/加载驱动catch(ClassNotFoundException e)(创建数据库连接对象public Connection getConnection()(try(conn=DriverManager.getConnection("jdbc:odbc:stu”,user,pass
8、word); return conn;catch(SQLException e)(return null;public Statement createStat()(try(conn=getConnection();stmt=conn.createStatement();return stmt;catch(SQLException e)(return null;public ResultSet getRs(String sql)(try(conn=getConnection();/.stmt=createStat();rs=stmt.executeQuery(sql);return rs;ca
9、tch(SQLException e)(return null;public void close()(try(if(rs!=null)rs.close();if(stmt!=null)stmt.close();if(conn!=null)conn.close();catch(SQLException ex)(ex.printStackTrace();/mainframe.javaimport java.awt.*;import java.awt.event.*;import javax.swing.*;import java.sql.*;public class mainframe exte
10、nds JFrame implements ActionListener(static mainframe s;static JPanel pan=new JPanel();static JLabel label1 = new JLabel(" 用 户");static JLabel label2 = new JLabel(" 密 码");static JTextField textField1 = new JTextField();static JPasswordField password = new JPasswordField();,true);
11、/static JButton button1 = new JButton("进入系统");static JRadioButton radioButton1=newJRadioButton(”管理员“管理员”初始状态被选中static JRadioButton radioButton2=newJRadioButton("学生");static JRadioButton radioButton3=newJRadioButton("教师");ButtonGroup buttonGroup=new ButtonGroup();public
12、mainframe()(JLabel label=new JLabel(new ImageIcon(” 图片 44.jpg");label.setSize(400,400);pan.add(label);pan.setLayout(null);pan.setSize(400,400);this.setTitle(" 学籍管理系统");this.setSize(400,400);this.setLayout(null);label1.setBounds(100,25,49,20);textField1.setBounds(155,24,120,20);label2.
13、setBounds(100,62,49,20);password.setBounds(155,61,120,20);button1.setBounds(150,200,101,22);radioButton1.setBounds(105,120,80,20);radioButton2.setBounds(180,120,60,20);radioButton3.setBounds(240,120,60,20);button1.addActionListener(this);buttonGroup.add(radioButton1);buttonGroup.add(radioButton2);bu
14、ttonGroup.add(radioButton3);this.add(radioButton1);this.add(radioButton2);this.add(radioButton3);this.add(label1);this.add(label2);this.add(textField1);this.add(password);this.add(button1);this.add(pan);this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); this.setVisible(true);public static void mai
15、n(String args)new mainframe();public void actionPerformed(ActionEvent e)if(radioButton1.isSelected()/ 管理员if(textField1.getText().equals("syc")&&password.getText().equals("123”)interfac b=new interfac();this.dispose();/JOptionPane.showMessageDialog(null,”登陆成功");elseif(&quo
16、t;”.equals(textField1.getText()|"".equals(password.getText() )(JOptionPane.showMessageDialog(null,"用户名或密码不能为 空")；else(JOptionPane.showMessageDialog(null,"用户名或密码输入有误"); if(radioButton2.isSelected()/ 学生( try(Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); catch (
17、ClassNotFoundException ce) ( JOptionPane.showMessageDialog(s,ce.getMessage(); try ( Connectioncon=DriverManager.getConnection("jdbc:odbc:stu","sa",""); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("select * from password where用户 名 ="
18、;'+textField1.getText()+"'and 密 码 ='"+password.getText()+"'");if(textField1.getText().equals("")|password.getText().equals("")(JOptionPane.showMessageDialog(this,"用户名或密码不可为空！");else if(rs.next()( new interfac();else(JOptionPane.showMe
19、ssageDialog(this,"您的输入有误");/stmt.close();catch (SQLException se)(JOptionPane.showMessageDialog(s,se.getMessage();/interface.javaimport java.awt.*;import java.awt.event.*;import javax.swing.*;public class interfac extends JFrame implements ActionListenerstatic JMenuBar jMenuBar = new JMenuB
20、ar();/ 菜单条static JMenu jMenuFile = new JMenu("文件");/ 菜单项static JMenu jMenuExit = new JMenu("退出");菜单子项static JMenuItem jMenuItem1 = new JMenuItem("添加信息");/static JMenuItem jMenuItem2 = new JMenuItem("修改信息");static JMenuItem jMenuItem3 = new JMenuItem(" 信息查
21、询");static JMenuItem jMenuItem4 = new JMenuItem(" 删除信息");请选择操作项");学籍管理系统");添加信息");修改信息");信息查询");删除信息");static JLabel label3 = new JLabel(" static JLabel label4 = new JLabel(" static JButton button2 = new JButton( static JButton button3 = new JBu
22、tton( static JButton button4 = new JButton( static JButton button5 = new JButton(public interfac()(this.setTitle("学籍管理系统");this.setLayout(null);this.setSize(400,400);label3.setBounds(158,92,98,33);label3.setFont(new Font("Dialog”,Font.PLAIN,15);label4.setFont(new Font("Dialog”,Fo
23、nt.BOLD,20);label4.setBounds(157,37,280,40);button2.setBounds(74,136,97,33);button3.setBounds(226,136,97,33);button4.setBounds(74,185,97,33);button5.setBounds(226,185,97,33);this.add(button2);this.add(button3);this.add(button4);this.add(button5);this.add(label3);this.add(label4);setJMenuBar(jMenuBar
24、);jMenuFile.add(jMenuIteml);/ ”文件“菜单项中加入子菜单jMenuFile.add(jMenuItem2);jMenuFile.add(jMenuItem3);jMenuFile.add(jMenuItem4);jMenuBar.add(jMenuFile);/ 将菜单项加入菜单条jMenuBar.add(jMenuExit);button2.addActionListener(this);/本窗 口 向按钮事件源注册button3.addActionListener(this);button4.addActionListener(this);button5.ad
25、dActionListener(this);jMenuItem1.addActionListener(this);/本窗 口 菜单子项注册jMenuItem2.addActionListener(this);jMenuItem3.addActionListener(this);jMenuItem4.addActionListener(this);jMenuExit.addActionListener(this);this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);this.setVisible(true);public static void
26、 main(String args)interfac a=new interfac();public void actionPerformed(ActionEvent e) /按钮事件的处理if(e.getSource()=jMenuExit)System.exit(0);else if(e.getSource()=jMenuItem1|e.getSource()=button2)trytj a=new tj();catch(Exception ee) else if(e.getSource()=jMenuItem2|e.getSource()=button3) (try(xg a=new x
27、g();catch(Exception ed)(elseif(e.getSource()=jMenuItem3|e.getSource()=button4)(tiy cx a=new cx(); catch(Exception ec)elseif(e.getSource()=jMenuItem4|e.getSource()=button5)trysc a=new sc();catch(Exception es)/tj.java添加界面import javax.swing.*;import java.awt.*;import java.awt.event.*;import java.sql.*;
28、public class tj extends JFrame implements ActionListenerstatic tj s;static JLabel labell = new JLabel(" 学号:");static JTextField textFieldl = new JTextField("");static JLabel label2 = new JLabel("姓名:");static JTextField textField2 = new JTextField("");static JL
29、abel label3 = new JLabel("性别:，static JTextField textField7=new JTextField("");static JLabel label4 = new JLabel("出生日期:");static JTextField textField3 = new JTextField("");static JLabel label5 = new JLabel("政治面貌:");static JTextField textField8=new JTextFie
30、ld("");static JLabel label6 = new JLabel("籍贯")；static JTextField textField4 = new JTextField("");static JLabel label7 = new JLabel("系别:，static JTextField textField9 = new JTextField("");static JLabel label8 = new JLabel("专业:");static JTextField
31、textField5 = new JTextField("");static JButton button1 = new JButton("增加");public tj()this.setTitle(-增加学生信息");this.setLayout(null);this.setSize(400,400);label1.setBounds(30, 11,51, 33);textField1.setBounds(86, 16, 74, 22);label2.setBounds(162, 11,51,33);textField2.setBounds(
32、192, 16, 44, 22);label3.setBounds(241, 11, 70, 33);textField7.setBounds(275, 15, 50, 25);label4.setBounds(31,53, 55, 33);textField3.setBounds(86, 58, 74, 22);label5.setBounds(241,53, 70, 33);textField8.setBounds(296, 57, 72, 25);label6.setBounds(163, 53, 26, 33);textField4.setBounds(191,58, 44, 22);
33、label7.setBounds(30, 94, 50, 33);textField9.setBounds(86,94,74,22);label8.setBounds(163, 94, 51,33);textField5.setBounds(190, 99, 178, 22);button1.setBounds(25,241,80,33);button1.addActionListener(this);this.add(label1);this.add(label2);this.add(label3);this.add(label4);this.add(label5);this.add(lab
34、el6);this.add(label7);this.add(label8);this.add(textField1);this.add(textField2);this.add(textField3);this.add(textField4);this.add(textField5);this.add(textField7);this.add(textField8);this.add(textField9);this.add(buttonl);this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);this.setVisible(true
35、);public static void main(String args) throws Exceptiontj a= new tj();a.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);public void actionPerformed(ActionEvent e)/事件处理程序if (e.getSource() = button1)tryClass.forName("sun.jdbc.odbc.JdbcOdbcDriver");catch (ClassNotFoundException ce)JOptionPane.
36、showMessageDialog(s,ce.getMessage();tryConnectioncon=DriverManager.getConnection("jdbc:odbc:stu”,"sa”,”");Statement stmt = con.createStatement();ResultSet rs=stmt.executeQuery("select * from xinxi where 学号 ='"+textField1.getText()+"”');if(rs.next()JOptionPane.sh
37、owMessageDialog(null,”此学号已经被注册"); else stmt.execute("insert into xinxi (学号,姓名,性别，出生日期，籍贯,系另J,专业)values ('"+textField1.getText()+"',”'+textField2.getText()+*"+textField7.getText()+"',”'+textField3.getText()+"',”'+textField8.getText()+*&qu
38、ot;+textField4.getText()+"',”'+textField9.getText()+"',”'+textField5.getText()+"')”)；JOptionPane.showMessageDialog(null,"添加信息成功");catch (SQLException se)(JOptionPane.showMessageDialog(s,se.getMessage();/xg.java 修改界面import javax.swing.*;import java.awt.*;i
39、mport java.awt.event.*;import java.sql.*;public class xg extends JFrame implements ActionListener(static xg s;static JLabel labell = new JLabel("学号:");static JTextField textFieldl = new JTextField("");static JLabel label2 = new JLabel("姓名:");static JTextField textField2
40、 = new JTextField("");static JLabel label3 = new JLabel("性别:，static JTextField textField7=new JTextField("");static JLabel label4 = new JLabel("出生日期:");static JTextField textField3 = new JTextField("");static JLabel label5 = new JLabel("政治面貌:");
41、static JTextField textField8=new JTextField("");static JLabel label6 = new JLabel("籍贯");static JTextField textField4 = new JTextField("");static JLabel label7 = new JLabel("系别:，static JTextField textField9 = new JTextField("");static JLabel label8 = new J
42、Label("专业:");static JTextField textField5 = new JTextField("");static JButton button2=new JButton(" 修改");public xg()this.setTitle(" 修改学生信息");this.setLayout(null);this.setSize(400,400);label1.setBounds(30, 11,51, 33);textField1.setBounds(86, 16, 74, 22);label2.
43、setBounds(162, 11,51,33);textField2.setBounds(192, 16, 44, 22);label3.setBounds(241, 11, 70, 33);textField7.setBounds(275, 15, 50, 25);label4.setBounds(31,53, 55, 33);textField3.setBounds(86, 58, 74, 22);label5.setBounds(241,53, 70, 33);textField8.setBounds(296, 57, 72, 25);label6.setBounds(163, 53,
44、 26, 33);textField4.setBounds(191,58, 44, 22);label7.setBounds(30, 94, 50, 33);textField9.setBounds(86,94,74,22);label8.setBounds(163, 94, 51,33);textField5.setBounds(190, 99, 178, 22);button2.setBounds(115,241,80,33);button2.addActionListener(this);this.add(label1);this.add(label2);this.add(label3)
45、;this.add(label4);this.add(label5);this.add(label6);this.add(label7);this.add(label8);this.add(textField1);this.add(textField2);this.add(textField3);this.add(textField4);this.add(textField5);this.add(textField7);this.add(textField8);this.add(textField9);this.add(button2);this.setDefaultCloseOperatio
46、n(JFrame.DISPOSE_ON_CLOSE);this.setVisible(true);public static void main(String args) throws Exceptionxg a=new xg();a.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);一 一public void actionPerformed(ActionEvent e)/事件处理程序if(e.getSource()=button2)tryClass.forName("sun.jdbc.odbc.JdbcOdbcDriver")
47、;catch (ClassNotFoundException ce)JOptionPane.showMessageDialog(s,ce.getMessage();tryConnection con = DriverManager.getConnection("jdbc:odbc:stu","sa","");Statement stmt = con.createStatement();ResultSet rs=stmt.executeQuery("select * from xinxi where 学号='"
48、;+textField1.getText ()+"”');if(textField1.getText().trim().equals("")JOptionPane.showMessageDialog(this,”学号不可为空!"); else if(rs.next()updateSql="update xinxi姓名set 学号String='"+textField1.getText()+"',IIItextField2.getText()+"',=”'+textField7
49、.getText()+"',生日期='"+textField3.getText()+"',政治面貌='"+textField8.getText()+"',籍贯='"+textField4.getText()+"',系 别='H+textField9.getText()+H',专业='"+textField5.getText()+ "”'try(stmt.executeQuery(updateSql); catch(SQLException se)