changetypedialog.java

java 读写EXCEL文件的源码

/********************************************************************
 *
 * $RCSfile: ChangeTypeDialog.java,v $  $Revision: 1.1 $  $Date: 2003/09/22 08:06:23 $
 *
 * $Log: ChangeTypeDialog.java,v $
 * Revision 1.1  2003/09/22 08:06:23  icestone
 * init
 *
 *
 *
 **********************************************************************/
package pcdmupgradedata;

import java.awt.*;
import javax.swing.*;
import java.sql.*;
import com.borland.jbcl.layout.*;
import java.awt.event.*;
import java.util.*;

/**
 * <p>Title: 选择对应设施修改界面</p>
 * <p>Description: </p>
 */

public class ChangeTypeDialog extends JDialog {
  private ChangeTypePanel panel1;
  private BorderLayout borderLayout1 = new BorderLayout();
  Connection conn;
  private JPanel jPanel1 = new JPanel();
  private JButton jButton1 = new JButton();
  private JButton jButton2 = new JButton();
  public ChangeTypeDialog(Frame frame, String title, boolean modal) {
    super(frame, title, modal);

  }

  public ChangeTypeDialog(Connection conn) {

    this(null, "选择对应设施类型", true);
    this.conn=conn;
    panel1 = new ChangeTypePanel(conn);
    try {

          jbInit();
          pack();
        }
        catch(Exception ex) {
          ex.printStackTrace();
    }
  }
  private void jbInit() throws Exception {
    panel1.setLayout(borderLayout1);
    this.getContentPane().setLayout(null);
    jButton1.setToolTipText("确定");
    jButton1.setText("确定");
    jButton1.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButton1_actionPerformed(e);
      }
    });
    jButton2.setToolTipText("返回");
    jButton2.setText("返回");
    jButton2.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButton2_actionPerformed(e);
      }
    });
    panel1.setBounds(new Rectangle(3, 1, 618, 316));
    jPanel1.setBorder(BorderFactory.createEtchedBorder());
    jPanel1.setBounds(new Rectangle(1, 319, 530, 40));
    jPanel1.add(jButton1, null);
    jPanel1.add(jButton2, null);
    this.getContentPane().add(panel1, null);
    this.getContentPane().add(jPanel1, null);
  }

  void jButton1_actionPerformed(ActionEvent e) {
    StringTokenizer RecordToken;
    String[] Record =new String[2];
    int  j=0;
    if(ChangeTypePanel.ListModel3.size()<=0) return;
    else
     {
/*拆分选择记录*/
      for(int i=0;i<ChangeTypePanel.ListModel3.size();i++)
       {
         RecordToken  = new StringTokenizer((String)ChangeTypePanel.ListModel3.elementAt(i),"->",false);
         while(RecordToken.hasMoreTokens())
          {
            Record[j]= ((String)RecordToken.nextToken());
            j++;
          }//end while
          updateCodeList(Record[0],Record[1].trim());
          ChangeTypePanel.ListModel1.removeElement(Record[0].trim());
          j=0;
        }
          JOptionPane.showMessageDialog(null,"记录已修改！");
          ChangeTypePanel.ListModel3.removeAllElements();
          ChangeTypePanel.jList3.repaint();
          ChangeTypePanel.jList1.repaint();
     }
  }

  void jButton2_actionPerformed(ActionEvent e) {
     this.dispose();
  }

 private  void updateCodeList(String sql1,String sql2){
//    this.setCursor(new java.awt.Cursor(java.awt.Cursor.WAIT_CURSOR));
    String Sql = "update "+(String)ChangeTypePanel.jComboBox1.getSelectedItem()+" set "+
                                             (String)ChangeTypePanel.jComboBox2.getSelectedItem()+"='"+
                                                     sql2+"' where  "+(String)ChangeTypePanel.jComboBox2.getSelectedItem()+"=rtrim('"+sql1+"')";
             try{
                     Statement  statement = conn.prepareStatement("");
                      try
                         {
                            statement.executeUpdate(Sql);
                          }
                          catch(java.sql.SQLException e){
                               return;
                         }
            finally{
                        statement.close();
                      }
                  }
              catch(java.sql.SQLException e){
                   }
//    this.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
//          ChangeTypePanel.jList3.removeAll();

 }
}