学生选课管理系统.zip

package com.java.view; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.MouseAdapter; import java.awt.event.MouseEvent; import java.sql.Connection; import java.sql.ResultSet; import java.util.Vector; import javax.swing.GroupLayout; import javax.swing.ImageIcon; import javax.swing.JButton; import javax.swing.JInternalFrame; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.JTextField; import javax.swing.LayoutStyle; import javax.swing.table.DefaultTableModel; import com.java.dao.CourseDao; import com.java.model.Course; import com.java.util.DbUtil; import com.java.util.StringUtil; //课程管理窗口 public class CourseManageInterFrm extends JInternalFrame { /** * */ private static final long serialVersionUID = 1L; //私有成员 private JTextField capacityTxt; private JTextField courseIdTxt; private JTextField courseNameTxt; private JTable courseTable; private JTextField courseTeacherTxt; private JTextField courseTimeTxt; private JLabel jLabel1; private JLabel jLabel2; private JLabel jLabel3; private JLabel jLabel4; private JLabel jLabel5; private JLabel jLabel6; private JLabel jLabel7; private JLabel jLabel8; private JLabel jLabel9; private JPanel jPanel1; private JPanel jPanel2; private JScrollPane jScrollPane1; private JButton jb_delete; private JButton jb_modify; private JButton jb_search; private JTextField numSelectedTxt; private JTextField s_courseNameTxt; private JTextField s_courseTeacherTxt; private JTextField s_courseTimeTxt; private int NumSelected; //数据库连接 DbUtil dbUtil = new DbUtil(); CourseDao courseDao = new CourseDao(); //构造方法 public CourseManageInterFrm() { //调用放置组件方法 initComponents(); this.setLocation(250, 50); this.fillTable(new Course()); } //重置时间清空方法 private void resetValue() { this.courseIdTxt.setText(""); this.courseNameTxt.setText(""); this.courseTeacherTxt.setText(""); this.courseTimeTxt.setText(""); this.capacityTxt.setText(""); this.numSelectedTxt.setText(""); } //填表 private void fillTable(Course course) { DefaultTableModel dtm = (DefaultTableModel) courseTable.getModel(); dtm.setRowCount(0); Connection con = null; try { con = dbUtil.getCon(); ResultSet rs = courseDao.courseList(con, course); while (rs.next()) { Vector<String> v = new Vector<String>(); v.add(rs.getString("courseId")); v.add(rs.getString("courseName")); v.add(rs.getString("courseTime")); v.add(rs.getString("courseTeacher")); v.add(rs.getString("capacity")); v.add(rs.getString("numSelected")); dtm.addRow(v); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { try { dbUtil.closeCon(con); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } } //放置组件方法 private void initComponents() { //创建组件 jPanel1 = new JPanel(); jLabel1 = new JLabel(); s_courseNameTxt = new JTextField(); jLabel2 = new JLabel(); s_courseTimeTxt = new JTextField(); jLabel3 = new JLabel(); s_courseTeacherTxt = new JTextField(); jb_search = new JButton(); jScrollPane1 = new JScrollPane(); courseTable = new JTable(); jPanel2 = new JPanel(); courseIdTxt = new JTextField(); jLabel4 = new JLabel(); courseNameTxt = new JTextField(); jLabel5 = new JLabel(); courseTimeTxt = new JTextField(); jLabel6 = new JLabel(); courseTeacherTxt = new JTextField(); jLabel7 = new JLabel(); capacityTxt = new JTextField(); jLabel8 = new JLabel(); numSelectedTxt = new JTextField(); jLabel9 = new JLabel(); jb_modify = new JButton(); jb_delete = new JButton(); //设置窗口属性 setClosable(true); setIconifiable(true); setTitle("课程信息修改"); //设置jPane1面板 jPanel1.setBorder(javax.swing.BorderFactory .createTitledBorder("搜索条件")); jLabel1.setText("课程名称"); jLabel2.setText("任课老师"); jLabel3.setText("上课时间"); //给按钮jb_search添加图片和文字及监听器 jb_search .setIcon(new ImageIcon(this.getClass().getResource( "/com/java/view/image/search.png"))); jb_search.setText("查询"); jb_search.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent evt) { jb_searchActionPerformed(evt); } }); //创建GroupLayout布局管理器 GroupLayout jPanel1Layout = new GroupLayout( jPanel1); jPanel1.setLayout(jPanel1Layout); //设置沿水平轴确定组件的位置和大小 jPanel1Layout.setHorizontalGroup(jPanel1Layout .createParallelGroup( GroupLayout.Alignment.LEADING) .addGroup( jPanel1Layout .createSequentialGroup() .addGap(24, 24, 24) .addComponent(jLabel1) .addPreferredGap( LayoutStyle.ComponentPlacement.RELATED) .addComponent( s_courseNameTxt, GroupLayout.PREFERRED_SIZE, 158, GroupLayout.PREFERRED_SIZE) .addGap(26, 26, 26) .addComponent(jLabel3) .addGap(18, 18, 18) .addComponent( s_courseTimeTxt, GroupLayout.PREFERRED_SIZE, 149, GroupLayout.PREFERRED_SIZE) .addGap(46, 46, 46) .addComponent(jLabel2) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent( s_courseTeacherTxt, GroupLayout.PREFERRED_SIZE, 110, GroupLayout.PREFERRED_SIZE) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.RELATED, 50, Short.MAX_VALUE) .addComponent(jb_search).addGap(94, 94, 94))); //设置沿垂直轴确定组件的位置和大小 jPanel1Layout.setVerticalGroup(jPanel1Layout .createParallelGroup( GroupLayout.Alignment.LEADING) .addGroup( jPanel1Layout .createSequentialGroup() .addGap(18, 18, 18) .addGroup( jPanel1Layout .createParallelGroup( GroupLayout.Alignment.BASELINE) .addComponent( s_courseNameTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE) .addComponent(jLabel1) .addComponent(jb_search) .addComponent(jLabel3) .addComponent( s_courseTimeTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE) .addComponent(jLabel2) .addComponent( s_courseTeacherTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)) .addContainerGap( GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))); //设置表 courseTable.setModel(new javax.swing.table.DefaultTableModel( new Object[][] { }, new String[] { "课程编号", "课程名称", "上课时间", "任课老师", "课程容量", "已选人数" }) { /** * */ private static final long serialVersionUID = 1L; boolean[] canEdit = new boolean[] { false, false, false, false, false, false }; public boolean isCellEditable(int rowIndex, int columnIndex) { return canEdit[columnIndex]; } }); //给课程表添加监听器 courseTable.addMouseListener(new MouseAdapter() { public void mousePressed(MouseEvent evt) { courseTableMousePressed(evt); } });