cardhandler.java~6~

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

package card;

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

public class cardhandler implements ActionListener {
    cardDialog cd;
        SelectDialog sd;
    cardmodel cm = new cardmodel();
    DatabaseOperate dp = new DatabaseOperate();
    allmodel am=new allmodel();
    public void actionPerformed(ActionEvent e) {
        if (e.getActionCommand() == "select") {
            String sql="";
                        if(!sd.txtcardid.getText().trim().equals("")){
                            sql+=" and  carid like '%" +
                              sd.txtcardid.getText().trim() +
                              "%'";
                        }
                        if(!sd.cboTypeName.getSelectedItem().toString().trim().equals("")){
                            sql += " and  typetable.tpname like '%" +
                              sd.cboTypeName.getSelectedItem().toString().trim() +
                              "%'";
                        }
                        if(!sd.txtname.getText().trim().equals("")){
                            sql += " and  frdname like '%" + sd.txtname.getText().trim() +
                              "%'";
                        }
                        if(!sd.txtsex.getText().trim().equals("")){
                            sql += " and  sex like '%" + sd.txtsex.getText().trim() +
                              "%'";
                        }
                        if(!sd.txtbrithday.getText().trim().equals("")){
                            sql += " and  birthday like '%" + sd.txtbrithday.getText().trim() +
                              "%'";
                        }
                        if(!sd.txtdepart.getText().trim().equals("")){
                            sql += " and  depart like '%" + sd.txtdepart.getText().trim() +
                              "%'";
                        }
                        if(!sd.txtpower.getText().trim().equals("")){
                            sql += " and  power like '%" + sd.txtpower.getText().trim() +
                              "%'";
                        }
                        if(!sd.txthomephone.getText().trim().equals("")){
                            sql += " and  homephone like '%" + sd.txthomephone.getText().trim() +
                              "%'";
                        }
                        if(!sd.txtofficephone.getText().trim().equals("")){
                            sql += " and  officephone like '%" + sd.txtofficephone.getText().trim() +
                              "%'";
                        }
                        if(!sd.txtmobil.getText().trim().equals("")){
                            sql += " and  mobil like '%" + sd.txtmobil.getText().trim() +
                              "%'";
                        }
                        if(!sd.txtaddress.getText().trim().equals("")){
                            sql += " and  address like '%" + sd.txtaddress.getText().trim() +
                              "%'";
                        }
                        if(!sd.txtnumber.getText().trim().equals("")){
                            sql += " and  number like '%" + sd.txtnumber.getText().trim() +
                              "%'";
                        }
                        if(!sd.txtemail.getText().trim().equals("")){
                            sql += " and  email like '%" + sd.txtemail.getText().trim() +
                              "%'";
                        }
                        Static.setSQL(sql);
            sd.setVisible(false);
        }
//        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);
               }
        }


    }
}