mainbean.java

这是一个很好用的软件

package oa.bean;

import java.util.*;
import java.util.Date;
import java.sql.*;
import oa.main.*;
import javax.swing.tree.DefaultMutableTreeNode;

public class MainBean extends ParentBean {

	String id1 = "-1";//记录唯一编号

	String id2 = "-1";//记录唯一编号

	//设置一级菜单号码
	public void setId1(String d1) {
		id1 = d1;
	}

	//设置二级菜单号码
	public void setId2(String d2) {
		id2 = d2;
	}

	//搜索文章keyword:关键字,s1:标题或关键字,s2:时间
	public Vector search(String keyword, String s1, String s2) {
		String sql = "";
		String temp[] = ds.splitStr(keyword, ' ');
		String sql1 = "";
		for (int i = 0; i < temp.length; i++) {
			if (temp[i].trim().length() == 0)
				continue;
			if (!sql1.equals(""))
				sql1 += " or ";
			if (s1.equals("1") || s1.equals(""))
				sql1 += " TITLE like '%" + temp[i] + "%' ";
			if (s1.equals("2"))
				sql1 += " KEYWORD like '%" + temp[i] + "%' ";
		}
		sql = "select ID,MENUID,TITLE,TOPICID,FROMSITE,WRITER,ADDTIME,KEYWORD,IFHEAD,IFGOOD,IFSHOW,IMG,HITS,ORGID,AUTHOR from news.article where ";

		sql = sql + "ORGANID='00000000000000000000' and ifshow='1' and " + sql1;

		if (s2.equals("all") || s2.equals(""))
			sql = sql + "order by edittime desc ";
		else {
			long i = Long.parseLong(s2) * 86400000;
			Date now = new Date();
			Date from = new Date(now.getTime() - i);
			java.text.SimpleDateFormat f = new java.text.SimpleDateFormat(
					"yyyy-MM-dd");
			String fromday = f.format(from);
			sql = sql + " and '" + fromday
					+ "'<=addtime order by edittime desc ";
		}

		ResultSet rs = selectRecord(sql);
		return getResultSetData(rs);
	}

	//搜索文章keyword:关键字,s1:标题或关键字,s2:时间,id:显示第几页
	public Vector search(String keyword, String s1, String s2, String id) {
		String sql = "";
		int recnum = 0;
		Vector vt = new Vector();

		sql = "select ID,MENUID,TITLE,TOPICID,FROMSITE,WRITER,ADDTIME,KEYWORD,IFHEAD,IFGOOD,IFSHOW,IMG,HITS,ORGID,AUTHOR from news.article where ";

		if (s1.equals("1") || s1.equals(""))
			sql = sql
					+ "ORGANID='00000000000000000000' and ifshow='1' and TITLE like '%"
					+ ds.toString(keyword) + "%' ";
		if (s1.equals("2"))
			sql = sql
					+ "ORGANID='00000000000000000000' and ifshow='1' and KEYWORD like '%"
					+ ds.toString(keyword) + "%' ";

		if (s2.equals("all") || s2.equals(""))
			sql = sql + "order by edittime desc ";
		else {
			long i = Long.parseLong(s2) * 86400000;
			Date now = new Date();
			Date from = new Date(now.getTime() - i);
			java.text.SimpleDateFormat f = new java.text.SimpleDateFormat(
					"yyyy-MM-dd");
			String fromday = f.format(from);
			sql = sql + " and '" + fromday
					+ "'<=addtime order by edittime desc ";
		}
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try {
			while (rs.next()) {
				recnum++;
			}
			vt.add(String.valueOf(recnum));
		} catch (Exception e) {
			System.out
					.println("MainBean.search(String keyword,String s1,String s2,String id)运行时出错："
							+ e);
		} finally {
			if (rs != null)
				try {
					stmt = rs.getStatement();
					rs.close();
				} catch (Exception e) {
					System.out
							.println("MainBean.search(String keyword,String s1,String s2,String id)关闭记录集rs时出错"
									+ e);
				}
			if (stmt != null)
				try {
					stmt.close();
				} catch (Exception e) {
					System.out
							.println("MainBean.search(String keyword,String s1,String s2,String id)关闭声明时statement出错"
									+ e);
				}
		}

		if (recnum == 0) {
			vt.add(String.valueOf(recnum));
			return vt;
		} else {
			int page = 0;
			if (id.equals(""))
				page = 1;
			else
				page = Integer.parseInt(id);

			Vector vt1 = (Vector) getOnePage(sql, page, 10);
			for (int j = 0; j < vt1.size(); j++) {
				vt.add(vt1.get(j));
			}
			return vt;
		}
	}

