xqsetframe.java

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

/*zysetFrame.java专业设置窗口
 *
 * @author 方景
 */
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class xqsetFrame extends JFrame implements ActionListener{
    public final static int TO_INSEART=1,TO_UPDATE=2;
    int insql;
    DataBaseManager db=new DataBaseManager();
    ResultSet rs;
    JLabel l1,l2,l3,l4,l5;
    JTextField field1,field2,field3;
    JRadioButton rbts[],r1,r2;
    ButtonGroup radioGroup1,radioGroup2;
    String rnames[]={"上学期","下学期","其他"},qlx="",qdq="是";
    JPanel p1,p2,p3,p4,p5,p6,p7;
    JButton b1,b2;
    /** Creates a new instance of xqsetFrame */
    public xqsetFrame(int inseartOrUpdate) {
        super("学期设置");
        insql=inseartOrUpdate;
        p1=new JPanel();
        p2=new JPanel();
        p2.setLayout(new GridLayout(3,1,0,0));
        p2.setBorder(BorderFactory.createTitledBorder("学期类型"));
        p3=new JPanel();
        p3.setLayout(new BorderLayout());
        p4=new JPanel();
        p5=new JPanel();
        p5.setLayout(new GridLayout(3,2,0,0));
        p6=new JPanel();
        p7=new JPanel();
        l1=new JLabel("学年");
        field1=new JTextField(15);
        p1.add(l1);
        p1.add(field1);
        rbts=new JRadioButton[3];
        radioGroup1=new ButtonGroup();
        for(int i=0;i<3;i++){
            rbts[i]=new JRadioButton(rnames[i],false);
            p2.add(rbts[i]); 
            radioGroup1.add(rbts[i]);
        }
        rbts[0].setSelected(true);
        p3.add(p1,BorderLayout.NORTH);
        p3.add(p2,BorderLayout.CENTER);
        radioGroup2=new ButtonGroup();
        r1=new JRadioButton("是",true);
        r2=new JRadioButton("否",false);
        radioGroup2.add(r1);
        radioGroup2.add(r2);
        p4.add(r1);
        p4.add(r2);
        l2=new JLabel("是否为当前学期");
        l3=new JLabel("起始时间");
        l4=new JLabel("结束时间");
        field2=new JTextField(6);
        field2.setText("YYYY-MM-DD");
        field3=new JTextField(6);
        field3.setText("YYYY-MM-DD");
        p5.add(l2);
        p5.add(p4);
        p5.add(l3);
        p5.add(field2);
        p5.add(l4);
        p5.add(field3);
        p6.add(p3);
        p6.add(p5);
        b1=new JButton("确定按钮");
        b2=new JButton("取消按钮");
        b1.addActionListener(this);
        b2.addActionListener(this);
        p7.add(b1);
        p7.add(b2);
        Container c=getContentPane();
        c.add(p6,BorderLayout.CENTER);
        c.add(p7,BorderLayout.SOUTH);
    }
    
    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        // TODO code application logic here
        xqsetFrame b=new xqsetFrame(xqsetFrame.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(field1.getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"学年不能为空！");
			}
			else
			{  
			 //--设置窗口功能--
			 if(insql==1){
				try
				{       
					String strSQL="insert into xueqi(qName,qxn,qlx,qdq,qks,qjs) values('"+
					field1.getText().trim()+qlx+"','"+
					field1.getText().trim()+"','"+
					qlx.trim()+"','"+
                                        qdq.trim()+"','"+
					field2.getText().trim()+"','"+
					field3.getText().trim().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 xueqi set qName='"+
					field1.getText().trim()+qlx+"',"+
					"qxn='"+field1.getText().trim()+"',"+
					"qlx='"+qlx.trim()+"',"+
					"qdq='"+field2.getText().trim()+"'where xNo='"+
					field3.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());
			        }	
			}
          }
        }
    }
    
}