internalcolumnbean.java

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

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

public class InternalColumnBean extends InternalColumnDao {
  public static void update(String title,String content) throws SysException{
    String sql = "UPDATE WAP_INTERNAL_COLUMN SET WAP_TITLE = '"+ title + "', WAP_CONTENT = '" + content + "'";
    if (updateBySql(sql) != 1) {
      throw new SysException("ERROR in updateUserAgent !! resultCount != 1");
    }
  }
  public static Collection getDateBySql()throws SysException{
    String sql = "SELECT * FROM WAP_INTERNAL_COLUMN";
    return queryBySql(sql);
  }
}