	//搜索文章keyword:关键字,s1:标题或关键字,s2:时间,id:显示第几页
	public Vector search1(String keyword, String s1, String s2, String id)//搜索文章
	{
		String sql = "";
		int recnum = 0;
		Vector vt = new Vector();

		keyword = ds.toString(keyword);
		String str[] = ds.splitStr(ds.toString(keyword), ' ');
		String field = "TITLE";
		if (s1.equals("2"))
			field = "KEYWORD";
		String sql1 = "";
		for (int i = 0; i < str.length; i++) {
			if (str[i].length() == 0)
				continue;
			if (!sql1.equals(""))
				sql1 += " or ";
			sql1 = sql1 + "lower(" + field + ") like '%" + str[i].toLowerCase()
					+ "%' ";
		}

		sql = "select ID,MENUID,TITLE,TOPICID,FROMSITE,WRITER,ADDTIME,KEYWORD,IFHEAD,IFGOOD,IFSHOW,IMG,HITS,ORGID,AUTHOR from news.article where ";

		sql = sql + "ORGANID='00000000000000000000' and ifshow='1' ";
		if (!sql1.equals(""))
			sql = sql + " and " + sql1;

		if (s2.equals("all") || s2.equals(""))
			sql = sql + "order by edittime desc ";
		else {
			long i = Long.parseLong(s2) * 86400000;
			Date now = new Date();
			Date from = new Date(now.getTime() - i);
			java.text.SimpleDateFormat f = new java.text.SimpleDateFormat(
					"yyyy-MM-dd");
			String fromday = f.format(from);
			sql = sql + " and '" + fromday
					+ "'<=addtime order by edittime desc ";
		}
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try {
			while (rs.next()) {
				recnum++;
			}
			vt.add(String.valueOf(recnum));
		} catch (Exception e) {
			System.out
					.println("MainBean.search1(String keyword,String s1,String s2,String id)运行时出错："
							+ e);
		} finally {
			if (rs != null)
				try {
					stmt = rs.getStatement();
					rs.close();
				} catch (Exception e) {
					System.out
							.println("MainBean.search1(String keyword,String s1,String s2,String id)关闭记录集rs时出错"
									+ e);
				}
			if (stmt != null)
				try {
					stmt.close();
				} catch (Exception e) {
					System.out
							.println("MainBean.search1(String keyword,String s1,String s2,String id)关闭声明时statement出错"
									+ e);
				}
		}

		if (recnum == 0) {
			vt.add(String.valueOf(recnum));
			return vt;
		} else {
			int page = 0;
			if (id.equals(""))
				page = 1;
			else
				page = Integer.parseInt(id);
			Vector vt1 = (Vector) db.getOnePage(sql, page, 10, true);
			//Vector vt1 =
			// (Vector)getOnePage1(sql,page,10,true);//getOnePage(sql,page,10);
			for (int j = 0; j < vt1.size(); j++) {
				vt.add(vt1.get(j));
			}
			return vt;
		}
	}

	//	根据某文章ID取得文章正文----------------------------------------------------------------------
	public String getOneContent(String id) {
		String sql = "select CONTENT from news.ARTICLE where ID=" + id + "";
		ResultSet rs = selectRecord(sql);
		return getStrByResultSet(rs, "CONTENT");
	}

	//取得所有定义的Css风格--------------------------------------------------------------------------
	public Vector getCss() {
		String sql = "";
		sql = "select * from news.NB_YSB order by ID";
		ResultSet rs = selectRecord(sql);
		return this.getResultSetData(rs);
	}

	//取得所有一级菜单--------------------------------------------------------------------------------
	public Vector getMenu() {
		String sql = "";
		sql = "select * from news.MENU where ZT='0' and ID2=0 order by ID1";
		ResultSet rs = selectRecord(sql);
		return getResultSetData(rs);
	}

	//根据一级菜单取得所有二级菜单------------------------------------------------------------------
	public Vector getMenu2() {
		String sql = "";
		sql = "select * from news.MENU where ID1 = " + id1
				+ " and ID2!=0 and ID3=0 order by ID2";
		ResultSet rs = selectRecord(sql);
		return getResultSetData(rs);
	}

