📄 install.jsp
字号:
<%@ page contentType="text/html;charset=GBK" %>
<%@ page import="net.acai.forum.*,
net.acai.database.*,
net.acai.util.*"%>
<html>
<head>
<title>阿菜网络论坛安装论坛</title></head>
<link rel="stylesheet" type="text/css" href="forum.css">
<BODY bgcolor="#ffffff" alink="#333333" vlink="#333333" link="#333333" topmargin="20">
<%
String action=ParamUtil.getString(request,"action","1");
if(action.equals("1")){
%>
请您先修改web-inf/classes/db.properties文件下面是我的机器上db.properties文件，红色部分为您要<br>修改的<br>
当您重新修改了db.properties请您注意要<font color=red size=4>重新启动resin服务器</font>！！！！<br>
<font color=green>//////////////////////////////////////////////////////////////////////////</font><br>
<br>
drivers=org.gjt.mm.mysql.Driver<br>
logfile=<font color=red>E:\\Apache\\htdocs\\acai\\log.txt</font> <br>
#修改数据库名称<br>
mysql.url=jdbc:mysql://localhost/<font color=red>acai</font>?useUnicode=true&characterEncoding =8859_1 <br>
#修改数据库的最大连接数量<br>
mysql.maxconn=<font color=red>100</font><br>
#修改数据库的用户名称<br>
mysql.user=<font color=red>acai</font><br>
#修改数据库的用户的密码<br>
mysql.password=<font color=red>123456</font><br>
<font color=green>//////////////////////////////////////////////////////////////////////////</font>
<form action="">
<input type="hidden" name="action" value="2">
<input type=submit value="测试数据源">
</form>
<%
}
else if(action.equals("2")){
try{
DBConnect dbc=new DBConnect();
out.println("数据库连接成功！");
%>
<form action="">
<input type="hidden" name="action" value="3">
<input type="submit" value="现在创建数据表!">
</form>
<%
}
catch(Exception e){
out.print("数据库连接失败，具体错误，请您查看您的日志文件！(log.txt)");
return;
}
}
else if(action.equals("3")){
try{
DBConnect dbc=new DBConnect();
String sql;
sql="DROP TABLE IF EXISTS config\n";
out.println("正在删除数据表格config<br>");
dbc.executeUpdate(sql);
out.println("删除成功<br>");
sql="CREATE TABLE config (\n ForumName varchar(20) NOT NULL default '',\n ForumURL varchar(100) NOT NULL default '',\n CompanyName varchar(40) NOT NULL default '',\n HostUrl varchar(100) NOT NULL default '',\n SMTPServer varchar(100) NOT NULL default '',\n SystemEmail varchar(50) NOT NULL default '',\n TimeAdjust varchar(10) NOT NULL default '',\n ScriptTimeOut varchar(10) NOT NULL default '',\n Logo varchar(100) NOT NULL default '',\n Picurl varchar(50) NOT NULL default '',\n Faceurl varchar(50) NOT NULL default '',\n EmailFlag int(11) NOT NULL default '0',\n Uploadpic int(11) NOT NULL default '0',\n IpFlag int(11) NOT NULL default '0',\n FromFlag int(11) NOT NULL default '0',\n guestuser int(11) NOT NULL default '0',\n guestlogin int(11) NOT NULL default '0',\n openmsg varchar(20) NOT NULL default '',\n badwords varchar(255) NOT NULL default '',\n AnnounceMaxBytes varchar(20) NOT NULL default '',\n MaxAnnouncePerPage varchar(15) NOT NULL default '',\n Maxtitlelist varchar(15) NOT NULL default '',\n Tablebackcolor varchar(15) NOT NULL default '',\n aTablebackcolor varchar(15) NOT NULL default '',\n Tabletitlecolor varchar(15) NOT NULL default '',\n aTabletitlecolor varchar(15) NOT NULL default '',\n Tablebodycolor varchar(15) NOT NULL default '',\n aTablebodycolor varchar(15) NOT NULL default '',\n TableFontcolor varchar(15) NOT NULL default '',\n TableContentcolor varchar(15) NOT NULL default '',\n AlertFontColor varchar(15) NOT NULL default '',\n ContentTitle varchar(15) NOT NULL default '',\n ads1 text NOT NULL,\n ads2 text NOT NULL,\n Copyright varchar(255) NOT NULL default '',\n Version varchar(255) NOT NULL default '',\n TitleFlag tinyint(3) unsigned NOT NULL default '0',\n uploadFlag tinyint(3) unsigned NOT NULL default '0',\n wealthReg int(11) NOT NULL default '0',\n wealthAnnounce int(11) NOT NULL default '0',\n wealthReannounce int(11) NOT NULL default '0',\n wealthDel int(11) NOT NULL default '0',\n wealthLogin int(11) NOT NULL default '0',\n epReg int(11) NOT NULL default '0',\n epAnnounce int(11) NOT NULL default '0',\n epReannounce int(11) NOT NULL default '0',\n epDel int(11) NOT NULL default '0',\n epLogin int(11) NOT NULL default '0',\n cpReg int(11) NOT NULL default '0',\n cpAnnounce int(11) NOT NULL default '0',\n cpReannounce int(11) NOT NULL default '0',\n cpDel int(11) NOT NULL default '0',\n cpLogin int(11) NOT NULL default '0',\n TopicNum int(11) NOT NULL default '0',\n BbsNum int(11) NOT NULL default '0',\n TodayNum int(11) NOT NULL default '0',\n UserNum int(11) NOT NULL default '0',\n lastUser varchar(50) NOT NULL default '',\n cookiepath varchar(50) NOT NULL default '',\n Maxonline int(11) NOT NULL default '0',\n MaxonlineDate varchar(50) NOT NULL default ''\n) TYPE=MyISAM\n";
out.println("正在创建数据表config!<br>");
dbc.executeUpdate(sql);
out.println("创建成功！<br>");
sql="DROP TABLE IF EXISTS bbs1";
out.println("正在删除论坛的文章表bbs1<br>");
dbc.executeUpdate(sql);
out.println("删除成功<br>");
sql="\nCREATE TABLE bbs1 (\n AnnounceID int(11) NOT NULL auto_increment,\n ParentID int(11) NOT NULL default '0',\n Child int(11) NOT NULL default '0',\n BoardID int(11) NOT NULL default '0',\n UserName varchar(50) NOT NULL default '',\n UserEmail varchar(255) NOT NULL default '',\n Topic varchar(255) NOT NULL default '',\n Body text NOT NULL,\n DateAndTime datetime NOT NULL default '0000-00-00 00:00:00',\n hits int(11) NOT NULL default '0',\n length int(11) NOT NULL default '0',\n RootID int(11) NOT NULL default '0',\n layer int(11) NOT NULL default '0',\n orders int(11) NOT NULL default '0',\n isbest int(11) NOT NULL default '0',\n ip varchar(20) NOT NULL default '',\n Expression varchar(255) NOT NULL default '',\n times int(11) NOT NULL default '0',\n locktopic int(11) NOT NULL default '0',\n signflag int(11) NOT NULL default '0',\n emailflag int(11) NOT NULL default '0',\n istop int(11) NOT NULL default '0',\n isvote int(11) NOT NULL default '0',\n PRIMARY KEY (AnnounceID),\n KEY boardbbs1(BoardID)\n) TYPE=MyISAM\n";
out.println("正在创建论坛文章表格bbs1<br>");
dbc.executeUpdate(sql);
out.println("创建数据表格bbs1成功！<br>");
sql="DROP TABLE IF EXISTS bbslink";
out.println("正在删除数据表格bbslink<br>");
dbc.executeUpdate(sql);
out.println("删除成功<br>");
sql="cREATE TABLE bbslink (\n id int(11) NOT NULL auto_increment,\n boardname char(50) NOT NULL default '',\n readme char(255) NOT NULL default '',\n url char(150) NOT NULL default '',\n KEY id(id)\n) TYPE=MyISAM";
out.println("正在创建数据表格bblink<br>");
dbc.executeUpdate(sql);
out.println("创建成功！<br>");
sql="DROP TABLE IF EXISTS bbsnews\n";
out.println("正在删除数据表格bbsnews<br>");
dbc.executeUpdate(sql);
out.println("删除成功！<br>");
sql="CREATE TABLE bbsnews (\n id int(11) NOT NULL auto_increment,\n boardid int(11) NOT NULL default '0',\n title varchar(50) NOT NULL default '',\n content text NOT NULL,\n username varchar(50) NOT NULL default '',\n addtime datetime NOT NULL default '0000-00-00 00:00:00',\n KEY bbsnewsboardid(boardid),\n KEY id(id)\n) TYPE=MyISAM\n";
out.println("正在创建数据表格bbsnews<br>");
dbc.executeUpdate(sql);
out.println("创建成功！<br>");
sql="DROP TABLE IF EXISTS board\n";
out.println("正在删除数据表格board!<br>");
dbc.executeUpdate(sql);
out.println("删除成功！<br>");
sql="CREATE TABLE board (\n boardid int(11) NOT NULL auto_increment,\n BoardType varchar(50) NOT NULL default '',\n class int(11) NOT NULL default '0',\n readme varchar(255) NOT NULL default '',\n BoardMaster varchar(50) NOT NULL default '',\n lockboard int(11) NOT NULL default '0',\n boardskin int(11) NOT NULL default '1',\n Tableback varchar(50) NOT NULL default '',\n Tabletitle varchar(50) NOT NULL default '',\n Tablebody varchar(50) NOT NULL default '',\n aTablebody varchar(50) NOT NULL default '',\n TableFont varchar(50) NOT NULL default '',\n TableContent varchar(50) NOT NULL default '',\n AlertFont varchar(50) NOT NULL default '',\n lastpostuser varchar(50) NOT NULL default '',\n lastposttime datetime NOT NULL default '0000-00-00 00:00:00',\n lastbbsnum int(11) NOT NULL default '0',\n lasttopicnum int(11) NOT NULL default '0',\n strAllowForumCode int(11) NOT NULL default '0',\n strAllowHTML int(11) NOT NULL default '0',\n strIMGInPosts int(11) NOT NULL default '0',\n strIcons int(11) NOT NULL default '0',\n strflash int(11) NOT NULL default '0',\n Forumlogo varchar(255) NOT NULL default '',\n indexIMG varchar(255) NOT NULL default '',\n lastrootid int(11) NOT NULL default '0',\n lasttopic varchar(255) NOT NULL default '',\n todayNum int(11) NOT NULL default '0',\n boarduser text NOT NULL,\n PRIMARY KEY (boardid)\n) TYPE=MyISAM\n";
out.println("正在创建数据表格board!<br>");
dbc.executeUpdate(sql);
out.println("创建成功！<br>");
sql="DROP TABLE IF EXISTS bookmark\n";
out.println("正在删除数据表格bookmark!<br>");
dbc.executeUpdate(sql);
out.println("删除成功！<br>");
sql="CREATE TABLE bookmark (\n id int(11) NOT NULL auto_increment,\n username varchar(50) NOT NULL default '',\n url varchar(100) default NULL,\n topic varchar(100) default NULL,\n addtime varchar(19) default NULL,\n KEY bookmarkUserName(username),\n KEY id(id)\n) TYPE=MyISAM\n";
out.println("正在创建数据表格bookmark<br>");
dbc.executeUpdate(sql);
out.println("创建成功！<br>");
sql="DROP TABLE IF EXISTS class\n";
out.println("正在删除数据表格class!<br>");
dbc.executeUpdate(sql);
out.println("删除成功！<br>");
sql="CREATE TABLE class (\n id int(11) NOT NULL auto_increment,\n class char(50) NOT NULL default '',PRIMARY KEY (id)\n) TYPE=MyISAM\n";
out.println("正在创建数据表格class<br>");
dbc.executeUpdate(sql);
out.println("创建成功！<br>");
sql="DROP TABLE IF EXISTS friend\n";
out.println("正在删除数据表格friend<br>");
dbc.executeUpdate(sql);
out.println("删除成功！");
sql="CREATE TABLE friend (\n F_id int(11) NOT NULL auto_increment,\n F_username varchar(50) default NULL,\n F_friend varchar(50) default NULL,\n F_addtime varchar(19) default NULL,\n PRIMARY KEY (F_id)\n) TYPE=MyISAM\n";
out.println("创建数据表格friend<br>");
dbc.executeUpdate(sql);
out.println("创建成功！<br>");
sql="DROP TABLE IF EXISTS log\n";
out.println("删除数据表格table成功！<br>");
dbc.executeUpdate(sql);
out.println("删除成功！<br>");
sql="CREATE TABLE log (\n l_id int(11) NOT NULL auto_increment,\n l_username varchar(50) default NULL,\n l_content varchar(50) default NULL,\n l_url varchar(255) default NULL,\n l_addtime varchar(19) default NULL,\n PRIMARY KEY (l_id)\n) TYPE=MyISAM\n";
out.println("正在创建数据表格log<br>");
dbc.executeUpdate(sql);
out.println("创建成功！");
sql="DROP TABLE IF EXISTS message\n";
out.println("删除数据表格message!<br>");
dbc.executeUpdate(sql);
out.println("删除成功！<br>");
sql="CREATE TABLE message (\n id int(11) NOT NULL auto_increment,\n sender varchar(50) default NULL,\n incept varchar(50) default NULL,\n title varchar(100) default NULL,\n content text,\n flag int(11) default '0',\n sendtime varchar(19) default NULL,\n delR int(11) default '0',\n delS int(11) default '0',\n isSend int(11) default '0',\n PRIMARY KEY (id)\n) TYPE=MyISAM\n";
out.println("正在创建数据表格message!<br>");
dbc.executeUpdate(sql);
out.println("创建成功！<br>");
sql="DROP TABLE IF EXISTS online\n";
out.println("正在删除数据表格online<br>");
dbc.executeUpdate(sql);
out.println("删除成功！<br>");
sql="CREATE TABLE online (\n id double NOT NULL auto_increment,\n username char(50) NOT NULL default '',\n userclass char(50) NOT NULL default '',\n stats char(250) NOT NULL default '',\n ip char(50) NOT NULL default '',\n startime datetime NOT NULL default '0000-00-00 00:00:00',\n lastimebk datetime NOT NULL default '0000-00-00 00:00:00',\n lastime char(50) NOT NULL default '',\n browser char(100) NOT NULL default '',\n actforip char(50) default NULL,\n ComeFrom char(50) NOT NULL default '',\n actCome char(50) default NULL\n,\n PRIMARY KEY (id)\n) TYPE=MyISAM\n";
out.println("正在创建数据表格online<br>");
dbc.executeUpdate(sql);
out.println("创建成功！<br>");
sql="DROP TABLE IF EXISTS user\n";
out.println("正在删除表格user<br>");
dbc.executeUpdate(sql);
out.println("删除成功！<br>");
sql="CREATE TABLE user (\n UserID int(11) NOT NULL auto_increment,\n UserName varchar(50) NOT NULL default '',\n UserEmail varchar(255) default NULL,\n Article int(11) default '0',\n UserPassword varchar(11) NOT NULL default '',\n sign text,\n Sex varchar(10) default NULL,\n homepage varchar(255) default NULL,\n addDate datetime default '0000-00-00 00:00:00',\n logins int(11) default '0',\n face varchar(255) default NULL,\n width int(11) default '0',\n height int(11) default '0',\n Oicq varchar(50) default NULL,\n lastlogin datetime default '0000-00-00 00:00:00',\n bbstype int(11) default '0',\n lockuser int(11) default '0',\n userclass int(11) default '0',\n UserGroup varchar(50) default NULL,\n userWealth int(11) default '0',\n userEP int(11) default '0',\n userCP int(11) default '0',\n title varchar(50) default NULL,\n showre tinyint(3) unsigned default '0',\n reann varchar(50) default NULL,\n PRIMARY KEY (UserID)) TYPE=MyISAM\n";
out.println("正在创建数据表格user<br>");
dbc.executeUpdate(sql);
out.println("创建成功！<br>");
sql="DROP TABLE IF EXISTS vote\n";
out.println("正在删除数据表格vote<br>");
dbc.executeUpdate(sql);
out.println("删除成功！<br>");
sql="CREATE TABLE vote (\n voteid int(11) NOT NULL auto_increment,\n announceid int(11) NOT NULL default '0',\n vote text NOT NULL,\n votenum varchar(50) NOT NULL default '',\n voteuser text NOT NULL,\n votetype int(11) NOT NULL default '0',\n PRIMARY KEY (voteid)\n) TYPE=MyISAM\n\n";
out.println("正在创建数据表格vote<br>");
dbc.executeUpdate(sql);
out.println("创建成功！<br>");
sql="INSERT INTO config VALUES (?, 'http://www.justhis.com/forum/', ?,\n 'http://www.justhis.com/', 'smtp.21cn.com', 'bitiboy@msn.com', '0', '300', 'pic/LOGO.GIF',\n 'pic/', 'face/', 1, 1, 0, 0, 1, 1, '0', ?, '16384',\n '20', '10', '#0099cc', '#777777', '#99ccff', '#e8f4ff', '#f2f8ff', '#e8f4ff', '#000000', \n'#000000', '#ff0000', '#00008b', '', '', ?, ?, '1', '1', 100, 3, 1, 5, 2, 0, 2,\n 1, 3, 1, 30, 2, 1, 3, 1, 0, 0, 0, 0, '', '/', 1, now())";
out.println("正在初始化数据库<br>");
dbc.prepareStatement(sql);
dbc.setBytes(1,"阿菜网络论坛".getBytes("GBK"));
dbc.setBytes(2,"阿菜网络".getBytes("GBK"));
dbc.setBytes(3,"操|妈妈的|我靠|fuck|bitch|变态|奶奶的|逼".getBytes("GBK"));
dbc.setBytes(4,"版权所有： <a href=http://www.justhis.com><font \nface=Verdana, Arial, Helvetica, sans-serif size=1><b>Justhis<font \ncolor=#CC0000>.Com</font></b></font></a>".getBytes("GBK"));
dbc.setBytes(5,"版本：<a \nhref=http://www.justhis.com/forum/download.jsp>Ver0.001</a>".getBytes("GBK"));
dbc.executeUpdate();
out.println("初始化成功！<br>");
%>
<form action="">
<input type="hidden" name="action" value="4">
<input type="submit" value="下一步">
</form>
<%
dbc.close();
}
catch(Exception e){
e.printStackTrace();
return;
}
}
else if(action.equals("4")){
%>
<%@include file="INC/const.jsp"%>
<form method="POST" action="install.jsp">
<input type="hidden" name="action" value="5">
<table width="95%" border="0" cellspacing="1" cellpadding="3" align=center bordercolor=<%=aTableBackColor%>>
<tr bgcolor=<%=aTableTitleColor%>>
<td height="23" colspan="2" ><font color=<%=tableFontColor%>><b>论坛变量设置</b></font></td>
</tr>
<tr>
<td width="41%">论坛名称</td>
<td width="59%">
<input type="text" name="forumName" size="35" value="<%=forumName%>">
</td>
</tr>
<tr>
<td width="41%">论坛的url</td>
<td width="59%">
<input type="text" name="forumURL" size="35" value="<%=forumURL%>">
</td>
</tr>
<tr>
<td width="41%">主页名称</td>
<td width="59%">
<input type="text" name="companyName" size="35" value="<%=companyName%>">
</td>
</tr>
<tr>
<td width="41%">主页URL</td>
<td width="59%">
<input type="text" name="hostURL" size="35" value="<%=hostURL%>">
</td>
</tr>
<tr>
<td width="41%">SMTP Server地址</td>
<td width="59%">
<input type="text" name="SMTPServer" size="35" value="<%=SMTPServer%>">
</td>
</tr>
<tr>
<td width="41%">论坛管理员Email</td>
<td width="59%">
<input type="text" name="systemEmail" size="35" value="<%=systemEmail%>">
</td>
</tr>
<tr>
<td width="41%">服务器时差</td>
<td width="59%">
<input type="text" size="35" value="<%=timeAdjust%>" name="timeAdjust">
</td>
</tr>
<tr>
<td width="41%">服务器脚本超时时间值，建议不要使用</td>
<td width="59%">
<input type="text" name="scriptTimeOut" size="35" value="<%=scriptTimeOut%>">
</td>
</tr>
<tr>
<td width="41%">论坛forumLogo地址</td>
<td width="59%">
<input type="text" name="forumLogo" size="35" value="<%=forumLogo%>">
</td>
</tr>
<tr>
<td width="41%">论坛图片目录</td>
<td width="59%">
<input type="text" name="picURL" size="35" value="<%=picURL%>">
</td>
</tr>
<tr>
<td width="41%">论坛表情地址</td>
<td width="59%">
<input type="text" name="faceURL" size="35" value="<%=faceURL%>">
</td>
</tr>
<tr>
<td width="41%">发送邮件组件</td>
<td width="59%">
<select name="emailFlag">
<option value="0" <%if(emailFlag==0) {%>selected<%}%>>不支持
<option value="1" <%if (emailFlag==1) {%>selected<%}%>>JMAIL
<option value="2" <%if (emailFlag==2) {%>selected<%}%>>CDONTS
<option value="3" <%if (emailFlag==3) {%>selected<%}%>>ASPEMAIL
</select>
</td>
</tr>
<tr>
<td width="41%">贴子上传图片</td>
<td width="59%">
<select name="uploadPic">
<option value="0" <%if("0".equals(uploadPic)) {%>selected<%}%>>否
<option value="1" <%if("1".equals(uploadPic)) {%>selected<%}%>>是
</select>
</td>
</tr>
<tr>
<td width="41%">用户IP</td>
<td width="59%">
<select name="ipFlag">
<option value="0" <%if ("0".equals(ipFlag)) {%>selected<%}%>>保密
<option value="1" <%if ("1".equals(ipFlag)) {%>selected<%}%>>公开
</select>
</td>
</tr>
<tr>
<td width="41%">头像上传</td>
<td width="59%">
<select name="uploadFlag">
<option value="0" <%if ("0".equals(uploadFlag)) {%>selected<%}%>>否
<option value="1" <%if ("1".equals(uploadFlag)) {%>selected<%}%>>是
</select>
</td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -