selectdialog.java

可以对名片进行增删改查,用户管理包括增删改查等,对名片查询时可以模糊查询

package card;

import java.awt.BorderLayout;
import java.awt.Frame;

import javax.swing.JDialog;
import javax.swing.JPanel;
import java.awt.Font;
import java.awt.Rectangle;
import javax.swing.JLabel;
import javax.swing.JTextField;
import javax.swing.JButton;
import java.awt.*;
import javax.swing.JComboBox;
import java.util.ArrayList;

/**
 * <p>Title: Card</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class SelectDialog extends JDialog {
    JPanel panel1 = new JPanel();
    JLabel lblCardid = new JLabel();
    JLabel lblName = new JLabel();
    JLabel lblSex = new JLabel();
    JLabel lblDate = new JLabel();
    JLabel lblDepart = new JLabel();
    JLabel lblPower = new JLabel();
    JLabel lblHomePhone = new JLabel();
    JLabel lblOfficePhone = new JLabel();
    JLabel lblMobic = new JLabel();
    JLabel lblAddress = new JLabel();
    JLabel lblEmail = new JLabel();
    JLabel jLabel13 = new JLabel();
    JTextField txtcardid = new JTextField();
    JTextField txtname = new JTextField();
    JTextField txtsex = new JTextField();
    JTextField txtbrithday = new JTextField();
    JTextField txtdepart = new JTextField();
    JTextField txtpower = new JTextField();
    JTextField txthomephone = new JTextField();
    JTextField txtofficephone = new JTextField();
    JTextField txtmobil = new JTextField();
    JTextField txtaddress = new JTextField();
    JTextField txtnumber = new JTextField();
    JTextField txtemail = new JTextField();
    JButton btnselect = new JButton();
    cardhandler ch=new cardhandler();
    JLabel jLabel1 = new JLabel();
    JComboBox cboTypeName = new JComboBox();
    DatabaseOperate dbo=new DatabaseOperate();




    public SelectDialog(Frame owner, String title, boolean modal) {
        super(owner, title, modal);
        try {
            setDefaultCloseOperation(DISPOSE_ON_CLOSE);
            jbInit();
            pack();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public SelectDialog() {
        this(new Frame(), "SelectDialog", false);
    }

    private void jbInit() throws Exception {
        panel1.setLayout(null);
        lblCardid.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        lblCardid.setText("名片编号：");
        lblCardid.setBounds(new Rectangle(61, 44, 80, 39));
        lblName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        lblName.setText("姓名：");
        lblName.setBounds(new Rectangle(60, 83, 90, 40));
        lblSex.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        lblSex.setText("性别：");
        lblSex.setBounds(new Rectangle(294, 88, 62, 24));
        lblDate.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        lblDate.setText("出生年月：");
        lblDate.setBounds(new Rectangle(59, 130, 75, 28));
        lblDepart.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        lblDepart.setText("工作单位：");
        lblDepart.setBounds(new Rectangle(294, 133, 79, 29));
        lblPower.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        lblPower.setText("职务：");
        lblPower.setBounds(new Rectangle(62, 179, 75, 26));
        lblHomePhone.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        lblHomePhone.setText("家庭电话：");
        lblHomePhone.setBounds(new Rectangle(291, 182, 76, 28));
        lblOfficePhone.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        lblOfficePhone.setText("办公电话：");
        lblOfficePhone.setBounds(new Rectangle(62, 217, 83, 35));
        lblMobic.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        lblMobic.setText("移动电话：");
        lblMobic.setBounds(new Rectangle(291, 225, 80, 31));
        lblAddress.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        lblAddress.setText("地址：");
        lblAddress.setBounds(new Rectangle(65, 269, 80, 27));
        lblEmail.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        lblEmail.setText("邮编：");
        lblEmail.setBounds(new Rectangle(293, 274, 81, 31));
        jLabel13.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jLabel13.setText("电子邮件：");
        jLabel13.setBounds(new Rectangle(68, 313, 83, 31));
        txtcardid.setText("");
        txtcardid.setBounds(new Rectangle(134, 49, 128, 28));
        txtname.setText("");
        txtname.setBounds(new Rectangle(134, 90, 130, 27));
        txtsex.setText("");
        txtsex.setBounds(new Rectangle(372, 85, 123, 30));
        txtbrithday.setText("");
        txtbrithday.setBounds(new Rectangle(133, 135, 131, 27));
        txtdepart.setText("");
        txtdepart.setBounds(new Rectangle(373, 129, 122, 29));
        txtpower.setText("");
        txtpower.setBounds(new Rectangle(136, 182, 128, 29));
        txthomephone.setText("");
        txthomephone.setBounds(new Rectangle(373, 182, 121, 31));
        txtofficephone.setText("");
        txtofficephone.setBounds(new Rectangle(138, 225, 127, 29));
        txtmobil.setText("");
        txtmobil.setBounds(new Rectangle(373, 226, 121, 30));
        txtaddress.setText("");
        txtaddress.setBounds(new Rectangle(137, 272, 129, 30));
        txtnumber.setText("");
        txtnumber.setBounds(new Rectangle(374, 275, 120, 28));
        txtemail.setText("");
        txtemail.setBounds(new Rectangle(139, 318, 130, 31));
        btnselect.setBounds(new Rectangle(257, 381, 120, 35));
        btnselect.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        btnselect.setText("多项查询");
        btnselect.setActionCommand("select");
        btnselect.addActionListener(ch);
        ch.sd=this;
        jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jLabel1.setText("类别名称：");
        jLabel1.setBounds(new Rectangle(292, 43, 70, 27));
        cboTypeName.setBounds(new Rectangle(371, 45, 123, 26));
        panel1.add(lblCardid);
        panel1.add(lblName);
        panel1.add(lblDate);
        panel1.add(lblPower);
        panel1.add(lblOfficePhone);
        panel1.add(lblAddress);
        panel1.add(jLabel13);
        panel1.add(txtcardid);
        panel1.add(txtname);
        panel1.add(txtbrithday);
        panel1.add(txtpower);
        panel1.add(txtofficephone);
        panel1.add(txtaddress);
        panel1.add(txtemail);
        panel1.add(btnselect);
        panel1.add(jLabel1);
        panel1.add(cboTypeName);
        panel1.add(txtsex);
        panel1.add(lblSex);
        panel1.add(lblDepart);
        panel1.add(txtdepart);
        panel1.add(txthomephone);
        panel1.add(lblHomePhone);
        panel1.add(lblMobic);
        panel1.add(txtmobil);
        panel1.add(txtnumber);
        panel1.add(lblEmail);
        ArrayList arr=dbo.selectType();
        this.cboTypeName.addItem("");
        for(int i=0;i<arr.size();i++){
            typemodel tm=(typemodel)arr.get(i);
            this.cboTypeName.addItem(tm.getTyname());
        }
        this.getContentPane().add(panel1, java.awt.BorderLayout.CENTER);

    }
}