ricgzsearch.java

一个个人信息管理系统

package soft1;

import java.awt.*;

import javax.swing.*;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import com.borland.dbswing.TableScrollPane;
import com.borland.dbswing.JdbTable;
import com.borland.dbswing.JdbTextField;
import com.borland.dbswing.JdbComboBox;
import com.borland.dbswing.JdbTextArea;
import javax.swing.border.TitledBorder;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.QueryDataSet;
import com.borland.dx.sql.dataset.ConnectionDescriptor;
import com.borland.dx.dataset.MetaDataUpdate;
import com.borland.dx.sql.dataset.QueryDescriptor;
import com.borland.dx.sql.dataset.Load;
import soft1Method.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import com.borland.dx.dataset.Column;
import java.awt.Rectangle;
import javax.swing.BorderFactory;
import java.awt.Color;
import java.sql.ResultSet;

public class RicgzSearch extends JFrame {
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    TableScrollPane tableScrollPane1 = new TableScrollPane();
    JdbTable jdbTable1 = new JdbTable();
    JdbTextField jdbTextField1 = new JdbTextField();
    JdbComboBox jdbComboBox1 = new JdbComboBox();
    JdbTextField jdbTextField2 = new JdbTextField();
    JdbTextArea jdbTextArea1 = new JdbTextArea();
    TitledBorder titledBorder1 = new TitledBorder("");
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    Database database1 = new Database();
    QueryDataSet queryDataSet1 = new QueryDataSet();
    GetValue gv=new GetValue();
    Column column1 = new Column();
    Column column2 = new Column();
    Column column3 = new Column();
    Column column4 = new Column();
    public RicgzSearch() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        this.getContentPane().setBackground(SystemColor.controlHighlight);
        setSize(new Dimension(500, 400));
        jLabel1.setText("主题");
        jLabel1.setBounds(new Rectangle(159, 34, 39, 19));
        jLabel4.setText("备注");
        jLabel4.setBounds(new Rectangle(159, 116, 43, 20));
        jLabel3.setText("时间");
        jLabel3.setBounds(new Rectangle(305, 75, 37, 21));
        jdbTextArea1.setBorder(titledBorder1);
        jdbTextArea1.setColumnName("Remarks");
        jdbTextArea1.setDataSet(queryDataSet1);
        jdbTextArea1.setBounds(new Rectangle(159, 147, 326, 182));
        jButton1.setBounds(new Rectangle(211, 336, 67, 30));
        jButton1.setText("修改");
        jButton1.addActionListener(new RicgzSearch_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(343, 336, 67, 30));
        jButton2.setText("删除");
        jButton2.addActionListener(new RicgzSearch_jButton2_actionAdapter(this));
        database1.setConnection(new ConnectionDescriptor("jdbc:odbc:PersonalDB",
                "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
        queryDataSet1.setMetaDataUpdate(MetaDataUpdate.TABLENAME +
                                        MetaDataUpdate.PRECISION +
                                        MetaDataUpdate.SCALE +
                                        MetaDataUpdate.SEARCHABLE);
        queryDataSet1.setQuery(new QueryDescriptor(database1, "Select * from WorkPad where UserName='"+gv.Getvalue()+"' and Caption like '%"+OtherSearch.jTextField1.getText()+"%'", null, true,
                      Load.ALL));

        String sqlQuery="select Sort from WorkPadSort";
        Dataset2 dataset2=new Dataset2();
         jdbComboBox1.addItem("");
         ResultSet rs2=dataset2.Rs(sqlQuery);
          while (rs2.next()) {
          jdbComboBox1.addItem(rs2.getString(1));
          }
        column1.setColumnName("UserName");
        column1.setDataType(com.borland.dx.dataset.Variant.STRING);
        column1.setPrecision(50);
        column1.setTableName("WorkPad");
        column1.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column1.setServerColumnName("USERNAME");
        column1.setSqlType(12);
        column2.setColumnName("Remarks");
        column2.setDataType(com.borland.dx.dataset.Variant.STRING);
        column2.setSearchable(false);
        column2.setTableName("WorkPad");
        column2.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column2.setServerColumnName("REMARKS");
        column3.setColumnName("Mydate");
        column3.setDataType(com.borland.dx.dataset.Variant.TIMESTAMP);
        column3.setTableName("WorkPad");
        column3.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column3.setServerColumnName("MYDATE");
        column3.setSqlType(93);
        column4.setColumnName("ID");
        column4.setDataType(com.borland.dx.dataset.Variant.INT);
        column4.setRowId(true);
        column4.setTableName("WorkPad");
        column4.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column4.setServerColumnName("ID");
        column4.setSqlType(4);
        tableScrollPane1.getViewport().setBackground(Color.white);
        tableScrollPane1.setBorder(BorderFactory.createLineBorder(Color.black));
        tableScrollPane1.setBounds(new Rectangle(0, 0, 150, 400));
        jLabel2.setBounds(new Rectangle(159, 77, 39, 19));
        jdbTextField2.setColumnName("Mydate");
        jdbTextField2.setDataSet(queryDataSet1);
        jdbTextField2.setBounds(new Rectangle(338, 73, 147, 28));
        jdbComboBox1.setColumnName("Sort");
        jdbComboBox1.setDataSet(queryDataSet1);
        jdbComboBox1.setBounds(new Rectangle(204, 73, 95, 28));
        jdbTextField1.setColumnName("Caption");
        jdbTextField1.setDataSet(queryDataSet1);
        jdbTextField1.setBounds(new Rectangle(204, 30, 281, 28));
        jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
        jdbTable1.setDataSet(queryDataSet1);
        tableScrollPane1.getViewport().add(jdbTable1);
        this.getContentPane().add(jdbTextArea1, null);
        this.getContentPane().add(jdbTextField1, null);
        jLabel2.setText("类型");
        this.getContentPane().add(jdbComboBox1, null);
        this.getContentPane().add(jLabel2, null);
        this.getContentPane().add(jLabel4, null);
        this.getContentPane().add(jdbTextField2, null);
        this.getContentPane().add(jLabel1, null);
        this.getContentPane().add(tableScrollPane1, null);
        this.getContentPane().add(jLabel3, null);
        this.getContentPane().add(jButton2, null);
        this.getContentPane().add(jButton1, null);
        queryDataSet1.setColumns(new Column[] {column4, column3, column2,
                                 column1});
    }

    public static void main(String[] args) {
        RicgzSearch ricgzsearch = new RicgzSearch();
    }

    public void jButton1_actionPerformed(ActionEvent e) {
      System.out.println( "Select * from WorkPad where Caption like '%"+OtherSearch.jTextField1.getText()+"%' and UserName='"+gv.Getvalue()+"'");
        if(queryDataSet1.getString("Caption").equals("")){
            JOptionPane.showMessageDialog(this,"请先输入主题！","提示",JOptionPane.PLAIN_MESSAGE);}
        else{
            queryDataSet1.setString("UserName",gv.Getvalue());
            queryDataSet1.post();
            queryDataSet1.saveChanges();
            JOptionPane.showMessageDialog(this,"更新成功！","提示",JOptionPane.PLAIN_MESSAGE);

}

    }

    public void jButton2_actionPerformed(ActionEvent e) {
        try{
                    queryDataSet1.deleteRow();
                    queryDataSet1.post();
                    queryDataSet1.saveChanges();
                    queryDataSet1.refresh();
                    JOptionPane.showMessageDialog(this,"删除成功！","提示",JOptionPane.PLAIN_MESSAGE);
                  }catch(Exception ex){
                    queryDataSet1.refresh();
                    JOptionPane.showMessageDialog(this,ex.toString(),"提示",JOptionPane.ERROR_MESSAGE);
                  }

    }

    public void jButton3_actionPerformed(ActionEvent e) {
   this.setVisible(false);
    }
}


class RicgzSearch_jButton2_actionAdapter implements ActionListener {
    private RicgzSearch adaptee;
    RicgzSearch_jButton2_actionAdapter(RicgzSearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton2_actionPerformed(e);
    }
}


class RicgzSearch_jButton1_actionAdapter implements ActionListener {
    private RicgzSearch adaptee;
    RicgzSearch_jButton1_actionAdapter(RicgzSearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton1_actionPerformed(e);
    }
}