initdatabase.jsp

这是一个用JSP开发的论坛源 码。。。 按照上在的README可轻松的捅有下JSP论坛

       String support="http://www.lybbs.net";
       String programmer="teddy 『星语凌』";
       String programemail="[e-mail]";
       String programqq="14606667";
       String version="ver 2.8.Server";
       String versionnumber="20031101";
       //凌云论坛内部信息，未经许可，绝对禁止修改，因为不听劝告，自行修改而可能带来的安装失败、数据破坏、升级失败、甚至服务器瘫痪等一切后果，概与本人无关。
       //谨记：因为坚持修改而带来的一切后果自负！！！
       //请尊重我的版权，请尊重我的劳动成果！
       number=dbConnect.executeUpdate("insert into config (id,title,support,programmer,programemail,programqq,version,versionnumber) values (1,'"+bbstitle+"','"+support+"','"+programmer+"','"+programemail+"','"+programqq+"','"+version+"','"+versionnumber+"')");
       if(number>0)
          out.println("写数据<b>完成！</b><br><br>");
       else out.println("写数据<b><font color=#ff0000>失败！</font></b><br><br>");
    //结束创建

    title="系统公告表";
    //开始创建
    query="CREATE TABLE announcement (id INT(8) UNSIGNED NOT NULL AUTO_INCREMENT,db smallint(4) unsigned not null ,author varchar(40) not null ,title varchar(150) NOT NULL ,content text not null,postat datetime not null, PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    number=dbConnect.executeUpdate(query);
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    //结束创建

    title="论坛小字报表";
    //开始创建
    query="CREATE TABLE xzb (id INT(8) UNSIGNED NOT NULL AUTO_INCREMENT,db smallint(4) unsigned not null ,author varchar(40) not null ,title varchar(150) NOT NULL ,content text not null,postat datetime not null, PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    number=dbConnect.executeUpdate(query);
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    //结束创建


    title="样式配置数据表";
    //开始创建
    query="CREATE TABLE style (id SMALLINT(4) UNSIGNED NOT NULL AUTO_INCREMENT,title varchar(30) NOT NULL ,adminselected enum('0','1') not null,forum smallint(4) not null,db smallint(4) not null,adminnamecolor varchar(8) NOT NULL,adminglow varchar(8) NOT NULL,banglow varchar(8) not null,catback varchar(8) not null,catbackpic varchar(20) not null,catfontcolor varchar(8) not null,font varchar(10) not null,fontcolormisc varchar(8) not null,fonthighlight varchar(8) not null,forumcolorone varchar(8) not null,forumcolortwo varchar(8) not null,forumfontcolor varchar(8) not null,lastpostfontcolor varchar(8) not null,lbbody varchar(150) not null,memglow varchar(8) not null,menufontcolor varchar(8) not null,menubackground varchar(8) not null,menubackpic varchar(20) not null,miscbackone varchar(8) not null,miscbacktwo varchar(8) not null,otherbackpic varchar(20) not null,otherbackpic1 varchar(20) not null,postcolorone varchar(8) not null,postcolortwo varchar(8) not null,postfontcolorone varchar(8) not null,postfontcolortwo varchar(8) not null,posternamefont varchar(10) not null,posternamecolor varchar(8) not null,smonamecolor varchar(8) not null,smoglow varchar(8) not null,tablebordercolor varchar(8) not null,teamnamecolor varchar(8) not null,teamglow varchar(8) not null,titleback varchar(8) not null,titleborder varchar(8) not null,titlecolor varchar(8) not null,titlefont varchar(8) not null,titlefontcolor varchar(8) not null,tablewidth varchar(8) not null,PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    number=dbConnect.executeUpdate(query); 
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
%>
<%@ include file="initstyle.jsp"%>
<%
    //结束创建

    title="公共样式配置数据表";
    //开始创建
    query="CREATE TABLE publicstyle (id TINYINT(2) UNSIGNED NOT NULL AUTO_INCREMENT,advpost enum('0','1') not null,allowattachment enum('0','1') not null,announcemove enum('0','1') not null,arrawpostflash enum('0','1') not null,arrawpostfontsize enum('0','1') not null,arrawpostmedia enum('0','1') not null,arrawpostpic enum('0','1') not null,arrawpostsound enum('0','1') not null,arrawsignflash enum('0','1') not null,arrawsignfontsize enum('0','1') not null,arrawsignmedia enum('0','1') not null,arrawsignpic enum('0','1') not null,arrawsignsound enum('0','1') not null,arrowavaupload enum('0','1') not null,arrowupload enum('0','1') not null,arrowuserdel enum('0','1') not null,autofreshtime smallint(5) unsigned not null,banfreshtime tinyint(2) unsigned not null,boarddispsign enum('0','1') not null,boardlogo varchar(30) not null,cinoption tinyint(3) unsigned not null,defaultheight tinyint(3) unsigned not null,defaultsmileheight tinyint(3) unsigned not null,defaultsmilewidth tinyint(3) unsigned not null,defaultwidth tinyint(3) unsigned not null,dispquickreply enum('0','1') not null,dispview enum('0','1') not null,editjhmpself enum('0','1') not null,editusertitleself enum('0','1') not null,hottopicmark tinyint(2) unsigned not null,hotpollmark tinyint(3) unsigned not null,infosopen tinyint(2) unsigned not null,imageviewnumber tinyint(2) unsigned not null,logdelmax tinyint(2) unsigned not null,look enum('0','1') not null,maxdeloneday tinyint(3) unsigned not null,maxinslegth tinyint(3) unsigned not null,maxinsline tinyint(2) unsigned not null,maxlistpost tinyint(2) unsigned not null,maxpollitem tinyint(3) unsigned not null,maxposticonheight tinyint(3) unsigned not null,maxposticonwidth tinyint(3) unsigned not null,maxpostreport tinyint(2) unsigned not null,maxsavepost tinyint(2) unsigned not null,maxsignlegth smallint(3) unsigned not null,maxsignline tinyint(2) unsigned not null,maxsmail tinyint(2) unsigned not null,maxthreads tinyint(2) unsigned not null,maxtopics tinyint(2) unsigned not null,maxtoptopic tinyint(2) unsigned not null,maxupload smallint(5) not null,membergone tinyint(2) unsigned not null,movetopicname enum('0','1') not null,newmarktime tinyint(3) unsigned not null,newmsgpop enum('0','1') not null,newrefers tinyint(2) unsigned not null,noself enum('0','1') not null,onlineview enum('0','1') not null,pagechange enum('0','1') not null,paraspace tinyint(3) unsigned not null,pvtip enum('0','1') not null,quotemode enum('0','1') not null,refreshforum enum('0','1') not null,regaccess enum('0','1') not null,searchopen enum('0','1') not null,sendwelcomemessage enum('0','1') not null,showskin enum('0','1') not null,smocanseeip enum('0','1') not null,sortalltopic enum('0','1') not null,sortposticonshow enum('0','1') not null,statsopen enum('0','1') not null,timetoshow tinyint(3) unsigned not null,linesperpage tinyint(2) unsigned not null,wordspace tinyint(3) not null,xzbopen enum('0','1') not null, PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    number=dbConnect.executeUpdate(query); 
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
%>
<%@ include file="initpublicstyle.jsp"%>
<%
    //结束创建

    title="短消息中心表";
    //开始创建
    query="CREATE TABLE webqq (id INT(6) UNSIGNED NOT NULL AUTO_INCREMENT, fromname varchar(30) NOT NULL ,toname varchar(30) NOT NULL ,title varchar(200) not null, message text NOT NULL ,sendat datetime NOT NULL ,operation varchar(4) NOT NULL ,viewed enum('0','1') NOT NULL , PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    number=dbConnect.executeUpdate(query);
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    //结束创建

    title="用户好友表";
    //开始创建
    query="CREATE TABLE friend (id INT(6) UNSIGNED NOT NULL AUTO_INCREMENT ,authorid int(6) unsigned not null ,friendname varchar(30) NOT NULL , PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    number=dbConnect.executeUpdate(query);
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    //结束创建

    title="禁止ip列表表";
    //开始创建
    query="CREATE TABLE banip (id SMALLINT(4) UNSIGNED NOT NULL AUTO_INCREMENT, banip varchar(20) NOT NULL , PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    number=dbConnect.executeUpdate(query);
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    //结束创建

    title="禁止言词表";
    //开始创建
    query="CREATE TABLE banword (id SMALLINT(4) UNSIGNED NOT NULL AUTO_INCREMENT, banword varchar(50) NOT NULL , PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    number=dbConnect.executeUpdate(query);
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    //结束创建

    title="论坛总分类信息表";
    //开始创建
    query="CREATE TABLE forum (id SMALLINT(4) UNSIGNED NOT NULL AUTO_INCREMENT,forum SMALLINT(4) UNSIGNED NOT NULL , forumname varchar(150) NOT NULL , forumexpand enum('1','0') not null, PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    number=dbConnect.executeUpdate(query);
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    //结束创建

    title="分类中分论坛信息表";
    //开始创建
    query="CREATE TABLE db (id SMALLINT(4) UNSIGNED NOT NULL AUTO_INCREMENT,forum SMALLINT(4) UNSIGNED NOT NULL,db SMALLINT(4) UNSIGNED NOT NULL, dbname varchar(30) NOT NULL , dbdescription varchar(100) NOT NULL ,htmlstat enum('0','1') not null,lycodestat enum('0','1') not null,privateforum enum('0','1') not null,dbpassword varchar(30) NOT NULL ,indexforum enum('0','1') not null,startnewthreads varchar(20) NOT NULL ,ratings enum('0','1') not null,dbgraphic varchar(30) NOT NULL ,teamlogo varchar(30) NOT NULL ,teamurl varchar(30) NOT NULL ,forumType VARCHAR(100) NOT NULL, PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    number=dbConnect.executeUpdate(query);
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    //结束创建

    title="联盟论坛信息表";
    //开始创建
    query="CREATE TABLE allianceforum (id SMALLINT(4) UNSIGNED NOT NULL AUTO_INCREMENT, forumname varchar(80) NOT NULL , forumurl varchar(150) NOT NULL ,weblogo varchar(150) NOT NULL ,forumdescription varchar(200) NOT NULL ,PRIMARY KEY (id), INDEX (id))";