initdatabase.jsp

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

    dbConnect.insert("ALTER TABLE posts ADD INDEX (forumType)");
    dbConnect.insert("alter table moneyhiddeninfo add index moneyhiddeninfo_1 (postID,postAuthorID)");
    number=dbConnect.executeBatch(false);
    if(number>0) {
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    }
    else {
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }
}

else if(previousversionnumber.equals("20030512")) {
    title="买帖的用户记录";
    //开始创建
    query="CREATE TABLE moneyhiddeninfo (id INT(10) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT, postID INT(10) UNSIGNED DEFAULT '0' NOT NULL, postAuthorID INT(6) UNSIGNED DEFAULT '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>");

    //开始升级
    out.println("<br><b>开始升级</b> <font color=#0000ff>"+title+"</font> ……<br>");
    dbConnect.insert("ALTER TABLE posts ADD markHidden ENUM('0','1') DEFAULT '0' NOT NULL, ADD markPost TINYINT(2) UNSIGNED DEFAULT '0' NOT NULL, ADD moneyHidden ENUM('0','1') DEFAULT '0' NOT NULL, ADD moneyPost SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL");
    dbConnect.insert("alter table moneyhiddeninfo add index moneyhiddeninfo_1 (postID,postAuthorID)");
    dbConnect.insert("ALTER TABLE posts CHANGE content content TEXT NOT NULL");
    dbConnect.insert("ALTER TABLE db ADD forumType VARCHAR(100) NOT NULL");
    dbConnect.insert("ALTER TABLE posts ADD forumType VARCHAR(20) NOT NULL");
    dbConnect.insert("ALTER TABLE posts ADD INDEX (forumType)");
    dbConnect.insert("ALTER TABLE config ADD addType varchar(200) not null");
    dbConnect.insert("ALTER TABLE uploadinfo ADD filewidth smallint(5) unsigned not null, ADD fileheight smallint(5) unsigned not null");
    number=dbConnect.executeBatch(false);
    if(number>0) {
       out.println("<font color=#0000ff>"+title+"</font> 升级<b>完成！</b><br><br>");
    }
    else {
       out.println("<font color=#0000ff>"+title+"</font> 升级<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }

}
else if(previousversionnumber.equals("20030612")) {
    //开始升级
    out.println("<br><b>开始升级</b> <font color=#0000ff>"+title+"</font> ……<br>");
    dbConnect.insert("ALTER TABLE uploadinfo ADD filewidth smallint(5) unsigned not null, ADD fileheight smallint(5) unsigned not null");
    number=dbConnect.executeBatch(false);
    if(number>0) {
       out.println("<font color=#0000ff>"+title+"</font> 升级<b>完成！</b><br><br>");
    }
    else {
       out.println("<font color=#0000ff>"+title+"</font> 升级<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }

}
else if(previousversionnumber.equals("20030906")) {
  //没有要单独升级的数据
}
if(previousversionnumber.equals("20030512") || previousversionnumber.equals("20030612") || previousversionnumber.equals("20030906")) {
    //升级数据库

    String bbstitle="LyBBS『凌云论坛』";
    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("update config set title='"+bbstitle+"',support='"+support+"',programmer='"+programmer+"',programemail='"+programemail+"',programqq='"+programqq+"',version='"+version+"',versionnumber='"+versionnumber+"' where id=1");
    if(number>0)
       out.println("写数据<b>完成！</b><br><br>");
    else out.println("写数据<b><font color=#ff0000>失败！</font></b><br><br>");
    dbConnect.executeUpdate("update allianceforum set forumurl='http://www.lybbs.net'");

    //开始升级
    out.println("<br><b>开始升级</b> <font color=#0000ff>"+title+"</font> ……<br>");
    dbConnect.insert("drop table style");
    number=dbConnect.executeBatch(false);

    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"%>
<%
    //结束创建

    dbConnect.insert("ALTER TABLE style ADD INDEX(adminselected)");
    dbConnect.insert("ALTER TABLE style ADD INDEX(db)");
    number=dbConnect.executeBatch(false);
    out.println("<font color=#0000ff>"+title+"</font> 升级<b>完成！</b><br><br>");

}
    //结束升级
dbConnect.close();
%>