personbean.java

这是一个用jsp+Oracle开发的联系人客户关系管理系统！

/**********************************************************
Copyright (C),2003-10-29, Beijing  USTB.
All rights reserved.
Filename: Person.java
Author: 
Version 1.0
Date:2004-3-4
Description:
Other:
Variable List:
1.String id = "-1"//记录唯一编号

Function List:
2.public Vector getData()//取得数据表内容
3.public Hashtable getOneData()//取得数据表中的某一条记录
4.public int add(Hashtable hash)//新增模块信息
5.public int mod(Hashtable hash)//修改模块信息
6.public int delData()//删除信息

7.public int toId(String name)//把模块名称转化为模块编号
8.public String toName(int id)//把模块编号转化为模块名称

History:
***********************************************************/
package com.bean;

import java.text.*;
import java.util.*;
import java.lang.*;
import java.io.*;
import java.sql.*;
import com.db.*;

public class PersonBean extends ParentBean
{
	String id = "-1";

	//设置记录唯一编号
	public void setID(String i)
	{
		id = i;
	}

	//取得数据表内容
	public Vector getData() throws Exception
	{
		Vector vect = new Vector();
		String sql = sql = " select * from Person";

		ResultSet rs = selectRecord(sql);

		//取得列数和列名
		ResultSetMetaData rsmd = rs.getMetaData();
		int cols = rsmd.getColumnCount();
		while(rs.next())
		{	
			Hashtable hash = new Hashtable();
			for(int i=1;i<=cols;i++)
			{
				String field = ds.toString(rsmd.getColumnName(i));
				String value = ds.toString(rs.getString(i));
				hash.put(field,value);
			}
			vect.add(hash);
		}
		rs.close(); Statement stmt = rs.getStatement(); if(stmt!=null) stmt.close();		
		return vect;
	}

	//取得数据表中的某一条记录
	public Hashtable getOneData() throws Exception
	{
		Hashtable hash = new Hashtable();
		String sql = " select * from Person where PersonID= "+id;

		ResultSet rs = selectRecord(sql);
		ResultSetMetaData rsmd = rs.getMetaData();
		int cols = rsmd.getColumnCount();
		if (rs.next())
		{
			for(int i=1;i<=cols;i++)
			{
				String field = ds.toString(rsmd.getColumnName(i));
				String value = ds.toString(rs.getString(i));
				hash.put(field,value);
			}
		}
		rs.close(); Statement stmt = rs.getStatement(); if(stmt!=null) stmt.close();
		return hash;
	}

	//设置新增模块信息
	public int add(Hashtable hash)
	{			
		int strPersonID = makeID_Add1("Person","PersonID","","",true);
		String strPersonName = ds.toString((String)hash.get("PersonName"));
		String strTeleNO = ds.toString((String)hash.get("TeleNO"));
		String strEmailAddress = ds.toString((String)hash.get("EmailAddress"));
		String strMobileNO = ds.toString((String)hash.get("MobileNO"));
		String strPasNO = ds.toString((String)hash.get("PasNO"));

		Vector vect = new Vector();
		vect.add("Person");
		vect.add(addVector("PersonID",strPersonID+"","NUM"));
		vect.add(addVector("PersonName",strPersonName,"CHAR"));
		vect.add(addVector("TeleNO",strTeleNO,"CHAR"));
		vect.add(addVector("EmailAddress",strEmailAddress,"CHAR"));
		vect.add(addVector("MobileNO",strMobileNO,"CHAR"));
		vect.add(addVector("PasNO",strPasNO,"CHAR"));
		return insertRecord(vect);	
	}
	
	//设置修改模块信息
	public int mod(Hashtable hash)
	{
		String strPersonName = ds.toString((String)hash.get("PersonName"));
		String strTeleNO = ds.toString((String)hash.get("TeleNO"));
		String strEmailAddress = ds.toString((String)hash.get("EmailAddress"));
		String strMobileNO = ds.toString((String)hash.get("MobileNO"));
		String strPasNO = ds.toString((String)hash.get("PasNO"));

		Vector vect = new Vector();
		vect.add("Person");
		vect.add(addVector("PersonName",strPersonName,"CHAR"));
		vect.add(addVector("TeleNO",strTeleNO,"CHAR"));
		vect.add(addVector("EmailAddress",strEmailAddress,"CHAR"));
		vect.add(addVector("MobileNO",strMobileNO,"CHAR"));
		vect.add(addVector("PasNO",strPasNO,"CHAR"));
		vect.add("PersonID="+id+"");

		return updateRecord(vect);	
	}

	//删除信息
	public int delData()
	{
		String sql = "delete from Person where PersonID = "+id;
		return deleteRecord(sql);
	}

	//把模块名称转化为模块编号
	public String toId(String name)
	{
		return ""+toID("Person","PersonName","PersonID",name);
	}

	//把模块编号转化为模块名称
	public String toName(String id)
	{		
		return toName("Person","PersonID","PersonName",id);
	}	

	public static void main(String args[]) throws Exception
	{
		
		PersonBean mb = new PersonBean();
		
		mb.setID("3");
		System.out.println("begin\r\n\r\n");
		
		Hashtable hash= new Hashtable();
		hash.put("PersonName","张华");
		hash.put("TeleNO","13811113914");
		hash.put("EmailAddress","[e-mail]");
		hash.put("MobileNO","000000000");
		hash.put("PasNO","666666666");
		mb.mod(hash);
		


		System.out.println(mb.getData());

		System.out.println("\r\n\r\nend");
	}
}