aasx1.java

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

/**
 * 用户信息管理
 */
package com.NCL;

import java.util.*;

import com.sinosoft.common.*;

public class AASX1 {

	/**
	 * @param args
	 * @author Vincent	 * 
	 */
	protected IndexMap propList;
	protected HashSet Property;
	private List strList = new ArrayList();
	private boolean EOF = false;
	private int COUNT;
	/**
	 * 构造函数
	 *
	 */
	public AASX1(){
		propList = new IndexMap();
		Property = new HashSet();
		Property.add("ID");		    //自增长ID （主键）
		Property.add("NAME");		//姓名
		Property.add("SEX");		//性别 1-男 2-女
		Property.add("BIRTHDAY");	//出生日期
		Property.add("IDTYPE");		//证件类型 1-身份证 2-军官证 3-护照 4-其他
		Property.add("IDNO");		//证件号码
		Property.add("ADDRESS");	//联系地址
		Property.add("ZIPCODE");	//邮政编码
		Property.add("PHONE");		//联系电话
		Property.add("EMAIL");		//电子邮件
		Property.add("MAKEDATE");	//创建日期
	}
	/**
	 * 初始化
	 * @param id 自增长ID
	 */
	public void init(String id){
		DBAccess d  = new DBAccess();
		String sql = "SELECT * from AASX1 where ID=?";
		this.propList = d.init(sql,id,this.Property);	
	}
	/**
	 * 创建
	 * @return boolean
	 */
	public boolean create(){
		DBAccess d = new DBAccess();
		String sql = "INSERT into AASX1(ID,NAME,SEX,BIRTHDAY,IDTYPE,IDNO,ADDRESS,ZIPCODE,PHONE,EMAIL,MAKEDATE) values(AASX1ID_SQE.nextval,?,?,?,?,?,?,?,?,?,SYSTEMDATE)";
		return d.execute(sql, this.propList);
	}
	/**
	 * 更新
	 * @return boolean
	 */
	public boolean update(){
		try{
			StringBuffer sql = new StringBuffer("UPDATE AASX1 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 ID=?");
			l.add(this.get("ID"));
			strList.clear();
			DBAccess q = new DBAccess();
			return q.executeUpdate(sql.toString(),l);
		}catch(Exception e){
			e.printStackTrace();
			System.out.println("AASX1.update():" + e.getMessage());
			return false;
		}
	}
	/**
	 * 删除
	 * @param id 自增长ID
	 * @return boolean
	 */
	public boolean delete(String id){
		DBAccess DBA= new DBAccess();
		String SQL = "DELETE from AASX1 WHERE ID=?";		
		return DBA.executeDelete(SQL,id);
	}
	/**
	 * 根据条件查询
	 * @param I			对象
	 * @param pageSize	分页大小
	 * @param pageIndex	分页页码
	 * @return String
	 */
	public String find(AASX1 I,int pageSize,int pageIndex){
		String result="";
		String name = I.get("NAME");
		String sex = I.get("SEX");
		String birthdayBegin = I.get("BIRTHDAYBEGIN");
		String birthdayEnd = I.get("BIRTHDAYEND");
		String idtype = I.get("IDTYPE");
		String idno = I.get("IDNO");
		String address = I.get("ADDRESS");
		String zipcode = I.get("ZIPCODE");
		String phone = I.get("PHONE");
		String email = I.get("EMAIL");
		String makedateBegin = I.get("MAKEDATEBEGIN");
		String makedateEnd = I.get("MAKEDATEEND");
		StringBuffer sql = new StringBuffer("SELECT ID from AASX1 where 1=1");	
		if(Data.hasValue(name))
			sql.append(" and NAME like ?");
		if(Data.hasValue(sex))
			sql.append(" and SEX=?");
		if(Data.hasValue(birthdayBegin) & Data.hasValue(birthdayEnd))
			sql.append(" and BIRTHDAY between ? AND ?");
		if(Data.hasValue(idtype))
			sql.append(" and IDTYPE=?");
		if(Data.hasValue(idno))
			sql.append(" and IDNO like ?");
		if(Data.hasValue(address))
			sql.append(" and ADDRESS like ?");
		if(Data.hasValue(zipcode))
			sql.append(" and ZIPCODE like ?");
		if(Data.hasValue(phone))
			sql.append(" and PHONE like ?");
		if(Data.hasValue(email))
			sql.append(" and EMAIL like ?");
		if(Data.hasValue(makedateBegin) & Data.hasValue(makedateEnd))
			sql.append(" and MAKEDATE between ? AND ?");
		sql.append(" order by ID desc");
		DBAccess q = new DBAccess();
		result = q.executeQuery(sql.toString(), this.propList, pageSize, pageIndex);
		setCOUNT(q.COUNT);
		setEOF(q.EOF);
		return result;	
	}
	
	/**
	 * 在此映射中关联指定值与指定键
	 * @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();
	}
	public static void main(String[] args) {
		 AASX1 aasx1= new AASX1(); 
		 //the first data
		 aasx1.set("NAME","张三");
		 aasx1.set("SEX","1");
		 aasx1.set("BIRTHDAY","19801006");
		 aasx1.set("IDTYPE","1");
		 aasx1.set("IDNO","110102198010060023");
		 aasx1.set("ADDRESS","aaaa");
		 aasx1.set("ZIPCODE","100050");
		 aasx1.set("PHONE","13671234352");
		 aasx1.set("EMAIL","[e-mail]");
		 aasx1.set("MAKEDATE","20080715");
		 boolean da1 = aasx1.create();
		 if (!da1)
			 System.out.println("第一条数据创建失败！");
		 aasx1.clear();
		 //the second data
		 aasx1.set("NAME","李四");
		 aasx1.set("SEX","2");
		 aasx1.set("BIRTHDAY","19741029");
		 aasx1.set("IDTYPE","1");
		 aasx1.set("IDNO","110102197410290029");
		 aasx1.set("ADDRESS","aabb");
		 aasx1.set("ZIPCODE","100023");
		 aasx1.set("PHONE","13341256954");
		 aasx1.set("EMAIL","[e-mail]");
		 aasx1.set("MAKEDATE","20080715");
		 boolean da2 = aasx1.create();
		 if (!da2)
			 System.out.println("第二条数据创建失败！");
		 aasx1.clear();
		 aasx1.set("NAME","李"); //need changed!! //dujh修改 2008年7月15
		 System.out.println(aasx1.find(aasx1,1,1));
		 //update
		 aasx1.setUpdateValue("ID","1");//dujh修改
		 aasx1.setUpdateValue("NAME","李三");
		 boolean da3 = aasx1.update();
		 if (!da3)
			 System.out.println("update success！");
         //delete
		 boolean da4 = aasx1.delete("1");
		 if (!da4)
			 System.out.println("delete success！");
	}
}