changeinf.java

一个简单的学籍管理系统..实现了增,删,查,改等功能

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
//import oracle.jdbc.driver.*;
public class ChangeInf extends JFrame implements ActionListener 
{
  String strurl;
  Connection conn;
  Statement stmt;
  ResultSet rs;

  Label label1 = new Label();
  TextField textField1 = new TextField();
  Label label2 = new Label();
  TextField textField2 = new TextField();
  Label label3 = new Label();
  Choice choice1 = new Choice();
  Label label4 = new Label();
  TextField textField3 = new TextField();
  Label label5 = new Label();
  Choice choice2 = new Choice();
  Label label6 = new Label();
  TextField textField4 = new TextField();
  Label label7 = new Label();
  Choice choice3 = new Choice();
  Label label8 = new Label();
  TextField textField5 = new TextField();
  Label label9 = new Label();
  TextArea textArea1 = new TextArea();
  Button button1 = new Button();
  TextField textField6 = new TextField();
  Button button2 = new Button();
  Label label10 = new Label();

  public ChangeInf() 
	{
    	try 
	{
      		jbInit();
   	}
    	catch (Exception e) 
	{
      	e.printStackTrace();
    	}
  	}

  private void jbInit() throws Exception {
    	label1.setText("学        号:");
   	label1.setVisible(false);
    	label1.setBounds(new Rectangle(30, 11, 51, 33));
    	this.getContentPane().setLayout(null);
    	textField1.setText("");
    	textField1.setVisible(false);
    	textField1.setBounds(new Rectangle(86, 16, 74, 22));
    
	label2.setBounds(new Rectangle(162, 11, 28, 33));
    	label2.setText("姓名:");
    	label2.setVisible(false);
    	textField2.setText("");
    	textField2.setVisible(false);
    	textField2.setBounds(new Rectangle(192, 16, 44, 22));
    
	label3.setText("性别:");
    	label3.setVisible(false);
    	label3.setBounds(new Rectangle(241, 11, 28, 33));
    	
	choice1.setEnabled(true);
    	choice1.setFont(new java.awt.Font("Dialog", 0, 12));
    	choice1.setForeground(Color.black);
    	choice1.setLocale(java.util.Locale.getDefault());
    	choice1.setVisible(false);
    	choice1.setBounds(new Rectangle(275, 15, 50, 25));
    	choice1.addItem("男");
    	choice1.addItem("女");
    	
	this.setDefaultCloseOperation(HIDE_ON_CLOSE);
    	this.setEnabled(true);
    	this.setResizable(false);
    	this.setTitle("修改学生信息");
    
	label4.setBounds(new Rectangle(31, 53, 49, 33));
    	label4.setText("出生日期:");
    	label4.setVisible(false);
    	textField3.setBounds(new Rectangle(86, 58, 74, 22));
    	textField3.setLocale(java.util.Locale.getDefault());
    	textField3.setText("");
    	textField3.setVisible(false);
    
	label5.setText("政治面貌:");
    	label5.setVisible(false);
    	label5.setBounds(new Rectangle(241, 53, 47, 33));
    	choice2.setBounds(new Rectangle(296, 57, 72, 25));
    	choice2.setVisible(false);
    	choice2.setLocale(java.util.Locale.getDefault());
    	choice2.setForeground(Color.black);
    	choice2.setFont(new java.awt.Font("Dialog", 0, 12));
    	choice2.setEnabled(true);
    
	label6.setText("籍贯:");
    	label6.setVisible(false);
    	label6.setBounds(new Rectangle(163, 53, 26, 33));
    	textField4.setBounds(new Rectangle(191, 58, 44, 22));
    	textField4.setText("");
    	textField4.setVisible(false);
    	
	label7.setBounds(new Rectangle(30, 94, 50, 33));
    	label7.setText("系        别:");
    	label7.setVisible(false);
    	choice3.setEnabled(true);
    	choice3.setFont(new java.awt.Font("Dialog", 0, 12));
    	choice3.setForeground(Color.black);
    	choice3.setLocale(java.util.Locale.getDefault());
    	choice3.setVisible(false);
    	choice3.setBounds(new Rectangle(86, 98, 75, 25));
    	
	label8.setBounds(new Rectangle(163, 94, 26, 33));
    	label8.setText("专业:");
    	label8.setVisible(false);
    	textField5.setText("");
    	textField5.setVisible(false);
    	textField5.setBounds(new Rectangle(190, 99, 178, 22));
    
	label9.setText("备        注:");
    	label9.setVisible(false);
    	label9.setBounds(new Rectangle(27, 132, 50, 33));
    	textArea1.setVisible(false);
    	textArea1.setBounds(new Rectangle(84, 139, 285, 95));
    	
    button1.setLabel("修改");
    button1.setVisible(false);
    button1.setBounds(new Rectangle(153, 241, 94, 22));
    button1.addActionListener(this);
    textField6.setText("");
    textField6.setBounds(new Rectangle(147, 92, 105, 23));
    button2.setFont(new java.awt.Font("Dialog", 1, 15));
    button2.setLabel("下一步");
    button2.setVisible(true);
    button2.setBounds(new Rectangle(156, 148, 89, 23));
    button2.addActionListener(this);
    label10.setFont(new java.awt.Font("Dialog", 1, 15));
    label10.setText("请输入要修改的学生学号");
    label10.setBounds(new Rectangle(110, 49, 178, 24));
    this.getContentPane().add(label3, null);
    this.getContentPane().add(label1, null);
    this.getContentPane().add(textField1, null);
    this.getContentPane().add(label2, null);
    this.getContentPane().add(textField2, null);
    this.getContentPane().add(choice1, null);
    this.getContentPane().add(label4, null);
    this.getContentPane().add(textField3, null);
    this.getContentPane().add(label6, null);
    this.getContentPane().add(textField4, null);
    this.getContentPane().add(label5, null);
    this.getContentPane().add(choice2, null);
    this.getContentPane().add(label7, null);
    this.getContentPane().add(choice3, null);
    this.getContentPane().add(label8, null);
    this.getContentPane().add(textField5, null);
    this.getContentPane().add(label9, null);
    this.getContentPane().add(textArea1, null);
    this.getContentPane().add(button2, null);
    this.getContentPane().add(textField6, null);
    this.getContentPane().add(label10, null);
    this.getContentPane().add(button1, null);

    choice2.addItem("团员");
    choice2.addItem("党员");
    choice2.addItem("其他");

    choice3.addItem("计算机");
    choice3.addItem("电子");
    choice3.addItem("生化");
    choice3.addItem("艺术");
	
	//DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
	conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:storm","scott","tiger");
    
    	stmt = conn.createStatement();
  }

