/**********************************************************
Copyright (C),2003-10-29, Beijing  USTB.
All rights reserved.
Filename: RationalBean.java
Author: 
Version 1.0
Date:2004-3-4
Description:
Other:
Variable List:
1.String id = "-1"//記錄唯一編號

Function List:
1.public Vector getData()//取得數據表內容
2.public Vector getOneData()//取得數據表內容
3.public int mod(Hashtable hash)//修改模塊信息


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

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

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

	//設置記錄唯一編號
	public void setID(String i)
	{
		id = i;
	}

	//取得數據表內容
	public Vector getData() throws Exception
	{
		Vector vect = new Vector();
		String sql = " select A.PersonID,A.PersonName,B.CustID,B.CustName "
					+" from Person A,Cust B,CustRelaPerson C "
					+" where A.PersonID=C.PersonID "
					+"   and B.CustID=C.CustID";
		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);
		}

		sql = " select PersonID,PersonName "
				+" from Person "
				+" where PersonID not in (select PersonID from CustRelaPerson)";

		rs = selectRecord(sql);

		//取得列數和列名
		rsmd = rs.getMetaData();
		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);
			}
			hash.put("CUSTID","");
			hash.put("CUSTNAME","");
			vect.add(hash);
		}
		rs.close(); Statement stmt = rs.getStatement(); if(stmt!=null) stmt.close();		
		return vect;
	}

	//取得數據表內容
	public Vector getOneData() throws Exception
	{
		Vector vect = new Vector();
		String sql = sql = " select A.CustID from CustRelaPerson A,Person B,Cust C where A.PersonID= "+id+" and A.PersonID=B.PersonID and A.CustID=C.CustID";

		ResultSet rs = selectRecord(sql);

		//取得列數和列名
		ResultSetMetaData rsmd = rs.getMetaData();
		int cols = rsmd.getColumnCount();
		while(rs.next())
		{	
			vect.add(ds.toString(rs.getString(1)));
		}
		rs.close(); Statement stmt = rs.getStatement(); if(stmt!=null) stmt.close();		
		return vect;
	}

	//設置修改模塊信息
	public int mod(Vector v)
	{
		//先清除原有數據
		deleteRecord("delete from CustRelaPerson where PersonID="+id);

		for(int i=0;i<v.size();i++)
		{
			Vector vect = new Vector();
			vect.add("CustRelaPerson");
			vect.add(addVector("PersonID",id,"NUM"));
			vect.add(addVector("CustID",(String)v.get(i),"NUM"));
			insertRecord(vect);
		}

		return 0;	
	}

		

	public static void main(String args[]) throws Exception
	{
		
		RelationBean mb = new RelationBean();
		
		System.out.println("begin\r\n\r\n");
		
		Hashtable hash= new Hashtable();
		
/*
		hash.put("NodeCode","node");
		hash.put("PartnerID","44");
		hash.put("RationalCode","Rationalcode");
		hash.put("RationalName","更新");
		hash.put("Address","beijing");
		hash.put("NetUserID","88");
		hash.put("Description","better");
		mb.mod(hash);
		
*/
		//mb.setID("3");
		Vector v = new Vector();
		v.add("1");
		v.add("2");
		v.add("3");
		//mb.mod(v);

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

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