cardhandler.java~4~

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

package card;

import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import javax.swing.JOptionPane;

public class cardhandler implements ActionListener {
    cardDialog cd;
    cardmodel cm = new cardmodel();
    DatabaseOperate dp = new DatabaseOperate();
    allmodel am=new allmodel();
    public void actionPerformed(ActionEvent e) {
        if (e.getActionCommand() == "select") {
//            cm.setCarid(Integer.parseInt(cd.txtcardid.getText().trim()));
//            cardmodel card = dp.cardselect(cm);
//            cd.txttypeid.setText(String.valueOf(card.getTpid()));
//            cd.txtname.setText(card.getFrdname());
//            cd.txtsex.setText(card.getSex());
//            cd.txtbrithday.setText(card.getBirthday());
//            cd.txtdepart.setText(card.getDepart());
//            cd.txtpower.setText(card.getPower());
//            cd.txthomephone.setText(card.getHomephone());
//            cd.txtofficephone.setText(card.getOfficephone());
//            cd.txtmobil.setText(card.getMobil());
//            cd.txtaddress.setText(card.getAddress());
//            cd.txtnumber.setText(card.getNumber());
//            cd.txtemail.setText(card.getEmail());
        }
        if (e.getActionCommand() == "update") {
            cm.setCarid(Integer.parseInt(cd.txtcardid.getText().trim()));
            cm.setTpid(Integer.parseInt(cd.txttypeid.getText().trim()));
            cm.setFrdname(cd.txtname.getText());
            cm.setSex(cd.txtsex.getText());
            cm.setBirthday(cd.txtbrithday.getText());
            cm.setDepart(cd.txtdepart.getText());
            cm.setPower(cd.txtpower.getText());
            cm.setHomephone(cd.txthomephone.getText());
            cm.setOfficephone(cd.txtofficephone.getText());
            cm.setMobil(cd.txtmobil.getText());
            cm.setAddress(cd.txtaddress.getText());
            cm.setNumber(cd.txtname.getText());
            cm.setEmail(cd.txtemail.getText());
               if(dp.cardupdate(am)){
                   JOptionPane.showMessageDialog(null,"更新成功","成功",JOptionPane.INFORMATION_MESSAGE);
               }
               else{
                   JOptionPane.showMessageDialog(null,"更新失败","失败",JOptionPane.INFORMATION_MESSAGE);
               }
        }

        if (e.getActionCommand() == "create") {
            cm.setCarid(Integer.parseInt(cd.txtcardid.getText().trim()));
            cm.setTpid(Integer.parseInt(cd.txttypeid.getText().trim()));
            cm.setFrdname(cd.txtname.getText());
            cm.setSex(cd.txtsex.getText());
            cm.setBirthday(cd.txtbrithday.getText());
            cm.setDepart(cd.txtdepart.getText());
            cm.setPower(cd.txtpower.getText());
            cm.setHomephone(cd.txthomephone.getText());
            cm.setOfficephone(cd.txtofficephone.getText());
            cm.setMobil(cd.txtmobil.getText());
            cm.setAddress(cd.txtaddress.getText());
            cm.setNumber(cd.txtname.getText());
            cm.setEmail(cd.txtemail.getText());
               if(dp.cardinsert(cm)){
                   JOptionPane.showMessageDialog(null,"创建名片成功","成功",JOptionPane.INFORMATION_MESSAGE);
               }
               else{
                   JOptionPane.showMessageDialog(null,"创建名片失败","失败",JOptionPane.INFORMATION_MESSAGE);
               }
        }


    }
}