qit.java

一个个人信息管理系统

package soft1;

import java.awt.*;

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

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class qit extends JPanel {
    public qit() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setLayout(xYLayout1);
        setSize(new Dimension(562, 370));
        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 ID,Type1,Name1 AS 密码名,Password1 AS 密码,Beyond AS 用途,Remarks1 AS 备注,UserName " +
                "from Pwd where Type1='Other' and UserName='"+gv.Getvalue()+"'", null, true,
                Load.ALL));
        jdbTable1.setBorder(BorderFactory.createLineBorder(Color.black));
        jdbTable1.setDataSet(queryDataSet1);
        jButton1.setText("添加");
        jButton1.addActionListener(new qit_jButton1_actionAdapter(this));
        jButton2.setText("保存");
        jButton2.addActionListener(new qit_jButton2_actionAdapter(this));
        jButton3.setText("删除");
        jButton3.addActionListener(new qit_jButton3_actionAdapter(this));
        column1.setColumnName("UserName");
        column1.setDataType(com.borland.dx.dataset.Variant.STRING);
        column1.setPrecision(50);
        column1.setTableName("Pwd");
        column1.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column1.setServerColumnName("UserName");
        column1.setSqlType(12);
        column2.setColumnName("ID");
        column2.setDataType(com.borland.dx.dataset.Variant.INT);
        column2.setRowId(true);
        column2.setTableName("Pwd");
        column2.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column2.setServerColumnName("ID");
        column2.setSqlType(4);
        column3.setColumnName("Type1");
        column3.setDataType(com.borland.dx.dataset.Variant.STRING);
        column3.setPrecision(50);
        column3.setTableName("Pwd");
        column3.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column3.setServerColumnName("Type1");
        column3.setSqlType(12);
        column4.setColumnName("密码名");
        column4.setDataType(com.borland.dx.dataset.Variant.STRING);
        column4.setPrecision(50);
        column4.setTableName("Pwd");
        column4.setWidth(10);
        column4.setServerColumnName("Name1");
        column4.setSqlType(12);
        column5.setColumnName("密码");
        column5.setDataType(com.borland.dx.dataset.Variant.STRING);
        column5.setPrecision(50);
        column5.setTableName("Pwd");
        column5.setWidth(10);
        column5.setServerColumnName("Password1");
        column5.setSqlType(12);
        this.add(tableScrollPane1, new XYConstraints( -1, 0, 563, 293));
        tableScrollPane1.getViewport().add(jdbTable1);
        this.add(jButton3, new XYConstraints(442, 312, 89, 31));
        this.add(jButton1, new XYConstraints(23, 312, 89, 31));
        this.add(jButton2, new XYConstraints(232, 312, 89, 31));
        queryDataSet1.setColumns(new Column[] {column2, column3, column4,
                                 column5, column1});
    }
    GetValue gv=new GetValue();
    QueryDataSet queryDataSet1 = new QueryDataSet();
    Database database1 = new Database();
    XYLayout xYLayout1 = new XYLayout();
    TableScrollPane tableScrollPane1 = new TableScrollPane();
    JdbTable jdbTable1 = new JdbTable();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    Column column1 = new Column();
    Column column2 = new Column();
    Column column3 = new Column();
    Column column4 = new Column();
    Column column5 = new Column();
    public void jButton1_actionPerformed(ActionEvent e) {
     queryDataSet1.insertRow(false);
    }

    public void jButton3_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 jButton2_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{
       //String s="insert into Pwd(Name1,Password1,Remarks1,UserName,Type1,Beyond) values ('"+queryDataSet1.getString("卡号")+"','"+queryDataSet1.getString("密码")+"','"+queryDataSet1.getString("备注")+"','"+gv.Getvalue()+"','Bank','"+queryDataSet1.getString("银行")+"')";
       //Dataset2 dt=new Dataset2();
       //System.out.println(gv.Getvalue());
       //System.out.println(s);
       //dt.Update(s);
       queryDataSet1.setString("Type1","Other");
            queryDataSet1.setString("UserName",gv.Getvalue());
       queryDataSet1.post();
      queryDataSet1.saveChanges();
      queryDataSet1.refresh();
       JOptionPane.showMessageDialog(this,"更新成功！","提示",JOptionPane.PLAIN_MESSAGE);
       queryDataSet1.refresh();
   }}


}


class qit_jButton2_actionAdapter implements ActionListener {
    private qit adaptee;
    qit_jButton2_actionAdapter(qit adaptee) {
        this.adaptee = adaptee;
    }

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


class qit_jButton3_actionAdapter implements ActionListener {
    private qit adaptee;
    qit_jButton3_actionAdapter(qit adaptee) {
        this.adaptee = adaptee;
    }

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


class qit_jButton1_actionAdapter implements ActionListener {
    private qit adaptee;
    qit_jButton1_actionAdapter(qit adaptee) {
        this.adaptee = adaptee;
    }

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