package coursedesign;

import java.awt.*;
import javax.swing.*;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.QueryDataSet;
import com.borland.dx.sql.dataset.QueryResolver;
import com.borland.dx.sql.dataset.ConnectionDescriptor;
import com.borland.dx.sql.dataset.QueryDescriptor;
import com.borland.dx.sql.dataset.Load;
import com.borland.dbswing.JdbTable;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class banjixinxi
    extends JFrame {
  XYLayout xYLayout1 = new XYLayout();
  JComboBox jComboBox1 = new JComboBox();
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  QueryResolver queryResolver1 = new QueryResolver();
  JdbTable jdbTable1 = new JdbTable();

  public banjixinxi() {
    try {
      jbInit();
    }
    catch (Exception exception) {
      exception.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    getContentPane().setLayout(xYLayout1);
    setTitle("學生基本信息查詢");
    setSize(new Dimension(500, 400));
    jComboBox1.setToolTipText("");
    jComboBox1.addItem("請選擇查詢條件");
     jComboBox1.addItem("學生信息");
     jComboBox1.addItem("班級信息");
     jComboBox1.addItem("選課信息");

    jComboBox1.setSelectedItem(this);
    database1.setConnection(new ConnectionDescriptor(
        "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=student", "sa",
        "yaya", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver", null));
    queryDataSet1.setQuery(new QueryDescriptor(database1,
                                               "SELECT * FROM base_info", null, true,
                                               Load.ALL));
    jComboBox1.addActionListener(new banjixinxi_jComboBox1_actionAdapter(this));
    this.getContentPane().add(jComboBox1, new XYConstraints(2, 1, 111, -1));
    this.getContentPane().add(jdbTable1, new XYConstraints(1, 40, 497, 332));

    jdbTable1.setDataSet(queryDataSet1);
  }

  public static void main(String[] args) {
    banjixinxi banjixinxi = new banjixinxi();

  }

  public void jComboBox1_actionPerformed(ActionEvent e) {
    int state = jComboBox1.getSelectedIndex();
    if(state==1)
    {
      try{
         String sql="select * from base_info";
         queryDataSet1.close();
            //將SQL語句傳給queryDataSet1執行。
            queryDataSet1.setQuery(new QueryDescriptor(database1, sql, null, true,Load.ALL));
            //將queryDataSet1打開
            queryDataSet1.open();
            //刷新queryDataSet1
            queryDataSet1.refresh();
       }//end try
       catch(Exception ex)
       {
         JOptionPane.showMessageDialog(null, "Sorry!暫時沒有學生信息記錄");
       }//end catch
    }//end if
    else{
     if(state==2){
         try {
      String sql1 = "select * from class_info";
      queryDataSet1.close();
      //將SQL語句傳給queryDataSet1執行。
      queryDataSet1.setQuery(new QueryDescriptor(database1, sql1, null, true, Load.ALL));
      queryDataSet1.open(); //將queryDataSet1打開
      queryDataSet1.refresh();//刷新queryDataSet1
    } //end try
    catch (Exception ex) {
      JOptionPane.showMessageDialog(null, "Sorry!暫時沒有班級信息記錄");
    } //end catch
   }//end if of else
       else
       {
         try{
         String sql2="select * from xuankebiao";
         queryDataSet1.close();
            //將SQL語句傳給queryDataSet1執行。
            queryDataSet1.setQuery(new QueryDescriptor(database1, sql2, null, true,Load.ALL));
            queryDataSet1.open(); //將queryDataSet1打開
            queryDataSet1.refresh();//刷新queryDataSet1
       }//end try
       catch(Exception ex)
       {
         JOptionPane.showMessageDialog(null, "Sorry!暫時沒有課程信息記錄");
       }//end catch
       }//end else of else
    }//end else
  }
}
class banjixinxi_jComboBox1_actionAdapter
    implements ActionListener {
  private banjixinxi adaptee;
  banjixinxi_jComboBox1_actionAdapter(banjixinxi adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jComboBox1_actionPerformed(e);
  }
}