学生成绩管理系统，界面基于Swing开发，数据库采用MySQL,大二时java程序设计的课设.zip

/* * MainFace.java * * Created on __DATE__, __TIME__ */ package View; import java.awt.Color; import java.util.ArrayList; import javax.swing.JFrame; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; import model.AddCourses; import model.CourseSelection; import model.DataConnection; import model.Grade; import model.ModelFactory; import model.SLogin; import model.TLogin; import model.Teacher; /** * * @author __USER__ */ public class MainFace extends javax.swing.JFrame { /** Creates new form MainFace * @param tea */ private TLogin tea; Object info[][]; Object o[][]; Object o2[][]; public MainFace(TLogin tea) { initComponents(); this.setTitle("学生成绩管理系统-教师"); this.setLocationRelativeTo(null); this.setResizable(false); //int tid = tea.getTid(); DataConnection dc = new DataConnection(); try { ArrayList<AddCourses> res = ModelFactory.TLookCourse(dc.getStat()); String title3[] = { "课程编号", "课程名称", "授课老师", "上课时间", "课程状态" }; o = new Object[res.size()][5]; for (int i = 0; i < res.size(); i++) { o[i][0] = res.get(i).getCid(); o[i][1] = res.get(i).getCname(); o[i][2] = res.get(i).getCteacher(); o[i][3] = res.get(i).getCtime(); o[i][4] = res.get(i).getState(); } DefaultTableModel dtm = new DefaultTableModel(o, title3); this.jTable3.setModel(dtm); ArrayList<CourseSelection> res2 = ModelFactory.CourseSelection(dc .getStat()); String title2[] = { "课程名称", "上课时间", "学生学号", "学生姓名", "学生性别", "系别", "班级" }; o2 = new Object[res2.size()][7]; for (int i = 0; i < res2.size(); i++) { o2[i][0] = res2.get(i).getCname(); o2[i][1] = res2.get(i).getCtime(); o2[i][2] = res2.get(i).getStuId(); o2[i][3] = res2.get(i).getStuName(); o2[i][4] = res2.get(i).getSex(); o2[i][5] = res2.get(i).getDepartment(); o2[i][6] = res2.get(i).getStuClass(); } DefaultTableModel dtm2 = new DefaultTableModel(o2, title2); this.jTable2.setModel(dtm2); ArrayList<Grade> res5 = ModelFactory.Grade(dc.getStat()); String title5[] = { "学生学号", "学生姓名", "课程名称", "上课时间", "课程成绩" }; info = new Object[res5.size()][5]; for (int i = 0; i < res5.size(); i++) { info[i][0] = res5.get(i).getSid(); info[i][1] = res5.get(i).getSname(); info[i][2] = res5.get(i).getCname(); info[i][3] = res5.get(i).getCtime(); info[i][4] = res5.get(i).getGrade(); } DefaultTableModel dtm5 = new DefaultTableModel(info, title5); this.jTable5.setModel(dtm5); } catch (Exception e) { // TODO Auto-generated catch block JOptionPane.showMessageDialog(this, e.getMessage()); } } public MainFace() { // TODO Auto-generated constructor stub } //GEN-BEGIN:initComponents // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() { jToggleButton1 = new javax.swing.JToggleButton(); panel1 = new java.awt.Panel(); menuBar1 = new java.awt.MenuBar(); menu1 = new java.awt.Menu(); jTabbedPane1 = new javax.swing.JTabbedPane(); jScrollPane4 = new javax.swing.JScrollPane(); jTable4 = new javax.swing.JTable(); jScrollPane1 = new javax.swing.JScrollPane(); jTable1 = new javax.swing.JTable(); jPanel1 = new javax.swing.JPanel(); jPanel2 = new javax.swing.JPanel(); jLabel1 = new javax.swing.JLabel(); jTabbedPane2 = new javax.swing.JTabbedPane(); jPanel4 = new javax.swing.JPanel(); jScrollPane3 = new javax.swing.JScrollPane(); jTable3 = new javax.swing.JTable(); jButton3 = new javax.swing.JButton(); jButton4 = new javax.swing.JButton(); jTextField1 = new javax.swing.JTextField(); jPanel5 = new javax.swing.JPanel(); jScrollPane2 = new javax.swing.JScrollPane(); jTable2 = new javax.swing.JTable(); jButton6 = new javax.swing.JButton(); jButton7 = new javax.swing.JButton(); jButton8 = new javax.swing.JButton(); jTextField2 = new javax.swing.JTextField(); jPanel6 = new javax.swing.JPanel(); jPanel3 = new javax.swing.JPanel(); jScrollPane5 = new javax.swing.JScrollPane(); jTable5 = new javax.swing.JTable(); jButton11 = new javax.swing.JButton(); jButton12 = new javax.swing.JButton(); jTextField3 = new javax.swing.JTextField(); jButton9 = new javax.swing.JButton(); jToggleButton1.setText("jToggleButton1"); javax.swing.GroupLayout panel1Layout = new javax.swing.GroupLayout( panel1); panel1.setLayout(panel1Layout); panel1Layout.setHorizontalGroup(panel1Layout.createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING).addGap(0, 100, Short.MAX_VALUE)); panel1Layout.setVerticalGroup(panel1Layout.createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING).addGap(0, 100, Short.MAX_VALUE)); menu1.setLabel("Menu"); menuBar1.add(menu1); jTable4.setModel(new javax.swing.table.DefaultTableModel( new Object[][] { { null, null, null, null }, { null, null, null, null }, { null, null, null, null }, { null, null, null, null } }, new String[] { "Title 1", "Title 2", "Title 3", "Title 4" })); jScrollPane4.setViewportView(jTable4); jTable1.setModel(new javax.swing.table.DefaultTableModel( new Object[][] { { null, null, null, null }, { null, null, null, null }, { null, null, null, null }, { null, null, null, null } }, new String[] { "Title 1", "Title 2", "Title 3", "Title 4" })); jScrollPane1.setViewportView(jTable1); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout( jPanel1); jPanel1.setLayout(jPanel1Layout); jPanel1Layout.setHorizontalGroup(jPanel1Layout.createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING).addGap(0, 105, Short.MAX_VALUE)); jPanel1Layout.setVerticalGroup(jPanel1Layout.createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING).addGap(0, 0, Short.MAX_VALUE)); jLabel1 .setText("\u4eb2\u7231\u7684\u8001\u5e08\uff0c\u60a8\u597d\uff01\u6b22\u8fce\u6765\u5230\u5b66\u751f\u6210\u7ee9\u7ba1\u7406\u7cfb\u7edf\uff01"); jTable3.setModel(new javax.swing.table.DefaultTableModel( new Object[][] { { null, null, null, null, null }, { null, null, null, null, null }, { null, null, null, null, null }, { null, null, null, null, null }, { null, null, null, null, null }, { null, null, null, null, null }, { null, null, null, null, null }, { null, null, null, null, null } }, new String[] { "课程代号", "课程名称", "任教老师", "课程人数", "开课情况" })); jScrollPane3.setViewportView(jTable3); jButton3.setText("\u5f00\u8bfe/\u7ed3\u8bfe"); jButton3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton3ActionPerformed(evt); } }); jButton4.setText("\u67e5\u627e\u8bfe\u7a0b"); jButton4.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton4ActionPerformed(evt); } }); jTextField1.setText("\u8bf7\u8f93\u5165\u8bfe\u7a0b\u540d\u79f0"); javax.swing.GroupLayout jPanel4Layout = new javax.swing.GroupLayout( jPanel4); jPanel4.setLayout(jPanel4Layout); jPanel4Layout .setHorizontalGroup(jPanel4Layout .createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jScrollPane3, javax.swing.GroupLayout.DEFAULT_SIZE, 659, Short.MAX_VALUE) .addGroup( jPanel4Layout .createSequentialGroup() .addComponent( jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 136, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jButton4) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.RELATED, 2