📄 showarticletree.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="gbk"%>
<%@ page import="java.sql.*" %>
<%!
String str="";
private void tree(Connection conn,int id,int level){
Statement stmt=null;
ResultSet rs=null;
String preStr="";
for(int i=0; i<level; i++)
{
preStr +="----";
}
try{
stmt=conn.createStatement();
String sql="select * from article where pid="+id;
rs=stmt.executeQuery(sql);
while(rs.next())
{
str +="<tr><td>"+rs.getInt("id")+"</td><td>"+preStr+"<a href=ShowArticleDetail.jsp?id="+rs.getInt("id")+">"
+rs.getString("title")+"</a></td><td><a href=delete.jsp?id="+rs.getInt("id")+">删除</a></td></tr>";
if(rs.getInt("isleaf") !=0)
{
tree(conn,rs.getInt("id"),level+1);
}
}
}catch(SQLException e)
{
e.printStackTrace();
}
finally{
}
}
%>
<%
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/bbs";
Connection conn=DriverManager.getConnection(url,"root","12345");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from article where pid=0");
while(rs.next())
{
str +="<tr><td>"+rs.getInt("id")+"</td><td><a href=ShowArticleDetail.jsp?id="+rs.getInt("id")+">"
+rs.getString("title")+"</a></td><td><a href=delete.jsp?id="+rs.getInt("id")+">删除</a></td></tr>";
if(rs.getInt("isleaf") !=0)
{
tree(conn,rs.getInt("id"),1);
}
}
rs.close();
stmt.close();
conn.close();
%>
<html>
<head>
<title>My JSP 'ShowArticleTree.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<a href="post.jsp">发表新贴</a>
<table border="1">
<%=str %>
<% str=""; %>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -