initdatabase.jsp

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

<%
/*##################################################################**
**#  程序名称：LyBBS『凌云论坛』                                   #**
**#                                                                #**
**#  程序开发: teddy 『星语凌』                                    #**
**#                                                                #**
**#  版权所有: 凌云创作室 (原流星电脑工作室)                       #**
**#                                                                #**
**#  主页地址: http://www.lybbs.net                                #**
**#  电邮地件: [e-mail]                                    #**
**#                                                                #**
**##################################################################*/
%>
<%
    //开始数据库初始化
    //模板：CREATE TABLE '' ('id' INT() UNSIGNED NOT NULL AUTO_INCREMENT, '' () NOT NULL , PRIMARY KEY ('id'), INDEX ('id'))
    //internalversion:1.2.1
    String title="";
dbConnect=new DBConnect();

if(previousversionnumber.equals("")) {
    title="用户表";
    //开始创建
    query="CREATE TABLE author (id INT(6) UNSIGNED NOT NULL AUTO_INCREMENT, username varchar(40) NOT NULL , password varchar(40) NOT NULL ,msgpopup enum('1','0') not null,myinfo ENUM('0','1') NOT NULL, mess VARCHAR(255) NOT NULL, advpost ENUM('0','1') NOT NULL,hidden enum('0','1') not null, onlineview enum('1','0') not null,threadages smallint(3) NOT NULL ,viewmode varchar(10) NOT NULL ,email varchar(40) NOT NULL ,showemail enum('0','1') not null,lostquestion varchar(150) not null,lostanswer varchar(150) not null,sex varchar(4) NOT NULL ,education varchar(10) NOT NULL ,marry varchar(8) NOT NULL ,work varchar(20) NOT NULL ,birthday date not null, astro varchar(8) NOT NULL ,usersx varchar(8) NOT NULL ,homepage varchar(40) NOT NULL ,qq varchar(16) NOT NULL ,icq varchar(16) NOT NULL ,country varchar(30) NOT NULL ,province varchar(30) NOT NULL ,city varchar(30) NOT NULL ,timedifference tinyint(3) not null,introdution varchar(255) NOT NULL ,signature varchar(255) NOT NULL ,notshowsignature ENUM('0','1') DEFAULT '0' NOT NULL,imagename varchar(30) NOT NULL ,imageurl VARCHAR(255) NOT NULL,imagewidth tinyint(3) unsigned NOT NULL ,imageheight tinyint(3) unsigned NOT NULL ,lastactivetime datetime NOT NULL ,logintime datetime NOT NULL ,activetime datetime NOT NULL ,registertime datetime NOT NULL ,online enum('0','1') not null,mark int(6) UNSIGNED not null,nposts int(6) UNSIGNED not null,ndelete int(6) UNSIGNED not null,nreply int(6) UNSIGNED not null,money int(8) unsigned not null,experience int(8) unsigned not null,charm int(8) unsigned not null,visittimes int(6) UNSIGNED not null,newmembertitle varchar(30) NOT NULL ,newsocialpart varchar(40) NOT NULL ,status char(1) not null default '0',allowprivate ENUM('0','1') DEFAULT '0' NOT NULL,styleid smallint(4) not null,viewid int(10) not null,forum smallint(4) unsigned not null,db smallint(4) unsigned not null,position VARCHAR(30) NOT NULL,recommendname varchar(30) not null,ipfrom varchar(30) not null,usermode tinyint(2) UNSIGNED not null DEFAULT '1',grade tinyint(2) not null,freshtime smallint(5) unsigned 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 reservename (id SMALLINT(4) UNSIGNED NOT NULL AUTO_INCREMENT, reservename 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="保留电子邮件表";
    //开始创建
    query="CREATE TABLE reservemail (id SMALLINT(4) UNSIGNED NOT NULL AUTO_INCREMENT, reservemail 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="用户分数维护计算表";
    //开始创建
    query="CREATE TABLE encourage (id tinyint(2) unsigned not null,coinname VARCHAR(20) NOT NULL , addrecommendmoney SMALLINT(4) UNSIGNED NOT NULL , addrecommendexperience SMALLINT(4) UNSIGNED NOT NULL , addrecommendcharm SMALLINT(4) UNSIGNED NOT NULL , addmoney SMALLINT(4) UNSIGNED NOT NULL , replymoney SMALLINT(4) UNSIGNED NOT NULL , loginmoney SMALLINT(4) UNSIGNED NOT NULL , delmoney SMALLINT(4) UNSIGNED NOT NULL , joinmoney SMALLINT(4) UNSIGNED NOT NULL , addexperience SMALLINT(4) UNSIGNED NOT NULL , replyexperience SMALLINT(4) UNSIGNED NOT NULL , loginexperience SMALLINT(4) UNSIGNED NOT NULL , delexperience SMALLINT(4) UNSIGNED NOT NULL , joinexperience SMALLINT(4) UNSIGNED NOT NULL , addcharm SMALLINT(4) UNSIGNED NOT NULL , replycharm SMALLINT(4) UNSIGNED NOT NULL , logincharm SMALLINT(4) UNSIGNED NOT NULL , delcharm SMALLINT(4) UNSIGNED NOT NULL , joincharm SMALLINT(4) UNSIGNED 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>");
       number=dbConnect.executeUpdate("insert into encourage (id,coinname,addrecommendmoney,addrecommendexperience,addrecommendcharm,addmoney,replymoney,loginmoney,delmoney,joinmoney,addexperience,replyexperience,loginexperience,delexperience,joinexperience,addcharm,replycharm,logincharm,delcharm,joincharm) values (1,'凌元点',100,0,10,10,8,15,20,1000,6,6,2,10,100,8,5,5,10,100)");
       if(number>0)
          out.println("写数据<b>完成！</b><br><br>");
       else out.println("写数据<b><font color=#ff0000>失败！</font></b><br><br>");
    //结束创建

    title="用户等级称谓数据表";
    //开始创建
    query="CREATE TABLE grade (usermode TINYINT(2) UNSIGNED NOT NULL,grade TINYINT(2) UNSIGNED NOT NULL, mpostmark int(10) UNSIGNED NOT NULL , mname varchar(20) NOT NULL , mgraphic varchar(20) NOT NULL , INDEX (grade))";
    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>");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,0,0,'新手上路','')");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,1,12,'侠客','pips1.gif')");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,2,50,'骑士','pips2.gif')");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,3,80,'圣骑士','pips3.gif')");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,4,150,'精灵','pips4.gif')");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,5,250,'精灵王','pips4.gif')");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,6,400,'风云使者','pips5.gif')");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,7,700,'光明使者','pips5.gif')");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,8,1000,'天使','pips6.gif')");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,9,1500,'大天使','pips6.gif')");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,10,2500,'精灵使','pips7.gif')");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,11,5000,'法师','pips8.gif')");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,12,8000,'大法师','pips8.gif')");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,13,12000,'法王','pips9.gif')");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,14,20000,'老法王','pips9.gif')");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,15,30000,'天神','pips10.gif')");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,16,50000,'天王','pips10.gif')");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,17,100000,'法老','pips10.gif')");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,18,99999999,'法老','pips10.gif')");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,19,99999999,'法老','pips10.gif')");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,20,99999999,'法老','pips10.gif')");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (3,0,0,'高级天王 [荣誉]','pips10.gif')");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (6,0,0,'终极天王 [荣誉]','pips10.gif')");
       dbConnect.insert("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (7,0,0,'究级天王 [荣誉]','pips10.gif')");
       number=dbConnect.executeBatch(false);
       if(number>0)
          out.println("写数据<b>完成！</b><br><br>");
       else out.println("写数据<b><font color=#ff0000>失败！</font></b><br><br>");
    //结束创建

    title="管理员信息表";
    //开始创建
    query="CREATE TABLE admin (id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT, authorid INT(6) UNSIGNED NOT NULL,authorname varchar(30) not null,forum SMALLINT(4) UNSIGNED NOT NULL,db SMALLINT(4) UNSIGNED NOT NULL,usermode tinyint(2) 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 config (id TINYINT(1) UNSIGNED NOT NULL, emailsupport enum('0','1') not null,smtp VARCHAR(30) NOT NULL ,sendemail VARCHAR(30) NOT NULL ,getemail VARCHAR(30) NOT NULL ,boarddescription VARCHAR(100) NOT NULL ,boardname VARCHAR(30) NOT NULL ,boardurl VARCHAR(30) NOT NULL ,copyright VARCHAR(255) NOT NULL ,title VARCHAR(30) NOT NULL ,support VARCHAR(200) NOT NULL ,programmer varchar(50) not null,programemail varchar(30) not null,programqq varchar(20) not null,version VARCHAR(30) NOT NULL,versionnumber VARCHAR(20) NOT NULL ,homename VARCHAR(50) NOT NULL ,homeurl VARCHAR(80) NOT NULL ,uploaddir VARCHAR(200) NOT NULL ,uploadurl VARCHAR(120) NOT NULL ,announcement enum('1','0') not null,floodcontrol enum('1','0') not null,floodcontrollimit tinyint(3) unsigned not null,togb enum('0','1') not null,status enum('1','0') not null,maintainreason VARCHAR(255) NOT NULL ,register enum('1','0') not null,registerreason VARCHAR(255) NOT NULL ,timedifference tinyint(3) not null,supername VARCHAR(30) NOT NULL ,superpassword VARCHAR(30) NOT NULL ,emoticons enum('1','0') not null,avatars enum('1','0') not null,allowusemsg enum('1','0') not null,maxmsgno smallint(6) unsigned not null,newusernotify enum('0','1') not null,oneaccountperemail  enum('0','1') not null,adimage varchar(100) not null,adimagelink varchar(100) not null,adimagewidth smallint(4) unsigned not null,adimageheight smallint(4) unsigned not null,arrowonlinemax smallint(4) unsigned not null,oicqshow enum('0','1') not null,useemote enum('1','0') not null,sticky enum('1','0') not null,dispboardsm enum('1','0') not null,dispborn enum('1','0') not null,recordviewstat  enum('1','0') not null,showfastlogin varchar(20) default 'top' not null,maxuploadava tinyint(3) unsigned not null default 200,db VARCHAR(30) NOT NULL, language VARCHAR(10) NOT NULL,addType VARCHAR(200) 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>");
       String bbstitle="LyBBS『凌云论坛』";