member.java

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

/**
 * 客户信息
 */
package com.NCL;

import com.NCL.axis.Customer;
import com.sinosoft.common.*;
import java.util.*;
import org.dom4j.Element;

public class Member extends Object{
	protected IndexMap propList;	
	protected HashSet Property;
	private List strList = new ArrayList();
	private String errorStr = "";      
	private boolean EOF = false;
	private int COUNT;
	protected String fMakeDate = "";
	protected String tMakeDate = "";
	protected String fBirthday = "";
	protected String tBirthday = "";
	private static final Random RANDOM = new Random();
	/**
	 * 构造函数
	 *
	 */
	public Member(){
		propList=new IndexMap();
		Property=new HashSet();
		Property.add("MemberName");		//客户姓名		
		Property.add("Sex");			//性别	
		Property.add("Birthday");		//出生日期	
		Property.add("IDType");			//证件类型
		Property.add("IDNumber");	    //证件号码
		Property.add("PolicyIDType");	//保单号码类型	
		Property.add("PolicyIDNumber"); //保单号码
		Property.add("MemberID");      	//登陆帐号
		Property.add("Password");   	//密码
		Property.add("NickName");  		//昵称
		Property.add("Province");     	//居住省市
		Property.add("Occupation");		//所在行业
		Property.add("Income");			//年收入
		Property.add("TelePhone");		//电话
		Property.add("MobilePhone");	//手机
		Property.add("Email");			//电子邮件 
		Property.add("ZipCode");		//邮政编码
		Property.add("PostalAddress");	//联系地址
		Property.add("MakeDate");  		//注册日期
		Property.add("CustomerNo");		//客户号
	}
	/**
	 * 获取fMakeDate
	 * @return String
	 */
	public String getfMakeDate() {
		return fMakeDate;
	}
	/**
	 * 设置fMakeDate
	 * @param str 日期
	 */
	public void setfMakeDate(String str) {
		fMakeDate = str;
	}
	/**
	 * 获取tMakeDate
	 * @return String
	 */
	public String gettMakeDate() {
		return tMakeDate;
	}
	/**
	 * 设置tMakeDate
	 * @param str 日期
	 */
	public void settMakeDate(String str) {
		tMakeDate = str;
	}
	/**
	 * 获取fBirthday
	 * @return String
	 */
	public String getfBirthday() {
		return fBirthday;
	}
	/**
	 * 设置fBirthday
	 * @param str 日期
	 */
	public void setfBirthday(String str) {
		fBirthday = str;
	}
	/**
	 * 获取tBirthday
	 * @return String
	 */
	public String gettBirthday() {
		return tBirthday;
	}
	/**
	 * 设置tBirthday
	 * @param str 日期
	 */
	public void settBirthday(String str) {
		tBirthday = str;
	}
	/**
	 * 设置errorStr
	 * @param tmp
	 */
	public void setErrorStr(String tmp){
		errorStr = tmp;
	}
	/**
	 * 获取errorStr
	 * @return String
	 */
	public String getErrorStr(){
		return errorStr;
	}
	
