学生学籍管理系统(含java源代码)

1、学生学籍管理详细设计学号：姓名：班级：一、设计题目：学生学籍管理二：设计内容：设计GUI学生学籍管理界面，用户可以加入学生信息，并对基本信息进行修改，添加，查询，删除。三：设计要求：进行简单的学生信息管理。四：总体设计(1)登陆界面的设计(2)主窗体的设计(3)添加学生信息窗体(4)查询学生信息窗体(5)修改学生信息窗体(6)删除学生信息窗体(7)事件响应的处理五：具体设计(1)程序结构的说明：A.入口 程序：student.java;B.登陆界面程序：mainframe.java;C.主窗体程序：interfac.java;D.添加信息窗口程序：tj.java;E.修改信息窗口程序：xg.j

2、ava;F.查询信息窗口程序：cx.java;G.删除信息窗口程序：sc.java;H.程序数据连接：DatabaseConn.java;(2)程序代码及分析说明A.程序源代码(已提交)“进入系统”，然后登陆界面消失；出现要操作的界面(屏幕左上角)。“添加信息”按钮，将信息加入 xinxi表中。“修改信息”按钮(如果数据库中不存在此学号，则弹出对话框“无此学生信息”), 若有则修改。“删除信息”按钮，弹出确认删除对话框，即可删除该生信息。“信息查询”按钮，在相应的文本区里显示查询的信息。H:源代码/student.java:程序的入口。初始化界面，使主界面位于屏幕中间，且用户不能改变大小/功能

3、：完成程序的执行顺序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(); elseframe.validate();DimensionscreenSize=Toolkit.getDefaultToolkit().getScreenSize();Dimension

4、 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,(screenSiz e.height-frameSize.height)/2);frame.setVisible(true);publi

5、c static void main(String口 args)tryUIManager.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=”"

6、；private Connection conn=null;private Statement stmt=null;private ResultSet rs=null; staticcatch(ClassNotFoundException e)。/创建数据库连接对象public Connection getConnection() tryconn=DriverManager.getConnection("jdbc:odbc:stu",user,password); return conn;catch(SQLException e) return null; public S

7、tatement createStat()tryconn=getConnection();stmt=conn.createStatement();return stmt;catch(SQLException e)return null; public ResultSet getRs(String sql) tryconn=getConnection();/stmt=createStat();rs=stmt.executeQuery(sql);return rs;catch(SQLException e) return null;public void close()tryif(rs!=null

8、)rs.close();if(stmt!=null)stmt.close();if(conn!=null)conn.close();catch(SQLException ex)ex.printStackTrace();/mainframe.javaimport java.awt.*;import javax.swing.*;import java.sql.*;public class mainframe extends JFrame implements ActionListenerstatic mainframe s;static JPanel pan=new JPanel();static

