menuimgbean.java

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

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

public class MenuImgBean extends MenuImgDao{
  public static String isUsed(int id) throws SysException {
	int i= getRowCountBySql( "SELECT COUNT(*) FROM wap_index_menu where menu_img = " + id );
	if (i>0)
		return "图片在首页菜单中被引用";
	i= getRowCountBySql( "SELECT COUNT(*) FROM wap_menu where img_id = " + id );
	if (i>0)
		return  "图片在目录或者频道中被引用";
	return null;
  }
  public static boolean isExists(String imgName) throws SysException {
    return getRowCountBySql("SELECT COUNT(*) FROM " + tableName + " WHERE IMG_NAME = '" + imgName +"'")>=1;
  }
  public static boolean isExists(int id, String imgName) throws SysException {
    return getRowCountBySql("SELECT COUNT(*) FROM " + tableName + " WHERE IMG_NAME = '" + imgName +"'" + " AND ID <> '" + id + "'")>=1;
  }

  public static String getSelectImgHTML() throws SysException {
    Collection coll = MenuImgBean.queryAll();
    return getSelectImgHTML(coll);
  }
  public static String getSelectImgHTML(int menuImgId) throws SysException {
    Collection coll = MenuImgBean.queryAll();
    return getSelectImgHTML(coll, menuImgId);
  }
  public static String getSelectImgHTML(Collection coll) throws SysException {
    return getSelectImgHTML(coll, 0);
  }
  public static String getSelectImgHTML(Collection coll, int menuImgId) throws SysException {
    String value = "";
    Iterator it = coll.iterator();
    while ( it.hasNext() ) {
      Hashtable element = (Hashtable)it.next();
      MenuImgModel menuImgModel = MenuImgBean.toModel(element);
      int id = menuImgModel.getId();
      String imgName = menuImgModel.getImgName();
      String imgUrl = menuImgModel.getImgUrl();
      value += "<option value=\"" + menuImgModel.getId() + "\" imgUrl=\"" + menuImgModel.getImgUrl() + "\"" + (menuImgId==0?"":menuImgModel.getId()==menuImgId?"selected":"") + ">";
      value += imgName + "</option>";
    }
    return value;
  }
  public static void main(String[] args) throws Exception {
    System.out.println(getSelectImgHTML());
  }
}