【Java开源代码栏目提醒】:网学会员--在 Java开源代码编辑为广大网友搜集整理了:CustBean.java绩等信息,祝愿广大网友取得需要的信息,参考学习。
/**********************************************************
Copyright (C),2003-10-29, Beijing USTB.
All rights reserved.
Filename: CustBean.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 CustBean 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 Cust";
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 Cust where CustID= "+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 strCustID = makeID_Add1("Cust","CustID","","",true);
String strNodeCode = ds.toString((String)hash.get("NodeCode"));
String strPartnerID = ds.toString((String)hash.get("PartnerID"));
String strCustCode = ds.toString((String)hash.get("CustCode"));
String strCustName = ds.toString((String)hash.get("CustName"));
String strAddress = ds.toString((String)hash.get("Address"));
String strNetUserID = ds.toString((String)hash.get("NetUserID"));
String strDescription = ds.toString((String)hash.get("Description"));
Vector vect = new Vector();
vect.add("Cust");
vect.add(addVector("CustID",strCustID+"","NUM"));
vect.add(addVector("NodeCode",strNodeCode,"CHAR"));
vect.add(addVector("PartnerID",strPartnerID+"","NUM"));
vect.add(addVector("CustCode",strCustCode,"CHAR"));
vect.add(addVector("CustName",strCustName,"CHAR"));
vect.add(addVector("Address",strAddress,"CHAR"));
vect.add(addVector("NetUserID",strNetUserID,"CHAR"));
vect.add(addVector("Description",strDescription,"CHAR"));
return insertRecord(vect);
}
//设置修改模块信息
public int mod(Hashtable hash)
{
String strNodeCode = ds.toString((String)hash.get("NodeCode"));
String strPartnerID = ds.toString((String)hash.get("PartnerID"));
String strCustCode = ds.toString((String)hash.get("CustCode"));
String strCustName = ds.toString((String)hash.get("CustName"));
String strAddress = ds.toString((String)hash.get("Address"));
String strNetUserID = ds.toString((String)hash.get("NetUserID"));
String strDescription = ds.toString((String)hash.get("Description"));
Vector vect = new Vector();
vect.add("Cust");
vect.add(addVector("NodeCode",strNodeCode,"CHAR"));
vect.add(addVector("PartnerID",strPartnerID+"","NUM"));
vect.add(addVector("CustCode",strCustCode,"CHAR"));
vect.add(addVector("CustName",strCustName,"CHAR"));
vect.add(addVector("Address",strAddress,"CHAR"));
vect.add(addVector("NetUserID",strNetUserID,"CHAR"));
vect.add(