softwaremanager.java

用于BBS交流的网站

package com.andrew.db;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.andrew.elements.Software;

public class SoftwareManager {
	private static final DB db = new DB();

	/**
	 * @param request
	 * @param response
	 * @return 查到的结果
	 */
	public String searchSoftwareItems(HttpServletRequest request, HttpServletResponse response) {
		String searchType = request.getParameter("searchType");
		String result = "";
		if (searchType.equals("softwareID")) {
			String softwareID = request.getParameter("softwareID");//先将ID保存为字符串，数据库操作中在转为整形
			result = db.searchSoftwareItems(searchType, softwareID);
		} else if (searchType.equals("softwareType")) {
			String softwareType = request.getParameter("softwareType");
			result = db.searchSoftwareItems(searchType, softwareType);
		} else if (searchType.equals("softwareName")) {
			String softwareName = request.getParameter("softwareName");
			result = db.searchSoftwareItems(searchType, softwareName);
		} else {
			result = "非法";
		}
		return result;
	}
	/**
	 * 增加一个软件信息到数据库downloadtlb以供下载
	 * @param sofeware
	 * @return true增加成功，否则false
	 */
	public boolean addSoftwareItems(Software software) {
		if (db.addSoftwareItem(software)) {
			return true;
		} else {
			return false;
		}
	}
	
	/**
	 * 在数据库downloadtlb中更新指定软件的信息
	 * @param software
	 * @return true成功更新，否则false
	 */
	public boolean updateSoftwareItems(Software software) {
		if (db.updateSoftwareItem(software)) {
			return true;
		} else {
			return false;
		}
	}
	
	/**
	 * 在数据downloadtlb中移除指定软件
	 * @param software
	 * @return true 成功移除，否则false
	 */
	public int removeSoftwareItems(HttpServletRequest request, HttpServletResponse response) {
		String removeType = request.getParameter("removeType");
		int changedItemsCount = 0;
		if (removeType.equals("softwareID")) {
			String softwareID = request.getParameter("softwareID");//先将ID保存为字符串，数据库操作中在转为整形
			changedItemsCount = db.removeSoftwareItems(removeType, softwareID);
		} else if (removeType.equals("softwareType")) {
			String softwareType = request.getParameter("softwareType");
			changedItemsCount = db.removeSoftwareItems(removeType, softwareType);
		} else if (removeType.equals("softwareName")) {
			String softwareName = request.getParameter("softwareName");
			changedItemsCount = db.removeSoftwareItems(removeType, softwareName);
		} else {
			//do nothing
		}
		return changedItemsCount;
	}
	
}