txbs_ret.java

一个个人信息管理系统

package soft1;

import java.awt.*;

import javax.swing.*;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
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.Load;
import com.borland.dx.sql.dataset.QueryDescriptor;
import com.borland.dx.dataset.Column;
import com.borland.dx.dataset.MetaDataUpdate;
import com.borland.dbswing.TableScrollPane;
import com.borland.dbswing.JdbTree;
import com.borland.dbswing.JdbTable;
import javax.swing.BorderFactory;
import java.awt.Color;
import javax.swing.border.TitledBorder;
import soft1Method.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.Rectangle;

public class Txbs_Ret extends JFrame {
    public Txbs_Ret() {
        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"));
        column1.setColumnName("ID");
        column1.setDataType(com.borland.dx.dataset.Variant.INT);
        column1.setRowId(true);
        column1.setTableName("AddrBook");
        column1.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column1.setServerColumnName("ID");
        column1.setSqlType(4);
        column4.setColumnName("ID");
        column4.setDataType(com.borland.dx.dataset.Variant.INT);
        column4.setRowId(true);
        column4.setTableName("AddrBook");
        column4.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column4.setServerColumnName("ID");
        column4.setSqlType(4);
        column12.setColumnName("UserName");
        column12.setDataType(com.borland.dx.dataset.Variant.STRING);
        column12.setPrecision(50);
        column12.setTableName("AddrBook");
        column12.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column12.setServerColumnName("USERNAME");
        column12.setSqlType(12);
        column2.setColumnName("类型");
        column2.setDataType(com.borland.dx.dataset.Variant.STRING);
        column2.setPrecision(50);
        column2.setTableName("AddrBook");
        column2.setWidth(5);
        column2.setServerColumnName("Type");
        column2.setSqlType(12);
        column3.setColumnName("姓名");
        column3.setDataType(com.borland.dx.dataset.Variant.STRING);
        column3.setPrecision(50);
        column3.setTableName("AddrBook");
        column3.setWidth(10);
        column3.setServerColumnName("Name");
        column3.setSqlType(12);
        column5.setColumnName("性别");
        column5.setDataType(com.borland.dx.dataset.Variant.STRING);
        column5.setPrecision(50);
        column5.setTableName("AddrBook");
        column5.setWidth(5);
        column5.setServerColumnName("Sex");
        column5.setSqlType(12);
        column6.setColumnName("家庭电话");
        column6.setDataType(com.borland.dx.dataset.Variant.STRING);
        column6.setPrecision(50);
        column6.setTableName("AddrBook");
        column6.setWidth(10);
        column6.setServerColumnName("HomePho");
        column6.setSqlType(12);
        column7.setColumnName("办公电话");
        column7.setDataType(com.borland.dx.dataset.Variant.STRING);
        column7.setPrecision(50);
        column7.setTableName("AddrBook");
        column7.setWidth(10);
        column7.setServerColumnName("OfficePho");
        column7.setSqlType(12);
        column8.setColumnName("移动电话");
        column8.setDataType(com.borland.dx.dataset.Variant.STRING);
        column8.setPrecision(50);
        column8.setTableName("AddrBook");
        column8.setWidth(10);
        column8.setServerColumnName("MobilePho");
        column8.setSqlType(12);
        column9.setColumnName("QQ");
        column9.setDataType(com.borland.dx.dataset.Variant.STRING);
        column9.setPrecision(50);
        column9.setTableName("AddrBook");
        column9.setWidth(10);
        column9.setServerColumnName("QQ");
        column9.setSqlType(12);
        column10.setColumnName("Email");
        column10.setDataType(com.borland.dx.dataset.Variant.STRING);
        column10.setPrecision(50);
        column10.setTableName("AddrBook");
        column10.setWidth(11);
        column10.setServerColumnName("Email");
        column10.setSqlType(12);
        jButton1.setBounds(new Rectangle(100, 337, 86, 28));
        jButton1.setText("修改");
        jButton1.addActionListener(new Txbs_Ret_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(311, 337, 86, 28));
        jButton2.setText("删除");
        jButton2.addActionListener(new Txbs_Ret_jButton2_actionAdapter(this));
        jdbTable1.setBorder(BorderFactory.createEtchedBorder());
        jdbTable1.setToolTipText("");
        jdbTable1.setRowHeight(20);
        jdbTable1.setSelectionBackground(Color.orange);
        jdbTable1.setDataSet(queryDataSet1);
        tableScrollPane1.setBounds(new Rectangle(2, 0, 496, 328));
        tableScrollPane1.getViewport().add(jdbTable1);
        this.getContentPane().add(tableScrollPane1, null);
        this.getContentPane().add(jButton1, null);
        this.getContentPane().add(jButton2, null);
        queryDataSet1.setMetaDataUpdate(MetaDataUpdate.TABLENAME +
                                        MetaDataUpdate.PRECISION +
                                        MetaDataUpdate.SCALE +
                                        MetaDataUpdate.SEARCHABLE);
        queryDataSet1.setQuery(new QueryDescriptor(database1,
                                                   "select ID,Type AS 类型,Name AS 姓名,Sex AS 性别,HomePho AS 家庭电话,OfficePho AS 办公电话,MobilePho AS 移动电话,"+
                "Email,QQ,Company AS 公司,Address AS 住址,Remarks AS 备注,UserName " +
                "from AddrBook where "+""+rb.s2+""+"="+"'"+TxbSearch.jTextField1.getText()+"'"+" and UserName='"+gv.Getvalue()+"'", null, true, Load.ALL));
        queryDataSet1.setColumns(new Column[] {column4, column2, column3,
                                 column5, column6, column7, column8, column10,
                                 column9, column12});
    }

