dialog1.java~1~

学生管理系统:有辅导员登入,学生登入和老师登入界面

package student;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import com.borland.dx.sql.dataset.*;
import com.borland.dx.dataset.*;

public class Dialog1 extends JDialog {
  JPanel panel1 = new JPanel();
  JButton jButton2 = new JButton();
  JLabel jLabel2 = new JLabel();
  JTextField jTextField2 = new JTextField();
  JButton jButton1 = new JButton();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JTextField jTextField1 = new JTextField();
String xieqi;
  JButton jButton3 = new JButton();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  Database database1 = new Database();
  Column column1 = new Column();
  ParameterRow parameterRow1 = new ParameterRow();
  JLabel jLabel6 = new JLabel();
  JTextField jTextField3 = new JTextField();
  JButton jButton4 = new JButton();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  JTextField jTextField4 = new JTextField();
  public Dialog1(Frame frame, String title, boolean modal,String xieqi){
    super(frame, title, modal);
    try {
      this.xieqi=xieqi;
      jbInit();
      pack();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  /*public Dialog1() {
    this(null, "", false);
 }*/

  private void jbInit() throws Exception {
    panel1.setLayout(null);
    this.getContentPane().setLayout(null);
    panel1.setBounds(new Rectangle(0, 0, 400, 300));
    jButton2.setBounds(new Rectangle(192, 190, 92, 35));
    jButton2.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton2.setText("取消");
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel2.setForeground(Color.red);
    jLabel2.setText("格式为：2005－2006学年度");
    jLabel2.setBounds(new Rectangle(49, 28, 269, 48));
    jTextField2.setFont(new java.awt.Font("Dialog", 0, 15));
    jTextField2.setEditable(false);
    jTextField2.setBounds(new Rectangle(165, 135, 127, 33));
      jTextField2.setText(xieqi);
    jButton1.setBounds(new Rectangle(73, 190, 92, 35));
    jButton1.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton1.setText("确定");
    jButton1.addActionListener(new Dialog1_jButton1_actionAdapter(this));

    jLabel1.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel1.setText("需修改的学期");
    jLabel1.setBounds(new Rectangle(49, 87, 102, 33));
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel3.setText("更新为");
    jLabel3.setBounds(new Rectangle(49, 135, 102, 33));
    jTextField1.setFont(new java.awt.Font("Dialog", 0, 15));
    jTextField1.setSelectionStart(11);
    jTextField1.setText("");
    jTextField1.setBounds(new Rectangle(165, 87, 127, 33));
    jButton3.setText("取消");
    jButton3.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton3.setBounds(new Rectangle(182, 168, 92, 35));
    jLabel4.setBounds(new Rectangle(39, 65, 102, 33));
    jLabel4.setText("需修改的学期");
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel5.setBounds(new Rectangle(39, 113, 102, 33));
    jLabel5.setText("更新为");
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 15));
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:studentmanage", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    column1.setSqlType(0);
    column1.setServerColumnName("NewColumn1");
    column1.setDataType(com.borland.dx.dataset.Variant.STRING);
    column1.setColumnName("学年");
    parameterRow1.setColumns(new Column[] {column1});
    jLabel6.setBounds(new Rectangle(39, 6, 269, 48));
    jLabel6.setText("格式为：2005－2006学年度");
    jLabel6.setForeground(Color.red);
    jLabel6.setFont(new java.awt.Font("Dialog", 0, 15));
    jTextField3.setBounds(new Rectangle(155, 113, 127, 33));
    jTextField3.setText(xieqi);
    jTextField3.setEditable(false);
    jTextField3.setFont(new java.awt.Font("Dialog", 0, 15));

    jButton4.setText("确定");
    jButton4.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton4.setBounds(new Rectangle(63, 168, 92, 35));
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from xieqi where 学年=:学年", parameterRow1, true, Load.ALL));
    jTextField4.setBounds(new Rectangle(155, 65, 127, 33));
    jTextField4.setText("");
    jTextField4.setSelectionStart(11);
    jTextField4.setFont(new java.awt.Font("Dialog", 0, 15));
    getContentPane().add(panel1, null);
    panel1.add(jTextField1, null);
    panel1.add(jLabel2, null);
    panel1.add(jLabel1, null);
    panel1.add(jLabel3, null);
    panel1.add(jButton1, null);
    panel1.add(jButton2, null);
    panel1.add(jTextField2, null);
    this.getContentPane().add(jButton3, null);
    this.getContentPane().add(jLabel4, null);
    this.getContentPane().add(jLabel5, null);
    this.getContentPane().add(jLabel6, null);
    this.getContentPane().add(jTextField3, null);
    this.getContentPane().add(jButton4, null);
    this.getContentPane().add(jTextField4, null);
  }

  void jButton1_actionPerformed(ActionEvent e) {
    String xieqi1=jTextField1.getText().trim();
       parameterRow1.setString("学年",xieqi1);
       queryDataSet1.executeQuery();
       if(queryDataSet1.rowCount()>0){
       String sql="update xieqi set 学年='"+xieqi+"' where  学年='"+xieqi1+"'";
       database1.executeStatement(sql);
       JOptionPane.showMessageDialog(this,"信息修改成功");
          this.dispose();
      }else{
         JOptionPane.showMessageDialog(this," 此学期不存在","信息提示",2);
     return;
       }

  }
}

class Dialog1_jButton1_actionAdapter implements java.awt.event.ActionListener {
  Dialog1 adaptee;

  Dialog1_jButton1_actionAdapter(Dialog1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}