yxsetframe.java

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

/*yxsetFrame.java 院系设置窗口
 *
 * @author 方景
 */
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class yxsetFrame extends JFrame implements ActionListener{
	public final static int TO_INSEART=1,TO_UPDATE=2;
	int insql;
	DataBaseManager db=new DataBaseManager();
	ResultSet rs;
    public JTextField fields[];
    JLabel labels[];
    public JTextArea textArea;
    JButton b1,b2;
    String labelsName[]={"系编号","系名称","系主任","联系方式"};
    public yxsetFrame(int inseartOrUpdate){
        super("院系设置");
        insql=inseartOrUpdate;
        labels=new JLabel[4];
        fields=new JTextField[4];
        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,10));
        p2.setLayout(new GridLayout(4,1,0,10));
        for(int i=0;i<4;i++){
            labels[i]=new JLabel(labelsName[i]+":");
            fields[i]=new JTextField(15);
            p1.add(labels[i]);
            p2.add(fields[i]); 
        }
        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(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 yuanxi(xNo,xName,xManager,xConnect,xMessage) values('"+
					fields[0].getText().trim()+"','"+
					fields[1].getText().trim()+"','"+
					fields[2].getText().trim()+"','"+
					fields[3].getText().trim()+"','"+
					textArea.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());
			        }
			}
			//--修改口功能--
			else{
			  try
				{
					String strSQL="update yuanxi set xName='"+
					fields[1].getText().trim()+"',"+
					"xManager='"+fields[2].getText().trim()+"',"+
					"xConnect='"+fields[3].getText().trim()+"',"+
					"xMessage='"+textArea.getText().trim()+"'where xNo='"+
					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());
			        }	
			}
          }
        }
    }
    
}