/**********************************************************
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","zhanghua@263.net");
		hash.put("MobileNO","000000000");
		hash.put("PasNO","666666666");
		mb.mod(hash);
		


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

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