📄 install.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="ht" scope="page" class="numb1.com.Dohtml"/>
<%@ include file = "include/config.jsp" %>
<%!
public String gb2iso(String qs){
try{
if (qs == null) return "NULL";
else return new String(qs.getBytes("gb2312"),"iso-8859-1");
}
catch(Exception e){
log("gb2iso error："+e.getMessage());
}
return "NULL";
}
%>
<%
String host="";
String db="";
String user="";
String pw="";
int table_num=2;//新建发贴表格的数量
host=request.getParameter("host");host=ht.donull(host);
db=request.getParameter("db");db=ht.donull(db);
user=request.getParameter("user");user=ht.donull(user);
pw=request.getParameter("mm");pw=ht.donull(pw);
if(host.compareTo("")==0 ||db.compareTo("")==0 || user.compareTo("")==0){
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>建立数据库</title>
<style type="text/css">
<!--
th{font-size:14px}
td{font-size:13px;color:#686868}
.style1 {color: #FFFFFF}
-->
</style>
</head>
<body>
<br><br><br><form name="form1" method="post" action="">
<table width="360" border="0" align="center" cellspacing="1" bgcolor="#e8e8e8" style="BORDER-BOTTOM: #d1d1ef 1px solid; BORDER-LEFT: #d1d1ef 1px solid; BORDER-RIGHT: #d1d1ef 1px solid; BORDER-TOP: #d1d1ef 1px solid">
<tr bgcolor="#ffffff">
<th colspan="2"><table width="100%" border="0" cellspacing="1">
<tr>
<th height="20" bgcolor="#7188e0"><span class="style1">建立数据库</span></th>
</tr>
</table>
</th>
</tr>
<tr bgcolor="#ffffff">
<td width="92"><div align="right">主机地址：</div></td>
<td width="259"><input name="host" type="text" id="host" style="BORDER: #7188e0 1px solid;color:#686868;" value="localhost" size="30"></td>
</tr>
<tr bgcolor="#ffffff">
<td><div align="right">密码：</div></td>
<td><input name="mm" type="password" id="mm" style="BORDER: #7188e0 1px solid;color:#686868;" size="30"></td>
</tr>
<tr bgcolor="#ffffff">
<td><div align="right">用户名：</div></td>
<td><input name="user" type="text" id="user" style="BORDER: #7188e0 1px solid;color:#686868;" value="root" size="30"></td>
</tr>
<tr bgcolor="#ffffff">
<td><div align="right">数据库：</div></td>
<td><input name="db" type="text" id="db" style="BORDER: #7188e0 1px solid;color:#686868;" value="numb1" size="30"></td>
</tr>
<tr bgcolor="#ffffff">
<th colspan="2"><input type="submit" name="Submit" value="提交">
<input type="reset" name="Submit" value="重置"></th>
</tr>
</table>
</form>
<%
}else{
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
String url="jdbc:mysql://"+host+"/"+db+"?user="+user+"&password="+pw;
Connection con=DriverManager.getConnection(url);
Statement st=con.createStatement();
String drop="DROP TABLE IF EXISTS board";
st.executeUpdate(drop);
String board_sql= "CREATE TABLE board (id int(11) NOT NULL auto_increment, btable varchar(20) NOT NULL default 'btable1', name varchar(30) NOT NULL default '', logo varchar(100) default NULL, inform varchar(160) default NULL, focus varchar(200) default NULL, boardmast varchar(255) NOT NULL default '', page varchar(80) NOT NULL default '', PRIMARY KEY (id)) ";
st.executeUpdate(board_sql);
String
board_sql_insert="INSERT INTO board VALUES (1,'btable1','"+gb2iso("菜鸟交流")+"','img/logo.gif','','','','pc'),(2,'btable1','"+gb2iso("网站建设")+"','img/logo.gif','','','','pc'),(3,'btable1','"+gb2iso("Web程序开发")+"','img/logo.gif','','','','pc'),(4,'btable1','"+gb2iso("JAVA开发")+"','img/logo.gif','','','','pc'),(5,'btable1','"+gb2iso("C/C++开发")+"','img/logo.gif','','','','pc'),(6,'btable1','"+gb2iso("数据库开发")+"','img/logo.gif','','','','pc'),(7,'btable1','"+gb2iso("BT专区")+"','img/logo.gif','','','','pc'),(8,'btable1','"+gb2iso("Windows")+"','img/logo.gif','','','','pc'),(9,'btable1','"+gb2iso("Linux/Unix")+"','img/logo.gif','','','','pc'),(10,'btable1','"+gb2iso("网络安全")+"','img/logo.gif','','','','pc'),(11,'btable2','"+gb2iso("幽默图片")+"','img/logo.gif','','','','other'),(12,'btable2','"+gb2iso("明星美眉")+"','img/logo.gif','','','','other'),(13,'btable2','"+gb2iso("自然风景")+"','img/logo.gif','','','','other'),(14,'btable2','"+gb2iso("边走边拍")+"','img/logo.gif','','','','other'),(15,'btable2','"+gb2iso("军迷世界")+"','img/logo.gif','','','','other'),(16,'btable2','"+gb2iso("创意之作")+"','img/logo.gif','','','','other'),(17,'btable2','"+gb2iso("单身一族")+"','img/logo.gif','','','','other'),(18,'btable2','"+gb2iso("笑话天地")+"','img/logo.gif','','','','other'),(19,'btable2','"+gb2iso("搞笑视频")+"','img/logo.gif','','','','other'),(20,'btable2','"+gb2iso("经典短信")+"','img/logo.gif','','','','other'),(21,'btable2','"+gb2iso("怀旧音乐")+"','img/logo.gif','','','','other')";
st.executeUpdate(board_sql_insert);
drop="DROP TABLE IF EXISTS friend";
st.executeUpdate(drop);
String
friend_sql=
"CREATE TABLE friend ( id int(11) NOT NULL auto_increment, userid varchar(20) NOT NULL default '', username varchar(20) NOT NULL default '', friendid varchar(20) NOT NULL default '', friendname varchar(20) NOT NULL default '', isfriend char(2) NOT NULL default 'y', PRIMARY KEY (id))";
st.executeUpdate(friend_sql);
drop="DROP TABLE IF EXISTS gift";
st.executeUpdate(drop);
String gift_sql="CREATE TABLE gift ( userid varchar(20) NOT NULL default '', flower int(11) NOT NULL default '0', flcom text, PRIMARY KEY (userid))";
st.executeUpdate(gift_sql);
drop="DROP TABLE IF EXISTS massage";
st.executeUpdate(drop);
String massage="CREATE TABLE massage ( id int(11) NOT NULL auto_increment, toid varchar(20) NOT NULL default '', toname varchar(20) NOT NULL default '', frid varchar(20) NOT NULL default '', frname varchar(20) NOT NULL default '', title varchar(30) NOT NULL default '', txt text NOT NULL, time datetime NOT NULL default '0000-00-00 00:00:00', isread int(11) default '0', PRIMARY KEY (id))";
st.executeUpdate(massage);
drop="DROP TABLE IF EXISTS master";
st.executeUpdate(drop);
String master="CREATE TABLE master ( id int(11) NOT NULL auto_increment, bid int(11) NOT NULL default '0', bname varchar(30) NOT NULL default '', userid varchar(20) NOT NULL default '', username varchar(20) NOT NULL default '', PRIMARY KEY (id))";
st.executeUpdate(master);
drop="DROP TABLE IF EXISTS numb1";
st.executeUpdate(drop);
String
numb1_sql="CREATE TABLE numb1 ( userid varchar(20) NOT NULL default '', pw varchar(20) NOT NULL default '', mail varchar(40) NOT NULL default '', tim datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (userid))";
st.executeUpdate(numb1_sql);
drop="DROP TABLE IF EXISTS online";
st.executeUpdate(drop);
String
online_sql=
"CREATE TABLE online ( userid varchar(20) NOT NULL default '', ontims int(11) default '0', txt int(11) default '0', re int(11) default '0', point int(11) default '0', popu int(11) NOT NULL default '0', suptxt int(11) default '0', recomtxt int(11) NOT NULL default '0', lastip varchar(15) default NULL, lastim datetime default '0000-00-00 00:00:00', penname1 varchar(250) default NULL, penname2 varchar(250) default NULL, PRIMARY KEY (userid))";
st.executeUpdate(online_sql);
drop="DROP TABLE IF EXISTS user";
st.executeUpdate(drop);
String user_sql="CREATE TABLE user ( userid varchar(20) NOT NULL, step int(11) NOT NULL default '1', root varchar(75) default NULL, question varchar(30) NOT NULL default '', answer varchar(30) NOT NULL default '', face varchar(50) default NULL, name varchar(20) default NULL, sex varchar(5) default NULL, birth varchar(10) default '2004-12-02', mail varchar(5) default NULL, qq varchar(15) default NULL, web varchar(30) default NULL, tel varchar(15) default NULL, comefrom varchar(20) default NULL, job varchar(20) default NULL, love varchar(30) default NULL, aboutme varchar(200) default NULL, refusemassage varchar(2) NOT NULL default 'n', PRIMARY KEY (userid))";
st.executeUpdate(user_sql);
drop="DROP TABLE IF EXISTS onlcount";
st.executeUpdate(drop);
String onlcount_sql="CREATE TABLE onlcount ( id int(11) NOT NULL auto_increment, page varchar(80) NOT NULL default '', time varchar(10) NOT NULL default '', userid varchar(20) NOT NULL default 'guest', username varchar(20) NOT NULL default '', ip varchar(15) NOT NULL default '', PRIMARY KEY (id))";
st.executeUpdate(onlcount_sql);
String bt_sql="";
String rbt_sql="";
for(int i=1;i<table_num+1;i++){
drop="DROP TABLE IF EXISTS btable"+i+"";
st.executeUpdate(drop);
bt_sql="CREATE TABLE btable"+i+" ( id int(11) NOT NULL auto_increment, boardid int(40) NOT NULL default '0', title varchar(50) NOT NULL default '', clas varchar(2) NOT NULL default 'a', txt text NOT NULL, up char(2) NOT NULL default 'n', super char(2) NOT NULL default 'n', recommendation char(2) NOT NULL default 'n', locked char(2) default 'n', userid varchar(20) default NULL, username varchar(20) NOT NULL default '', lastid varchar(20) default NULL, lastname varchar(20) default NULL, tim datetime NOT NULL default '0000-00-00 00:00:00', editime datetime NOT NULL default '0000-00-00 00:00:00', ip varchar(15) default NULL, readtimes int(11) default '0', retimes int(11) NOT NULL default '0', lastretime datetime NOT NULL default '0000-00-00 00:00:00', penname varchar(250) default NULL, upload_pic varchar(100) NOT NULL default '', upload_file varchar(100) NOT NULL default '', PRIMARY KEY (id))";
st.executeUpdate(bt_sql);
drop="DROP TABLE IF EXISTS rebtable"+i+"";
st.executeUpdate(drop);
rbt_sql="CREATE TABLE rebtable"+i+" ( id int(11) NOT NULL auto_increment, bbsid int(11) default '0', boardid int(11) NOT NULL default '0', retitle varchar(40) NOT NULL default '', txt text NOT NULL, userid varchar(20) NOT NULL default '', username varchar(20) NOT NULL default '', time datetime NOT NULL default '0000-00-00 00:00:00', editime datetime default '0000-00-00 00:00:00', ip varchar(15) NOT NULL default '', penname varchar(250) default NULL, upload_pic varchar(100) NOT NULL default '', upload_file varchar(100) NOT NULL default '', PRIMARY KEY (id))";
st.executeUpdate(rbt_sql);
}
st.close();
con.close();
}catch(SQLException e){
out.print("<meta http-equiv=\"refresh\" content=\"5;URL=install.jsp\"><center><font color=#ff0000><h3>密码错误！</h3></font></center>");
}
if(absDir.length()-absDir.lastIndexOf("/") == 1){
absDir=absDir.substring(0,absDir.lastIndexOf("/"));
}
java.io.File f =new java.io.File(absDir+request.getRequestURI());
boolean b = f.delete();
if(b){
out.print("<meta http-equiv=\"refresh\" content=\"3;URL=index.jsp\"><center><font color=#ff0000><h3>创建成功！install.jsp文件已经删除...3秒后自动跳入首页</h3></font></center>");
}else{
out.print("<meta http-equiv=\"refresh\" content=\"3;URL=index.jsp\"><center><font color=#ff0000><h3>创建成功！install.jsp文件删除失败...3秒后自动跳入首页，请手动删除该页面</h3></font></center>");
}
}
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -