Java+Swing+sqlserver学生成绩管理系统(高分期末大作业).rar

package cn.student.view; import java.awt.Dimension; import java.awt.EventQueue; import javax.swing.JButton; import javax.swing.JComboBox; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JScrollPane; import javax.swing.JPanel; import javax.swing.JTable; import javax.swing.JTextField; import java.awt.BorderLayout; import java.awt.CardLayout; import java.awt.Color; import java.awt.GridLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.util.List; import javax.swing.table.DefaultTableCellRenderer; import javax.swing.table.DefaultTableModel; import javax.swing.table.TableColumn; import cn.student.dao.CourseDao; import cn.student.dao.ScoreDao; import cn.student.model.Course; import cn.student.model.Student; import cn.student.model.Users; public class CourseFrame extends JFrame { // 定义布局 BorderLayout mainLayout = new BorderLayout(); CardLayout layout = new CardLayout(); JFrame bamFrame; MainPanel mainPanel = new MainPanel();// 主面板 CoursePanel coursePanel = new CoursePanel(); JPanel upPanel = new JPanel();// 主面板中的---上面板 JPanel downPanel = new JPanel();// 主面板中的---下面板 JPanel leftPanel = new JPanel();// 主面板中的---左面板 JPanel rightPanel = new JPanel();// 主面板中的---右面板 ScoreDao scoredao = new ScoreDao(); ScoreMainPanel scoreMainPanel = new ScoreMainPanel();//成绩容器 ScoreAddPanel scoreAddPanel = new ScoreAddPanel(); CourseDao coursedao = new CourseDao(); CourseUpdatePanel courseUpdatePanel = new CourseUpdatePanel();//添加课程页面 final Object[] columnNames = {"序号","学期", "课程编号", "课程名称","学分", "任课老师"}; //列名最好用final修饰 Object[][] rowData = queryData("");; DefaultTableModel model = new DefaultTableModel(rowData,columnNames); JTable dataTable = new JTable (model); JScrollPane pane2; JScrollPane pane3; public CourseFrame() { downPanel.setLayout(layout); dataTable.setPreferredScrollableViewportSize(new Dimension(900, 500));//设置表格的大小 dataTable.setRowHeight (30);//设置每行的高度为20 dataTable.setRowHeight (0, 20);//设置第1行的高度为15 dataTable.setRowMargin (5);//设置相邻两行单元格的距离 dataTable.setSelectionBackground (Color.white);//设置所选择行的背景色 dataTable.setSelectionForeground (Color.blue);//设置所选择行的前景色 //friends.setGridColor (Color.black);//设置网格线的颜色 dataTable.selectAll ();//选择所有行 //dataTable.setRowSelectionInterval (1,2);//设置初始的选择行,这里是1到3行都处于选择状态 dataTable.clearSelection ();//取消选择 dataTable.setDragEnabled (false);//不懂这个 dataTable.setShowGrid (false);//是否显示网格线 dataTable.setShowHorizontalLines (false);//是否显示水平的网格线 dataTable.setShowVerticalLines (true);//是否显示垂直的网格线 //friends.setValueAt ("tt", 0, 0);//设置某个单元格的值,这个值是一个对象 dataTable.doLayout (); dataTable.setBackground (Color.lightGray); // 设置表格中的数据居中显示 DefaultTableCellRenderer r=new DefaultTableCellRenderer(); r.setHorizontalAlignment(JLabel.CENTER); dataTable.setDefaultRenderer(Object.class,r); pane2 = new JScrollPane (courseUpdatePanel);//JTable最好加在JScrollPane上 pane2.setPreferredSize(new Dimension (900,500)); //JScrollPane pane2 = new JScrollPane (example2); coursePanel.add(new JScrollPane (dataTable), BorderLayout.SOUTH); // 定义布局 BorderLayout mainLayout = new BorderLayout(); // 左布局 leftPanel.add(mainPanel); leftPanel.setBackground(Color.WHITE);// 左边背影色 //右布局 rightPanel.setLayout(layout); rightPanel.add("coursePanel", coursePanel);// rightPanel.add("scoreMainPanel", scoreMainPanel);// rightPanel.add("courseUpdatePanel", courseUpdatePanel);// rightPanel.add("scoreAddPanel", scoreAddPanel);// // 定义主窗体 bamFrame = new JFrame("学生成绩管理系统(管理员端)"); bamFrame.getContentPane().setLayout(mainLayout); bamFrame.setSize(1050, 600);// 设定窗体大小 // 给窗体加面板 bamFrame.getContentPane().add(leftPanel, BorderLayout.WEST); bamFrame.getContentPane().add(rightPanel, BorderLayout.CENTER); addListeners();// 调用监听方法 bamFrame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); //bamFrame.pack(); bamFrame.setVisible(true); //设置窗口居中 bamFrame.setLocationRelativeTo(null); } // 窗体中部分对象监听方法 private void addListeners() { // 在窗体的左容器上点查询按钮 mainPanel.getCourseButton().addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { layout.show(rightPanel, "coursePanel"); } }); // 在窗体的左容器上点 mainPanel.getScoreButton().addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { String cname = scoreMainPanel.scorePanel.getsnoField().getText(); System.out.print(cname); scoreMainPanel.queryData(cname); layout.show(rightPanel, "scoreMainPanel"); } }); // 查询按钮 coursePanel.getSelectButton().addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { String cname = coursePanel.getsnoField().getText(); System.out.print(cname); Object[][] rowData2 = queryData(cname); model.setDataVector(rowData2, columnNames); layout.show(downPanel, "cardSelect"); } }); // 添加按钮 coursePanel.getUpdateButton().addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { int i = dataTable.getSelectedRow(); if(i>=0) { String courseid = (String) dataTable.getValueAt(i, 0); String semester = (String) dataTable.getValueAt(i, 1); String couserno = (String) dataTable.getValueAt(i, 2); String coursename = (String) dataTable.getValueAt(i, 3); String mark = (String) dataTable.getValueAt(i, 4); String teachername = (String) dataTable.getValueAt(i, 5); courseUpdatePanel.getCourseidText().setText(courseid); courseUpdatePanel.getCoursenameText().setText(coursename); courseUpdatePanel.getSemesterText().setText(semester); courseUpdatePanel.getCousernoText().setText(couserno); courseUpdatePanel.getMarkText().setText(mark); layout.show(rightPanel, "courseUpdatePanel"); }else { JOptionPane.showMessageDialog(rightPanel, "请选择要添加任课老师的课程！"); return; } } }); // 点击《提交》按钮 courseUpdatePanel.getOkButton().addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { String courseid = courseUpdatePanel.getCourseidText().getText(); String coursename = courseUpdatePanel.getCoursenameText().getText(); String couserno = courseUpdatePanel.getCousernoText().getText(); String mark = courseUpdatePanel.getMarkText().getText(); String semester = courseUpdatePanel.getSemesterText().getText(); Users user1 = (Users) courseUpdatePanel.getJcb_choose().getSelectedItem(); String teacherid = user1.getUserid(); String teachername = user1.getName(); int i = coursedao.updateCourse(courseid,couserno,coursename,semester,mark,teachername,teacherid); if(i>0) { JOptionPane.showMessageDialog(downPanel, "添加任课老师成功！"); Object[][] rowData2 = queryData(""); model.setDataVector(rowData2, columnNames); layout.show(rightPanel, "coursePanel"); }else{ JOptionPane.showMessageDialog(downPanel, "添加任课老师失败！"); } } }); // 点击《返回》按钮 courseUpdatePanel.getBackButton().addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { Object[][] rowData2 = queryData(""); model.setDataVector(rowData2, columnNames); layout.show(rightPanel, "coursePanel"); } }); // 查询成绩按钮 scoreMainPanel.scorePanel.getSelectButton().