frameinput.java~54~

java 对clob字段的读写

package projectclob;

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

public class FrameInput extends JFrame {
  JPanel contentPane;
  BorderLayout borderLayout1 = new BorderLayout();
  JPanel jPanelCenter = new JPanel();
  JPanel jPanelSouth = new JPanel();
  JPanel jPanelNorth = new JPanel();
  JLabel jLabel1 = new JLabel();
  JSplitPane jSplitPane1 = new JSplitPane();
  JPanel jPanelLeft = new JPanel();
  JPanel jPanelRight = new JPanel();
  BorderLayout borderLayout2 = new BorderLayout();
  JPanel jPanel1 = new JPanel();
  GridLayout gridLayout1 = new GridLayout();
  JCheckBox jCheckBox1 = new JCheckBox();
  JCheckBox jCheckBox2 = new JCheckBox();
  JCheckBox jCheckBox3 = new JCheckBox();
  JTextField jTextFieldWellId = new JTextField();
  JTextField jTextFieldWellName = new JTextField();
  JComboBox jComboBoxVerify = new JComboBox();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  JdbTable jdbTable1 = new JdbTable();
  BorderLayout borderLayout3 = new BorderLayout();
  JScrollPane jScrollPane1 = new JScrollPane();
  JTextArea jTextAreaRemark = new JTextArea();
  BorderLayout borderLayout5 = new BorderLayout();
  JPanel jPanel3 = new JPanel();
  BorderLayout borderLayout6 = new BorderLayout();
  JPanel jPanel4 = new JPanel();
  JButton jButtonSave = new JButton();
  JButton jButtonDelete = new JButton();
  JButton jButtonNew = new JButton();
  JButton jButtonCancel = new JButton();
  Database databaselhdb = new Database();
  Column columnwellif = new Column();
  QueryDataSet queryDataSettestinput = new QueryDataSet();
  Column columnRowID = new Column();
  Column columnwell_id = new Column();
  Column columnwell_name = new Column();
  Column columncreate_date = new Column();
  Column columnverify_rd = new Column();
  Column columnwell_if = new Column();
  JPanel jPanel2 = new JPanel();
  JButton jButtonselect = new JButton();
  Border border1;
  TitledBorder titledBorder1;
  Border border2;

  //Construct the frame
  public FrameInput() {
    enableEvents(AWTEvent.WINDOW_EVENT_MASK);
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }

