fclassroom.java

中小学校园的教师

package untitled2;

import javax.swing.*;
import java.awt.*;
import com.borland.dbswing.*;
import com.borland.dx.sql.dataset.*;
import com.borland.jbcl.layout.*;
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.awt.event.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class FClassroom extends JFrame {
  Database database1 = new Database();
  QueryDataSet queryDS = new QueryDataSet();
  XYLayout xYLayout1 = new XYLayout();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  XYLayout xYLayout3 = new XYLayout();
  JButton jButton4 = new JButton();
  JLabel jLabel2 = new JLabel();
  JComboBox jCBclass1 = new JComboBox();
  JPanel jPanel1 = new JPanel();
  JButton jButton5 = new JButton();
  XYLayout xYLayout2 = new XYLayout();
  JButton jButton6 = new JButton();
  TableScrollPane tableScrollPane2 = new TableScrollPane();
  JdbTable jdbTable1 = new JdbTable();
  Connection con;
  Statement st;
  PreparedStatement  ps;
  ResultSet rs;
  String sql;
  static  boolean flag;
  static int statu;


  public FClassroom() {
    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  void jbInit() throws Exception {
    queryDS.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1,
        "SELECT classroom.classroom_id as 教室号,classroom.classroom_name as " +
        "教室名,classroom.classroom_site as 容量,classroom.classroom_size as 地址 " +
        "FROM Digital_Campus.dbo.classroom", null, true, Load.ALL));
    queryDS.setAccumulateResults(false);
    queryDS.setResolvable(true);
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor(
        "jdbc:odbc:digital_campus", "dbw", "123456", false,
        "sun.jdbc.odbc.JdbcOdbcDriver"));

    this.getContentPane().setLayout(xYLayout3);

    xYLayout1.setWidth(502);
    xYLayout1.setHeight(300);

    xYLayout3.setWidth(498);
    xYLayout3.setHeight(300);
    this.setSize(new Dimension(800, 600));
    // jButton4.addActionListener(new ClassroomVindicatePanel_jButton4_actionAdapter(this));
    jButton4.setText("添加");
    jButton4.addActionListener(new FClassroom_jButton4_actionAdapter(this));
    jLabel2.setText("教室编号");
    jPanel1.setMinimumSize(new Dimension(800, 600));
    jPanel1.setLayout(xYLayout2);
    jButton5.setText("更新");
    jButton5.addActionListener(new FClassroom_jButton5_actionAdapter(this));
    // jButton5.addActionListener(new ClassroomVindicatePanel_jButton5_actionAdapter(this));
    jButton6.setText("重置");
    jButton6.addActionListener(new FClassroom_jButton6_actionAdapter(this));
    //jButton6.addActionListener(new ClassroomVindicatePanel_jButton6_actionAdapter(this));
    jdbTable1.setDataSet(queryDS);
    jPanel1.add(jLabel2, new XYConstraints(9, 22, -1, -1));
    jPanel1.add(jCBclass1, new XYConstraints(62, 21, 88, -1));
    jPanel1.add(jButton6, new XYConstraints(242, 19, 66, 31));
    jPanel1.add(jButton5, new XYConstraints(323, 20, 64, 30));
    jPanel1.add(jButton4, new XYConstraints(167, 23, 66, 28));
    this.getContentPane().add(tableScrollPane2,
                              new XYConstraints(5, 64, 500, 247));
    this.getContentPane().add(jPanel1, new XYConstraints(4, 6, 507, 58));
    tableScrollPane2.getViewport().add(jdbTable1, null);
    this.getContentPane().add(tableScrollPane1, new XYConstraints(0, 0, 400, -1));
    addIclass();
  }

  void addIclass() throws SQLException {
    sql = "SELECT classroom_id FROM dbo.classroom";
    con = DBConnection.getConnection();
    st = con.createStatement();
    rs = st.executeQuery(sql);
    while (rs.next()) {
      jCBclass1.addItem(rs.getString(1));
    }

  }

  void jButton5_actionPerformed(ActionEvent e)
  {
    jCBclass1.removeAllItems();
        try {
          addIclass();
        }
        catch (SQLException ex) {
        }
        queryDS.refresh();

  }

  void jButton4_actionPerformed(ActionEvent e)
  {
    add ad = new add();
       flag = true;
       ad.show();

  }

  void jButton6_actionPerformed(ActionEvent e)
  {
    add ad = new add();
       statu = jCBclass1.getSelectedIndex()+1;
       flag = false;
       ad.show();

  }
}

class FClassroom_jButton5_actionAdapter implements java.awt.event.ActionListener {
  FClassroom adaptee;

  FClassroom_jButton5_actionAdapter(FClassroom adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton5_actionPerformed(e);
  }
}

class FClassroom_jButton4_actionAdapter implements java.awt.event.ActionListener {
  FClassroom adaptee;

  FClassroom_jButton4_actionAdapter(FClassroom adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton4_actionPerformed(e);
  }
}

class FClassroom_jButton6_actionAdapter implements java.awt.event.ActionListener {
  FClassroom adaptee;

  FClassroom_jButton6_actionAdapter(FClassroom adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton6_actionPerformed(e);
  }
}