shsssearch.java

一个个人信息管理系统

package soft1;

import java.awt.*;

import javax.swing.*;
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.sql.dataset.QueryDescriptor;
import com.borland.dx.sql.dataset.Load;
import com.borland.dx.dataset.MetaDataUpdate;
import com.borland.dbswing.TableScrollPane;
import java.awt.BorderLayout;
import com.borland.dbswing.JdbTable;
import java.awt.Rectangle;
import com.borland.dbswing.JdbTextField;
import com.borland.dbswing.JdbComboBox;
import com.borland.dbswing.JdbTextArea;
import javax.swing.border.TitledBorder;
import com.borland.dbswing.JdbLabel;
import soft1Method.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import com.borland.dx.dataset.Column;

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

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
           setSize(new Dimension(500, 400));
        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 NotePad where UserName='"+gv.Getvalue()+"' and Caption like '%"+OtherSearch.jTextField1.getText()+"%' ", null, true,
                Load.ALL));
        jdbComboBox1.addItem("");
      jdbComboBox1.addItem("很热");
     jdbComboBox1.addItem("晴朗");
     jdbComboBox1.addItem("阴");
     jdbComboBox1.addItem("小雨");
     jdbComboBox1.addItem("中雨");
     jdbComboBox1.addItem("大雨");
     jdbComboBox1.addItem("随便");
     jdbComboBox2.addItem("");
      jdbComboBox2.addItem("好");
       jdbComboBox2.addItem("很好");
        jdbComboBox2.addItem("一般");
        jdbComboBox2.addItem("不好");
        jdbComboBox2.addItem("很不好");
       jdbComboBox2.addItem("随便");

        jLabel1.setText("主题");
        jLabel1.setBounds(new Rectangle(161, 16, 39, 28));
        jLabel2.setText("天气");
        jLabel2.setBounds(new Rectangle(161, 59, 39, 32));
        jLabel3.setText("心情");
        jLabel3.setBounds(new Rectangle(337, 60, 39, 29));
        jdbTextField1.setColumnName("Caption");
        jdbTextField1.setDataSet(queryDataSet1);
        jdbTextField1.setBounds(new Rectangle(196, 13, 287, 31));
        jdbComboBox1.setColumnName("Weather");
        jdbComboBox1.setDataSet(queryDataSet1);
        jdbComboBox1.setBounds(new Rectangle(196, 60, 125, 29));
        jdbTextArea1.setBorder(titledBorder1);
        jdbTextArea1.setColumnName("Detail");
        jdbTextArea1.setDataSet(queryDataSet1);
        jdbTextArea1.setBounds(new Rectangle(161, 140, 322, 171));
        jButton1.setBounds(new Rectangle(354, 330, 87, 27));
        jButton1.setText("删除");
        jButton1.addActionListener(new ShssSearch_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(226, 330, 87, 27));
        jButton2.setText("修改");
        jButton2.addActionListener(new ShssSearch_jButton2_actionAdapter(this));
        jdbComboBox2.setColumnName("Motion");
        jdbComboBox2.setDataSet(queryDataSet1);
        jdbComboBox2.setBounds(new Rectangle(373, 60, 110, 29));
        column1.setColumnName("ID");
        column1.setDataType(com.borland.dx.dataset.Variant.INT);
        column1.setRowId(true);
        column1.setTableName("NotePad");
        column1.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column1.setServerColumnName("ID");
        column1.setSqlType(4);
        column2.setColumnName("Mydate");
        column2.setDataType(com.borland.dx.dataset.Variant.TIMESTAMP);
        column2.setTableName("NotePad");
        column2.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column2.setServerColumnName("时间");
        column2.setSqlType(93);
        column3.setColumnName("Detail");
        column3.setDataType(com.borland.dx.dataset.Variant.STRING);
        column3.setSearchable(false);
        column3.setTableName("NotePad");
        column3.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column3.setServerColumnName("DETAIL");
        column4.setColumnName("UserName");
        column4.setDataType(com.borland.dx.dataset.Variant.STRING);
        column4.setPrecision(50);
        column4.setTableName("NotePad");
        column4.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column4.setServerColumnName("USERNAME");
        column4.setSqlType(12);
        column5.setColumnName("Weather");
        column5.setDataType(com.borland.dx.dataset.Variant.STRING);
        column5.setPrecision(50);
        column5.setTableName("NotePad");
        column5.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column5.setServerColumnName("WEATHER");
        column5.setSqlType(12);
        column6.setColumnName("Motion");
        column6.setDataType(com.borland.dx.dataset.Variant.STRING);
        column6.setPrecision(50);
        column6.setTableName("NotePad");
        column6.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column6.setServerColumnName("MOTION");
        column6.setSqlType(12);
        column7.setColumnName("Special");
        column7.setDataType(com.borland.dx.dataset.Variant.STRING);
        column7.setPrecision(50);
        column7.setTableName("NotePad");
        column7.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column7.setServerColumnName("SPECIAL");
        column7.setSqlType(12);
        jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
        jdbTable1.setDataSet(queryDataSet1);
        column9.setColumnName("Caption");
        column9.setDataType(com.borland.dx.dataset.Variant.STRING);
        column9.setPrecision(50);
        column9.setSchemaName("");
        column9.setTableName("NotePad");
        column9.setServerColumnName("CAPTION");
        column9.setSqlType(12);
        jLabel4.setText("特别提醒");
        jLabel4.setBounds(new Rectangle(161, 106, 56, 24));
        jdbTextField2.setText("jdbTextField2");
        jdbTextField2.setColumnName("Special");
        jdbTextField2.setDataSet(queryDataSet1);
        jdbTextField2.setBounds(new Rectangle(221, 103, 117, 27));
        jdbLabel1.setBorder(titledBorder4);
        jdbLabel1.setColumnName("Mydate");
        jdbLabel1.setDataSet(queryDataSet1);
        jdbLabel1.setBounds(new Rectangle(343, 103, 140, 27));
        tableScrollPane1.getViewport().add(jdbTable1);
        this.getContentPane().add(tableScrollPane1, null);
        this.getContentPane().add(jdbTextField1);
        this.getContentPane().add(jdbComboBox1);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jdbTextArea1);
        this.getContentPane().add(jdbComboBox2);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jdbTextField2);
        this.getContentPane().add(jdbLabel1);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jLabel4);
        tableScrollPane1.setBounds(new Rectangle(1, 0, 151, 397));
        queryDataSet1.setColumns(new Column[] {column1, column2, column9,
                                 column3, column4, column5, column6, column7});
    }

    public static void main(String[] args) {
        ShssSearch shsssearch = new ShssSearch();
    }

    public void jButton2_actionPerformed(ActionEvent e) {System.out.println("Select * from NotePad 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 jButton1_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);
              }

    }
}


class ShssSearch_jButton1_actionAdapter implements ActionListener {
    private ShssSearch adaptee;
    ShssSearch_jButton1_actionAdapter(ShssSearch adaptee) {
        this.adaptee = adaptee;
    }

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


class ShssSearch_jButton2_actionAdapter implements ActionListener {
    private ShssSearch adaptee;
    ShssSearch_jButton2_actionAdapter(ShssSearch adaptee) {
        this.adaptee = adaptee;
    }

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