	/**
	 * 在此映射中关联指定值与指定键
	 * @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();
	}
	/**
	 * 初始化
	 * @param CustomerNo 客户号
	 */
	public void init(String CustomerNo){
		DBAccess d  = new DBAccess();
		String sql = "SELECT * from members where CustomerNo=?";
		this.propList = d.init(sql,CustomerNo,this.Property);	
	}
	/**
	 * 创建
	 * @return boolean
	 */
	public boolean create(){
		String sql = "INSERT into members values (?,?,to_date(?,'yyyy-MM-dd'),?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,sysdate,?)";
		DBAccess d  = new DBAccess();
		return d.execute(sql,this.propList);
	}
	/**
	 * 更新
	 * @return boolean
	 */
	public boolean update(){
		StringBuffer sql = new StringBuffer("update Members 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 CustomerNo=?");
		l.add(this.get("CustomerNo"));
		strList.clear();
		DBAccess q = new DBAccess();
		return q.executeUpdate(sql.toString(),l);
	}
	/**
	 * 根据条件查询
	 * @param cm		对象
	 * @param pageSize	分页大小
	 * @param pageIndex	分页页码
	 * @return String
	 */
	public String find(Member cm,int pageSize,int pageIndex){
		String MemberName = cm.get("MemberName");
		String Sex = cm.get("Sex");                             //0 1
		String IDType = cm.get("IDType");                       //0 1 2 3 4 5 6 7
		String IDNumber = cm.get("IDNumber");
		String PolicyIDType = cm.get("PolicyIDType");           //0 1
		String PolicyIDNumber = cm.get("PolicyIDNumber");
		String MemberID = cm.get("MemberID");
		String NickName = cm.get("NickName");
		String Province = cm.get("Province");                   //省代码，由PlaceCode().getProOption()产生
		String Occupation = cm.get("Occupation");  
		String Income = cm.get("Income");
		String TelePhone = cm.get("TelePhone");
		String MobilePhone = cm.get("MobilePhone");
		String Email = cm.get("Email");
		String ZipCode = cm.get("ZipCode");
		String PostalAddress = cm.get("PostalAddress");
		String CustomerNo = cm.get("CustomerNo");
		String fBirthday = cm.getfBirthday();
		String tBirthday = cm.gettBirthday();
		String fMakeDate = cm.getfMakeDate();
		String tMakeDate = cm.gettMakeDate();
		if(Data.hasValue(fBirthday) && fBirthday.length()!=10)return "";
		if(Data.hasValue(tBirthday) && tBirthday.length()!=10)return "";
		if(Data.hasValue(fMakeDate) && fMakeDate.length()!=10)return "";
		if(Data.hasValue(tMakeDate) && tMakeDate.length()!=10)return "";
		StringBuffer SQL = new StringBuffer("SELECT CustomerNo from Members where 1=1");
		if(Data.hasValue(MemberName))
			SQL.append(" and MemberName=?");
		if(Data.hasValue(Sex))
			SQL.append(" and Sex=?");
		if(Data.hasValue(IDType))
			SQL.append(" and IDType=?");
		if(Data.hasValue(IDNumber))
			SQL.append(" and IDNumber=?");
		if(Data.hasValue(PolicyIDType))
			SQL.append(" and PolicyIDType=?");
		if(Data.hasValue(PolicyIDNumber))
			SQL.append(" and PolicyIDNumber=?");
		if(Data.hasValue(MemberID))
			SQL.append(" and MemberID=?");
		if(Data.hasValue(NickName))
			SQL.append(" and NickName=?");
		if(Data.hasValue(Province))
			SQL.append(" and Province=?");
		if(Data.hasValue(Occupation))
			SQL.append(" and Occupation=?");
		if(Data.hasValue(Income))
			SQL.append(" and Income=?");
		if(Data.hasValue(TelePhone))
			SQL.append(" and TelePhone=?");
		if(Data.hasValue(MobilePhone))
			SQL.append(" and MobilePhone=?");
		if(Data.hasValue(Email))
			SQL.append(" and Email=?");
		if(Data.hasValue(ZipCode))
			SQL.append(" and ZipCode=?");
		if(Data.hasValue(PostalAddress))
			SQL.append(" and PostalAddress=?");
		if(Data.hasValue(CustomerNo))
			SQL.append(" and CustomerNo=?");
		if(Data.hasValue(fBirthday))
			SQL.append(" and Birthday>=to_date('" + fBirthday + "','yyyy-MM-dd')");
		if(Data.hasValue(tBirthday))
			SQL.append(" and Birthday<=to_date('" + tBirthday + " 23:59:59','yyyy-MM-dd hh24:mi:ss')");
		if(Data.hasValue(fMakeDate))
			SQL.append(" and MakeDate>=to_date('" + fMakeDate + "','yyyy-MM-dd')");
		if(Data.hasValue(tMakeDate))
			SQL.append(" and MakeDate<=to_date('" + tMakeDate + " 23:59:59','yyyy-MM-dd hh24:mi:ss')");