	//根据一二级菜单取得所有三级菜单信息
	public Vector getMenu3() {
		String sql = "";
		sql = "select * from news.MENU where ID1 = " + id1 + " and ID2 = "
				+ id2 + " and ID3!=0";
		ResultSet rs = selectRecord(sql);
		return getResultSetData(rs);
	}

	//根据一级菜单名得到其编号-----------------------------------------------------------------------
	public String toId1(String m1) {
		String id = "";
		String sql = "";
		sql = "select distinct ID1 from news.MENU where MENU1 = '" + m1 + "'";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try {
			if (rs.next()) {
				id = ds.toString(rs.getString("ID1"));
			}
		} catch (Exception e) {
			System.out.println("MainBean.toId1(String m1)运行时出错：" + e);
		} finally {
			if (rs != null)
				try {
					stmt = rs.getStatement();
					rs.close();
				} catch (Exception e) {
					System.out.println("MainBean.toId1(String m1)关闭记录集rs时出错"
							+ e);
				}
			if (stmt != null)
				try {
					stmt.close();
				} catch (Exception e) {
					System.out
							.println("MainBean.toId1(String m1)关闭声明时statement出错"
									+ e);
				}
		}

		return id;
	}

	//根据一级菜单编号得到其名------------------------------------------------------------------------
	public String toMenu1(String id1) {
		String menu = "";
		String sql = "";
		if (id1.equals("")) {
			return menu;
		}
		sql = "select distinct MENU1 from news.MENU where ID1 = " + id1 + "";
		ResultSet rs = selectRecord(sql);
		menu=getStrByResultSet(rs,"MEMU1");
		return menu;
	}

	//根据一、二级菜单编号得到其名
public String toMenu2(String id1, String id2) {
	 String menu = "";
	 String sql = "";
	 if (id1.equals("") || id2.equals("")) {
	 return menu;
	 }
	 sql = "select distinct MENU2 from news.MENU where ID1 = " + id1
	 + " and ID2 = " + id2 + " and ID3= 0";
	 ResultSet rs = selectRecord(sql);
	 menu=getStrByResultSet(rs,"MENU2");
	 return menu; }

	//根据一级菜单下的取得文章------------------------------------------------------------------------
	public Vector getArticle(String id) {
		Vector v_menu = new Vector();
		Vector v_article = new Vector();
		if (id.equals(""))
			return v_article;
		//检索菜单表编号
		int num = 0;
		String sql = "select num from news.nb_zyszb where id=" + id;
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try {
			if (rs.next())
				num = rs.getInt(1);
		} catch (Exception e) {
			System.out.println("MainBean.getArticle(String id)运行时出错：" + e);
		} finally {
			if (rs != null)
				try {
					stmt = rs.getStatement();
					rs.close();
				} catch (Exception e) {
					System.out
							.println("MainBean.getArticle(String id)关闭记录集rs时出错"
									+ e);
				}
			if (stmt != null)
				try {
					stmt.close();
				} catch (Exception e) {
					System.out
							.println("MainBean.getArticle(String id)关闭声明时statement出错"
									+ e);
				}
		}
		sql = "select ID from news.Menu where Id3!=0 and Id1=" + id;
		rs = selectRecord(sql);
		Vector v_child = new Vector();
		try {
			while (rs.next()) {
				v_menu.add(rs.getString("ID"));
			}
			if (rs != null)
				try {
					stmt = rs.getStatement();
					rs.close();
				} catch (Exception e) {
					System.out
							.println("MainBean.getArticle(String id)关闭记录集rs时出错"
									+ e);
				}
			if (stmt != null)
				try {
					stmt.close();
				} catch (Exception e) {
					System.out
							.println("MainBean.getArticle(String id)关闭声明时statement出错"
									+ e);
				}
			if (v_menu.isEmpty())
				return v_menu;

			//检索子菜单表编号
			sql = "select ID from news.menuchild where isthis=0 and IDPARENT in (select ID from news.Menu where Id3!=0 and Id1="
					+ id + ")";
			rs = selectRecord(sql);
			while (rs.next()) {
				String id4 = rs.getString("ID");
				v_child.add(id4);
				Stack s4 = new Stack();
				s4.push(id4);

				while (!s4.empty())//当有孩子节点时继续搜索
				{
					id4 = (String) s4.pop();
					sql = "select count(id) from news.menuchild where isthis=1 and IDPARENT="
							+ id4;
					ResultSet rs4 = selectRecord(sql);
					int count = 0;
					try {
						if (rs4.next())
							count = rs4.getInt(1);
					} catch (Exception e) {