学生选课管理系统V0.1.0

package sc; import java.awt.*; import java.awt.event.*; import javax.swing.*; import javax.swing.event.*; import java.sql.*; import java.util.HashSet; import java.util.Iterator; /******************************** * 处理search面板的鼠标右键触发 * ******************************** */ class RightMouseListener extends MouseAdapter { private MyPopupMenu popupMenu; private MyTable t; public RightMouseListener(MyTable t) { this.t = t; this.popupMenu = t.popupMenu; } public void mouseReleased(MouseEvent e){checkForTriggerEvent(e);} public void mousePressed(MouseEvent e){checkForTriggerEvent(e); } private void checkForTriggerEvent(MouseEvent e) { if(e.isPopupTrigger()) popupMenu.show((Component)(t.getParent()),e.getX(),e.getY()); } } /************************ * 处理search面板的事件 * ************************ */ class SearchPaneListener extends KeyAdapter implements ActionListener { private JMenu menu; private JTextField textField; private JButton submit; private JPanel content; public SearchPaneListener(SearchPane p) { this.menu = p.menu; this.textField = p.textField; this.submit = p.submit; this.content = p.center; } public void actionPerformed(ActionEvent e) { //按下提交或者菜单 if( e.getActionCommand() == "提交查询" || e.getActionCommand() == "学生清单") { String sql; if(e.getActionCommand() == "提交查询") sql = "select * from student where "+getListName(menu.getText())+" = '"+textField.getText().trim()+"' order by sno asc"; else sql = "select * from student order by sno asc"; ResultSet s = Database.db.executeQuery(sql); MyTable table = new MyTable( s , Database.TABLEHEAD , Database.STULIST ); //利用结果集创建表单 String[] funList = {"删除_delete","-","详情_info"}; //弹出菜单的功能 table.setPopupMenu(funList); //添加弹出菜单 table.popupMenu.addPopupMenuListener( new PopupMenuListenerOnStudent( table ) ); table.addMouseListener( new RightMouseListener(table) ); //添加表单鼠标监听 content.removeAll(); //先清除以前的表单 content.add( new JScrollPane(table) ); //添加新表单到滚动板 content.getParent().validate(); //更新父容器 table.getModel().addTableModelListener(new STML(table)); //表格事件监听，修改时更新数据库 } else menu.setText( " "+((JMenuItem)e.getSource()).getText()+" " ); } //在文本框中按下enter public void keyReleased(KeyEvent k) { if(k.getKeyChar() == '\n') submit.doClick(); } //从Database.STUDENT和Database.STULIST中找出对应关系 public String getListName(String name) { int listNum = Database.STUDENT.length,i=0; for( ; i < listNum ; i++) if( name.indexOf( Database.STUDENT[i] ) != -1 ) break; return Database.STULIST[i]; } } class STML implements TableModelListener { private JTable table; public STML(JTable t) { table = t; } //修改表格的数据 public void tableChanged(TableModelEvent e) { int row = e.getFirstRow(); int col = e.getColumn(); if(col > 0) { String sno = table.getValueAt(row,0).toString(); String s = table.getValueAt(row,col).toString(); String sql = "UPDATE student SET "+Database.STULIST[col]+" ='"+s+"' WHERE sno = '"+sno+"'"; Database.db.executeUpdate(sql); } } } /********************** * 处理插入面板的事件 * ********************** */ class InsertPaneListener implements ActionListener { private InsertPane p; private String sno; private String sname = null; private String ssex; private int sage; private String sdept = null; private String errorInfo = ""; public InsertPaneListener(InsertPane p) { this.p = p; } public void actionPerformed(ActionEvent e) { if(e.getSource() == p.rButton[0] || e.getSource() == p.rButton[1]) p.tempSex = ( e.getSource() == p.rButton[0] ) ? "男" : "女"; else if( isValid() ) //如果输入合法 { String sql = "insert into student values " + "( '"+sno+"' , '"+sname+"' , '"+ssex+"' , '"+sage+"' , '"+sdept+"' )"; if(Database.db.executeUpdate(sql)) errorInfo = "成功添加了 ："+sql; else errorInfo = "添加失败 ：已存在该学生"; p.errorText.setText(errorInfo); } } //检查用户的输入是否合法 public boolean isValid() { try { Integer.parseInt(p.textarea[0].getText()); sno = p.textarea[0].getText(); } catch(Exception ne) { errorInfo +="学号应该为数字\n"; } try { sage = Integer.parseInt(p.textarea[2].getText()); } catch(Exception ne) { errorInfo +="年龄应该为数字\n"; } sname = p.textarea[1].getText(); sdept = p.textarea[3].getText(); ssex = p.tempSex; if(sname.equals("") ) { errorInfo += "姓名不该为空\n"; } if(sage <= 0 || sage >100 ) { errorInfo += "年龄不该为空\n"; } if(sdept.equals("") ) { errorInfo += "院系不该为空\n"; } //是否存在错误 if(!errorInfo.equals("")) { p.errorText.setText(errorInfo); errorInfo=""; return false; } else { p.errorText.setText(""); return true; } } } /****************** * 选项卡面板切换 * ****************** */ class TabbedPaneListener implements ChangeListener { private MainPane tabbedPane; public TabbedPaneListener(MainPane mp) { this.tabbedPane = mp; } public void stateChanged(ChangeEvent e) { int index = tabbedPane.getSelectedIndex(); //当切换到选课时向数据库查询 if(tabbedPane.getTitleAt(index) == "选课") { String sql = "select one.cno,one.cname,two.cname cpname,one.ccredit " + "from course one,course two " + "where one.cpno = two.cno"; ResultSet s = Database.db.executeQuery(sql); MyTable table = new MyTable(s,Database.COURSEHEAD,Database.COULIST); String[] funList = {"选修_select","-","查看关联课程_courseLink"}; table.setPopupMenu( funList ); table.popupMenu.addPopupMenuListener( new PopupMenuListenerOnCourse( table ) ); table.addMouseListener( new RightMouseListener( table ) ); tabbedPane.coursePane.center.removeAll(); tabbedPane.coursePane.center.add( new JScrollPane( table ) ); tabbedPane.coursePane.center.validate(); } } } /************************************ * 选修课程面板上弹出菜单的事件处理 * ************************************ */ class PopupMenuListenerOnCourse implements ActionListener { private MyTable table; private HashSet hCno = null; public PopupMenuListenerOnCourse(MyTable t) { this.table = t; } public void actionPerformed(ActionEvent e) { if(e.getActionCommand().equals("查看关联课程")) //查看关联课程 { int rows[] = table.getSelectedRows(); hCno = new HashSet(); //保存某一课程的所有各级先修课 for(int i = 0 ; i < rows.length ; i++) { hCno.add(rows[i]); String cpname = table.getValueAt(rows[i],2).toString(); getRelativeCourse( cpname , table.getRowCount() , hCno); } Iterator i = hCno.iterator(); while(i.hasNext()) { int s = Integer.parseInt(i.next().toString()); //获取关联课程的行号 table.addRowSelectionInterval(s,s); //设置关联课程为被选中状态 } } else //选修课程 { if(hCno != null) { Iterator i = hCno.iterator(); while(i.hasNext()) { int s = Integer.parseInt(i.next().toString()); //获取关联课程的行号 String sno = "000001"; //学号 String cno = table.getValueAt(s,0).toString(); //课程号 String grade = "0"; String sql = "INSERT INTO SC VA