【Java开源代码栏目提醒】:网学会员Java开源代码为您提供PunishBean.java参考,解决您在PunishBean.java学习中工作中的难题,参考学习。
/**********************************************************
Copyright (C),2004-8-13, Beijing USTB.
All rights reserved.
Filename: RuleBean.java
Author: 邹晨
Version 1.0
Date:2004-8-19
Description:惩罚管理
Other:
Variable List:
Function List:
History:
***********************************************************/
package kjb2.library.bean;
import java.text.*;
import java.util.*;
import java.lang.*;
import java.io.*;
import java.sql.*;
import kjb.main.*;
public class PunishBean extends ParentBean
{
private String id = "-1";
//设置惩罚ID
public void setID(String i)
{
id = i;
}
//取得所有信息内容
public Vector getData()
{
String sql = "";
sql = "select * from KJB2_KJXX_CFB order by CFID";
return searchData(sql);
}
//分页取得所有信息
public Vector getPageData(int page)
{
String sql ="";
sql = "select * from KJB2_KJXX_CFB order by CFID";
return getOnePage(sql,page,20);
}
//根据惩罚的详细信息
public Hashtable getOneData(String id)
{
String sql="";
sql = "select * from KJB2_KJXX_CFB where CFID="+id+"";
return searchOneData(sql);
}
//新增惩罚
public int addRule(Hashtable hash)
{
int intID = makeID("KJB2_KJXX_CFB","CFID","","",true);
String strREADERID = ds.toString((String)hash.get("READERID"));
String strBOOKID = ds.toString((String)hash.get("BOOKID"));
String strCFYY = ds.toString((String)hash.get("CFYY"));
String strCFJG = ds.toString((String)hash.get("CFJG"));
String strFKJE = ds.toString((String)hash.get("FKJE"));
String strZT = ds.toString((String)hash.get("ZT"));
Vector vect = new Vector();
vect.add("KJB2_KJXX_CFB");
vect.add(addVector("CFID",String.valueOf(intID),"NUM"));
vect.add(addVector("READERID",strREADERID,"NUM"));
vect.add(addVector("BOOKID",strBOOKID,"NUM"));
vect.add(addVector("CFYY",strCFYY,"CHAR"));
vect.add(addVector("CFJG",strCFJG,"CHAR"));
vect.add(addVector("FKJE",strFKJE,"NUM"));
vect.add(addVector("ZT",strZT,"CHAR"));
return insertRecord(vect);
}
//修惩罚信息
public int modRule(Hashtable hash)
{
String strCFID = ds.toString((String)hash.get("CFID"));
String strCFYY = ds.toString((String)hash.get("CFYY"));
String strCFJG = ds.toString((String)hash.get("CFJG"));
String strFKJE = ds.toString((String)hash.get("FKJE"));
String strZT = ds.toString((String)hash.get("ZT"));
Vector vect = new Vector();
vect.add("KJB2_KJXX_CFB");
vect.add(addVector("CFYY",strCFYY,"CHAR"));
vect.add(addVector("CFJG",strCFJG,"CHAR"));
vect.add(addVector("FKJE",strFKJE,"NUM"));
vect.add(addVector("ZT",strZT,"CHAR"));
vect.add("CFID = "+strCFID);
return updateRecord(vect);
}
//查找所有的统一函数
private Vector searchData(String sql)
{
Vector vect = new Vector();
ResultSet rs = selectRecord(sql);
//取得列数和列名
Statement stmt = null;
try{
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);
}
}catch(Exception e){System.out.println("运行时出错:"+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}
}
return vect;
}
//查找一条记录统一函数
private Hashtable searchOneData(String sql)
{
Hashtable hash = new Hashtable();
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
//取得列数和列名
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);
}
}
}catch(Exception e){System.out.println("运行时出错:"+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}
}
return hash;
}
}
上一篇:
PullSupplier.java
下一篇:
美国emba教育概况及其借鉴意义