?? sysconfbean.java
字號:
/**********************************************************
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;//系統(tǒng)設置的類型
2.String id = "-1"//記錄唯一編號
Function List:
1.public void setType(String t)//設置所設置的系統(tǒng)類型
2.public void setID(String i)//設置記錄唯一編號
3.public Vector getData()//取得數(shù)據(jù)表內(nèi)容
4.public Hashtable getOneData()//取得數(shù)據(jù)表中的某一條記錄
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";
//設置系統(tǒng)管理類型
public void setType(int t)
{
type = t;
}
//設置記錄唯一編號
public void setID(String i)
{
id = i;
}
//取得數(shù)據(jù)表內(nè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{
//取得列數(shù)和列名
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;
}
//取得數(shù)據(jù)表中的某一條記錄
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"));
//檢驗是否已經(jīng)存在
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+" ");
//檢驗是否已經(jīng)存在
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);}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -