product.java

java swing源码 欢迎下载 有问题请联系 我一定负责到底

/**
 * 产品信息
 */
package com.NCL;

import com.sinosoft.common.*;
import java.util.*;

public class Product{

	protected IndexMap propList;	
	protected HashSet Property;
	private List strList = new ArrayList();
	private boolean EOF = false;
	private int COUNT;
	private String StartDate;
	private String EndDate;
	/**
	 * 构造函数
	 *
	 */
	public Product(){
		propList=new IndexMap();
		Property=new HashSet();
		Property.add("ProductID");			//ID
		Property.add("ProductName");		//产品名称
		Property.add("ProductChannel");		//产品渠道
		Property.add("ProductType");		//产品类型
		Property.add("ProductStress");		//重点推荐
		Property.add("ProductCMSURL");		//CMS文章URL		
		Property.add("MakeDate");			//建立时间		
		Property.add("ProductImage");		//产品图片连接地址
	}
	/**
	 * 初始化
	 * @param ProductID	产品ID
	 */
	public void init(String ProductID){
		DBAccess d = new DBAccess();	
		String SQL = "SELECT * from Product where ProductID=?";
		this.propList=d.init(SQL, ProductID, this.Property);
		
	}
	/**
	 * 根据条件查询产品ID
	 * @param prod		对象
	 * @param pageSize	分页大小
	 * @param pageIndex	分页页码
	 * @return String
	 */
	public String find(Product prod,int pageSize,int pageIndex){		
		String result="";
			StringBuffer sql = new StringBuffer("select ProductID from Product where 1=1");	
			if(Data.hasValue(prod.get("ProductName")))
				sql.append(" and ProductName like ?");
			if(Data.hasValue(prod.get("ProductChannel")))
				sql.append(" and ProductChannel=?");
			if(Data.hasValue(prod.get("ProductType")))
				sql.append(" and ProductType like ?");
			if(Data.hasValue(prod.get("ProductStress")))
				sql.append(" and ProductStress=?");			
//			if(Data.hasValue(prod.get("StartDate")))
//				sql.append(" and MakeDate>=to_date('" + Data.formatValue(this.getStartDate())  + "','yyyy-MM-dd')");
//			if(Data.hasValue(prod.get("EndDate")))
//				sql.append(" and MakeDate<=to_date('" + Data.formatValue(this.getEndDate()) + " 23:59:59','yyyy-MM-dd hh24:mi:ss')");
			sql.append(" order by MakeDate desc");
			DBAccess q = new DBAccess();
			result = q.executeQuery(sql.toString(), this.propList, pageSize, pageIndex);
			setCOUNT(q.COUNT);
			setEOF(q.EOF);
			return result;		
	}
	/**
	 * 更新
	 * @return booealn
	 */
	public boolean update(){
		try{
			StringBuffer sql = new StringBuffer("update Product set ");
			List l = new ArrayList();
			for(int i=0;i<strList.size();i++){
				Object[] strArray =(Object[]) strList.get(i);
				sql.append(strArray[0]);
				sql.append("=?,");
				l.add(strArray[1]);
			}
			sql.deleteCharAt(sql.lastIndexOf(","));
			sql.append(" where ProductID=?");
			l.add(this.get("ProductID"));
			strList.clear();
			DBAccess q = new DBAccess();
			return q.executeUpdate(sql.toString(),l);
		}catch(Exception e){
			e.printStackTrace();
			System.out.println("Product.update():" + e.getMessage());
			return false;
		}
	}
	/**
	 * 创建
	 * @return	boolean
	 */
	public boolean create(){
		String sql = "insert into Product(ProductID,ProductName,ProductChannel,ProductType,"
				+"ProductStress,ProductCMSURL,MakeDate,ProductImage)values(?,?,?,?,?,?,sysdate,?)";
		DBAccess q = new DBAccess();
		return q.execute(sql, this.propList);
	}	
	/**
	 * 删除
	 * @param ProductID	产品ID
	 * @return boolean
	 */
	public boolean delete(String ProductID){		
			DBAccess DBA = new DBAccess();			
			StringBuffer SQL = new StringBuffer("delete Product  where ProductID=?");
			return DBA.executeDelete(SQL.toString(), ProductID);
		
	}
	/**
	 * 找产品类型
	 * @param ProductChannel	产品渠道
	 * @param ProdcutType		产品类型
	 * @return	String
	 */
	public String findProductType(String ProductChannel,String ProdcutType){
		//产品类型数组
		//个人
		String[] PersonArray={"分红型保险","保障型寿险","意外险","少儿险","养老保险","健康险","投资型保险","精选组合"};
		String[] PersonIDArray={"90","91","92","93","94","95","96","98"};
		//银行
		String[] BankArray={"保障型寿险","健康险","养老保险","分红型保险","投资型保险","精选组合","意外险"};
		String[] BankIDArray={"99","100","101","102","103","104","178"};
		//团险
		String[] GroupArray={"健康险","寿险","养老保险","精选组合","意外险"};
		String[] GroupIDArray={"105","106","107","108","109"};
		String TypeName="";
		if(ProductChannel.equals("84")){//个险
			for(int i=0;i<PersonIDArray.length;i++){
				if(PersonIDArray[i].equals(ProdcutType)){
					TypeName=PersonArray[i];
					break;
				}
			}
		}
		if(ProductChannel.equals("85")){//银行
			for(int i=0;i<BankIDArray.length;i++){
				if(BankIDArray[i].equals(ProdcutType)){
					TypeName=BankArray[i];
					break;
				}
			}					
		}
		if(ProductChannel.equals("87")){//团险	
			for(int i=0;i<GroupIDArray.length;i++){
				if(GroupIDArray[i].equals(ProdcutType)){
					TypeName=GroupArray[i];
					break;
				}
			}				
		}
		return TypeName;		
	}
	
