开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 电子书籍 > Java书籍 > 查看源码
SkinUtil.java
资源名称：第4章 BBS论坛系统.rar　[点击查看]
上传用户：yuyunping
上传日期：2013-03-21
资源大小：1844k
文件大小：13k
源码类别：

Java书籍

开发平台：

Java

SkinUtil.java：源码内容
  1. package net.acai.forum;
  2. /**
  3.  * Title:        清清网络
  4.  * Description:
  5.  * Copyright:    Copyright (c) 2002
  6.  * Company:      www.SuperSpace.com
  7.  * @author:       SuperSpace
  8.  * @version 1.0
  9.  */
  10. import net.acai.database.*;
  11. import net.acai.forum.*;
  12. import net.acai.forum.util.*;
  13. import net.acai.util.*;
  14. import net.acai.ip.*;
  15. import javax.servlet.http.*;
  16. import java.sql.*;
  17. import java.util.*;
  18. public class SkinUtil
  19. {
  20. public static void login(HttpServletRequest request,
  21.  HttpServletResponse response,
  22.  String username,
  23.  String password) throws UserNotFoundException,Exception
  24. {
  25. /*User sessionUser=new User(username,password);
  26. HttpSession session=request.getSession(true);
  27. session.setAttribute("UJBBUser",sessionUser);
  28. GCookie.setCookie(response,"UJBBUName",username,60*60*60);
  29. GCookie.setCookie(response,"UJBBUPSW",password,60*60*60);*/
  30. }
  31. public static User checkUser(HttpServletRequest request,HttpServletResponse response,int loginSign) throws UserNotFoundException,Exception{
  32. String userName=GCookie.getCookieValue(request,"UJBBUName","");
  33. String userPassword=GCookie.getCookieValue(request,"UJBBUPSW","");
  34. User tempUser=new User(userName,userPassword,loginSign);
  35. return tempUser;
  36. }
  38. public static void userLogin(HttpServletRequest request,HttpServletResponse response,int loginSign) throws UserNotFoundException,Exception{
  39. String userName=ParamUtil.getString(request,"userName","");
  40. String userPassword=ParamUtil.getString(request,"userPassword","");
  41. User tempUser=new User(userName,userPassword,loginSign);
  42. int cookieDate=ParamUtil.getInt(request,"cookieDate",1);
  43. switch(cookieDate){
  44. case 1:
  45. cookieDate=3600*24;
  46. break;
  47. case 2:
  48. cookieDate=30*3600*24;
  49. break;
  50. case 3:
  51. cookieDate=365*30*3600*24;
  52. break;
  54. default:
  55. cookieDate=3600*24;
  56. break;
  57. }
  59. GCookie.setCookie(response,"UJBBUName",userName,cookieDate);
  60. GCookie.setCookie(response,"UJBBUPSW",userPassword,cookieDate);
  61. }
  62. public static void userLogout(HttpServletResponse response,HttpServletRequest request) throws Exception
  63. {
  65. String userName=GCookie.getCookieValue(request,"UJBBUName","");
  66. String userPassword=GCookie.getCookieValue(request,"UJBBUPSW","");
  67. GCookie.setCookie(response,"UJBBUName",userName,0);
  68. GCookie.setCookie(response,"UJBBUPSW",userPassword,0);
  70. long  statUserID=Long.parseLong(StringUtils.replace(request.getRemoteAddr(),".",""));
  71.   String sql="delete from bbs.online where ID="+statUserID;
  73. DBConnect dbc=new DBConnect(sql);
  74. dbc.executeUpdate();
  75. }
  78. public static User userLogin(String userName,String userPassword,int loginSign) throws UserNotFoundException,Exception{
  79. User tempUser=new User(userName,userPassword,loginSign);
  80. return tempUser;
  81. }
  84. public static void checkUserStats(HttpServletRequest request,HttpServletResponse response){
  85. String stats;
  86. if((stats=ParamUtil.getString(request,"stats"))==null)
  87. {
  88. stats="论坛首页 response";
  89. }
  91. checkUserStats(request,response,stats);
  93. }
  95. public static void checkUserStats(HttpServletRequest request,HttpServletResponse response,String stats){
  97. String userName=GCookie.getCookieValue(request,"UJBBUName","");
  98. String userPassword=GCookie.getCookieValue(request,"UJBBUPSW","");
  99. String ip=request.getRemoteAddr();
  100. String[] addr=IPLocalizer.search(request);
  101. String comeFrom="";
  102. for(int i=0;i<addr.length;i++)
  103. comeFrom+=addr[i];
  104. String actCome=request.getHeader("X_FORWARDED_FOR");
  105. long  statUserID=Long.parseLong(StringUtils.replace(ip,".",""));
  106.   boolean onlineSign=false;
  107.   String browser=request.getHeader("User-Agent");
  108. ResultSet rs;
  109.   try{
  110. String sql="";
  111. DBConnect dbc=new DBConnect();
  112. try{
  113.   sql="select * from bbs.online where id=?";
  114. dbc.prepareStatement(sql);
  115. dbc.setLong(1,statUserID);
  116. //dbc.setBytes(2,userName(new String(.getBytes("ISO-8859-1"),"GBK")).getBytes());
  117. rs=dbc.executeQuery();
  118. if(rs.next())
  119. onlineSign=true;
  120. else
  121. onlineSign=false;
  122. rs.close();
  123. }
  124. catch(Exception e){
  125. onlineSign=false;
  126. }
  131. if("".equals(userName)){
  132. //System.out.println("++++++++++++++"+stats);
  133. //if(stats.indexOf("response")==-1)stats = net.ds.toGBK(stats);
  134. //System.out.println("--------------"+stats);
  135. if(!onlineSign){
  136. sql="insert into bbs.online (id,username,userclass,ip,startime,lastimebk,browser,stats,actforip,ComeFrom,actCome) values(?,?,?,?,?,?,?,?,?,?,?)";
  137. dbc.prepareStatement(sql);
  138. dbc.setLong(1,statUserID);
  139. dbc.setString(2,"guest");
  140. dbc.setBytes(3,("客人").getBytes());
  141. dbc.setBytes(4,(new String(ip.getBytes("ISO-8859-1"),"GBK")).getBytes());
  142. dbc.setString(5,Format.getDateTime());
  143. dbc.setString(6,Format.getDateTime());
  144. dbc.setString(7,browser);
  145. dbc.setBytes(8,stats.getBytes());
  146. dbc.setString(9,actCome);
  147. dbc.setBytes(10,comeFrom.getBytes());
  148. dbc.setString(11,actCome);
  149. dbc.executeUpdate();
  150. dbc.clearParameters();
  152. }
  153. else{
  154. sql="update bbs.online set lastimebk=?,lastime=?,ComeFrom=?,actCome=?,stats=? where id=?";
  155. dbc.prepareStatement(sql);
  156. dbc.setString(1,Format.getDateTime());
  157. dbc.setString(2,Format.getStrDateTime());
  158. dbc.setBytes(3,comeFrom.getBytes());
  159. dbc.setString(4,actCome);
  160. dbc.setBytes(5,stats.getBytes());
  161. dbc.setLong(6,statUserID);
  162. dbc.executeUpdate();
  163. dbc.clearParameters();
  165. }
  166. }
  167. else{
  168. sql="select * from bbs.online where  ID=? or username=?";
  169. dbc.prepareStatement(sql);
  170. dbc.setLong(1,statUserID);
  171. dbc.setBytes(2,(new String(userName.getBytes("ISO-8859-1"),"GBK")).getBytes());
  172. rs=dbc.executeQuery();
  173. if(rs.next())
  174. onlineSign=true;
  175. else
  176. onlineSign=false;
  177. dbc.clearParameters();
  178. try{
  179. //stats = net.ds.toGBK(stats);
  180. User theUser=new User(userName,userPassword,4);
  181. if(onlineSign){
  183. sql="update bbs.online set id=?,userName=?,userClass=?,lastimebk=?,lastime=?,ComeFrom=?,actCome=?,stats=? where id=? or username=?";
  184. dbc.prepareStatement(sql);
  185. dbc.setLong(1,statUserID);
  186. dbc.setBytes(2,(new String(userName.getBytes("ISO-8859-1"),"GBK")).getBytes());
  187. dbc.setBytes(3,getUserClass(theUser.getUserClass()).getBytes());
  188. dbc.setString(4,Format.getDateTime());
  189. dbc.setString(5,Format.getStrDateTime());
  190. dbc.setBytes(6,comeFrom.getBytes());
  191. dbc.setString(7,actCome);
  192. dbc.setBytes(8,stats.getBytes());
  193. dbc.setLong(9,statUserID);
  194. dbc.setBytes(10,(new String(userName.getBytes("ISO-8859-1"),"GBK")).getBytes());
  195. dbc.executeUpdate();
  196. dbc.clearParameters();
  197. }
  198. else{
  200. sql="insert into bbs.online(id,username,userclass,ip,startime,lastimebk,browser,stats,actforip,ComeFrom,actCome) values(?,?,?,?,?,?,?,?,?,?,?)";
  201. dbc.prepareStatement(sql);
  202. dbc.setLong(1,statUserID);//statUserID);
  203. dbc.setBytes(2,(new String(userName.getBytes("ISO-8859-1"),"GBK")).getBytes());
  204. dbc.setBytes(3,getUserClass(theUser.getUserClass()).getBytes());
  205. dbc.setString(4,ip);
  206. dbc.setString(5,Format.getDateTime());
  207. dbc.setString(6,Format.getStrDateTime());
  208. dbc.setString(7,browser);
  209. dbc.setBytes(8,stats.getBytes());
  210. if(actCome==null){
  211. dbc.setString(9,"null");
  212. dbc.setString(11,"null");
  213. }
  214. else{
  215. dbc.setString(9,actCome);
  216. dbc.setString(11,actCome);
  217. }
  218. dbc.setBytes(10,comeFrom.getBytes());
  219. dbc.executeUpdate();
  220. dbc.clearParameters();
  221. }
  222. }
  223. catch(Exception e){
  225. if(!onlineSign){
  226. sql="insert into bbs.online (id,username,userclass,ip,startime,lastimebk,browser,stats,actforip,ComeFrom,actCome) values(?,?,?,?,?,?,?,?,?,?,?)";
  227. dbc.prepareStatement(sql);
  228. dbc.setLong(1,statUserID);
  229. dbc.setString(2,"guest");
  230. dbc.setBytes(3,(new String("客人".getBytes("ISO-8859-1"),"GBK")).getBytes());
  231. dbc.setBytes(4,(new String(ip.getBytes("ISO-8859-1"),"GBK")).getBytes());
  232. dbc.setString(5,Format.getDateTime());
  233. dbc.setString(6,Format.getDateTime());
  234. dbc.setString(7,browser);
  235. dbc.setBytes(8,stats.getBytes());
  236. dbc.setString(9,actCome);
  237. dbc.setBytes(10,comeFrom.getBytes());
  238. dbc.setString(11,actCome);
  239. dbc.executeUpdate();
  240. dbc.clearParameters();
  242. }
  243. else{
  244. sql="update bbs.online set lastimebk=?,lastime=?,ComeFrom=?,actCome=?,stats=? where id=?";
  245. dbc.prepareStatement(sql);
  246. dbc.setString(1,Format.getDateTime());
  247. dbc.setString(2,Format.getStrDateTime());
  248. dbc.setBytes(3,comeFrom.getBytes());
  249. dbc.setString(4,actCome);
  250. dbc.setBytes(5,stats.getBytes());
  251. dbc.setLong(6,statUserID);
  252. dbc.executeUpdate();
  253. dbc.clearParameters();
  255. }
  257. }
  259. }
  263. sql="delete from bbs.online where "
  264. +" datepart(YYYY,getdate()-lastimebk)=0 and "
  265. +" datepart(MM,getdate()-lastimebk)=0 and "
  266. +" datepart(DD,getdate()-lastimebk)=0 and "
  267. +" datepart(HH,getdate()-lastimebk)=0 and "
  268. +" datepart(MI,getdate()-lastimebk)<20";
  270. dbc.executeUpdate(sql);
  271. sql="select Maxonline from bbs.config";
  272. rs=dbc.executeQuery(sql);
  273. rs.next();
  274. int oldMaxOnLine=rs.getInt(1);
  275. sql="select count(*) from bbs.online";
  276. ResultSet tmprs=dbc.executeQuery(sql);
  277. tmprs.next();
  278. int newMaxOnLine=tmprs.getInt(1);
  279. if(newMaxOnLine>oldMaxOnLine){
  280. sql="update bbs.config set Maxonline="+newMaxOnLine+",MaxonlineDate=getdate()";
  281. dbc.executeUpdate(sql);
  282. ForumPropertiesManager.resetManager();
  283. }
  285. dbc.close();
  287. }
  288. catch(Exception e){
  290. e.printStackTrace();
  291. }
  293. }
  294. public static String getUserClass(int userClass){
  295. String user_level="";
  296. switch(userClass){
  298. case 1:
  299. user_level="新手上路";
  300. break;
  301. case 2:
  302. user_level="论坛游民";
  303. break;
  304. case 3:
  305. user_level="论坛游侠";
  306. break;
  307. case 4:
  308. user_level="业余侠客";
  309. break;
  310. case 5:
  311. user_level="职业侠客";
  312. break;
  313. case 6:
  314. user_level="侠之大者";
  315. break;
  316. case 7:
  317. user_level="黑侠";
  318. break;
  319. case 8:
  320. user_level="蝙蝠侠";
  321. break;
  322. case 9:
  323. user_level="蜘蛛侠";
  324. break;
  325. case 10:
  326. user_level="青蜂侠";
  327. break;
  328. case 11:
  329. user_level="小飞侠";
  330. break;
  331. case 12:
  332. user_level="火箭侠";
  333. break;
  334. case 13:
  335. user_level="蒙面侠";
  336. break;
  337. case 14:
  338. user_level="城市猎人";
  339. break;
  340. case 15:
  341. user_level="罗宾汉";
  342. break;
  343. case 16:
  344. user_level="阿诺";
  345. break;
  346. case 17:
  347. user_level="侠圣";
  348. break;
  349. case 18:
  350. user_level="贵宾";
  351. break;
  352. case 19:
  353. user_level="版主";
  354. break;
  355. case 20:
  356. user_level="总版主";
  357. break;
  358. default:
  359. user_level="新手上路";
  360. break;
  361. }
  362. return user_level;
  363. }
  366. public static int getPoint(int p){
  367. int level_point=0;
  368. switch(p){
  369. case 1:
  370. level_point=0;
  371. break;
  372. case 2:
  373. level_point=100;
  374. break;
  375. case 3:
  376. level_point=200;
  377. break;
  378. case 4:
  379. level_point=300;
  380. break;
  381. case 5:
  382. level_point=400;
  383. break;
  384. case 6:
  385. level_point=500;
  386. break;
  387. case 7:
  388. level_point=600;
  389. break;
  390. case 8:
  391. level_point=800;
  392. break;
  393. case 9:
  394. level_point=1000;
  395. break;
  396. case 10:
  397. level_point=1200;
  398. break;
  399. case 11:
  400. level_point=1500;
  401. break;
  402. case 12:
  403. level_point=1800;
  404. break;
  405. case 13:
  406. level_point=2100;
  407. break;
  408. case 14:
  409. level_point=2500;
  410. break;
  411. case 15:
  412. level_point=3000;
  413. break;
  414. case 16:
  415. level_point=3500;
  416. break;
  417. case 17:
  418. level_point=4000;
  419. break;
  420. default:
  421. level_point=0;
  422. break;
  423. }
  424. return level_point;
  425. }
  427. public static Vector getTopList(HttpServletRequest request) throws Exception{
  428. int orders=ParamUtil.getInt(request,"orders",7);
  429. String sql="";
  430. switch(orders){
  431. case 1:
  432. sql="select username,useremail,userclass,oicq,homePage,article,addDate,userwealth as wealth ,userID from bbs.myuser order by article desc";
  433. break;
  434. case 2:
  435. sql="select  username,useremail,userclass,oicq,homePage,article,addDate,userwealth as wealth ,userID from bbs.myuser order by AddDate desc";
  436. break;
  437. case 7:
  438. sql="select username,useremail,userclass,oicq,homePage,article,addDate,userwealth as wealth ,userID from bbs.myuser order by AddDate desc ";
  439. break;
  440. default:
  441. sql="select  username,useremail,userclass,oicq,homePage,article,addDate,userwealth as wealth ,userID from bbs.myuser order by article desc";
  442. break;
  443. }
  445. DBConnect dbc=new DBConnect();
  446. ResultSet rs=dbc.executeQuery(sql);
  447. Vector userVector=new Vector();
  448. int i = 0 ;
  449. while(rs.next()){
  451. User tempUser=new User();
  452. tempUser.setUserName(rs.getString(1));
  453. tempUser.setUserEmail(rs.getString(2));
  454. tempUser.setUserClass(rs.getInt(3));
  455. tempUser.setOicq(rs.getString(4));
  456. tempUser.setHomePage(rs.getString(5));
  457. tempUser.setArticle(rs.getInt(6));
  458. tempUser.setAddDate(rs.getString(7));
  459. tempUser.setUserWealth(rs.getInt(8));
  460. tempUser.setUserID(rs.getInt(9));
  461. userVector.add(tempUser);
  463. i++;
  464. if(orders!=7)
  465. {
  466. if(i==10)break;
  467. }
  468. }
  469. return userVector;
  470. }
  473. }