usercardbean.java

WAP PUSH后台源码,WAP PUSH后台源码

package com.sxit.wap.usercard;

import java.sql.*;
import java.util.*;
import com.sxit.wap.common.*;
import com.sxit.wap.exception.*;

public class UserCardBean extends UserCardDao {
  public static Collection getUserCardByUserMdn(String userMdn) throws
      SysException {
    String sql = "SELECT * FROM WAP_USER_CARD WHERE USER_MDN = '" + userMdn +
        "'";
    return queryBySql(sql);
  }

  public static boolean insert(String userMdn, String userName,String userEmail)  {
    UserCardModel user = new UserCardModel();
    user.setUserMdn(userMdn);
    user.setUserName(userName);
    user.setUserEmail(userEmail);
    try {
      insert(user);
      return true;
    }
    catch (Exception ex) {
      ex.printStackTrace();
      return false;
    }
  }

  public static boolean update(String userMdn, String userJob, String userCom) {
    try {
      String sql = "UPDATE WAP_USER_CARD SET USER_JOB = '" + userJob +
          "' , USER_COM ='" + userCom + "' WHERE USER_MDN ='" + userMdn + "'";
      System.out.println(sql);
      if (updateBySql(sql) == 1) {
        return true;
      }else {
        return false;
      }
    }catch (Exception ex) {
      return false;
    }
  }

  public static boolean update(String userMdn,String userTel,String userFax,String userAdress){
  try{
    String sql = "UPDATE WAP_USER_CARD SET USER_TEL = '" + userTel +
          "' , USER_FAX ='" + userFax +"', USER_ADRESS = '" + userAdress + "' WHERE USER_MDN ='" + userMdn + "'";
      if (updateBySql(sql) == 1) {
        return true;
      }else {
        return false;
      }
     }catch(Exception ex){
       return false;
      }
  }
  public static boolean updateByColumnn(String userMdn,String colName,String colValue)throws SysException{
  try{
      String sql = "UPDATE WAP_USER_CARD SET " + colName + " = '" + colValue + "' WHERE USER_MDN = '" + userMdn + "'";
      if (updateBySql(sql) == 1) {
         return true;
       } else {
         return false;
       }
      }catch(Exception ex){
        return false;
       }
  }
 public static boolean isExist(String userMdn)throws SysException{
   String sql = "SELECT COUNT(*) FROM WAP_USER_CARD WHERE USER_MDN = '" +userMdn + "'";
   return getRowCountBySql(sql) > 0;
 }
}