package untitled1;

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

public class Frame1 extends JFrame {
  JPanel contentPane;
  BorderLayout borderLayout1 = new BorderLayout();
  Database db = new Database();
  QueryDataSet queryDataSetDb = new QueryDataSet();
  QueryDataSet queryDataSetFile = new QueryDataSet();
  QueryDataSet queryDataSetTemp = new QueryDataSet();
  TextDataFile bakDataFile = new TextDataFile();
  JPanel jPanel1 = new JPanel();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  JdbStatusLabel StatusLabel = new JdbStatusLabel();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JdbTable jdbTable1 = new JdbTable();

  //Construct the frame
  public Frame1() {
    enableEvents(AWTEvent.WINDOW_EVENT_MASK);
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  //Component initialization
  private void jbInit() throws Exception  {
    contentPane = (JPanel) this.getContentPane();
    bakDataFile.setEncoding("Cp1252");
    db.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:oracle:thin:@localhost:1521:han", "scott", "tiger", false, "oracle.jdbc.driver.OracleDriver"));
    db.setUseTableName(false);
    db.setTransactionIsolation(java.sql.Connection.TRANSACTION_READ_UNCOMMITTED);
    db.setDatabaseName("");
    contentPane.setLayout(borderLayout1);
    this.setSize(new Dimension(400, 300));
    this.setTitle("Frame Title");
    jPanel1.setLayout(null);
    tableScrollPane1.setBounds(new Rectangle(38, 11, 333, 203));
    StatusLabel.setText("");
    StatusLabel.setBounds(new Rectangle(0, 242, 84, 33));
    jButton1.setBounds(new Rectangle(99, 241, 86, 25));
    jButton1.setText("Save");
    jButton1.addActionListener(new Frame1_jButton1_actionAdapter(this));
    jButton2.setBounds(new Rectangle(218, 241, 89, 25));
    jButton2.setText("Recover");
    jButton2.addActionListener(new Frame1_jButton2_actionAdapter(this));
    jdbTable1.setDataSet(queryDataSetDb);
    queryDataSetDb.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(db, "SELECT TEST.ID,TEST.NAME FROM SCOTT.TEST ORDER BY TEST.ID", null, true, Load.ALL));
    contentPane.add(jPanel1,  BorderLayout.CENTER);
    jPanel1.add(tableScrollPane1, null);
    tableScrollPane1.getViewport().add(jdbTable1, null);
    jPanel1.add(StatusLabel, null);
    jPanel1.add(jButton1, null);
    jPanel1.add(jButton2, null);
  }
  //Overridden so we can exit when window is closed
  protected void processWindowEvent(WindowEvent e) {
    super.processWindowEvent(e);
    if (e.getID() == WindowEvent.WINDOW_CLOSING) {
      System.exit(0);
    }
  }

  void jButton1_actionPerformed(ActionEvent e) {
       StatusLabel.setText("\u5F00\u59CB\u5907\u4EFD");
       JFileChooser j=new JFileChooser();
       try{
         if(JFileChooser.APPROVE_OPTION==j.showSaveDialog(this)){
           String FileName=j.getSelectedFile().getAbsolutePath();
           TextDataFile txtDataFile=new TextDataFile();
           txtDataFile.setFileName(FileName);
           txtDataFile.save(queryDataSetDb);
           StatusLabel.setText("\u5907\u4EFD\u6210\u529F");
         }
       }
       catch(Exception ex){
         StatusLabel.setText("\u5907\u4EFD\u5931\u8D25");
       }
  }

  void jButton2_actionPerformed(ActionEvent e) {
       JFileChooser j=new JFileChooser();
       try{
         if(JFileChooser.APPROVE_OPTION==j.showOpenDialog(this)){
           String FileName=j.getSelectedFile().getAbsolutePath();
           bakDataFile.setFileName(FileName);
           bakDataFile.load(queryDataSetFile);
           bakDataFile.setLoadAsInserted(true);
           jdbTable1.setDataSet(queryDataSetFile);
           /*String types[]=new String[1];
           types[0]="TABLE";
           Database dbTemp=new Database();
           dbTemp.setConnection(db.getConnection());
           DatabaseMetaData dbSchemaData=dbTemp.getMetaData();
           ResultSet rs=dbSchemaData.getTables(null,null,"%",types);
           String tableName="";
           if(rs!=null){
             if (rs.next()) {
               tableName = rs.getString("TABLE_NAME").trim();
             }
           }
           StatusLabel.setText(tableName);
            */
           db.executeStatement("delete from test");
           //db.commit();
           db.saveChanges(queryDataSetFile);
           db.commit();
           //queryDataSetDb.refresh();
           StatusLabel.setText("\u6062\u590D\u6210\u529F");
         }
       }
       catch(Exception ex){
         System.out.println(ex.toString());
         StatusLabel.setText("\u6062\u590D\u5931\u8D25");
       }
  }
}

class Frame1_jButton1_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jButton1_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class Frame1_jButton2_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jButton2_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}