sysconfbean.java

在系统开发过程中用到了javabean和jsp技术

/**********************************************************
Copyright (C),2003-10-29, Beijing  USTB.
All rights reserved.
Filename: SysConfBean.java
Author: 邹晨
Version 1.0
Date:2003-10-29
Description:
Other:
Variable List:
1.int type = 0;//系统设置的类型
2.String id = "-1"//记录唯一编号

Function List:
1.public void setType(String t)//设置所设置的系统类型
2.public void setID(String i)//设置记录唯一编号

3.public Vector getData()//取得数据表内容
4.public Hashtable getOneData()//取得数据表中的某一条记录

5.public int setPic(Hashtable hash)//设置图片
6.public int addMain(Hashtable hash)//新增模块信息
7.public int modMain(Hashtable hash)//修改模块信息

8.public int setFtp(String ip)//设置FTP

9.public int addCss(Hashtable hash)//增加CSS样式表信息

10.public int modCss(Hashtable hash)//修改CSS样式表信息

11.public int delData()//删除信息

12.public int toId(String name)//把模块名称转化为模块编号
13.public String toName(int id)//把模块编号转化为模块名称

14.public void newCssFile(Hashtable hash)//生成css文件
15.public Hashtable getCSSCOLOR(String path,String cssfile)//取得css文件中颜色值
16.public void initMain()//初始化，模块信息


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

import java.text.*;
import java.util.*;
import java.lang.*;
import java.io.*;
import java.sql.*;
import oa.main.*;

public class SysConfBean extends ParentBean
{
	int type = 0;
	String id = "-1";

	//设置系统管理类型
	public void setType(int t)
	{
		type = t;
	}

	//设置记录唯一编号
	public void setID(String i)
	{
		id = i;
	}

	//取得数据表内容
	public Vector getData()
	{
		Vector vect = new Vector();
		String sql = "";

		switch (type)
		{
			case 13: sql = " select * from news.NB_TPSZB";break;
			case 14: sql = " select * from news.NB_ZYSZB order by Id ";break;
			case 15: sql = " select * from news.NB_YSB order by Id ";break;
			case 16: sql = " select * from news.NB_FTPSET";break;
			case 17: sql = " select * from news.COMCONFB";break;
			case 21: sql = " select * from news.NB_LINK order by XH";break;
			default:break;
		}

		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;
	}

	//取得数据表中的某一条记录
	public Hashtable getOneData()
	{
		Hashtable hash = new Hashtable();
		String sql = "";

		switch (type)
		{
			case 13: sql = " select * from news.NB_TPSZB ";break;
			case 14: sql = " select * from news.NB_ZYSZB where Id = "+id;break;
			case 15: sql = " select * from news.NB_YSB where Id = "+id;break;
			case 16: sql = " select * from news.NB_FTPSET";break;
			case 17: sql = " select * from news.COMCONFB";break;
			case 21: sql = " select * from news.NB_LINK where LINKID= "+id;break;
			default:break;
		}

		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;
	}

	//设置图片
	public int setPic(Hashtable hash)
	{
		String sql = "";
		String strNum = ds.toString((String)hash.get("NUM"));
		String strHeight = ds.toString((String)hash.get("HEIGHT"));
		String strWidth = ds.toString((String)hash.get("WIDTH"));

		Vector vect = new Vector();
		vect.add("NB_TPSZB");
		vect.add(addVector("NUM",strNum,"NUM"));
		vect.add(addVector("HEIGHT",strHeight,"NUM"));
		vect.add(addVector("WIDTH",strWidth,"NUM"));

		sql = "select * from news.NB_TPSZB";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
		if(!rs.next())
		{
			return insertRecord(vect);
		}
		}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);}
		}
		sql = "update news.NB_TPSZB set Num = "+strNum+",HEIGHT = "+strHeight+",WIDTH = "+strWidth+"";
		executeUpdate(sql);
		return 0;
		//return updateRecord(vect);
	}

	//设置新增模块信息
	public int addMain(Hashtable hash)
	{
		String strId = ds.toString((String)hash.get("ID"));
		String strNum = ds.toString((String)hash.get("NUM"));
		String strIsShowtime = ds.toString((String)hash.get("ISSHOWTIME"));

		Vector vect = new Vector();
		vect.add("NB_ZYSZB");
		vect.add(addVector("ID",strId,"NUM"));
		vect.add(addVector("NUM",strNum,"NUM"));
		vect.add(addVector("ISSHOWTIME",strIsShowtime,"NUM"));
		String sql = "select * from news.NB_ZYSZB where ID="+strId+"";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
			if(rs.next())
				return 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 insertRecord(vect);
	}

	//设置修改模块信息
	public int modMain(Hashtable hash)
	{
		String strNum = ds.toString((String)hash.get("NUM"));
		String strIsShowtime = ds.toString((String)hash.get("ISSHOWTIME"));
		Vector vect = new Vector();
		vect.add("NB_ZYSZB");
		vect.add(addVector("NUM",strNum,"NUM"));
		vect.add(addVector("ISSHOWTIME",strIsShowtime,"NUM"));
		vect.add("ID="+id+"");
		return updateRecord(vect);
	}



	//增加主页链接信息
	public int addLink(Hashtable hash)
	{
		int intId = db.makeID("NB_LINK","LINKID","","",true);
		String strNAME  = ds.toString((String)hash.get("LINKNAME"));
		String strADDR = ds.toString((String)hash.get("LINKADDRESS"));
		String strSTATE	= ds.toString((String)hash.get("STATE"));
		String strXH = ds.toString((String)hash.get("XH"));

		Vector vect =new Vector();
		vect.add("NB_LINK");
		vect.add(addVector("LINKID",intId+"","NUM"));
		vect.add(addVector("LINKNAME",strNAME,"CHAR"));
		vect.add(addVector("LINKADDRESS",strADDR,"CHAR"));
		vect.add(addVector("STATE",strSTATE,"NUM"));
		vect.add(addVector("XH",strXH,"NUM"));

		//检验是否已经存在
		ResultSet rs = selectRecord("select LINKID from news.NB_LINK where LINKNAME='"+strNAME+"'");
		Statement stmt = null;
		try{
			if(!rs.next())
			{
				int t =  insertRecord(vect);
				setSort("NB_LINK","XH","LINKID","","order by XH,LINKID",true);
				return t;
			}
		}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 1;
	}

	//修改主页链接信息
	public int modLink(Hashtable hash)
	{
		String strNAME  = ds.toString((String)hash.get("LINKNAME"));
		String strADDR = ds.toString((String)hash.get("LINKADDRESS"));
		String strSTATE	= ds.toString((String)hash.get("STATE"));
		String strXH = ds.toString((String)hash.get("XH"));

		Vector vect = new Vector();
		vect.add("NB_LINK");
		vect.add(addVector("LINKNAME",strNAME,"CHAR"));
		vect.add(addVector("LINKADDRESS",strADDR,"CHAR"));
		vect.add(addVector("STATE",strSTATE,"NUM"));
		vect.add(addVector("XH",strXH,"NUM"));
		vect.add(" LINKID="+id+" ");

		//检验是否已经存在
		ResultSet rs = selectRecord("select LINKID from news.NB_LINK where LINKNAME='"+strNAME+"' and LINKID<>"+id);
		Statement stmt = null;
		try{
			if(!rs.next())
			{
				int t =  updateRecord(vect);
				setSort("NB_LINK","XH","LINKID","","order by XH,LINKID",true);
				return t;
			}
		}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);}
		}