?? initdatabase.jsp

?? BBS系統
?? JSP
?? 第 1 頁 / 共 4 頁
字號:
12 3 4 下一頁
<%
/*##################################################################**
**#  LyBBS ver 1.2.b2 (1.2.beta-2版) / 凌云論壇 ver 1.2.b2         #**
**#                                                                #**
**#  版權所有: 凌云工作室 (原流星電腦工作室)                       #**
**#                                                                #**
**#  制作人  : 星語凌 『teddy (Yongshan Ye)』                      #**
**#                                                                #**
**#  主頁地址: http://www.unix-now.com/lybbs   凌云論壇主頁        #**
**#            http://www.ierp.info/lybbs      凌云論壇鏡像站      #**
**#            http://horseye@sina.com/        凌云論壇支持信箱    #**
**#                                                                #**
**##################################################################*/
%>
<%
    //開始數據庫初始化
    //模板：CREATE TABLE '' ('id' INT() UNSIGNED NOT NULL AUTO_INCREMENT, '' () NOT NULL , PRIMARY KEY ('id'), INDEX ('id'))
    //internalversion:1.2.1
    String title="";

if(previousversionnumber.equals("")) {

    title="注冊聲明表";
    //開始創建
    query="CREATE TABLE regrules (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>");
       String content="<b>繼續注冊前請先閱讀論壇協議</b><p>"+
"歡迎您加入本站點參加交流和討論，本站點為公共論壇，為維護網上公共秩序和社會穩定，請您自覺遵守以下條款：<BR><BR>"+
"一、不得利用本站危害國家安全、泄露國家秘密，不得侵犯國家社會集體的和公民的合法權益，不得利用本站制作、復制和傳播下列信息： <BR>"+
"　（一）煽動抗拒、破壞憲法和法律、行政法規實施的；<BR>"+
"　（二）煽動顛覆國家政權，推翻社會主義制度的；<BR>"+
"　（三）煽動分裂國家、破壞國家統一的；<BR>"+
"　（四）煽動民族仇恨、民族歧視，破壞民族團結的；<BR>"+
"　（五）捏造或者歪曲事實，散布謠言，擾亂社會秩序的；<BR>"+
"　（六）宣揚封建迷信、淫穢、色情、賭博、暴力、兇殺、恐怖、教唆犯罪的；<BR>"+
"　（七）公然侮辱他人或者捏造事實誹謗他人的，或者進行其他惡意攻擊的；<BR>"+
"　（八）損害國家機關信譽的；<BR>"+
"　（九）其他違反憲法和法律行政法規的；<BR>"+
"　（十）進行商業廣告行為的。<BR>"+
"二、互相尊重，對自己的言論和行為負責。 <BR><p>";
       insertok=connect.executeUpdate("insert into regrules (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><font color=#ff0000>失敗！</font></b><br>");
       out.println("<font color=#ff0000><b>請查看服務器返回的錯誤信息！</b></font><br><br>");
    }
    //結束創建

    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 ,imagename varchar(30) NOT NULL ,imageurl VARCHAR(255) NOT NULL,imagewidth tinyint(3) NOT NULL ,imageheight tinyint(3) 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 enum('0','1') not null,styleid smallint(4) not null,viewid int(10) not null,forum smallint(4) unsigned not null,db smallint(4) unsigned not null,recommendname varchar(30) not null,ipfrom varchar(30) not null,usermode tinyint(2) not null,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>");
    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><font color=#ff0000>失敗！</font></b><br>");
       out.println("<font color=#ff0000><b>請查看服務器返回的錯誤信息！</b></font><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>");
    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 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>");
    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 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>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 創建<b>完成！</b><br><br>");
       insertok=connect.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(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 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>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 創建<b>完成！</b><br><br>");
       insertok=connect.executeUpdate("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,0,0,'新手上路','')");
       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,1,12,'俠客','pips1.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,2,50,'騎士','pips2.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,3,80,'圣騎士','pips3.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,4,150,'精靈','pips4.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,5,250,'精靈王','pips4.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,6,400,'風云使者','pips5.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,7,700,'光明使者','pips5.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,8,1000,'天使','pips6.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,9,1500,'大天使','pips6.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,10,2500,'精靈使','pips7.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,11,5000,'法師','pips8.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,12,8000,'大法師','pips8.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,13,12000,'法王','pips9.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,14,20000,'老法王','pips9.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,15,30000,'天神','pips10.gif')");
       if(insertok)
          out.println("寫數據<b>完成！</b><br>");
       else out.println("寫數據<b><font color=#ff0000>失敗！</font></b><br>");
12 3 4 下一頁
?? 文件大小 798 K
?? 上傳用戶 sgly2002
?? 所屬分類 Jsp/Servlet
??? 相關標簽

#BBS
?? 快捷鍵說明

復制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

?? initdatabase.jsp

?? 快捷鍵說明
