学生档案管理系统Java程序.doc

南华大学计算机科学与技术学院Java精读程序分析报告 （ 2008 2009 学年度 第 一 学期 ）程序名称： 学生档案管理系统专业班级： 计算机科学与技术专业061班指导老师： 谭敏生小组成员：姓名学号姓名学号姓名学号姓名学号姓名学号学生档案管理系统Java精读程序一目录1.about.java32.addresult.java53.adduser.java114.addxj.java155.cxbj.java186.cxxj.java207.mainFrame.java248.sacnresult.java429.scanuser.java4610.scanusers.java4911.Start.java5112.sznjkc.java5313.tjkcxx.java5914.tjxjxx.java6315.xgbj.java6916.xgcj.java7817.xgkcxx.java8818.xgxjxx.java10019.xiugaimima.java114小组总结118/1. about.java /程序功能： 程序分析成员：/package studentsystem;import java.awt.*;import javax.swing.*;import java.awt.event.*;public class about extends JDialog JPanel panel1 = new JPanel(); ImageIcon icon=new ImageIcon(xuan.jpg);/设置背景图片 JLabel jLabel1 = new JLabel(icon); JButton sure = new JButton(); public about(Frame frame, String title, boolean modal) super(frame, title, true); try jbInit(); pack(); catch(Exception ex) ex.printStackTrace(); public about() this(null, , true); private void jbInit() throws Exception jLabel1.setText(); jLabel1.setBounds(new Rectangle(5, 5, 392, 250); panel1.setBounds(new Rectangle(0, 299, 1, 1); panel1.setLayout(null); jLabel1.setText(); jLabel1.setBounds(new Rectangle(-43, 0, 414, 245); sure.setBounds(new Rectangle(109, 243, 79, 29); sure.setFont(new java.awt.Font(Dialog, 0, 15); sure.setText(确 定); jLabel1.setToolTipText(leeyingzhang制作!); sure.addActionListener(new about_sure_actionAdapter(this); this.setTitle(呵呵！); this.getContentPane().add(panel1, null); this.getContentPane().add(sure, null); this.getContentPane().add(jLabel1, null); this.setBounds(200,200,330,310); this.getContentPane().setLayout(null); this.setVisible(true); void sure_actionPerformed(ActionEvent e) this.dispose(); class about_sure_actionAdapter implements java.awt.event.ActionListener about adaptee; about_sure_actionAdapter(about adaptee) this.adaptee = adaptee; public void actionPerformed(ActionEvent e) adaptee.sure_actionPerformed(e); /2. addresult.java/程序功能： 程序分析成员：/package studentsystem;import javax.swing.*;import java.awt.*;import java.awt.event.*;import java.sql.*;public class addresult extends JFrame JLabel jLabel1 = new JLabel(); JComboBox ksbh = new JComboBox(); JLabel jLabel2 = new JLabel(); JLabel jLabel3 = new JLabel(); JLabel jLabel4 = new JLabel(); JLabel jLabel5 = new JLabel(); JLabel jLabel6 = new JLabel(); JComboBox xh = new JComboBox(); JComboBox kc = new JComboBox(); JComboBox bh = new JComboBox(); JTextField xm = new JTextField(); JTextField fs = new JTextField(); JButton ok = new JButton(); JButton ocancel = new JButton(); Statement ps, is,kcs,cr,xms; ResultSet rs, as,xzkc,xsxm; Connection con; String url; public addresult() try jbInit(); catch (Exception e) e.printStackTrace(); /*JDBC-ODBC连接数据库,并读取数据库*/ try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); Connection con = DriverManager.getConnection( jdbc:odbc:lee, sa, 123); ps = con.createStatement(ResultSet. TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); is = con.createStatement(ResultSet. TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); kcs= con.createStatement(ResultSet. TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); cr= con.createStatement(ResultSet. TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); xms= con.createStatement(ResultSet. TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); catch (Exception err) String error = err.getMessage(); Log log=new Log(); log.addLog(rr,数据库连接出错); log.closeStream(); JOptionPane.showMessageDialog(null, 连接数据库错误!); try rs = ps.executeQuery(select distinct class_NO from student ); /ORDER BY class_NO DESC while (rs.next() / xh.addItem(rs.getString(student_ID); bh.addItem(rs.getString(class_NO); xzkc = kcs.executeQuery(select * from gradecourse ); /ORDER BY class_NO DESC while (xzkc.next() / xh.addItem(rs.getString(student_ID); kc.addItem(xzkc.getString(course_Name); catch (Exception err) String error = err.getMessage(); JOptionPane.showMessageDialog(null, error); public static void main(String args) addresult addresult = new addresult(); private void jbInit() throws Exception jLabel1.setFont(new java.awt.Font(Dialog, 0, 15); jLabel1.setText(考试编号); jLabel1.setBounds(new Rectangle(13, 11, 67, 28); this.setLocale(java.util.Locale.getDefault(); this.setResizable(false); this.setState(Frame.NORMAL); this.setTitle(添加成绩信息); this.getContentPane().setLayout(null); ksbh.setFont(new java.awt.Font(Dialog, 0, 15); ksbh.setBounds(new Rectangle(77, 12, 132, 26); ksbh.addItem(期中); ksbh.addItem(期末); jLabel2.setBounds(new Rectangle(214, 8, 63, 28); jLabel2.setText(选择班号); jLabel2.setFont(new java.awt.Font(Dialog, 0, 15); jLabel3.setBounds(new Rectangle(7, 54, 67, 28); jLabel3.setText(选择学号); jLabel3.setFont(new java.awt.Font(Dialog, 0, 15); jLabel4.setBounds(new Rectangle(217, 51, 63, 28); jLabel4.setText(姓 名); jLabel4.setFont(new java.awt.Font(Dialog, 0, 15); jLabel5.setBounds(new Rectangle(215, 89, 64, 28); jLabel5.setText(输入分数); jLabel5.setFont(new java.awt.Font(Dialog, 0, 15); jLabel6.setBounds(new Rectangle(9, 92, 67, 28); jLabel6.setText(选择课程); jLabel6.setFont(new java.awt.Font(Dialog, 0, 15); xh.setFont(new java.awt.Font(Dialog, 0, 15); xh.setBounds(new Rectangle(75, 55, 138, 24); xh.addItemListener(new addresult_xh_itemAdapter(this); kc.setFont(new java.awt.Font(Dialog, 0, 15); kc.setBounds(new Rectangle(75, 87, 138, 27); bh.setFont(new java.awt.Font(Dialog, 0, 15); bh.setBounds(new Rectangle(280, 8, 96, 27); bh.addItemListener(new addresult_bh_itemAdapter(this); xm.setText(); xm.setBounds(new Rectangle(280, 50, 96, 26); fs.setText(); fs.setBounds(new Rectangle(280, 90, 97, 27); ok.setBounds(new Rectangle(83, 142, 89, 32); ok.setFont(new java.awt.Font(Dialog, 0, 15); ok.setText(确 定); ok.addActionListener(new addresult_ok_actionAdapter(this); ocancel.setText(退 出); ocancel.addActionListener(new addresult_ocancel_actionAdapter(this); ocancel.setBounds(new Rectangle(206, 142, 89, 32); ocancel.setFont(new java.awt.Font(Dialog, 0, 15); this.getContentPane().add(jLabel1, null); this.getContentPane().add(ksbh, null); this.getContentPane().add(jLabel3, null); this.getContentPane().add(jLabel6, null); this.getContentPane().add(kc, null); this.getContentPane().add(xm, null); this.getContentPane().add(bh, null); this.getContentPane().add(fs, null); this.getContentPane().add(jLabel5, null); this.getContentPane().add(jLabel4, null); this.getContentPane().add(jLabel2, null); this.getContentPane().add(xh, null); this.getContentPane().add(ocancel, null); this.getContentPane().add(ok, null); this.setBounds(300, 300, 400, 250); this.setVisible(true); void ocancel_actionPerformed(ActionEvent e) this.dispose(); void bh_itemStateChanged(ItemEvent e) /从数据库中读取数据，并显示 try xh.removeAllItems(); as = is.executeQuery( select distinct student_ID from student where class_NO= + bh.getSelectedItem() + ); /ORDER BY class_NO DESC while (as.next() xh.addItem(as.getString(student_ID); catch (Exception err) err.printStackTrace(); String error = err.getMessage(); JOptionPane.showMessageDialog(null, error); void ok_actionPerformed(ActionEvent e) JOptionPane.showConfirmDialog(null, 确定添加！, 添加成绩, JOptionPane.YES_NO_OPTION); try cr.executeUpdate(Insert Into result Values( + ksbh.getSelectedItem().toString() + , + xh.getSelectedItem().toString() + , + xm.getText().trim() + , + bh.getSelectedItem().toString() + , + kc.getSelectedItem().toString() + , + fs.getText().trim() + ); JOptionPane.showMessageDialog(null, 插入成绩成功！); Log log=new Log(); log.addLog(rr,插入成绩+ksbh.getSelectedItem().toString()+成功); log.closeStream(); this.dispose(); catch (Exception err) err.printStackTrace(); String error = err.getMessage(); JOptionPane.showMessageDialog(null, error); void xh_itemStateChanged(ItemEvent e) /从数据库中读取数据，并显示 xm.setText(); try xsxm= xms.executeQuery( select student_Name from student where class_NO= + bh.getSelectedItem().toString().trim() + and student_ID= + xh.getSelectedItem().toString().trim() + ); /ORDER BY class_NO DESC while (xsxm.next() xm.setText(xsxm.getString(student_Name); catch (Exception err) err.printStackTrace(); String error = err.getMessage(); JOptionPane.showMessageDialog(null, error); class addresult_ocancel_actionAdapter implements java.awt.event.ActionListener addresult adaptee; addresult_ocancel_actionAdapter(addresult adaptee) this.adaptee = adaptee; public void actionPerformed(ActionEvent e) adaptee.ocancel_actionPerformed(e); class addresult_bh_mouseAdapter extends java.awt.event.MouseAdapter addresult adaptee; addresult_bh_mouseAdapter(addresult adaptee) this.adaptee = adaptee; class addresult_bh_itemAdapter implements java.awt.event.ItemListener addresult adaptee; addresult_bh_itemAdapter(addresult adaptee) this.adaptee = adaptee; public void itemStateChanged(ItemEvent e) adaptee.bh_itemStateChanged(e); class addresult_ok_actionAdapter implements java.awt.event.ActionListener addresult adaptee; addresult_ok_actionAdapter(addresult adaptee) this.adaptee = adaptee; public void actionPerformed(ActionEvent e) adaptee.ok_actionPerformed(e); class addresult_xh_itemAdapter implements java.awt.event.ItemListener addresult adaptee; addresult_xh_itemAdapter(addresult adaptee) this.adaptee = adaptee; public void itemStateChanged(ItemEvent e) adaptee.xh_itemStateChanged(e); /3. adduser.java /程序功能： 程序分析成员：/package studentsystem;import java.awt.*;import javax.swing.*;import java.awt.event.*;import java.sql.*;public class adduser extends JDialog Statement ps; ResultSet rs; Connection con; String url; JPanel panel1 = new JPanel(); JLabel jLabel1 = new JLabel(); JTextField userF = new JTextField(); JLabel jLabel2 = new JLabel(); JButton sure = new JButton(); JButton cancel = new JButton(); JLabel jLabel3 = new JLabel(); JPasswordField pwd = new JPasswordField(); JPasswordField pwd1 = new JPasswordField(); JComboBox power = new JComboBox(); JLabel jLabel4 = new JLabel(); public adduser(Frame frame, String title, boolean modal) super(frame, title, modal); try jbInit(); pack(); catch (Exception ex) ex.printStackTrace(); public adduser() this(null, , true); private void jbInit() throws Exception panel1.setLayout(null); this.getContentPane().setLayout(null); panel1.setBounds(new Rectangle(10, 10, 452, 369); jLabel1.setFont(new java.awt.Font(Dialog, 0, 15); jLabel1.setText(请输入用户名); jLabel1.setBounds(new Rectangle(2, 17, 101, 35); userF.setText(); userF.setBounds(new Rectangle(113, 19, 121, 31); jLabel2.setFont(new java.awt.Font(Dialog, 0, 15); jLabel2.setText(请 输 入 密 码); jLabel2.setBounds(new Rectangle(7, 69, 101, 35); sure.setBounds(new Rectangle(12, 204, 90, 35); sure.setFont(new java.awt.Font(Dialog, 0, 15); sure.setText(确 定); sure.addActionListener(new adduser_sure_actionAdapter(this); cancel.setBounds(new Rectangle(132, 204, 90, 38); cancel.setFont(new java.awt.Font(Dialog, 0, 15); cancel.setText(取 消); cancel.addActionListener(new adduser_cancel_actionAdapter(this); this.setTitle(添加用户); jLabel3.setFont(new java.awt.Font(Dialog, 0, 15); jLabel3.setText(请再次输入密码); jLabel3.setBounds(new Rectangle(3, 109, 106, 35); pwd.setBounds(new Rectangle(114, 68, 120, 32); pwd1.setText(); pwd1.setBounds(new Rectangle(115, 108, 120, 32); power.setBounds(new Rectangle(113, 155, 125, 29); jLabel4.setFont(new java.awt.Font(Dialog, 0, 15); jLabel4.setText(请选择权限); jLabel4.setBounds(new Rectangle(5, 156, 95, 34); getContentPane().add(panel1, null); panel1.add(jLabel1, null); panel1.add(sure, null); panel1.add(cancel, null); panel1.add(jLabel3, null); panel1.add(jLabel2, null); panel1.add(pwd, null); panel1.add(pwd1, null); panel1.add(userF, null); power.addItem(系统管理员); power.addItem(普通用户); panel1.add(power, null); panel1.add(jLabel4, null); this.setBounds(300, 300, 300, 300); this.setVisible(true); void cancel_actionPerformed(ActionEvent e) this.dispose(); void sure_actionPerformed(ActionEvent e) if (pwd.getText().trim() = pwd1.getText().trim() JOptionPane.showConfirmDialog(null, 确定添加？, 添加用户, JOptionPane.YES_NO_OPTION); try try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); Connection con = DriverManager.getConnection( jdbc:odbc:lee, sa, 123); ps = con.createStatement(ResultSet. TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); catch (Exception err) String error = err.getMessage(); Log log=new Log(); log.addLog(rr,数据库连接出错); log.closeStream(); JOptionPane.showMessageDialog(null, 连接数据库错误!); try ps.executeUpdate(Insert Into users Values( + userF.getText().trim() + , + pwd.getText().trim() +,+ power.getSelectedItem().toString() + ); ps.close(); JOptionPane.showMessageDialog(null, 添加成功); Log log=new Log();/添加日志 log.addLog(rr,添加+ userF.getText().trim()+(+power.getSelectedItem().toString()+)+成功); log.closeStream(); this.dispose(); catch (SQLException sqle) String error = sqle.getMessage(); JOptionPane.showMessageDialog(null, error); sqle.printStackTrace(); catch (Exception ex) ex.getMessage(); String error = ex.getMessage(); JOptionPane.showMessageDialog(null, error); ex.printStackTrace(); class adduser_cancel_actionAdapter implements java.awt.event.ActionListener adduser adaptee; adduser_cancel_actionAdapter(adduser adaptee) this.adaptee = adaptee; public void actionPerformed(ActionEvent e) adaptee.cancel_actionPerformed(e); class adduser_sure_actionAdapter implements java.awt.event.ActionListener adduser adaptee; adduser_sure_actionAdapter(adduser adaptee) this.adaptee = adaptee; public void actionPerformed(ActionEvent e) adaptee.sure_actionPerformed(e); /4. addxj.java/程序功能： 程序分析成员：/package studentsystem;import javax.swing.*;import java.awt.*;import java.awt.event.*;import java.sql.*;public class addxj extends JFrame Statement ps;ResultSet rs;Connection con;String url; JLabel jLabel1 = new JLabel(); JLabel jLabel2 = new JLabel(); JLabel jLabel3 = new JLabel(); JLabel jLabel4 = new JLabel(); JT