  //Component initialization
  private void jbInit() throws Exception  {
    contentPane = (JPanel) this.getContentPane();
    border1 = new EtchedBorder(EtchedBorder.RAISED,Color.white,Color.pink);
    titledBorder1 = new TitledBorder(border1,"备注信息");
    border2 = BorderFactory.createCompoundBorder(new TitledBorder(new EtchedBorder(EtchedBorder.RAISED,Color.white,Color.pink),"备注信息"),BorderFactory.createEmptyBorder(3,3,3,3));
    contentPane.setLayout(borderLayout1);
    this.setSize(new Dimension(615, 420));
    this.setTitle("Frame Title");
    jLabel1.setBackground(Color.lightGray);
    jLabel1.setFont(new java.awt.Font("Dialog", 1, 20));
    jLabel1.setText("录井数据采集");
    jPanelNorth.setBackground(Color.pink);
    jSplitPane1.setOrientation(JSplitPane.HORIZONTAL_SPLIT);
    jSplitPane1.setPreferredSize(new Dimension(300, 180));
    jPanelLeft.setLayout(borderLayout2);
    jPanelLeft.setMaximumSize(new Dimension(32767, 32767));
    jPanelLeft.setPreferredSize(new Dimension(100, 180));
    jPanel1.setLayout(gridLayout1);
    jCheckBox1.setText("井名");
    jCheckBox2.setText("井号");
    jCheckBox3.setText("检验情况");
    gridLayout1.setColumns(2);
    gridLayout1.setRows(3);
    jPanelCenter.setLayout(borderLayout3);
    borderLayout2.setHgap(20);
    borderLayout2.setVgap(20);
    jPanel1.setPreferredSize(new Dimension(87, 75));
    jTextFieldWellId.setOpaque(true);
    jTextFieldWellId.setText("");
    jTextFieldWellName.setText("");
    tableScrollPane1.setPreferredSize(new Dimension(472, 180));
    jPanelRight.setPreferredSize(new Dimension(482, 180));
    jScrollPane1.setBorder(border2);
    jScrollPane1.setPreferredSize(new Dimension(400, 100));
    jPanelSouth.setLayout(borderLayout5);
    jPanel3.setLayout(borderLayout6);
    jButtonSave.setText("保存");
    jButtonDelete.setText("删除");
    jButtonNew.setText("新建");
    jButtonCancel.setText("取消");
    databaselhdb.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:oracle:thin:@188.188.97.124:1521:lhdb", "model", "model", false, "oracle.jdbc.driver.OracleDriver"));

    queryDataSettestinput.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(databaselhdb, "SELECT TEST_INPUT.WELL_ID,TEST_INPUT.WELL_NAME,TEST_INPUT.CREATE_DATE,TEST_INPUT.VERIFY_RD,TEST_INPUT" +
      ".WELL_IF FROM MODEL.TEST_INPUT", null, true, Load.ALL));
    jdbTable1.setDataSet(queryDataSettestinput);
    columnRowID.setCaption("ROWID");
    columnRowID.setColumnName("ROWID");
    columnRowID.setDataType(com.borland.dx.dataset.Variant.STRING);
    columnRowID.setDefault("");
    columnRowID.setRowId(true);
    columnRowID.setSchemaName("MODEL");
    columnRowID.setTableName("TEST_INPUT");
    columnRowID.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    columnRowID.setServerColumnName("ROWID");
    columnRowID.setSqlType(-8);
    columnRowID.setHidden(true);
    columnwell_id.setCaption("井号");
    columnwell_id.setColumnName("WELL_ID");
    columnwell_id.setDataType(com.borland.dx.dataset.Variant.BIGDECIMAL);
    columnwell_id.setPrecision(6);
    columnwell_id.setScale(0);
    columnwell_id.setSchemaName("MODEL");
    columnwell_id.setTableName("TEST_INPUT");
    columnwell_id.setServerColumnName("WELL_ID");
    columnwell_id.setSqlType(2);
    columnwell_name.setCaption("井名");
    columnwell_name.setColumnName("WELL_NAME");
    columnwell_name.setDataType(com.borland.dx.dataset.Variant.STRING);
    columnwell_name.setPrecision(20);
    columnwell_name.setSchemaName("MODEL");
    columnwell_name.setTableName("TEST_INPUT");
    columnwell_name.setWidth(30);
    columnwell_name.setServerColumnName("WELL_NAME");
    columnwell_name.setSqlType(12);
    columncreate_date.setCaption("开井日期");
    columncreate_date.setColumnName("CREATE_DATE");
    columncreate_date.setDataType(com.borland.dx.dataset.Variant.DATE);
    columncreate_date.setSchemaName("MODEL");
    columncreate_date.setTableName("TEST_INPUT");
    columncreate_date.setWidth(30);
    columncreate_date.setServerColumnName("CREATE_DATE");
    columncreate_date.setSqlType(91);
    columnverify_rd.setCaption("校验结果");
    columnverify_rd.setColumnName("VERIFY_RD");
    columnverify_rd.setDataType(com.borland.dx.dataset.Variant.STRING);
    columnverify_rd.setPrecision(8);
    columnverify_rd.setSchemaName("MODEL");
    columnverify_rd.setTableName("TEST_INPUT");
    columnverify_rd.setWidth(15);
    columnverify_rd.setServerColumnName("VERIFY_RD");
    columnverify_rd.setSqlType(12);
    columnwell_if.setCaption("是否为新井");
    columnwell_if.setColumnName("WELL_IF");
    columnwell_if.setDataType(com.borland.dx.dataset.Variant.BIGDECIMAL);
    columnwell_if.setPrecision(1);
    columnwell_if.setScale(0);
    columnwell_if.setSchemaName("MODEL");
    columnwell_if.setTableName("TEST_INPUT");
    columnwell_if.setWidth(10);
    columnwell_if.setServerColumnName("WELL_IF");
    columnwell_if.setSqlType(2);
    queryDataSettestinput.setColumns(new Column[] {columnRowID, columnwell_id, columnwell_name, columncreate_date, columnverify_rd, columnwell_if});
    jButtonselect.setText("查找");
    contentPane.add(jPanelCenter, BorderLayout.CENTER);
    contentPane.add(jPanelSouth,  BorderLayout.SOUTH);
    jPanelSouth.add(jPanel3,  BorderLayout.CENTER);
    jPanel3.add(jScrollPane1, BorderLayout.CENTER);
    jPanelSouth.add(jPanel4,  BorderLayout.SOUTH);
    jPanel4.add(jButtonCancel, null);
    jPanel4.add(jButtonNew, null);
    jPanel4.add(jButtonDelete, null);
    jPanel4.add(jButtonSave, null);

    jScrollPane1.getViewport().add(jTextAreaRemark, null);
    contentPane.add(jPanelNorth, BorderLayout.NORTH);
    jPanelNorth.add(jLabel1, null);
    jPanelCenter.add(jSplitPane1, BorderLayout.CENTER);
    jSplitPane1.add(jPanelLeft, JSplitPane.TOP);
    jSplitPane1.add(jPanelRight, JSplitPane.BOTTOM);
    tableScrollPane1.getViewport().add(jdbTable1, null);
  jPanelRight.add(tableScrollPane1, null);
    jPanelLeft.add(jPanel1, BorderLayout.NORTH);
    jPanel1.add(jCheckBox2, null);
    jPanel1.add(jTextFieldWellId, null);
    jPanel1.add(jCheckBox1, null);
    jPanel1.add(jTextFieldWellName, null);
    jPanel1.add(jCheckBox3, null);
    jPanel1.add(jComboBoxVerify, null);
    jPanelLeft.add(jPanel2,  BorderLayout.CENTER);
    jPanel2.add(jButtonselect, null);
    jPanelLeft.add(jPanel2,  BorderLayout.CENTER);

  }

  //Overridn so w can exit when window is closed
  protected void processWindowEvent(WindowEvent e) {
    super.processWindowEvent(e);
    if (e.getID() == WindowEvent.WINDOW_CLOSING) {
      System.exit(0);
    }
  }
}