9、 JLabe11abel1 = new 儿abel("用 户)static JLabe11abel2 = new 儿abel("密 码)static JTextField textField1 = new JTextField();static JPasswordField password = new JPasswordField();,true);/static JButton button1 = new JButton(" 进入系统");static JRadioButton radioButton1=new JRadioButton("

10、管理员“管理员”初始状态被选中static JRadioButton radioButton2=new JRadioButton("学生");static JRadioButton radioButton3=new JRadioButton("教师");ButtonGroup buttonGroup=new ButtonGroup();public mainframe()JLabel label=new JLabel(new ImageIcon(" 图片 44.jpg");label.setSize(400,400);pan.add(

11、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.setBounds(100,62,49,20);password.setBounds(155,61,120,20);button1.setBounds(150,200,101,22);radioBut

12、ton1.setBounds(105,120,80,20);radioButton2.setBounds(180,120,60,20);radioButton3.setBounds(240,120,60,20);buttonl.addActionListener(this); buttonGroup.add(radioButtonl); buttonGroup.add(radioButton2); buttonGroup.add(radioButton3); this.add(radioButtonl); this.add(radioButton2); this.add(radioButton

13、3); this.add(labell); this.add(label2); this.add(textFieldl); this.add(password); this.add(buttonl); this.add(pan);this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); this.setVisible(true); public static void main(String口 args) new mainframe。； public void actionPerformed(ActionEvent e) if(radioButt

14、on1.isSelected() 管理员 if(textField1.getText().equals("syc")&&password.getText().equals("123") interfac b=new interfac(); this.dispose(); /JOptionPane.showMessageDialog(null,"登陆成功");elseif("".equals(textField1.getText()|”.equals(password.getText() ) JOpt

15、ionPane.showMessageDialog(null,”用户名或密码不能为空）elseJOptionPane.showMessageDialog(null,”用户名或密码输入有误) if(radioButton2.isSelected()/ 学生 try catch (ClassNotFoundException ce) JOptionPane.showMessageDialog(s,ce.getMessage(); try Connectioncon=DriverManager.getConnection("jdbc:odbc:stu","sa"

16、;,""); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("select * from password where用户 名 = '"+textField1.getText()+"'and 密 码 ='"+password.getText()+"”');if(textField1.getText().equals("")|password.getText().equals(

17、"") JOptionPane.showMessageDialog(this,”用户名或密码不可为空！")； else if(rs.next() new interfac(); elseJOptionPane.showMessageDialog(this,”您的输入有误");/stmt.close(); catch (SQLException se) JOptionPane.showMessageDialog(s,se.getMessage(); /interface.java import java.awt.*; import javax.swing.

18、*;public class interfac extends JFrame implements ActionListener static JMenuBar jMenuBar = new JMenuBar();/ 菜单条static JMenu jMenuFile = new JMenu("文件");/ 菜单项static JMenu jMenuExit = new JMenu("退出");菜单子项static JMenuItem jMenuItem1 = new JMenuItem("添加信息)/static JMenuItem jMen

19、uItem2 = new JMenuItem("修改信息)static JMenuItem jMenuItem3 = new JMenuItem("信息查询");static JMenuItem jMenuItem4 = new JMenuItem("删除信息)请选择操作项");学籍管理系统"); 添加信息) 修改信息) 信息查询");删除信息)static JLabe11abel3 = new JLabel(" static JLabel label4 = new JLabel(" static JBu

20、tton button2 = new JButton(" static JButton button3 = new JButton(" 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.s

21、etFont(new Font("Dialog",Font.PLAIN,15);label4.setFont(new Font("Dialog",Font.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(butt

22、on3);this.add(button4);this.add(button5);this.add(label3);this.add(label4);setJMenuBar(jMenuBar);jMenuFile.add(jMenuItem1);/ ”文件“菜单项中加入子菜单jMenuFile.add(jMenuItem2);jMenuFile.add(jMenuItem3);jMenuFile.add(jMenuItem4);jMenuBar.add(jMenuFile);/ 将菜单项加入菜单条jMenuBar.add(jMenuExit);button2.addActionListener

23、(this);/本窗 口 向按钮事件源注册button3.addActionListener(this);button4.addActionListener(this);button5.addActionListener(this);jMenuItem1.addActionListener(this);本窗 口 菜单子项注册jMenuItem2.addActionListener(this);jMenuItem3.addActionListener(this);jMenuItem4.addActionListener(this);jMenuExit.addActionListener(this

24、);this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);this.setVisible(true);public static void 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 t

25、j();catch(Exception ee) else if(e.getSource()=jMenuItem2|e.getSource()=button3)try xg a=new xg();catch(Exception ed)elseif(e.getSource()=jMenuItem3|e.getSource()=button4)trycx a=new cx(); catch(Exception ec) elseif(e.getSource()=jMenuItem4|e.getSource()=button5) try sc a=new sc();catch(Exception es)

26、/tj.java添加界面import javax.swing.*;import java.awt.*;import java.sql.*;public class tj extends JFrame implements ActionListenerstatic tj s;static JLabe11abel1 = new 儿abel("学号:")；static JTextField textField1 = new JTextField("");static 儿abel label2 = new 儿abel("姓名:");stati

27、c JTextField textField2 = new JTextField("");static 儿abel label3 = new 儿abel("性别:")；static JTextField textField7=new JTextField("");static 儿abel label4 = new 儿abel("出生日期:");static JTextField textField3 = new JTextField("");static 儿abel label5 = new 儿

28、abel("政治面貌:");static JTextField textField8=new JTextField("");static 儿abel label6 = new 儿abel("籍贯)static JTextField textField4 = new JTextField("");static 儿abel label7 = new 儿abel("系另U:");static JTextField textField9 = new JTextField("");static

29、儿abel label8 = new 儿abel("专业:");static JTextField 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,

30、 22);label2.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.setBou

31、nds(163, 53, 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);button1.setBounds(25,241,80,33);buttonl.addActionListener(this);this.add(labell);this.add(label2);this.

32、add(label3);this.add(label4);this.add(label5);this.add(label6);this.add(label7);this.add(label8);this.add(textFieldl);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.setDefaultCl

33、oseOperation(JFrame.DISPOSE_ON_CLOSE);this.setVisible(true);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)trycatch (ClassNotFoundException ce)JOption

34、Pane.showMessageDialog(s,ce.getMessage();tryConnectionconDriverManager.getConnection("jdbc:odbc:stu","sa"," ")；Statement stmt = con.createStatement();ResultSet rs=stmt.executeQuery("select * from xinxi where 学号 ='"+textField1.getText ()+皿);if(rs.next()JOpt

35、ionPane.showMessageDialog(null,"此学号已经被注册"); else stmt.execute("insert into xinxi (学号，姓名，性别，出生日期， 政治面貌，籍贯,系别,专业)values ('"+textField1.getText()+”',”'+textField2.getText()+"'J'+textField7.getText()+"?"+textField3.getText()+"?"+textField8

36、.getText() +"'J'+textField4.getText()+"?"+textField9.getText()+”':"+textField5.getText()+"')");JOptionPane.showMessageDialog(null,"添加信息成功");catch (SQLException se) JOptionPane.showMessageDialog(s,se.getMessage(); /xg.java修改界面import javax.swing.

37、*; import java.awt.*; import java.sql.*;public class xg extends JFrame implements ActionListener static xg s;static JLabe11abel1 = new 儿abel("学号:")；static JTextField textField1 = new JTextField("");static 儿abel label2 = new 儿abel("姓名:");static JTextField textField2 = ne

38、w JTextField("");static 儿abel label3 = new 儿abel("性别:")；static JTextField textField7=new JTextField("");static 儿abel label4 = new 儿abel("出生日期:");static JTextField textField3 = new JTextField("");static 儿abel label5 = new 儿abel("政治面貌:");stat

39、ic JTextField textField8=new JTextField("");static 儿abel label6 = new 儿abel("籍贯)static JTextField textField4 = new JTextField("");static 儿abel label7 = new 儿abel("系另U:");static JTextField textField9 = new JTextField("");static 儿abel label8 = new 儿abel(&qu

40、ot;专业:");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.setBounds(162, 1

41、1,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, 26, 33);textFie

42、ld4.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);this.add(label4

43、);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.setDefaultCloseOperation(JFrame.DISPOSE

44、_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)trycatch (ClassNotFoundException ce)JOptionPane.showMessageDialog(s,ce.ge

45、tMessage(); try Connection con = DriverManager.getConnection ("jdbc:odbc:stu","sa","");xinxi where 学号学号不可为空!Statement stmt = con.createStatement();ResultSet rs=stmt.executeQuery("select * from='"+textField1.getText()+皿);if(textField1.getText().trim().equal

46、s("")JOptionPane.showMessageDialog(this,”");else if(rs.next() String ='"+textField1.getText()+"', ='"+updateSql="update姓名xinxiset 学号textField2.getText()+”',性 别二"'+textField7.getText()+”',出生日期二"'+textField3.getText()+"'

47、,政治面貌='"+textField8.getText()+"',籍贯="'+textField4.getText()+"',系 别='"+textField9.getText()+"', 专业='"+textField5.getText()+ "”'trystmt.executeQuery(updateSql); catch(SQLException se) JOptionPane.showMessageDialog(null,”修改成功)catch

48、(SQLException se)JOptionPane.showMessageDialog(s,se.getMessage();/sc.java 删除界面import javax.swing.*;import java.awt.*;import java.sql.*;public class sc extends JFrame implements ActionListenerstatic sc s;static JLabe11abel1 = new 儿abel("学号:")；static JTextField textField1 = new JTextField(&q

49、uot;");static 儿abel label2 = new 儿abel("姓名:");static JTextField textField2 = new JTextField("");static 儿abel label3 = new 儿abel("性别:")；static JTextField textField7=new JTextField("");static 儿abel label4 = new 儿abel("出生日期:");static JTextField tex

50、tField3 = new JTextField("");static 儿abel label5 = new 儿abel("政治面貌:");static JTextField textField8=new JTextField("");static 儿abel label6 = new 儿abel("籍贯)static JTextField textField4 = new JTextField("");static 儿abel label7 = new 儿abel("系另U ：");

51、static JTextField textField9 = new JTextField("");static 儿abel label8 = new 儿abel("专业:");static JTextField textField5 = new JTextField("");static JButton button4=new JButton(" 删除)public sc() throws Exceptionthis.setTitle("删除学生信息)this.setLayout(null);this.setSi

52、ze(400,400);label1.setBounds(30, 11,51, 33);textField1.setBounds(86, 16, 74, 22);label2.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.s

53、etBounds(241,53, 70, 33);textField8.setBounds(296, 57, 72, 25);label6.setBounds(163, 53, 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);button4.setBounds(295,241,8

54、0,33);button4.addActionListener(this);this.add(label1);this.add(label2);this.add(label3);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);

55、this.add(textField8);this.add(textField9); this.add(button4); this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE); this.setVisible(true);public static void main(String口 args) throws Exception sc a= new sc();a.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);一 一public void actionPerformed(ActionEven

56、t e)/sc if (e.getSource() = button4) try catch (ClassNotFoundException ce) JOptionPane.showMessageDialog(s,ce.getMessage(); try Connectioncon=DriverManager.getConnection("jdbc:odbc:stu","sa","");Statement stmt = con.createStatement();ResultSet rs=stmt.executeQuery("

57、;select * from xinxi where学号二"'+textField1.getText()+"”');if(textField1.getText().trim().equals("") JOptionPane.showMessageDialog(this,”学号不可为空！")； else if(rs.next() JOptionPane.showConfirmDialog(null,”确定要删除该信息嘛？ n删除的信息将不能恢复，继续？","删除 确定 ”,JOptionPane.OK_CANC

58、EL_OPTION);,JOption.QUESTION_MESSAGE)=0;stmt.execute("deletefrom xinxi where 学号='"+textField1.getText()+"”');JOptionPane.showMessageDialog(null,"删除信息成 功！")； this.dispose();else JOptionPane.showMessageDialog(null,”无此学号对应信息","警告",JOptionPane.WARNING_MESS

59、AGE);catch(Exception ed)JOptionPane.showMessageDialog(s,ed.getMessage();/cx.java查询界面import javax.swing.*;import java.awt.*;import java.sql.*;public class cx extends JFrame implements ActionListenerstatic cx s;static JLabe11abel1 = new 儿abel("学号:")；static JTextField textField1 = new JTextField("");static 儿abel label2 = new 儿abel("姓名:");static JTextField textField2 = new JTextField("");static 儿abel