insertok=connect.executeUpdate("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,16,50000,'天王','pips10.gif')");
       if(insertok)
          out.println("寫數據<b>完成！</b><br>");
       else out.println("寫數據<b><font color=#ff0000>失??！</font></b><br>");
       insertok=connect.executeUpdate("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,17,100000,'法老','pips10.gif')");
       if(insertok)
          out.println("寫數據<b>完成！</b><br>");
       else out.println("寫數據<b><font color=#ff0000>失敗！</font></b><br>");
       insertok=connect.executeUpdate("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,18,99999999,'法老','pips10.gif')");
       if(insertok)
          out.println("寫數據<b>完成！</b><br>");
       else out.println("寫數據<b><font color=#ff0000>失敗！</font></b><br>");
       insertok=connect.executeUpdate("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,19,99999999,'法老','pips10.gif')");
       if(insertok)
          out.println("寫數據<b>完成！</b><br>");
       else out.println("寫數據<b><font color=#ff0000>失敗！</font></b><br>");
       insertok=connect.executeUpdate("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,20,99999999,'法老','pips10.gif')");
       if(insertok)
          out.println("寫數據<b>完成！</b><br>");
       else out.println("寫數據<b><font color=#ff0000>失敗！</font></b><br>");
       insertok=connect.executeUpdate("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (1,0,0,'高級天王 [榮譽]','pips10.gif')");
       if(insertok)
          out.println("寫數據<b>完成！</b><br>");
       else out.println("寫數據<b><font color=#ff0000>失?。?lt;/font></b><br>");
       insertok=connect.executeUpdate("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (2,0,0,'終極天王 [榮譽]','pips10.gif')");
       if(insertok)
          out.println("寫數據<b>完成！</b><br>");
       else out.println("寫數據<b><font color=#ff0000>失敗！</font></b><br>");
       insertok=connect.executeUpdate("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (3,0,0,'究級天王 [榮譽]','pips10.gif')");
       if(insertok)
          out.println("寫數據<b>完成！</b><br><br>");
       else out.println("寫數據<b><font color=#ff0000>失??！</font></b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 創建<b>失??！</b><br>");
       out.println("<font color=#ff0000><b>請查看服務器返回的錯誤信息！</b></font><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>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 創建<b>完成！</b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 創建<b>失敗！</b><br>");
       out.println("<font color=#ff0000><b>請查看服務器返回的錯誤信息！</b></font><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, 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>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 創建<b>完成！</b><br><br>");
       String bbstitle="LyBBS『凌云論壇』";
       String support="http://www.unix-now.com/lybbs";
       String programmer="星語凌 『teddy』";
       String programemail="horseye@sina.com";
       String programqq="14606667";
       String version="ver 1.2.beta-2";
       String versionnumber="20020612";
       //凌云論壇內部信息，未經許可，絕對禁止修改，因為不聽勸告，自行修改而可能帶來的安裝失敗、數據破壞、升級失敗、甚至服務器癱瘓等一切后果，概與本人無關。
       //謹記：因為堅持修改而帶來的一切后果自負?。?！
       //請尊重我的版權，請尊重我的勞動成果！
       insertok=connect.executeUpdate("insert into config (id,title,support,programmer,programemail,programqq,version,versionnumber) values (1,'"+bbstitle+"','"+support+"','"+programmer+"','"+programemail+"','"+programqq+"','"+version+"','"+versionnumber+"')");
       if(insertok)
          out.println("寫數據<b>完成！</b><br><br>");
       else out.println("寫數據<b><font color=#ff0000>失敗！</font></b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 創建<b>失?。?lt;/b><br>");
       out.println("<font color=#ff0000><b>請查看服務器返回的錯誤信息！</b></font><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>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 創建<b>完成！</b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 創建<b>失?。?lt;/b><br>");
       out.println("<font color=#ff0000><b>請查看服務器返回的錯誤信息！</b></font><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>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 創建<b>完成！</b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 創建<b>失??！</b><br>");
       out.println("<font color=#ff0000><b>請查看服務器返回的錯誤信息！</b></font><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,adminglow varchar(8) NOT NULL ,adminnamecolor varchar(8) NOT NULL ,advpost enum('0','1') not null,allowattachment enum('0','1') not null,announcemove enum('0','1') not null,arrawpostfontsize enum('0','1') not null,arrawpostpic enum('0','1') not null,arrawsignfontsize enum('0','1') not null,arrawsignpic 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,banglow varchar(8) not null,boardlogo varchar(30) not null,catbackpic varchar(20) not null,catback varchar(8) not null,catfontcolor varchar(8) 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,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,hottopicmark tinyint(2) unsigned not null,hotpollmark tinyint(3) unsigned not null,infosopen tinyint(2) unsigned not null,imageviewnumber tinyint(2) unsigned not null,lastpostfontcolor varchar(8) not null,lbbody varchar(150) not null,linesperpage 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,memglow varchar(8) not null,menubackground varchar(8) not null,menubackpic varchar(20) not null,menufontcolor varchar(8) not null,miscbackone varchar(8) not null,miscbacktwo varchar(8) 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,otherbackpic varchar(20) not null,otherbackpic1 varchar(20) not null,pagechange enum('0','1') not null,paraspace tinyint(3) unsigned not null,postcolorone varchar(8) not null,postcolortwo varchar(8) not null,posternamecolor varchar(8) not null,posternamefont varchar(10) not null,postfontcolorone varchar(8) not null,postfontcolortwo varchar(8) 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,smoglow varchar(8) not null,smonamecolor varchar(8) not null,sortalltopic enum('0','1') not null,sortposticonshow enum('0','1') not null,statsopen enum('0','1') not null,tablebordercolor varchar(8) not null,tablewidth varchar(8) not null,teamglow varchar(8) not null,teamnamecolor varchar(8) not null,timetoshow tinyint(3) unsigned 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,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>");
    createok_style=connect.executeUpdate(query); 
    if(createok_style) {
       out.println("<font color=#0000ff>"+title+"</font> 創建<b>完成！</b><br><br>");
%>
<%@ include file="initstyle.jsp"%>
<%
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 創建<b>失?。?lt;/b><br>");
       out.println("<font color=#ff0000><b>請查看服務器返回的錯誤信息！</b></font><br><br>");
    }
    //結束創建

    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>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 創建<b>完成！</b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 創建<b>失??！</b><br>");
       out.println("<font color=#ff0000><b>請查看服務器返回的錯誤信息！</b></font><br><br>");
    }
    //結束創建

    title="短消息歡迎信息表";
    //開始創建
    query="CREATE TABLE regmsg (id TINYINT(2) UNSIGNED NOT NULL, content text 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>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 創建<b>完成！</b><br><br>");
       String content="感謝您的注冊，歡迎您的到來，希望這里能給您帶來快樂！多多發言吧！<br><br><br>本站全體管理人員向您問好";
       insertok=connect.executeUpdate("insert into regmsg (id,content) values (1,'"+content+"')");
       if(insertok)
          out.println("寫數據<b>完成！</b><br><br>");
       else out.println("寫數據<b><font color=#ff0000>失敗！</font></b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 創建<b>失??！</b><br>");
       out.println("<font color=#ff0000><b>請查看服務器返回的錯誤信息！</b></font><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>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 創建<b>完成！</b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 創建<b>失敗！</b><br>");
       out.println("<font color=#ff0000><b>請查看服務器返回的錯誤信息！</b></font><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>");
    createok=connect.executeUpdate(query);