groupsmtpbean.java

来自「WAP PUSH后台源码,WAP PUSH后台源码」· Java 代码 · 共 17 行

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

public class GroupSmtpBean extends GroupSmtpDao{
  public static Collection getGroupSmtp(int groupId)throws SysException{
    String sql = "SELECT * FROM WAP_GROUP_SMTP WHERE GROUP_ID =" + groupId;
    return queryBySql(sql);
  }
  public static int updateByModel(GroupSmtpModel smtpmodel)throws SysException{
    String sql = "UPDATE WAP_GROUP_SMTP SET GROUP_ID = " + smtpmodel.getGroupId() + ",SMTP_URL = '" + smtpmodel.getSmtpUrl() +"',SMTP_USER_NAME = '" + smtpmodel.getSmtpUserName() + "',SMTP_USER_PWD = '" + smtpmodel.getSmtpUserPwd() + "'";
    return updateBySql(sql);
  }
}