sysconfbean.java

这是一个很好用的软件

package oa.bean;

import java.util.*;
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);
				}
		}
		return 1;
	}

	//设置FTP
	public int setFtp(String ip) {
		String sql = "";
		String strFtpIP = ip;
		Vector vect = new Vector();
		vect.add("NB_FTPSET");
		vect.add(addVector("FTPIP", strFtpIP, "CHAR"));
		sql = "select * from news.NB_FTPSET";
		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) {