1、学生学籍管理系统含java源代码学生学籍管理详细设计 学号:_ 姓名:_ 班级:_1、设计题目:学生学籍管理二:设计内容: 设计GUI学生学籍管理界面,用户可以加入学生信息,并对基本信息进行修改,添加,查询,删除。三:设计要求: 进行简单的学生信息管理。四:总体设计 (1)登陆界面的设计 (2)主窗体的设计 (3)添加学生信息窗体 (4)查询学生信息窗体 (5)修改学生信息窗体 (6)删除学生信息窗体 (7)事件响应的处理五:具体设计(1)程序结构的说明:A.入口程序:student.java;B.登陆界面程序:mainframe.java;C.主窗体程序:interfac.java;D.添加
2、信息窗口程序:tj.java;E.修改信息窗口程序:xg.java;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 student boolean packFrame=false; /JFrame frame=new JFrame(); public student() mainframe frame=new mainframe(); if(packFrame) frame.pack(); else frame.validate(); Dimension screenSize=Toolkit.getDefau
4、ltToolkit().getScreenSize(); Dimension frameSize=frame.getSize(); if(frameSize.heightscreenSize.height) frameSize.height=screenSize.height; if(frameSize.widthscreenSize.width) frameSize.width=screenSize.width; frame.setLocation(screenSize.width-frameSize.width)/2,(screenSize.height-frameSize.height)
5、/2); frame.setVisible(true); public 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=; privat
6、e static String password=; private Connection conn=null; private Statement stmt=null; private ResultSet rs=null; static catch(ClassNotFoundException e) /创建数据库连接对象 public Connection getConnection() try conn=DriverManager.getConnection(jdbc:odbc:stu,user,password); return conn; catch(SQLException e) r
7、eturn 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; catch(SQLException e) return null;
8、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 javax.swing.*;import java.sql.*;public class mainframe extends JFrame implements ActionListener static mainf
9、rame 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(); static JButton button1 = new JButton(进入系统); static JRadioButton radioButton1
10、=new JRadioButton(管理员,true);/“管理员”初始状态被选中 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(label
11、); 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); radioButton1.se
12、tBounds(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); buttonGroup.add(radioButton3); this.add(radioButton1); this.add(radioButton2); this.add(radioButton3);
13、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 main(String args) new mainframe(); public void actionPerformed(ActionEvent e) if(radioButton1
14、.isSelected()/管理员 if(textField1.getText().equals(syc) & password.getText().equals(123) interfac b=new interfac(); this.dispose(); /JOptionPane.showMessageDialog(null,登陆成功); else if(.equals(textField1.getText() | .equals(password.getText() ) JOptionPane.showMessageDialog(null,用户名或密码不能为空); else JOptio
15、nPane.showMessageDialog(null,用户名或密码输入有误); if(radioButton2.isSelected()/学生 try catch (ClassNotFoundException ce) JOptionPane.showMessageDialog(s,ce.getMessage(); try Connection con = DriverManager.getConnection(jdbc:odbc:stu,sa,); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQue
16、ry(select * from password where 用户名 = +textField1.getText()+ and 密码 = +password.getText()+); if(textField1.getText().equals()|password.getText().equals() JOptionPane.showMessageDialog(this,用户名或密码不可为空!); else if(rs.next() new interfac(); else JOptionPane.showMessageDialog(this,您的输入有误); /stmt.close();
17、 catch (SQLException se) JOptionPane.showMessageDialog(s,se.getMessage(); /interface.javaimport java.awt.*;import javax.swing.*;public class interfac extends JFrame implements ActionListener static JMenuBar jMenuBar = new JMenuBar();/菜单条 static JMenu jMenuFile = new JMenu(文件);/菜单项 static JMenu jMenu
18、Exit = new JMenu(退出); static JMenuItem jMenuItem1 = new JMenuItem(添加信息);/菜单子项 static JMenuItem jMenuItem2 = new JMenuItem(修改信息); static JMenuItem jMenuItem3 = new JMenuItem(信息查询); static JMenuItem jMenuItem4 = new JMenuItem(删除信息); static JLabel label3 = new JLabel(请选择操作项); static JLabel label4 = new
19、 JLabel(学籍管理系统); static JButton 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,
20、92,98,33); label3.setFont(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(b
21、utton3); 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.addA
22、ctionListener(this);/本窗口向按钮事件源注册 button3.addActionListener(this); button4.addActionListener(this); button5.addActionListener(this); jMenuItem1.addActionListener(this);/本窗口菜单子项注册 jMenuItem2.addActionListener(this); jMenuItem3.addActionListener(this); jMenuItem4.addActionListener(this); jMenuExit.addA
23、ctionListener(this); 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.getSourc
24、e()=button2) try tj a=new tj(); catch(Exception ee) else if(e.getSource()=jMenuItem2|e.getSource()=button3) try xg a=new xg(); catch(Exception ed) else if(e.getSource()=jMenuItem3|e.getSource()=button4) try cx a=new cx(); catch(Exception ec) else if(e.getSource()=jMenuItem4|e.getSource()=button5) tr
25、y sc a=new sc(); catch(Exception es) /tj.java 添加界面import javax.swing.*;import java.awt.*;import java.sql.*;public class tj extends JFrame implements ActionListener static tj s; static JLabel label1 = new JLabel(学号:); static JTextField textField1 = new JTextField(); static JLabel label2 = new JLabel(
26、姓名:); static JTextField textField2 = 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(政治面貌:); static JTextField textFie
27、ld8=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 JLabel(专业:); static JTextField textField5 = new JTextField(); static JButt
28、on 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(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,
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1