	/**
	 * 在此映射中关联指定值与指定键
	 * @param name 指定键
	 * @param value 指定值
	 */
	public void setUpdateValue(String name,Object value){
		if(this.set(name,value)){
			Object[] uValue = new Object[2];
			uValue[0] = name;
			uValue[1] = value;
			strList.add(uValue);
		}
	}
	/**
	 * 在此映射中关联指定值与指定键
	 * @param name 指定键
	 * @param value 指定值
	 */
	public boolean set(String name, Object value){
		if(Property.contains(name)){
			propList.put(name,value);
			return true;
		}else
			return false;		
	}
	/**
	 * 返回指定键在此映射中所映射的值
	 * @param name 指定键
	 * @return
	 */
	public String get(String name){
		if (Property.contains(name)){
			String value = (String)propList.get(name);
			if(value != null && !value.equals(""))
				return value;
			else
				return "";
		}else 
			return "";
	}
	/**
	 * 返回COUNT
	 * @return int
	 */
	public int getCOUNT() {
		return COUNT;
	}
	/**
	 * 设置COUNT
	 * @param count
	 */
	public void setCOUNT(int count) {
		COUNT = count;
	}
	/**
	 * 返回EOF
	 * @return boolean
	 */
	public boolean isEOF() {
		return EOF;
	}
	/**
	 * 设置EOF
	 * @param eof
	 */
	public void setEOF(boolean eof) {
		EOF = eof;
	}
	/**
	 * 清空propList
	 *
	 */
	public void clear(){
		propList.clear();
	}
	/**
	 * 获取StartDate
	 * @return String
	 */
	public String getStartDate() {
		return StartDate;
	}
	/**
	 * 设置StartDate
	 * @param startDate 日期
	 */
	public void setStartDate(String startDate) {
		StartDate = startDate;
	}
	/**
	 * 获取EndDate
	 * @return String
	 */
	public String getEndDate() {
		return EndDate;
	}
	/**
	 * 设置EndDate
	 * @param endDate 日期
	 */
	public void setEndDate(String endDate) {
		EndDate = endDate;
	}
}