skinutil.java

一个用jsp写的完整的论坛源代码

						jw.setString(2, userName);
						jw.setString(3, getUserClass(theUser.getUserClass()));
						jw.setString(4, ip);
						jw.setString(5, DateUtil.getLocalDate());
						jw.setString(6, DateUtil.getLocalDate());
						jw.setString(7, browser);
						jw.setString(8, stats);
						if (actCome == null) {
							jw.setString(9, "null");
							jw.setString(11, "null");
						} else {
							jw.setString(9, actCome);
							jw.setString(11, actCome);
						}

						jw.setString(10, comeFrom);

						jw.executeUpdate();
						jw.clearParameters();
					}
				} catch (Exception e) {

					if (!onlineSign) {
						sql = "insert into "
								+ BBSConst.TABLE_ONLINE
								+ " (id,username,userclass,ip,startime,lastimebk,browser,stats,actforip,ComeFrom,actCome) values(?,?,?,?,?,?,?,?,?,?,?)";
						jw.prepareStatement(sql);
						jw.setString(1, statUserID);
						jw.setString(2, "guest");
						jw.setString(3, "客人");
						jw.setString(4, ip);
						jw.setString(5, DateUtil.getLocalDate());
						jw.setString(6, DateUtil.getLocalDate());
						jw.setString(7, browser);
						jw.setString(8, stats);
						jw.setString(9, actCome);
						jw.setString(10, comeFrom);
						jw.setString(11, actCome);
						jw.executeUpdate();
						jw.clearParameters();

					} else {
						sql = "update "
								+ BBSConst.TABLE_ONLINE
								+ " set lastimebk=?,lastime=?,ComeFrom=?,actCome=?,stats=? where id=?";
						jw.prepareStatement(sql);
						jw.setString(1, DateUtil.getLocalDate());
						jw.setString(2, DateUtil.getLocalDate());
						jw.setString(3, comeFrom);
						jw.setString(4, actCome);
						jw.setString(5, stats);
						jw.setString(6, statUserID);
						jw.executeUpdate();
						jw.clearParameters();
					}
				}
			}
			//
			sql = "delete from " + BBSConst.TABLE_ONLINE
					+ " where now()>date_add(lastimebk,interval 20 minute)";
			jw.executeUpdate(sql);
			sql = "select Maxonline from " + BBSConst.TABLE_CONFIG + "";
			int oldMaxOnLine = jw.doIntSearch(sql);
			sql = "select count(*) from " + BBSConst.TABLE_ONLINE + "";
			int newMaxOnLine = jw.doIntSearch(sql);
			if (newMaxOnLine > oldMaxOnLine) {
				sql = "update " + BBSConst.TABLE_CONFIG + " set Maxonline="
						+ newMaxOnLine + ",MaxonlineDate=now()";
				jw.executeUpdate(sql);
				ForumPropertiesManager.resetManager();
			}
		} catch (Exception e) {
			log.error("刷新在线用户状态出错", e);
		} finally {
			jw.close();
		}
	}

	public static String getUserClass(int userClass) {
		String user_level = "";
		switch (userClass) {

		case 1:
			user_level = "新手上路";
			break;
		case 2:
			user_level = "论坛游民";
			break;
		case 3:
			user_level = "论坛游侠";
			break;
		case 4:
			user_level = "业余侠客";
			break;
		case 5:
			user_level = "职业侠客";
			break;
		case 6:
			user_level = "侠之大者";
			break;
		case 7:
			user_level = "黑侠";
			break;
		case 8:
			user_level = "蝙蝠侠";
			break;
		case 9:
			user_level = "蜘蛛侠";
			break;
		case 10:
			user_level = "青蜂侠";
			break;
		case 11:
			user_level = "小飞侠";
			break;
		case 12:
			user_level = "火箭侠";
			break;
		case 13:
			user_level = "蒙面侠";
			break;
		case 14:
			user_level = "城市猎人";
			break;
		case 15:
			user_level = "罗宾汉";
			break;
		case 16:
			user_level = "阿诺";
			break;
		case 17:
			user_level = "侠圣";
			break;
		case 18:
			user_level = "贵宾";
			break;
		case 19:
			user_level = "版主";
			break;
		case 20:
			user_level = "总版主";
			break;
		default:
			user_level = "新手上路";
			break;
		}
		return user_level;
	}

	public static int getPoint(int p) {
		int level_point = 0;
		switch (p) {
		case 1:
			level_point = 0;
			break;
		case 2:
			level_point = 100;
			break;
		case 3:
			level_point = 200;
			break;
		case 4:
			level_point = 300;
			break;
		case 5:
			level_point = 400;
			break;
		case 6:
			level_point = 500;
			break;
		case 7:
			level_point = 600;
			break;
		case 8:
			level_point = 800;
			break;
		case 9:
			level_point = 1000;
			break;
		case 10:
			level_point = 1200;
			break;
		case 11:
			level_point = 1500;
			break;
		case 12:
			level_point = 1800;
			break;
		case 13:
			level_point = 2100;
			break;
		case 14:
			level_point = 2500;
			break;
		case 15:
			level_point = 3000;
			break;
		case 16:
			level_point = 3500;
			break;
		case 17:
			level_point = 4000;
			break;
		default:
			level_point = 0;
			break;
		}
		return level_point;
	}

	public static Vector getTopList(HttpServletRequest request)
			throws Exception {
		int orders = ParamUtil.getInt(request, "orders", 7);
		int page = ParamUtil.getInt(request, "Page", 1);
		String sql = "";
		switch (orders) {
		case 1:
			orderName = "发贴总数Top10";
			sql = "select username,useremail,userclass,oicq,homePage,article,addDate,userwealth as wealth ,userID from "
					+ BBSConst.TABLE_USER + " order by article desc limit 0,10";
			break;
		case 2:
			orderName = "最新用户注册";
			sql = "select  username,useremail,userclass,oicq,homePage,article,addDate,userwealth as wealth ,userID from "
					+ BBSConst.TABLE_USER + " order by AddDate desc limit 0,10";
			break;
		case 7:
			orderName = "所有用户列表";
			sql = "select username,useremail,userclass,oicq,homePage,article,addDate,userwealth as wealth ,userID from "
					+ BBSConst.TABLE_USER + " order by AddDate desc ";
			break;
		default:
			orderName = "发贴总数Top10";
			sql = "select  username,useremail,userclass,oicq,homePage,article,addDate,userwealth as wealth ,userID from "
					+ BBSConst.TABLE_USER + " order by article desc limit 0,10";
			break;
		}
		JdbcWrapper jw = new JdbcWrapper();
		Vector userVector = new Vector();
		if(orders == 7){
			jw.executeLimitQuery(sql, (page-1)*10, 10);
		}else{
			jw.executeQuery(sql);
		}
		allUserNum = jw.getAllRows();
		allPages = jw.getPages();
		while (jw.next()) {
			User tempUser = new User();
			tempUser.setUserName(jw.getString(1));
			tempUser.setUserEmail(jw.getString(2));
			tempUser.setUserClass(jw.getInt(3));
			tempUser.setOicq(jw.getString(4));
			tempUser.setHomePage(jw.getString(5));
			tempUser.setArticle(jw.getInt(6));
			tempUser.setAddDate(jw.getString(7));
			tempUser.setUserWealth(jw.getInt(8));
			tempUser.setUserID(jw.getInt(9));
			userVector.add(tempUser);
		}
		return userVector;
	}

	public static int allUserNum = 0, allPages = 1;
	
	public static String orderName = "";
	
}