package stumanage;

import javax.swing.*;
import javax.swing.plaf.*;
import com.borland.dbswing.*;
import java.awt.*;
import com.borland.jbcl.layout.*;
import com.borland.dx.sql.dataset.*;
import com.borland.dx.dataset.*;
import java.awt.event.*;

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

public class MainFrame
    extends JFrame {
  PaneLayout paneLayout1 = new PaneLayout();
  static JTabbedPane jTabbedPane1 = new JTabbedPane();
  static JPanel jPanel1 = new JPanel();
  static JPanel jPanel2 = new JPanel();
  static JPanel jPanel3 = new JPanel();
  static JPanel jPanel4 = new JPanel();
  static JPanel jPanel5 = new JPanel();
  BorderLayout borderLayout1 = new BorderLayout();
  JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar();
  BorderLayout borderLayout2 = new BorderLayout();
  Database database1 = new Database();
  JPanel jPanel6 = new JPanel();
  BorderLayout borderLayout3 = new BorderLayout();
  JPanel jPanel7 = new JPanel();
  JPanel jPanel8 = new JPanel();
  FlowLayout flowLayout1 = new FlowLayout();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JLabel jLabel7 = new JLabel();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  JdbTable jdbTable1 = new JdbTable();
  QueryDataSet queryDataSet2 = new QueryDataSet();
  Column column8 = new Column();
  Column column9 = new Column();
  Column column10 = new Column();
  Column column11 = new Column();
  Column column12 = new Column();
  Column column13 = new Column();
  Column column14 = new Column();
  Font font1;
  BorderLayout borderLayout4 = new BorderLayout();
  JPanel jPanel9 = new JPanel();
  JLabel jLabel8 = new JLabel();
  JLabel jLabel9 = new JLabel();
  JLabel jLabel10 = new JLabel();
  JLabel jLabel11 = new JLabel();
  JdbNavToolBar jdbNavToolBar2 = new JdbNavToolBar();
  JPanel jPanel10 = new JPanel();
  JPanel jPanel11 = new JPanel();
  JPanel jPanel12 = new JPanel();
  BorderLayout borderLayout5 = new BorderLayout();
  JLabel jLabel12 = new JLabel();
  TableScrollPane tableScrollPane2 = new TableScrollPane();
  JdbTable jdbTable2 = new JdbTable();
  JLabel jLabel13 = new JLabel();
  TableScrollPane tableScrollPane3 = new TableScrollPane();
  BorderLayout borderLayout6 = new BorderLayout();
  JButton jButton3 = new JButton();
  JButton jButton4 = new JButton();
  XYLayout xYLayout1 = new XYLayout();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  Column column1 = new Column();
  Column column2 = new Column();
  Column column3 = new Column();
  Column column4 = new Column();
  Column column5 = new Column();
  Column column6 = new Column();
  Column column7 = new Column();
  JdbTable jdbTable3 = new JdbTable();
  JLabel jLabel14 = new JLabel();
  JLabel jLabel15 = new JLabel();
  JPanel jPanel13 = new JPanel();
  JLabel jLabel16 = new JLabel();
  JLabel jLabel17 = new JLabel();
  BorderLayout borderLayout7 = new BorderLayout();
  JPanel jPanel14 = new JPanel();
  JPanel jPanel15 = new JPanel();
  TableScrollPane tableScrollPane4 = new TableScrollPane();
  BorderLayout borderLayout8 = new BorderLayout();
  BorderLayout borderLayout9 = new BorderLayout();
  JPanel jPanel16 = new JPanel();
  JPanel jPanel17 = new JPanel();
  JPanel jPanel18 = new JPanel();
  JdbTable jdbTable4 = new JdbTable();
  GridBagLayout gridBagLayout1 = new GridBagLayout();
  JLabel jLabel18 = new JLabel();
  JLabel jLabel19 = new JLabel();
  JdbTextField jdbTextField1 = new JdbTextField();
  JdbTextField jdbTextField2 = new JdbTextField();
  JdbTextArea jdbTextArea1 = new JdbTextArea();
  BorderLayout borderLayout10 = new BorderLayout();
  JButton jButton5 = new JButton();
  JButton jButton6 = new JButton();
  BorderLayout borderLayout11 = new BorderLayout();
  JLabel jLabel20 = new JLabel();
  JdbTextField jdbTextField3 = new JdbTextField();
  JdbTextField jdbTextField4 = new JdbTextField();
  JdbTextField jdbTextField5 = new JdbTextField();
  JdbTextField jdbTextField7 = new JdbTextField();
  JdbTextField jdbTextField8 = new JdbTextField();
  JPanel jPanel19 = new JPanel();
  GridBagLayout gridBagLayout2 = new GridBagLayout();
  ButtonGroup buttonGroup1 = new ButtonGroup();
  JdbRadioButton jdbRadioButton2 = new JdbRadioButton();
  JdbRadioButton jdbRadioButton1 = new JdbRadioButton();
  JdbNavField jdbNavField1 = new JdbNavField();
  JdbTextField jdbTextField9 = new JdbTextField();
  JdbTextField jdbTextField10 = new JdbTextField();
  QueryDataSet queryDataSet4 = new QueryDataSet();
  QueryDataSet qSet_course = new QueryDataSet();
  Column column15 = new Column();
  Column column16 = new Column();
  Column column18 = new Column();
  Column column19 = new Column();
  JdbTextField jdbTextField11 = new JdbTextField();
  JdbNavField jdbNavField2 = new JdbNavField();
  JdbNavField jdbNavField3 = new JdbNavField();
  JdbTextField jdbTextField12 = new JdbTextField();
  JdbTextField jdbTextField13 = new JdbTextField();
  JdbTextField jdbTextField14 = new JdbTextField();
  QueryDataSet qSet_jiangli = new QueryDataSet();
  Column column20 = new Column();
  Column column21 = new Column();
  Column column22 = new Column();
  Column column23 = new Column();
  Column column24 = new Column();
  Column column25 = new Column();
  JdbNavToolBar jdbNavToolBar3 = new JdbNavToolBar();

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

  public static void main(String[] args) {
    try {
      UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());
    }
    catch (Exception e) {
    }
    //System.out.println(new javax.swing.UIManager());
    Font f = new java.awt.Font("SansSerif", 0, 12);
UIManager.put("Label.font",f);
UIManager.put("Label.foreground",Color.black);
UIManager.put("Button.font",f);
UIManager.put("Menu.font",f);
UIManager.put("MenuItem.font",f);
UIManager.put("List.font",f);
UIManager.put("CheckBox.font",f);
UIManager.put("RadioButton.font",f);
UIManager.put("ComboBox.font",f);
    UIManager.put("TextArea.font",f);
    UIManager.put("dbTextArea.font",f);
    UIManager.put("font",f);

    MainFrame mainFrame = new MainFrame();
    mainFrame.setFont(new java.awt.Font("SansSerif", 0, 12));
    mainFrame.pack();
    mainFrame.setSize(600,450);
    mainFrame.show();
  }

  private void jbInit() throws Exception {
    font1 = new java.awt.Font("SansSerif", 0, 12);
    this.getContentPane().setLayout(paneLayout1);
    jPanel1.setLayout(borderLayout1);
    jdbNavToolBar1.setDebugGraphicsOptions(0);
    jdbNavToolBar1.setAlignment(FlowLayout.CENTER);
    jPanel5.setLayout(borderLayout2);
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:microsoft:sqlserver://localhost:1433;databaseName=student", "sa", "sa", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
    database1.setDatabaseName("");
    jPanel6.setFont(new java.awt.Font("SansSerif", 0, 12));
    jPanel6.setMinimumSize(new Dimension(50, 100));
    jPanel6.setPreferredSize(new Dimension(50, 110));
    jPanel6.setLayout(borderLayout3);
    jPanel7.setFont(new java.awt.Font("SansSerif", 0, 12));
    jPanel7.setMinimumSize(new Dimension(100, 30));
    jPanel7.setPreferredSize(new Dimension(100, 40));
    jPanel7.setLayout(flowLayout1);
    jPanel8.setFont(new java.awt.Font("SansSerif", 0, 12));
    jPanel8.setMinimumSize(new Dimension(10, 10));
    jPanel8.setLayout(gridBagLayout2);
    jLabel1.setText("學號：");
    flowLayout1.setAlignment(FlowLayout.LEFT);
    jLabel2.setHorizontalAlignment(SwingConstants.RIGHT);
    jLabel2.setText("姓名：");
    jLabel3.setHorizontalAlignment(SwingConstants.RIGHT);
    jLabel3.setText("性別：");
    jLabel4.setHorizontalAlignment(SwingConstants.RIGHT);
    jLabel4.setText("班級：");
    jLabel5.setHorizontalAlignment(SwingConstants.RIGHT);
    jLabel5.setText("生日：");
    jLabel6.setHorizontalAlignment(SwingConstants.RIGHT);
    jLabel6.setText("電話：");
    jLabel7.setHorizontalAlignment(SwingConstants.RIGHT);
    jLabel7.setText("地址：");
    jButton1.setText("修改");
    jButton1.addActionListener(new MainFrame_jButton1_actionAdapter(this));
    jButton2.setText("取消");
   jdbTable1.setFont(new java.awt.Font("SansSerif", 0, 12));
    jdbTable1.setDataSet(queryDataSet2);
    jTabbedPane1.setFont(new java.awt.Font("SansSerif", 0, 12));
    jTabbedPane1.setMinimumSize(new Dimension(500, 194));
    jTabbedPane1.setPreferredSize(new Dimension(500, 607));
    queryDataSet2.setProvider(null);
    queryDataSet2.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT student_info.student_id,student_info.student_name,student_info.student_class,student_info.stud" +
      "ent_sex,student_info.student_birthday,student_info.student_tel,student_info.student_address " +
      "FROM student.dbo.student_info", null, true, Load.ALL));
    column8.setCaption("生日");
    column8.setColumnName("student_birthday");
    column8.setDataType(com.borland.dx.dataset.Variant.TIMESTAMP);
    column8.setDisplayMask("yyyy-MM-dd");
    column8.setEditMask("yyyy-MM-dd");
    column8.setSchemaName("dbo");
    column8.setTableName("student_info");
    column8.setWidth(10);
    column8.setServerColumnName("student_birthday");
    column8.setSqlType(93);
    column9.setCaption("學號");
    column9.setColumnName("student_id");
    column9.setDataType(com.borland.dx.dataset.Variant.INT);
    column9.setEditMask("######");
    column9.setFont(new java.awt.Font("SansSerif", 0, 12));
    column9.setRowId(true);
    column9.setSchemaName("dbo");
    column9.setTableName("student_info");
    column9.setWidth(10);
    column9.setServerColumnName("student_id");
    column9.setSqlType(4);
    column10.setCaption("姓名");
    column10.setColumnName("student_name");
    column10.setDataType(com.borland.dx.dataset.Variant.STRING);
    column10.setPrecision(50);
    column10.setSchemaName("dbo");
    column10.setTableName("student_info");
    column10.setWidth(10);
    column10.setServerColumnName("student_name");
    column10.setSqlType(12);
    column11.setCaption("班級");
    column11.setColumnName("student_class");
    column11.setDataType(com.borland.dx.dataset.Variant.INT);
    column11.setSchemaName("dbo");
    column11.setTableName("student_info");
    column11.setWidth(10);
    column11.setServerColumnName("student_class");
    column11.setSqlType(4);
    column12.setCaption("性別");
    column12.setColumnName("student_sex");
    column12.setDataType(com.borland.dx.dataset.Variant.STRING);
    column12.setPrecision(50);
    column12.setSchemaName("dbo");
    column12.setTableName("student_info");
    column12.setWidth(10);
    column12.setServerColumnName("student_sex");
    column12.setSqlType(12);
    column13.setCaption("聯(lián)系電話");
    column13.setColumnName("student_tel");
    column13.setDataType(com.borland.dx.dataset.Variant.STRING);
    column13.setPrecision(50);
    column13.setSchemaName("dbo");