📄 infoarticlebean.java
字号:
/**********************************************************
Copyright (C),2003-10-21, Beijing USTB.
All rights reserved.
Filename:
Author:
Version 1.0
Date:2004-12-13
Description:
Other:
Variable List:
1.int strID //菜单唯一编号
Function List:
History:
***********************************************************/
package oa.bean;
import java.text.*;
import java.util.*;
import java.lang.*;
import java.io.*;
import java.sql.*;
import oa.main.*;
public class InfoArticleBean extends ParentBean
{
/**
设置某条记录的某个参数值
String table:表名
String tj:更新条件，为空时更新整个数据表
String paramname:更新字段名
String paramvalue:更新字段值
boolean strtype:更新字段的类型，true=数值型 false=字符型
**/
public int setParameter(String table,String tj,String paramname,String paramvalue,boolean strtype)
{
String sql = "";
if(strtype)//参数是数值型
sql = "update " + table + " set "+paramname+"="+paramvalue;
else//参数是字符型
sql = "update " + table + " set "+paramname+"='"+ds.toGBK(paramvalue)+"'";
if(!tj.equals(""))
sql = sql + " where " + tj;
return deleteRecord(sql);
}
/**
查找所有的统一函数
String sql:查询的sql语句
**/
public 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;
}
/**
查找一条记录统一函数
String sql:查询的sql语句
**/
public 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;
}
/**
查询某一属性的值
String table:表名
**/
public String getValue(String table,String field1,String field2,String field3,String value1,String value2,boolean type1,boolean type2)
{
String value = "";
String sql = "";
//只有唯一主键field1
sql = "select "+field1+" from "+table;
//有两个主键field1、field2
if(!value1.equals(""))//当第一个字段不空时，作为条件查询第二个字段
{
sql = "select "+field2+" from "+table+" where "+field1+"="+value1;
if(!type1) //是字符串时 将type1设为false
sql = "select "+field2+" from "+table+" where "+field1+"='"+value1+"'";
}
if(!value2.equals(""))//当第二个字段不空时，作为条件查询第三个字段
{
sql = "select "+field3+" from "+table+" where "+field1+"="+value1+" and "+field2+"="+value2;
if(!type2) //是字符串时 将type1设为false
sql = "select "+field3+" from "+table+" where "+field1+"='"+value1+"' and "+field2+"='"+value2+"'";
}
//Statement stm = conn.createStatement();
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
if(rs.next())
{
value = ds.toString(rs.getString(1));
}
}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 value;
}
/**
取得一页数据
String table:表名
String datascope:查询条件，为空时返回整个数据表的数据
String order:排序字段
int page:返回第几页的数据
**/
public Vector getOnePageData(String table,String datascope,String order,int page) throws Exception
{
Vector vect = new Vector();
String sql = "select * from " + table;
if(!datascope.equals(""))
sql = sql + " where " +datascope;
if(!order.equals(""))
sql = sql + " order by " + order;
//System.out.println(sql);
vect = getOnePage(sql,page,20);
return vect;
}
/**
执行sql语句
String sql:执行的sql语句
**/
public int changeData(String sql)
{
return deleteRecord(sql);
}
/**
生成最大的编号
String table:表名
String id:要查询的字段
String tj:条件
**/
public int MaxNo(String table,String id,String tj) throws Exception
{
int strMaxNo = -1;
String sql = "select max(" + id + ") as mID from " + table;
if(!tj.equals(""))
sql = sql + " where " + tj;
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
while(rs.next())
{
strMaxNo = rs.getInt("mID");
}
}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);}
}
if(strMaxNo==-1)
strMaxNo = 1;
else
strMaxNo = strMaxNo +1;
return strMaxNo;
}
/**
排序
String tablename:表名
String colname:排序字段名
String px:排序字段的插入值
String oldpx:排序字段的原值
String tj:其他条件
**/
public int getPX(String tablename,String colname,String px,String oldpx,String tj)
{
int out = 0;
String sql = "";
if(oldpx.equals(""))
sql = "update "+tablename+" set "+colname+"="+colname+"+1 where "+colname+">="+px;
else
{
int insertOld = Integer.parseInt(oldpx);
int insertNew = Integer.parseInt(px);
if(insertOld < insertNew)
sql = "update "+tablename+" set "+colname+"="+colname+"-1 where "+colname+">"+insertOld+" and "+colname+"<="+insertNew;
else if(insertOld > insertNew)
sql = "update "+tablename+" set "+colname+"="+colname+"+1 where "+colname+"<"+insertOld+" and "+colname+">="+insertNew;
}
if(!tj.equals(""))
sql = sql + " and " + tj;
if(px.equals(oldpx))
sql = "";
if(!sql.equals(""))
out = deleteRecord(sql);
return out;
}
public int operArticle(Hashtable hash) throws Exception//对菜单表数据记录进行增加和修改操作
{
int errcode = 0;
String sql = "";
//int intMax = db.makeID("MENU","ID","","",true);
String strID = ds.toString((String)hash.get("ID"));
String strMENUID = ds.toString((String)hash.get("MENUID"));
String strTITLE = ds.toString((String)hash.get("TITLE"));
String strCONTENT = ds.toString((String)hash.get("CONTENT"));
String strFROMSITE = ds.toString((String)hash.get("FROMSITE"));
String strWRITER = ds.toString((String)hash.get("WRITER"));
String strADDTIME = ds.toString((String)hash.get("ADDTIME"));
String strKEYWORD = ds.toString((String)hash.get("KEYWORD"));
String strIFSHOW = ds.toString((String)hash.get("IFSHOW"));
String strORGID = ds.toString((String)hash.get("ORGID"));
String strMLEVEL = ds.toString((String)hash.get("MLEVEL"));
String strOLDORGID = ds.toString((String)hash.get("OLDORGID"));
String strSTRSIZE = ds.toString((String)hash.get("STRSIZE"));
String strCURSIZE = ds.toString((String)hash.get("CURSIZE"));
String strRECORDID = ds.toString((String)hash.get("RECORDID"));
String strSAVE = ds.toString((String)hash.get("SAVE"));
Vector vect =new Vector();
vect.add("hg2_info_article");
if(strSAVE.equals("ADD"))//增加文章
{
//strADDTIME = ds.getDateTime();
vect.add(addVector("ID",strID,"NUM"));
vect.add(addVector("MENUID",strMENUID,"NUM"));
vect.add(addVector("TITLE",strTITLE,"CHAR"));
vect.add(addVector("FROMSITE",strFROMSITE,"CHAR"));
vect.add(addVector("WRITER",strWRITER,"CHAR"));
vect.add(addVector("ADDTIME",strADDTIME,"CHAR"));
vect.add(addVector("KEYWORD",strKEYWORD,"CHAR"));
vect.add(addVector("IFSHOW",strIFSHOW,"CHAR"));
vect.add(addVector("ORGID",strORGID,"CHAR"));
vect.add(addVector("MLEVEL",strMLEVEL,"CHAR"));
vect.add(addVector("OLDORGID",strOLDORGID,"CHAR"));
vect.add(addVector("STRSIZE",strSTRSIZE,"CHAR"));
vect.add(addVector("CURSIZE",strCURSIZE,"CHAR"));
vect.add(addVector("RECORDID",strRECORDID,"CHAR"));
return insertRecord(vect);
//return UpdateBLOB_JNDI("hg2_info_article","ID="+strID,"CONTENT",strCONTENT);
}
if(strSAVE.equals("MOD"))//增加文章
{
vect.add(addVector("MENUID",strMENUID,"NUM"));
vect.add(addVector("TITLE",strTITLE,"CHAR"));
vect.add(addVector("FROMSITE",strFROMSITE,"CHAR"));
//vect.add(addVector("WRITER",strWRITER,"CHAR"));
//vect.add(addVector("ADDTIME",strADDTIME,"CHAR"));
vect.add(addVector("KEYWORD",strKEYWORD,"CHAR"));
vect.add(addVector("IFSHOW","0","CHAR"));
vect.add(addVector("ORGID",strORGID,"CHAR"));
vect.add(addVector("MLEVEL",strMLEVEL,"CHAR"));
vect.add(addVector("OLDORGID",strOLDORGID,"CHAR"));
vect.add(addVector("STRSIZE",strSTRSIZE,"CHAR"));
vect.add(addVector("CURSIZE",strCURSIZE,"CHAR"));
vect.add(addVector("RECORDID",strRECORDID,"CHAR"));
vect.add("id="+strID);
return updateRecord(vect);
//return UpdateBLOB_JNDI("hg2_info_article","ID="+strID,"CONTENT",strCONTENT);
}
return 0;
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -