zysetframe.java

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

/*zysetFrame.java专业设置窗口
 *
 * @author 方景
 */
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class zysetFrame extends JFrame implements ActionListener{
    public final static int TO_INSEART=1,TO_UPDATE=2;
    int insql;
    DataBaseManager db=new DataBaseManager();
    ResultSet rs;
    JTextField fields[];
    JLabel labels[],label1;
    JComboBox box1;
    JTextArea textArea;
    JButton b1,b2;
    String labelsName[]={"专业编号","专业名称","专业主任"},xiName,xiNo="";
    public zysetFrame(int inseartOrUpdate){
        super("专业信息设置"); 
        insql=inseartOrUpdate;
        labels=new JLabel[3];
        fields=new JTextField[3];
        JPanel p1=new JPanel();
        JPanel p2=new JPanel();
        JPanel p3=new JPanel();
        JPanel p4=new JPanel();
        JPanel p5=new JPanel();
        p1.setLayout(new GridLayout(4,1,0,15));
        p2.setLayout(new GridLayout(4,1,0,10));
        label1=new JLabel("系名称：");
        box1=new JComboBox();
        try{
        rs=db.getResult("Select xName From yuanxi");
        while(rs.next()){
        	box1.addItem(rs.getString("xName"));
        }
        }catch(SQLException e){
        	System.out.println("在执行数据库访问时发生了错误22!");
        	e.printStackTrace();
        }
        p1.add(label1);
        p2.add(box1);
        for(int i=0;i<3;i++){
            labels[i]=new JLabel(labelsName[i]+":");
            fields[i]=new JTextField(15);
            p1.add(labels[i]);
            p2.add(fields[i]); 
        }
         box1.addItemListener(
          new ItemListener(){
          	public void itemStateChanged(ItemEvent event)
          	{
              if(event.getStateChange()==ItemEvent.SELECTED){
              xiName=((String)(box1.getItemAt(box1.getSelectedIndex()))).trim();
              try{
                 rs=db.getResult("Select xNo From yuanxi where xName="+"'"+xiName+"'");
                 while(rs.next()){
                 xiNo=rs.getString("xNo");
                 }
              }catch(SQLException e){
        	   System.out.println("在执行数据库访问时发生了错误11!");
        	   e.printStackTrace();
               }
              }
            }
           } 	
        );
        p3.setBorder(BorderFactory.createTitledBorder("专业介绍介绍"));
        textArea=new JTextArea(5,15);
        JScrollPane t=new JScrollPane(textArea);
        b1=new JButton("确定按钮");
        b1.addActionListener(this);
        b2=new JButton("取消按钮");
        b2.addActionListener(this);
        p3.add(t);
        p4.add(p1);
        p4.add(p2);
        p4.add(p3);
        p5.add(b1);
        p5.add(b2);
        Container c=getContentPane();
        c.add(p4,BorderLayout.CENTER);
        c.add(p5,BorderLayout.SOUTH);
    }
     
    public void actionPerformed(ActionEvent e) {
        if(e.getSource()==b2)
		{
			db.closeConnection();
			this.dispose();
		}
        else if(e.getSource()==b1){
        	if(xiNo.equals(""))
			{
				JOptionPane.showMessageDialog(null,"请选择一个系！");
			}
            else if(fields[0].getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"专业编号不能为空！");
			}
			else if(fields[1].getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"专业名称不能为空！");
			}
			else if(fields[2].getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"专业主任不能为空！");
			}	
			else
			{
			  //--设置窗口功能--
			  if(insql==1){
				try
				{
					String strSQL="insert into zhuanye(zNo,zName,zManager,zMessage,xNo) values('"+
					fields[0].getText().trim()+"','"+
					fields[1].getText().trim()+"','"+
					fields[2].getText().trim()+"','"+
					textArea.getText().trim()+"','"+xiNo+"')";
					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 xNo='"+
					xiNo+"',"+
					"zName='"+fields[1].getText().trim()+"',"+
					"zManager='"+fields[2].getText().trim()+"',"+
					"zMessage='"+textArea.getText().trim()+
					"'where zNo='"+fields[0].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());
			        }	
		     }
	    	}
        }
    }
    
}