njsetframe.java

java课程设计题目—— 学生信息管理系统的一个JAVA源代码

/*zysetFrame.java专业设置窗口
 *
 * @author 方景
 */
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class njsetFrame extends JFrame implements ActionListener{
    myItemListener handler;
    public final static int TO_INSEART=1,TO_UPDATE=2;
    int insql;
    DataBaseManager db=new DataBaseManager();
    ResultSet rs;
    JLabel labels[];
    JComboBox box1,box2;
    JTextField field1,field2;
    JButton b1,b2;
    JPanel p1,p2;
    Box box;
    String labelNames[]={"系名称","专业名称","年级编号","年纪名称"},xName="",zName="",zNo="";
    /** Creates a new instance of njsetFrame */
    public njsetFrame(int inseartOrUpdate) {
       super("年级设置");
       insql=inseartOrUpdate;
       p1=new JPanel();
       p2=new JPanel();
       box=Box.createVerticalBox();
       p1.setLayout(new GridLayout(4,1,0,15));
       p2.setLayout(new GridLayout(4,1,0,10));
       labels=new JLabel[4];
       for(int i=0;i<4;i++){
           labels[i]=new JLabel(labelNames[i]+": ");
           p1.add(labels[i]);
       }
       box1=new JComboBox();
       box2=new JComboBox();
       handler=new myItemListener();
       box2.addItemListener(handler);
       try{
        rs=db.getResult("Select xName From yuanxi");
        box1.addItem("请选择系");
        while(rs.next()){
        	box1.addItem(rs.getString("xName"));
        }
        }catch(SQLException e){
        	System.out.println("在执行数据库访问时发生了错误22!");
        	e.printStackTrace();
        }
       box1.addItemListener(
          new ItemListener(){
              public void itemStateChanged(ItemEvent event){
                  if(event.getStateChange()==ItemEvent.SELECTED){
                     xName=((String)(box1.getItemAt(box1.getSelectedIndex()))).trim();
                     box2.removeItemListener(handler);
                     box2.removeAllItems();
                     try{
                        rs=db.getResult("Select zName From yuanxi y,zhuanye z where xName="+"'"+xName+"'and y.xNo=z.xNo");
                        box2.addItem("请选择专业");
                        while(rs.next()){
                            box2.addItem(rs.getString("zName"));
                        }
                     }catch(SQLException e){
        	            System.out.println("在执行数据库访问时发生了错误11!");
        	            e.printStackTrace();
                     }
                     box2.addItemListener(handler);
                 }
             }
         } 	
       );
       field1=new JTextField(15);
       field2=new JTextField(15);
       p2.add(box1);
       p2.add(box2);
       p2.add(field1);
       p2.add(field2);
       b1=new JButton("确定按钮");
       b2=new JButton("取消按钮");
       b1.addActionListener(this);
       b2.addActionListener(this);
       box.add(Box.createVerticalStrut(25));
       box.add(b1);
       box.add(Box.createVerticalStrut(25));
       box.add(b2);
       Container c=getContentPane();
       c.add(p1,BorderLayout.WEST);
       c.add(p2,BorderLayout.CENTER);
       c.add(box,BorderLayout.EAST);
    }
    
    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        // TODO code application logic here
         njsetFrame b=new njsetFrame(njsetFrame.TO_INSEART);
         b.pack();
         b.show();
    }
    
    public void actionPerformed(ActionEvent e) {
        if(e.getSource()==b2){
	    db.closeConnection();
	    this.dispose();
         }
        else if(e.getSource()==b1){
            if(xName.equals("")||xName.equals("请选择系")){
		JOptionPane.showMessageDialog(null,"请选择一个系！");
	    }
	    else if(zName.equals("")||zName.equals("请选择专业")){
		JOptionPane.showMessageDialog(null,"请选择一个专业！");
	    }
            else if(field1.getText().trim().equals("")){
		JOptionPane.showMessageDialog(null,"年级编号不能为空！");
	    }
	   else if(field2.getText().trim().equals("")){
	       JOptionPane.showMessageDialog(null,"年级名称不能为空！");
	   }
	  else{
			  //--设置窗口功能--
	       if(insql==1){
		   try{
			String strSQL="insert into nianji(nNo,nName,zNo) values('"+
		        field1.getText().trim()+"','"+
			field2.getText().trim()+"','"+
			zNo+"')";
		       if(db.updateSql(strSQL)){
			  JOptionPane.showMessageDialog(null,"添加信息成功！");
			  this.dispose();
			}
			else{
			   JOptionPane.showMessageDialog(null,"添加信息失败！");
			   this.dispose();
			}
			 db.closeConnection();
		     }catch(Exception ex){
		     System.out.println(ex.toString());
		     }
               }
		     //--修改窗口功能--
	      else{
		    try{
		       String strSQL="update zhuanye set nNo='"+
		       field1.getText().trim()+"',"+
		       "nName='"+field2.getText().trim()+"',"+
		       "zNo='"+zNo+"'"+
			"where zNo='"+field1.getText().trim()+"'";
			if(db.updateSql(strSQL)){
			    JOptionPane.showMessageDialog(null,"修改信息成功！");
			    this.dispose();
			}
			else{
			     JOptionPane.showMessageDialog(null,"添加信息失败请认真填写各项信息!");
			    this.dispose();
			}
			     db.closeConnection();
		    }catch(Exception ex){
			System.out.println(ex.toString());
		    }	
	     }
	   }
        }
    }
    private class myItemListener implements ItemListener{
              public void itemStateChanged(ItemEvent event){
                  if(event.getStateChange()==ItemEvent.SELECTED){
                     zName=((String)(box2.getItemAt(box2.getSelectedIndex()))).trim();
                     try{
                        rs=db.getResult("Select zNo From zhuanye where zName="+"'"+zName+"'");
                        while(rs.next()){
                           zNo=rs.getString("zNo");
                        }
                     }catch(SQLException e){
        	            System.out.println("在执行数据库访问时发生了错误222221!");
        	            e.printStackTrace();
                     }
                 }
             }
         } 	
    
}