bjselectframe.java

java学生管理系统

/*zysetFrame.java专业设置窗口
 *
 * @author 方景
 */
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.table.*;
import java.util.Vector;
public class bjSelectFrame extends JFrame implements ActionListener{
        DataBaseManager db=new DataBaseManager();
	ResultSet rs;
	JPanel p1,p2,p3,p4,p5;
	JLabel label;
	JRadioButton rb[];
	String rbnames[]={"系名称","专业名","年级名","班级编号","班级名称"},bnames[]={"查询按钮","修改按钮","删除按钮"},chaxun;
	ButtonGroup radioGroup;
	JTextField field;
	JTable table=null;
	DefaultTableModel defaultModel=null;
	JButton buttons[];
    /** Creates a new instance of bjSelectFrame */
    public bjSelectFrame() {
        super("班级查询");
        label=new JLabel("查询条件：");
		field=new JTextField(15);
		p1=new JPanel();
		p1.add(label);
		p1.add(field);
		p2=new JPanel();
		radioGroup=new ButtonGroup();
		rb=new JRadioButton[5];
		for(int i=0;i<5;i++){
			rb[i]=new JRadioButton(rbnames[i],false);
			radioGroup.add(rb[i]);
			p2.add(rb[i]);
		}
		rb[0].setSelected(true);
		p3=new JPanel();
		p3.setLayout(new GridLayout(2,1,0,0));
		p3.add(p1);
		p3.add(p2);
		p4=new JPanel();
		String[] name={"班级编号","班级名称","班主任","班级人数"};
		String[][] data=new String[0][0];
		defaultModel=new DefaultTableModel(data,name);
		table=new JTable(defaultModel);
		table.setPreferredScrollableViewportSize(new Dimension(400,80));
		JScrollPane s=new JScrollPane(table);
		p4.add(s);
		p5=new JPanel();
		buttons=new JButton[3];
		for(int i=0;i<3;i++){
	            buttons[i]=new JButton(bnames[i]);
		    buttons[i].addActionListener(this);
	            p5.add(buttons[i]);
		}
	Container c=getContentPane();
        c.add(p3,BorderLayout.NORTH);
        c.add(p4,BorderLayout.CENTER);
        c.add(p5,BorderLayout.SOUTH);;	
	 } 
        
        public static void main(String[] args) {
        // TODO code application logic here
         bjSelectFrame b=new bjSelectFrame();
         b.pack();
         b.show();
    }
	 public void actionPerformed(ActionEvent e){   
	    //--查询按钮功能--
		if(e.getSource()==buttons[0]){	
		    if(rb[0].isSelected())chaxun="xName";	
		    else if(rb[1].isSelected())chaxun="zName";
		    else if(rb[2].isSelected())chaxun="nName";
		    else if(rb[3].isSelected())chaxun="bNo";
                    else if(rb[4].isSelected())chaxun="bName";
	    
	            String strSQL;
	            strSQL="select bNo,bName,bManager,bRenShu From yuanxi y,zhuanye z,nianji n,banji b where y.xNo=z.xNo and z.zNo=n.zNo and n.nNo=b.nNo and "+chaxun+" like '"+field.getText()+"%'";
	            try{
	               //首先要删除table中的数据先：
	                int rowCount=defaultModel.getRowCount()-1;//取得table中的数据行；
	                int j=rowCount;
	                for(int i=0;i<=rowCount;i++){
	             	defaultModel.removeRow(j);   //删除rowCount行的数据；
	        	    defaultModel.setRowCount(j); //重新设置行数；
	        	    j=j-1;
	                }
		            rs=db.getResult(strSQL);
		            while(rs.next()){
		               Vector data=new Vector();
			       data.addElement(rs.getString(1));
			       data.addElement(rs.getString(2));
			       data.addElement(rs.getString(3));
			       data.addElement(rs.getString(4));
			       defaultModel.addRow(data);
		           }
		           table.revalidate();
	          } catch(SQLException sqle){
			    System.out.println(sqle.toString());
		      }
	            catch(Exception ex){
			    System.out.println(ex.toString());
		      }
	      
	   }
	   //--修改按钮功能--
	   else if(e.getSource()==buttons[1]){
	 	  if(table.getSelectedRow()==-1){
		    JOptionPane.showMessageDialog(null,"请选择要修改的行！");
		    return;
		  }						
	 	  String str[]=new String[4];
	 	  int row=table.getSelectedRow();
	   	  for(int i=0;i<4;i++){
	 	     str[i]=(String)table.getValueAt(row,i);
	 	  }
	   	  bjsetFrame bjSet=new bjsetFrame(bjsetFrame.TO_UPDATE);
		  Dimension FrameSize=bjSet.getPreferredSize();
		  Dimension MainFrameSize=getSize();
		  Point loc=getLocation();
		  bjSet.setLocation((MainFrameSize.width-FrameSize.width)/2+loc.x,
		  (MainFrameSize.height-FrameSize.height)/2+loc.y);
                  bjSet.label.setVisible(false);
                  bjSet.field.setVisible(false);
                  bjSet.bt[0].setVisible(false);
		  for(int i=0;i<4;i++){
		  bjSet.fields[i].setText(str[i]);	
		  }
		  String strSQL;
	      strSQL="select xName,zName,nName From yuanxi y,zhuanye z,nianji n,banji b where y.xNo=z.xNo and z.zNo=n.zNo and n.nNo=b.nNo and bNo='"+str[0].trim()+"'";
	      rs=db.getResult(strSQL);
	      System.out.println(1);
	       try{
	           while(rs.next()){
		         bjSet.boxs[0].setSelectedItem(rs.getString("xName").trim());
		         bjSet.boxs[1].setSelectedItem(rs.getString("zName").trim());
		         bjSet.boxs[2].setSelectedItem(rs.getString("nName").trim());
		           }
	          } catch(SQLException sqle){
			    System.out.println(sqle.toString());
		      }
	            catch(Exception ex){
			    System.out.println(ex.toString());
		      }
	 	  bjSet.pack();
		  bjSet.show();  
	  }
	  //--删除按钮功能--
	  else if(e.getSource()==buttons[2]){
	 	 int rows[];
	 	 rows=new int[table.getSelectedRows().length];
	 	 for(int i=0;i<table.getSelectedRows().length;i++){
	         rows[i]=table.getSelectedRows()[i];
	 	  String bNo=(String)table.getValueAt(rows[i],1);
	    	String strSql="delete from banji where bNo='"+bNo.trim()+"'";
	    	try{
		        if(db.updateSql(strSql)) {
			       JOptionPane.showMessageDialog(null,"删除信息成功！");
			       this.dispose();
		        }
		        else{
		          JOptionPane.showMessageDialog(null,"添加信息失败请认真填写各项信息!");
		          this.dispose();
	        	}
	
		   }catch(Exception ex){
	         System.out.println(ex.toString());
	       }
	    }
	    db.closeConnection();
     }
   }
    
}