selectpanel.java

java 读写EXCEL文件的源码

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

import java.awt.*;
import javax.swing.*;
import com.borland.jbcl.layout.*;
import javax.swing.border.*;
import java.awt.event.*;
import java.awt.event.*;
import java.sql.*;
import java.net.*;
import java.util.*;
import javax.swing.event.*;
/**
 * <p>Title:自定义列表转换流程操作 </p>
 * <p>Description: </p>
 */

public class SelectPanel extends JPanel {
  public static JCheckBox jCheckBox[];
  private JPanel jPanel3 = new JPanel();
  private JScrollPane jScrollPane2 = new JScrollPane();
  private JPanel jPanel2 = new JPanel();
  private JScrollPane jScrollPane1 = new JScrollPane();
  private JPanel jPanel1 = new JPanel();
  private  int  X1=2;
  private  int  Y1=20;
  public  static int  pos=0;
  static Vector  uTablename=new Vector();;
  Connection conn;
  private JTabbedPane jTabbedPane1 = new JTabbedPane();
  private PaneLayout paneLayout3 = new PaneLayout();
  private PaneLayout paneLayout4 = new PaneLayout();
  private JPanel jPanel4 = new JPanel();
  private JPanel jPanel5 = new JPanel();
  private XYLayout xYLayout1 = new XYLayout();
  private XYLayout xYLayout2 = new XYLayout();
  private PaneLayout paneLayout1 = new PaneLayout();
  private JTextPane jTextPane1 = new JTextPane();
  private TitledBorder titledBorder1;
  private BorderLayout borderLayout1 = new BorderLayout();
  public SelectPanel(Connection conn) {
    this.conn=conn;
    try {
      jbInit();
      getCheckbox();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }
  void jbInit() throws Exception {
    titledBorder1 = new TitledBorder("备注");
    this.setBorder(BorderFactory.createEtchedBorder());
    this.setLayout(borderLayout1);

    jPanel3.setBorder(BorderFactory.createEtchedBorder());
    jPanel3.setLayout(paneLayout1);
    jScrollPane2.setBorder(BorderFactory.createEtchedBorder());
    jScrollPane1.setBorder(BorderFactory.createEtchedBorder());
    jPanel1.setLayout(paneLayout3);
    jPanel2.setLayout(paneLayout4);

    jPanel4.setLayout(xYLayout1);
    jPanel5.setLayout(xYLayout2);
    jTextPane1.setForeground(SystemColor.activeCaption);
    jTextPane1.setBorder(titledBorder1);
    jTextPane1.setSelectionEnd(0);
    jTextPane1.setText("直接选择需\n转换或重新\n转换更改的\n数据表,选\n择时请确认\n其上层的数\n据表已转换,\n否则将无法\n完成数据表\n的转换。");
    jTabbedPane1.add(jPanel1, "基本设施表");
    jPanel1.add(jScrollPane1, new PaneConstraints("jScrollPane1", "jScrollPane1", PaneConstraints.ROOT, 1.0f));
    jTabbedPane1.add(jPanel2, "关联设施表");
    jPanel2.add(jScrollPane2, new PaneConstraints("jScrollPane2", "jScrollPane2", PaneConstraints.ROOT, 1.0f));
    this.add(jTextPane1, BorderLayout.EAST);
    jScrollPane2.getViewport().add(jPanel5, null);
    jScrollPane1.getViewport().add(jPanel4, null);
    this.add(jPanel3, BorderLayout.CENTER);
    jPanel3.add(jTabbedPane1,  new PaneConstraints("jTabbedPane1", "jTabbedPane1", PaneConstraints.ROOT, 1.0f));

  }
/*查询中间表构建checkbox*/
 private void getCheckbox(){
 	String  sql=null;
        Vector  sizeS=new Vector() ;
        /*JCheckBox[]下标定义写死便于调用-createMidTable*/
        jCheckBox=new JCheckBox[88];

     for(int j=0;j<2;j++)
       {
        try{
             /*basic dev table*/
               sql="select  CTABLENAME  from zjdy_t where class="+j+" order by ser";
               Statement QueryTableStatement = conn.createStatement();
               ResultSet TableNameResult=QueryTableStatement.executeQuery(sql);
	       while(TableNameResult.next())
                {
                   sizeS.addElement(TableNameResult.getString(1));
	         }//end while
              QueryTableStatement.close();
              TableNameResult.close();
 	     }
        catch(java.sql.SQLException e){}
            for(int i=0;i<sizeS.size();i++)
                {
                     jCheckBox[pos]=new JCheckBox();
                     jCheckBox[pos].setText((String)sizeS.elementAt(i));
                     if(j==0)
                       jPanel4.add(jCheckBox[pos],new XYConstraints(X1, Y1, -1, -1));
                     else
                       jPanel5.add(jCheckBox[pos],new XYConstraints(X1, Y1, -1, -1));

                 jCheckBox[pos].addActionListener(new java.awt.event.ActionListener() {

                 public void actionPerformed(ActionEvent e) {
                    jCheckBox1_actionPerformed(e);
                     }
                   });

                 jCheckBox[pos].setSelected(false);
                   X1+=170;
                   if((i+1)%5==0)
                     {
                       Y1+=25;
                       X1=2;
                     }//end if
               pos++;
             }//end for
           sizeS.removeAllElements();
           X1=2;
           Y1=20;
         }//end for
         sizeS=null;

    }
  void jCheckBox1_actionPerformed(ActionEvent e) {
         /*外键同步，下标值=ser-1*/
         if(e.getActionCommand().equals("局站"))
           {

           	if(jCheckBox[13].isSelected()!=jCheckBox[8].isSelected())
           	 {
           	  jCheckBox[13].setSelected(jCheckBox[8].isSelected());
           	  compareVector(jCheckBox[13].getText());
           	 }
           	if(jCheckBox[14].isSelected()!=jCheckBox[8].isSelected())
           	 {
           	  jCheckBox[14].setSelected(jCheckBox[8].isSelected());
           	  compareVector(jCheckBox[14].getText());
           	 }
           	if(jCheckBox[15].isSelected()!=jCheckBox[8].isSelected())
           	 {
           	  jCheckBox[15].setSelected(jCheckBox[8].isSelected());
           	  compareVector(jCheckBox[15].getText());
           	 }
           	if(jCheckBox[31].isSelected()!=jCheckBox[8].isSelected())
           	 {
           	  jCheckBox[31].setSelected(jCheckBox[8].isSelected());
           	  compareVector(jCheckBox[31].getText());
           	 }
           	if(jCheckBox[16].isSelected()!=jCheckBox[8].isSelected())
           	 {
           	  jCheckBox[16].setSelected(jCheckBox[8].isSelected());
           	  compareVector(jCheckBox[16].getText());
           	 }
           	if(jCheckBox[32].isSelected()!=jCheckBox[8].isSelected())
           	 {
           	  jCheckBox[32].setSelected(jCheckBox[8].isSelected());
           	  compareVector(jCheckBox[32].getText());
           	 }
           	if(jCheckBox[17].isSelected()!=jCheckBox[8].isSelected())
           	 {
           	  jCheckBox[17].setSelected(jCheckBox[8].isSelected());
           	  compareVector(jCheckBox[17].getText());
           	 }
           	if(jCheckBox[22].isSelected()!=jCheckBox[8].isSelected())
           	 {
           	  jCheckBox[22].setSelected(jCheckBox[8].isSelected());
           	  compareVector(jCheckBox[22].getText());
           	 }
           	if(jCheckBox[24].isSelected()!=jCheckBox[8].isSelected())
           	 {
           	  jCheckBox[24].setSelected(jCheckBox[8].isSelected());
           	  compareVector(jCheckBox[24].getText());
           	 }
           	if(jCheckBox[34].isSelected()!=jCheckBox[8].isSelected())
           	 {
           	  jCheckBox[34].setSelected(jCheckBox[8].isSelected());
           	  compareVector(jCheckBox[34].getText());
           	 }
           	if(jCheckBox[26].isSelected()!=jCheckBox[8].isSelected())
           	 {
           	  jCheckBox[26].setSelected(jCheckBox[8].isSelected());
           	  compareVector(jCheckBox[26].getText());
           	 }
           	if(jCheckBox[27].isSelected()!=jCheckBox[8].isSelected())
           	 {
           	  jCheckBox[27].setSelected(jCheckBox[8].isSelected());
           	  compareVector(jCheckBox[27].getText());
           	 }
           	if(jCheckBox[36].isSelected()!=jCheckBox[8].isSelected())
           	 {
           	  jCheckBox[36].setSelected(jCheckBox[8].isSelected());
           	  compareVector(jCheckBox[36].getText());
           	 }
           	if(jCheckBox[21].isSelected()!=jCheckBox[8].isSelected())
           	 {
           	  jCheckBox[21].setSelected(jCheckBox[8].isSelected());
           	  compareVector(jCheckBox[21].getText());
           	 }
           	if(jCheckBox[18].isSelected()!=jCheckBox[8].isSelected())
           	 {
           	  jCheckBox[18].setSelected(jCheckBox[8].isSelected());
           	  compareVector(jCheckBox[18].getText());
           	 }
           	if(jCheckBox[23].isSelected()!=jCheckBox[8].isSelected())
           	 {
           	  jCheckBox[23].setSelected(jCheckBox[8].isSelected());
           	  compareVector(jCheckBox[23].getText());
           	 }
           	if(jCheckBox[19].isSelected()!=jCheckBox[8].isSelected())
           	 {
           	  jCheckBox[19].setSelected(jCheckBox[8].isSelected());
           	  compareVector(jCheckBox[19].getText());
           	 }
           	if(jCheckBox[38].isSelected()!=jCheckBox[8].isSelected())
           	 {
           	  jCheckBox[38].setSelected(jCheckBox[8].isSelected());
           	  compareVector(jCheckBox[38].getText());
           	 }

            }//END JZ
           if(e.getActionCommand().equals("机房"))
           {
           	if(jCheckBox[46].isSelected()!=jCheckBox[13].isSelected())
           	 {
           	  jCheckBox[46].setSelected(jCheckBox[13].isSelected());
           	  compareVector(jCheckBox[46].getText());
           	 }
           	if(jCheckBox[30].isSelected()!=jCheckBox[13].isSelected())
           	 {
           	  jCheckBox[30].setSelected(jCheckBox[13].isSelected());
           	  compareVector(jCheckBox[30].getText());
           	 }
           	if(jCheckBox[25].isSelected()!=jCheckBox[13].isSelected())
           	 {
           	  jCheckBox[25].setSelected(jCheckBox[13].isSelected());
           	  compareVector(jCheckBox[25].getText());
           	 }
           	if(jCheckBox[29].isSelected()!=jCheckBox[13].isSelected())
           	 {
           	  jCheckBox[29].setSelected(jCheckBox[13].isSelected());
           	  compareVector(jCheckBox[29].getText());
           	 }

           }//END JF
           if(e.getActionCommand().equals("电缆"))
           {
           	if(jCheckBox[42].isSelected()!=jCheckBox[34].isSelected())
           	 {
           	  jCheckBox[42].setSelected(jCheckBox[34].isSelected());
           	  compareVector(jCheckBox[42].getText());
           	 }
           	if(jCheckBox[35].isSelected()!=jCheckBox[34].isSelected())
           	 {
           	  jCheckBox[35].setSelected(jCheckBox[34].isSelected());
           	  compareVector(jCheckBox[35].getText());
           	 }
           	if(jCheckBox[40].isSelected()!=jCheckBox[34].isSelected())
           	 {
           	  jCheckBox[40].setSelected(jCheckBox[34].isSelected());
           	  compareVector(jCheckBox[40].getText());
           	 }
           	if(jCheckBox[44].isSelected()!=jCheckBox[34].isSelected())
           	 {
           	  jCheckBox[44].setSelected(jCheckBox[34].isSelected());
           	  compareVector(jCheckBox[44].getText());
           	 }
           	if(jCheckBox[45].isSelected()!=jCheckBox[34].isSelected())
           	 {
           	  jCheckBox[45].setSelected(jCheckBox[34].isSelected());
           	  compareVector(jCheckBox[45].getText());
           	 }
           	if(jCheckBox[61].isSelected()!=jCheckBox[34].isSelected())
           	 {
           	  jCheckBox[61].setSelected(jCheckBox[34].isSelected());
           	  compareVector(jCheckBox[61].getText());
           	 }

           }//END DL
          if(e.getActionCommand().equals("电缆段"))
           {
           	if(jCheckBox[62].isSelected()!=jCheckBox[42].isSelected())
           	 {
           	  jCheckBox[62].setSelected(jCheckBox[42].isSelected());
           	  compareVector(jCheckBox[62].getText());
           	 }
          }//END DLD       

          if(e.getActionCommand().equals("光缆"))
           {

           	if(jCheckBox[43].isSelected()!=jCheckBox[36].isSelected())
           	 {
           	  jCheckBox[43].setSelected(jCheckBox[36].isSelected());
           	  compareVector(jCheckBox[43].getText());
           	 }