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

源码开发语言/平台
当前位置：首页 > 源码/资料 > Java编程 > Jsp/Servlet > 查看源码
ForumPropertiesManager.java
资源名称：BBS_system_on_java.rar　[点击查看]
上传用户：toby834
上传日期：2013-10-21
资源大小：2613k
文件大小：9k
源码类别：

Jsp/Servlet

开发平台：

Java

ForumPropertiesManager.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.  */
  11. /**
  12.  * Title:        清清网络
  13.  * Description:
  14.  * Copyright:    Copyright (c) 2002
  15.  * Company:      211.68.39.120、webcpu.51.net
  16.  * @author:       SuperSpace
  17.  * @version 1.0
  18.  */
  19. import net.acai.database.*;
  20. import net.acai.util.*;
  21. import java.sql.*;
  22. import java.util.Hashtable;
  23. import javax.servlet.http.*;
  24. public class ForumPropertiesManager{
  25. private static ForumPropertiesManager manager=null;
  26. private static Object managerLock=new Object();
  27. public static void resetManager(){
  28. manager=null;
  29. }
  31. public static String getString(String name) throws Exception{
  32. if(manager==null){
  33. synchronized(managerLock){
  34. if(manager==null){
  35. manager=new ForumPropertiesManager();
  36. }
  37. }
  38. }
  39. return manager.getStr(name);
  40. }
  41. public static void setString(String name){
  42. if(manager==null){
  43. synchronized(managerLock){
  44. if(manager==null){
  45. manager=new ForumPropertiesManager();
  46. }
  47. }
  48. }
  49. manager.setStr(name);
  50. }
  52. private static Hashtable forumHash=new Hashtable();
  53. public ForumPropertiesManager() {
  54. try{
  55. DBConnect dbc=new DBConnect("select * from bbs.config");
  56. ResultSet rs=dbc.executeQuery();
  57. ResultSetMetaData rsmd=rs.getMetaData();
  58. rs.next();
  59. for(int i=1;i<=rsmd.getColumnCount();i++){
  60. forumHash.put(rsmd.getColumnName(i),rs.getString(i));
  61. }
  62. dbc.close();
  63. }
  64. catch(SQLException e)
  65. {
  66. System.out.println("ResultSetMetaData出现问题!");
  67. }
  68. catch(Exception e)
  69. {
  70. System.out.println("DBConnect 出现问题！");
  71. }
  76. }
  77. public String getStr(String name) throws Exception{
  78. if(forumHash.isEmpty())
  79. throw new Exception("好像数据库连接有问题，请您确定您安装了数据库了吗？n<br>如果您没有安装数据库，请您运行install.jsp，安装数据库！");
  80. return (String)forumHash.get(name);
  81. }
  82. public void setStr(String name)
  83. {
  84. }
  85. public Hashtable getHashtable(){
  86. return forumHash;
  87. }
  88. public static void saveGrade(HttpServletRequest request) throws Exception{
  89. int wealthReg,wealthLogin,wealthAnnounce,wealthReAnnounce,wealthDel;
  90. int epReg,epLogin,epAnnounce,epReAnnounce,epDel;
  91. int cpReg,cpLogin,cpAnnounce,cpReAnnounce,cpDel;
  92. try{
  93. wealthReg=ParamUtil.getInt(request,"wealthReg");
  94. wealthLogin=ParamUtil.getInt(request,"wealthLogin");
  95. wealthAnnounce=ParamUtil.getInt(request,"wealthAnnounce");
  96. wealthReAnnounce=ParamUtil.getInt(request,"wealthReAnnounce");
  97. wealthDel=ParamUtil.getInt(request,"wealthDel");
  99. epReg=ParamUtil.getInt(request,"epReg");
  100. epLogin=ParamUtil.getInt(request,"epLogin");
  101. epAnnounce=ParamUtil.getInt(request,"epAnnounce");
  102. epReAnnounce=ParamUtil.getInt(request,"epReAnnounce");
  103. epDel=ParamUtil.getInt(request,"epDel");
  105. cpReg=ParamUtil.getInt(request,"cpReg");
  106. cpLogin=ParamUtil.getInt(request,"cpLogin");
  107. cpAnnounce=ParamUtil.getInt(request,"cpAnnounce");
  108. cpReAnnounce=ParamUtil.getInt(request,"cpReAnnounce");
  109. cpDel=ParamUtil.getInt(request,"cpDel");
  110. }
  111. catch(Exception e){
  112. e.printStackTrace();
  113. throw new Exception("请您输入的为数字！");
  114. }
  115. String sql="update bbs.config set "+
  116. "wealthReg="+wealthReg+",wealthLogin="+wealthLogin+",wealthAnnounce="+wealthAnnounce+",wealthDel="+wealthDel+",wealthReAnnounce="+wealthReAnnounce+
  117. ",epReg="+epReg+",epLogin="+epLogin+",epAnnounce="+epAnnounce+",epDel="+epDel+",epReAnnounce="+epReAnnounce+
  118. ",cpReg="+cpReg+",cpLogin="+cpLogin+",cpAnnounce="+cpAnnounce+",cpDel="+cpDel+",cpReAnnounce="+cpReAnnounce;
  119. DBConnect dbc=new DBConnect(sql);
  120. dbc.executeUpdate();
  121. dbc.close();
  122. ForumPropertiesManager.resetManager();
  123. }
  124. public static void saveConst(HttpServletRequest request) throws Exception{
  126. String forumName=ParamUtil.getString(request,"forumName");
  127. if(forumName==null||"".equals(forumName.trim()))
  128. throw new Exception("请您输入论坛的名称！");
  129. String forumURL=ParamUtil.getString(request,"forumURL");
  130. if(forumURL==null||"".equals(forumURL.trim()))
  131. throw new Exception("请您输入论坛的连接地址！");
  132. String companyName=ParamUtil.getString(request,"companyName");
  133. if(companyName==null||"".equals(companyName.trim()))
  134. throw new Exception("请您输入主页的名称！");
  135. String hostURL=ParamUtil.getString(request,"hostURL");
  136. if(hostURL==null||"".equals(hostURL.trim()))
  137. throw new Exception("请您输入主页的地址！～");
  138. String SMTPServer=ParamUtil.getString(request,"SMTPServer");
  139. if(SMTPServer==null||"".equals(SMTPServer.trim()))
  140. throw new Exception("请您输入邮件服务器的地址！");
  141. String systemEmail=ParamUtil.getString(request,"systemEmail");
  142. if(systemEmail==null||"".equals(systemEmail.trim()))
  143. throw new Exception("请您填写邮件的发送人地址");
  144. int timeAdjust=ParamUtil.getInt(request,"timeAdjust",0);
  145. int scriptTimeOut=ParamUtil.getInt(request,"scriptTimeOut",300);
  146. String logo=ParamUtil.getString(request,"forumLogo");
  147. if(logo==null||"".equals(logo.trim()))
  148. throw new Exception("请您填写论坛的logo地址！");
  149. String picURL=ParamUtil.getString(request,"picURL");
  150. if(picURL==null||"".equals(picURL.trim()))
  151. throw new Exception("请您填写论坛图片的目录！");
  152. String faceURL=ParamUtil.getString(request,"faceURL");
  153. if(faceURL==null||"".equals(faceURL.trim()))
  154. throw new Exception("请您填写论坛的表情目录！");
  156. int emailFlag=ParamUtil.getInt(request,"emailFlag",0);
  157. int uploadPic=ParamUtil.getInt(request,"uploadPic",0);
  158. int ipFlag=ParamUtil.getInt(request,"ipFlag",0);
  159. int fromFlag=ParamUtil.getInt(request,"fromFlag",0);
  160. int titleFlag=ParamUtil.getInt(request,"titleFlag",0);
  161. int uploadFlag=ParamUtil.getInt(request,"uploadFlag",0);
  162. int guestUser=ParamUtil.getInt(request,"guestUser",0);
  163. String  openMSG=ParamUtil.getString(request,"openMSG","");
  164. String  announceMaxBytes=ParamUtil.getString(request,"announceMaxBytes","");
  165. String maxAnnouncePerPage=ParamUtil.getString(request,"maxAnnouncePerPage","");
  166. String maxTitleList=ParamUtil.getString(request,"maxTitleList","");
  167. String tableBackColor=ParamUtil.getString(request,"tableBackColor");
  168. String aTableBackColor=ParamUtil.getString(request,"aTableBackColor");
  169. String tableTitleColor=ParamUtil.getString(request,"tableTitleColor");
  170. String aTableTitleColor=ParamUtil.getString(request,"aTableTitleColor");
  171. String tableFontColor=ParamUtil.getString(request,"tableFontColor");
  172. String tableContentColor=ParamUtil.getString(request,"tableContentColor");
  173. String alertFontColor=ParamUtil.getString(request,"alertFontColor");
  174. String contentTitle=ParamUtil.getString(request,"contentTitle");
  175. String tableBodyColor=ParamUtil.getString(request,"tableBodyColor");
  176. String aTableBodyColor=ParamUtil.getString(request,"aTableBodyColor");
  177. String ads1=ParamUtil.getString(request,"ads1","");
  178. String ads2=ParamUtil.getString(request,"ads2","");
  179. String copyRight=ParamUtil.getString(request,"copyRight","");
  180. String version=ParamUtil.getString(request,"version","");
  181. //////////////////////////插入数据库中！//////////////////////////////////
  182. DBConnect dbc=new DBConnect();
  183. String sql="update bbs.config set forumName=?,forumURL=?,companyName=?,hostURL=?,SMTPServer=?n"+
  184. ",systemEmail=?,timeAdjust="+timeAdjust+",scriptTimeOut="+scriptTimeOut+",logo=?n"+
  185. ",picURL=?,faceURL=?,emailFlag="+emailFlag+",uploadPic="+uploadPic+",ipFlag="+ipFlag+"n"+
  186. ",fromFlag="+fromFlag+",uploadFlag="+uploadFlag+",guestUser="+guestUser+"n"+
  187. ",openMSG='"+openMSG+"',maxAnnouncePerPage='"+maxAnnouncePerPage+"'n"+
  188. ",announceMaxBytes='"+announceMaxBytes+"'n"+
  189. ",maxTitleList='"+maxTitleList+"',tableBackColor='"+tableBackColor+"'n"+
  190. ",aTableBackColor='"+aTableBackColor+"',tableTitleColor='"+tableTitleColor+"'n"+
  191. ",aTableTitleColor='"+aTableTitleColor+"',tableFontColor='"+tableFontColor+"'n"+
  192. ",tableContentColor='"+tableContentColor+"',alertFontColor='"+alertFontColor+"'n"+
  193. ",contentTitle='"+contentTitle+"',tableBodyColor='"+tableBodyColor+"'n"+
  194. ",aTableBodyColor='"+aTableBodyColor+"',ads1=?n"+
  195. ",ads2=?,copyRight=?n"+
  196. ",version=?";
  197. dbc.prepareStatement(sql);
  198. dbc.setBytes(1,(new String(forumName.getBytes("ISO-8859-1"),"GBK")).getBytes());
  199. dbc.setBytes(2,(new String(forumURL.getBytes("ISO-8859-1"),"GBK")).getBytes());
  200. dbc.setBytes(3,(new String(companyName.getBytes("ISO-8859-1"),"GBK")).getBytes());
  201. dbc.setBytes(4,(new String(hostURL.getBytes("ISO-8859-1"),"GBK")).getBytes());
  202. dbc.setBytes(5,(new String(SMTPServer.getBytes("ISO-8859-1"),"GBK")).getBytes());
  203. dbc.setBytes(6,(new String(systemEmail.getBytes("ISO-8859-1"),"GBK")).getBytes());
  204. dbc.setBytes(7,(new String(logo.getBytes("ISO-8859-1"),"GBK")).getBytes());
  205. dbc.setBytes(8,(new String(picURL.getBytes("ISO-8859-1"),"GBK")).getBytes());
  206. dbc.setBytes(9,(new String(faceURL.getBytes("ISO-8859-1"),"GBK")).getBytes());
  207. dbc.setBytes(10,(new String(ads1.getBytes("ISO-8859-1"),"GBK")).getBytes());
  208. dbc.setBytes(11,(new String(ads2.getBytes("ISO-8859-1"),"GBK")).getBytes());
  209. dbc.setBytes(12,(new String(copyRight.getBytes("ISO-8859-1"),"GBK")).getBytes());
  210. dbc.setBytes(13,(new String(version.getBytes("ISO-8859-1"),"GBK")).getBytes());
  211. dbc.executeUpdate();
  212. dbc.close();
  213. resetManager();
  216. }
  217. }