📄 setup.jsp
字号:
<%@ page language="java" contentType="text/html; charset=GBK"
pageEncoding="GBK"%>
<%@page import="java.util.*,java.io.*,java.sql.*"%>
<%@ include file="conn.jsp"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>初始化安装</title>
</head>
<body>
请先在
<font color="red">conn.jsp</font> 中配置好各项参数再运行本页面!
<br>
本程序由terminus于08-11-15完成,耗时3天...
<br>
...
<br>
<%
if (null != request.getParameter("agree")) {
%>
<br>
<font color="red">数据库初始化完成!</font>
<br>
<a href="index.jsp">点这里进入首页</a>
<br>
<%
//建立管理员数据表
stmt.executeUpdate("DROP TABLE IF EXISTS " + tadmin);
stmt
.executeUpdate("CREATE TABLE "
+ tadmin
+ "("
+ " id mediumint(8) unsigned NOT NULL auto_increment,"
+ " name varchar(10) NOT NULL,"
+ " password varchar(40) NOT NULL,"
+ " permission int(11) NOT NULL,"
+ " PRIMARY KEY (id)"
+ ") ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=gbk;");
//建立BBS帖子数据表
stmt.executeUpdate("DROP TABLE IF EXISTS " + tbbs);
stmt
.executeUpdate("CREATE TABLE "
+ tbbs
+ "("
+ " id mediumint(8) unsigned NOT NULL auto_increment,"
+ " author varchar(10) NOT NULL,"
+ " authorid int(8) unsigned NOT NULL,"
+ " title varchar(100) NOT NULL,"
+ " content mediumtext NOT NULL,"
+ " dnt varchar(50) NOT NULL,"
+ " PRIMARY KEY (id)"
+ ") ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=gbk;");
//建立BBS回帖数据表
stmt.executeUpdate("DROP TABLE IF EXISTS " + treply);
stmt
.executeUpdate("CREATE TABLE "
+ treply
+ "("
+ " id mediumint(8) unsigned NOT NULL auto_increment,"
+ " postid mediumint(8) unsigned NOT NULL,"
+ " author varchar(10) NOT NULL,"
+ " authorid int(8) unsigned NOT NULL,"
+ " title varchar(100) NOT NULL,"
+ " content mediumtext NOT NULL,"
+ " dnt varchar(50) NOT NULL,"
+ " PRIMARY KEY (id)"
+ ") ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=gbk;");
//建立用户信息表
stmt.executeUpdate("DROP TABLE IF EXISTS " + tuinfo);
stmt
.executeUpdate("CREATE TABLE "
+ tuinfo
+ "("
+ " id mediumint(8) unsigned NOT NULL auto_increment,"
+ " name varchar(10) NOT NULL,"
+ " password varchar(40) NOT NULL,"
+ " email varchar(40) NOT NULL,"
+ " PRIMARY KEY (id)"
+ ") ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=gbk;");
//初始化后台管理员
stmt.executeUpdate("TRUNCATE TABLE " + tadmin);
stmt
.executeUpdate("INSERT INTO "
+ tadmin
+ "(name,password,permission)VALUES('admin123','7c4a8d09ca3762af61e59520943dc26494f8941b','0')");
} else {
%>
<br>
<font color="red">点"同意"初始化数据库</font>
<br>
<br>
<form action="setup.jsp" name="form" method="post">
<input type="hidden" value="agreed" name="agree">
<input type="submit" name="submit" value="同意")>
</form>
<br>
<%
}
%>
<!-- 载入页尾 -->
<jsp:include page="./include/foot.jsp"></jsp:include>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -