initdatabase.jsp

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

    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 allianceforum (forumname,forumurl,weblogo,forumdescription) VALUES ('凌云论坛','http://www.lybbs.net','images/lylogo.gif','LyBBS『凌云论坛』大本营')");
       if(number>0)
          out.println("写数据<b>完成！</b><br><br>");
    //结束创建

    title="帖子库表";
    //开始创建
    query="CREATE TABLE posts (id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, forum smallint(4) UNSIGNED not null,db smallint(4) UNSIGNED not null,clicktimes int(6) unsigned not null,hotpost enum('0','1') not null,view varchar(30) NOT NULL,groupid int(10) UNSIGNED not null,orderby int(10) unsigned not null,parentid int(10) UNSIGNED not null,top enum('0','1') not null,titlelock enum('0','1') not null,titleimage varchar(20) NOT NULL ,authorid int(6) UNSIGNED not null,author varchar(30) NOT NULL ,title varchar(80) not null,content text not null,postat datetime not null,ipfrom varchar(20) NOT NULL ,accessary enum('0','1') not null,accessaryname varchar(20) NOT NULL ,vote enum('0','1') not null,jinghua enum('0','1') not null ,markHidden ENUM('0','1') DEFAULT '0' NOT NULL, markPost  TINYINT(2) UNSIGNED DEFAULT '0' NOT NULL, moneyHidden ENUM('0','1') DEFAULT '0' NOT NULL, moneyPost SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL, forumType VARCHAR(20) 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>");
    //结束创建

    title="投票系统表";
    //开始创建
    query="CREATE TABLE vote (id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT, postsid int(10) unsigned not null,votetitle varchar(50) NOT NULL ,votenumber int(10) 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 icon (id TINYINT(2) UNSIGNED NOT NULL AUTO_INCREMENT, onlineadmin varchar(20) NOT NULL ,onlinesmod varchar(20) NOT NULL ,onlinemod varchar(20) NOT NULL ,onlinemember varchar(20) NOT NULL ,onlinerz VARCHAR(20) NOT NULL,onlineselfcolor varchar(8) NOT NULL ,onlineguest varchar(20) NOT NULL ,zg_havenew varchar(20) NOT NULL ,zg_nonew varchar(20) NOT NULL ,kf_havenew varchar(20) NOT NULL ,kf_nonew varchar(20) NOT NULL ,pl_havenew varchar(20) NOT NULL ,pl_nonew varchar(20) NOT NULL ,bm_havenew varchar(20) NOT NULL ,bm_nonew varchar(20) NOT NULL ,rz_havenew VARCHAR(20) NOT NULL,rz_nonew VARCHAR(20) NOT NULL,jh_pic varchar(20) NOT NULL ,lm_pic varchar(20) NOT NULL ,newthreadlogo varchar(20) NOT NULL ,newpolllogo varchar(20) NOT NULL ,newxzblogo varchar(20) NOT NULL ,newreplylogo varchar(20) NOT NULL ,wlogo varchar(20) NOT NULL ,nwlogo varchar(20) NOT NULL ,help_blogo varchar(20) NOT NULL ,new_blogo 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>");
       number=dbConnect.executeUpdate("insert into icon (id,onlineadmin,onlinesmod,onlinemod,onlinemember,onlineselfcolor,onlineguest,zg_havenew,zg_nonew,kf_havenew,kf_nonew,pl_havenew,pl_nonew,bm_havenew,bm_nonew,rz_havenew , rz_nonew ,onlinerz,jh_pic,lm_pic,newthreadlogo,newpolllogo,newxzblogo,newreplylogo,wlogo,nwlogo,help_blogo,new_blogo) values (1,'messages0.gif','messages3.gif','messages4.gif','messages1.gif','#0000FF','messages2.gif','foldernew.gif','folder.gif','folderallnew.gif','folderall.gif','follownew.gif','follow.gif','lock_l.gif','lock_b.gif','rzfoldernew.gif','rzfolder.gif','messages5.gif','jinghua.gif','shareforum.gif','newthread.gif','newpoll.gif','newxzb.gif','newreply.gif','w.gif','nw.gif','help_b.gif','topnew.gif')");
       if(number>0)
          out.println("写数据<b>完成！</b><br><br>");
       else out.println("写数据<b><font color=#ff0000>失败！</font></b><br><br>");
    //结束创建

    title="论坛状态表";
    //开始创建
    query="CREATE TABLE boardstatus (id TINYINT(2) UNSIGNED NOT NULL,visittimes bigint(20) unsigned not null, clicktimes bigint(20) unsigned not null,maxonlinenumber smallint(5) unsigned not null,recordat 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>");
       number=dbConnect.executeUpdate("insert into boardstatus (id,maxonlinenumber,recordat) values (1,0,now())");
       if(number>0)
          out.println("写数据<b>完成！</b><br><br>");
       else out.println("写数据<b><font color=#ff0000>失败！</font></b><br><br>");
    //结束创建

    title="创建投票记录库";
    //开始创建
    query="CREATE TABLE voterecord (id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, postsid INT(10) UNSIGNED NOT NULL, voteid SMALLINT(5) UNSIGNED NOT NULL, votename 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 uploadinfo (  id mediumint(8) unsigned NOT NULL auto_increment,  postsid int(10) unsigned NOT NULL default '0',  filename varchar(40) NOT NULL default '',  fileext varchar(40) NOT NULL default '',  filesize varchar(20) NOT NULL default '',  uploaddate date NOT NULL default '0000-00-00', filewidth smallint(5) unsigned NOT NULL default '0', fileheight smallint(5) unsigned NOT NULL default '0', 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 allowprivate (  id smallint(5) unsigned NOT NULL auto_increment,  authorid int(6) unsigned NOT NULL default '0',  dbid smallint(4) unsigned NOT NULL default '0',  checkpass enum('0','1') NOT NULL default '0',  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 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>");

    //创建索引
    title="创建数据库索引";
    //开始创建
    dbConnect.insert("ALTER TABLE author ADD INDEX author_1 (username,password)");
    dbConnect.insert("ALTER TABLE author ADD INDEX(online)");
    dbConnect.insert("ALTER TABLE author ADD INDEX (db)");
    dbConnect.insert("ALTER TABLE author ADD INDEX (usermode)");
    dbConnect.insert("ALTER TABLE grade ADD INDEX(usermode)");
    dbConnect.insert("ALTER TABLE xzb ADD INDEX(db) ");
    dbConnect.insert("ALTER TABLE style ADD INDEX(adminselected)");
    dbConnect.insert("ALTER TABLE style ADD INDEX(db)");
    dbConnect.insert("alter table webqq add index webqq_1 (fromname,operation)");
    dbConnect.insert("alter table webqq add index webqq_2 (toname,operation)");
    dbConnect.insert("ALTER TABLE friend ADD INDEX(authorid) ");
    dbConnect.insert("ALTER TABLE friend ADD INDEX(friendname) ");
    dbConnect.insert("ALTER TABLE db ADD INDEX(forum)");
    dbConnect.insert("alter table posts add index posts_1 (db,groupid,orderby,parentid)");
    dbConnect.insert("alter table posts add index(authorid) ");
    dbConnect.insert("alter table posts add index(author) ");
    dbConnect.insert("ALTER TABLE vote ADD INDEX(postsid)");
    dbConnect.insert("ALTER TABLE uploadinfo ADD INDEX(postsid)");
    dbConnect.insert("alter table allowprivate add index allowprivate_1 (authorid,dbid)");
    dbConnect.insert("alter table voterecord add index voterecord_1 (postsid,votename)");
    dbConnect.insert("alter table voterecord add index(voteid)");
    dbConnect.insert("ALTER TABLE announcement ADD INDEX(db)");
    dbConnect.insert("ALTER TABLE banword ADD INDEX(banword) ");
    dbConnect.insert("ALTER TABLE reservename ADD INDEX(reservename)");
    dbConnect.insert("ALTER TABLE admin ADD INDEX(db)");
    dbConnect.insert("ALTER TABLE admin ADD INDEX(authorid)");
    dbConnect.insert("ALTER TABLE admin ADD INDEX(authorname)");