  public void actionPerformed(ActionEvent e) 
	{
   	 if (e.getSource() == button2) 
	{
      	try 
	{
        rs = stmt.executeQuery("SELECT * FROM BaseInf where 学号='" +textField6.getText() + "'");
        if (rs.next()) 
	{
          textField6.setVisible(false);
          button2.setVisible(false);
          label10.setVisible(false);
          label1.setVisible(true);
          label2.setVisible(true);
          label3.setVisible(true);
          label4.setVisible(true);
          label5.setVisible(true);
          label6.setVisible(true);
          label7.setVisible(true);
          label8.setVisible(true);
          label9.setVisible(true);
          textArea1.setVisible(true);
          textArea1.setText(rs.getString("备注"));
          textField1.setVisible(true);
          textField1.enable(false);
          textField1.setText(rs.getString("学号"));
          textField2.setVisible(true);
          textField2.setText(rs.getString("姓名"));
          textField3.setVisible(true);
          textField3.setText(rs.getString("出生日期"));
          textField4.setVisible(true);
          textField4.setText(rs.getString("籍贯"));
          textField5.setVisible(true);
          textField5.setText(rs.getString("专业"));
          choice1.setVisible(true);
          choice1.select(rs.getString("性别"));
          choice2.setVisible(true);
          choice2.select(rs.getString("政治面貌"));
          choice3.setVisible(true);
          choice3.select(rs.getString("系别"));
          button1.setVisible(true);
        }
        else
          JOptionPane.showMessageDialog(null, "无此学号对应信息", "警告",
                                        JOptionPane.WARNING_MESSAGE);
      }
      catch (Exception eg) {
        eg.printStackTrace();
      }
    }
    else if (e.getSource() == button1) {
      try {
        stmt.execute("DELETE FROM BaseInf where 学号=' " + textField6.getText() +" ' ");
        stmt.execute(
            "insert into BaseInf (学号,系别,专业,姓名,性别,出生日期,籍贯,政治面貌,备注) values ('" +
            textField1.getText() + "','" + choice3.getSelectedItem() + "','" +
            textField5.getText() + "','" + textField2.getText() + "','" +
            choice1.getSelectedItem() + "','" + textField3.getText() + "','" +
            textField4.getText() + "','" + choice2.getSelectedItem() + "','" +
            textArea1.getText() + "')");
        JOptionPane.showMessageDialog(null, "修改信息成功!");
      }
      catch (Exception eg) {
        JOptionPane.showMessageDialog(null, "请认真检查各项(不能为空),\n日期要合法!然后重试.",
                                      "异常警告", JOptionPane.WARNING_MESSAGE);
        eg.printStackTrace();
      }
    }
  }
}