    public static void main(String[] args) {
        Txbs_Ret txbs_ret = new Txbs_Ret();
    }

    Database database1 = new Database();
    Column column1 = new Column();
    TableScrollPane tableScrollPane1 = new TableScrollPane();
    QueryDataSet queryDataSet1 = new QueryDataSet();
    JdbTable jdbTable1 = new JdbTable();
    TitledBorder titledBorder1 = new TitledBorder("");
    RatioBMethod rb=new RatioBMethod();
    GetValue gv=new GetValue();
    Column column4 = new Column();
    Column column12 = new Column();
    Column column2 = new Column();
    Column column3 = new Column();
    Column column5 = new Column();
    Column column6 = new Column();
    Column column7 = new Column();
    Column column8 = new Column();
    Column column9 = new Column();
    Column column10 = new Column();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    public void jButton1_actionPerformed(ActionEvent e) {
        if(queryDataSet1.getString("姓名").equals("")){
        JOptionPane.showMessageDialog(this,"请先输入姓名！","提示",JOptionPane.PLAIN_MESSAGE);}
        else if(queryDataSet1.getString("类型").equals("")){
        JOptionPane.showMessageDialog(this,"请输入类型！","提示",JOptionPane.PLAIN_MESSAGE);}
        else{
       queryDataSet1.setString("UserName",gv.Getvalue());
       queryDataSet1.post();
      queryDataSet1.saveChanges();
      //queryDataSet1.refresh();
       JOptionPane.showMessageDialog(this,"更新成功！","提示",JOptionPane.PLAIN_MESSAGE);
       //queryDataSet1.refresh();
   }


    }

    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);
            }

    }
}


class Txbs_Ret_jButton2_actionAdapter implements ActionListener {
    private Txbs_Ret adaptee;
    Txbs_Ret_jButton2_actionAdapter(Txbs_Ret adaptee) {
        this.adaptee = adaptee;
    }

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


class Txbs_Ret_jButton1_actionAdapter implements ActionListener {
    private Txbs_Ret adaptee;
    Txbs_Ret_jButton1_actionAdapter(Txbs_Ret adaptee) {
        this.adaptee = adaptee;
    }

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