?? showarticletree.jsp
字號:
<%@ page language="java" contentType="text/html; charset=gbk"
pageEncoding="gbk"%>
<%@ page import="java.sql.*" %>
<%
String strlog = (String)session.getAttribute("admin");
if(strlog != null && strlog.equals("true")){
isLog = true;
}
%>
<%!
String str = "";
String login = "";
boolean isLog = false;
private void tree(Connection conn, int id, int level) {
Statement stmt = null;
ResultSet rs = null;
String blank = "";
for(int i=0; i<level; i++) {
blank += " ";
}
try {
stmt = conn.createStatement();
String sql = "select * from article where pid = " + id;
rs = stmt.executeQuery(sql);
while(rs.next()) {
if(isLog){
login = "<td><a href='Delete.jsp?id=" + rs.getInt("id") + "&pid=" + rs.getInt("pid") + "'>刪除</a></td>";
}
str += "<tr><td>" + rs.getInt("id") + "</td><td>" +
blank + "<a href='ShowArticleDetail.jsp?id=" + rs.getInt("id") + "'>" +
rs.getString("title") + "</a></td>" + login + "</tr>";
if(rs.getInt("isleaf") != 0) {
tree(conn, rs.getInt("id"), level+1);
}
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if(rs != null) {
rs.close();
rs = null;
}
if(stmt != null) {
stmt.close();
stmt = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
%>
<%
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/bbs?user=root&password=yuanshuai");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from article where pid = 0");
while(rs.next()) {
if(isLog){
login = "<td><a href='Delete.jsp?id=" + rs.getInt("id") + "&pid=" + rs.getInt("pid") + "'>刪除</a></td>";
}
str += "<tr><td>" + rs.getInt("id") + "</td><td>" +
"<a href='ShowArticleDetail.jsp?id=" + rs.getInt("id") + "'>" + rs.getString("title") +
"</a></td>" + login + "</tr>";
if(rs.getInt("isleaf") != 0) {
tree(conn, rs.getInt("id"), 1);
}
}
rs.close();
stmt.close();
conn.close();
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<title>ShowArticleTree</title>
</head>
<body text="red" link="green" vlink="red" alink="yellow">
<h2><center>ShowArticleTree</center></h2>
<div align="center"><a href="Post.jsp">發表新貼</a></div>
<%
String stradmin = null;
if(!isLog){
stradmin = "<div align=right><a href='Login.jsp'>管理員登錄</a></div><br>";
}else{
stradmin = "<div align=right>admin!你好!</div><br>";
}
%>
<%=stradmin %>
<table border="5" align="center" bordercolorlight="#FF00FF" bordercolordark="#FF0000">
<%= str %>
<%
str = "";
isLog = false;
%>
</table>
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -