📄 showarticle1.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>
<%@ 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();
rs=stmt.executeQuery("select * from article where pid="+id);
while (rs.next())
{
str+="<tr><td>"+rs.getInt("id")+"</td><td>"+preStr+rs.getString("title")+"</td></tr>";
if(rs.getInt("isleaf") !=0)
{
tree(conn,rs.getInt("id"),level+1);
}
}
}catch(SQLException e){e.printStackTrace();}
}
%>
<%
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/bbs","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>"+rs.getString("title")+"</td></tr>";
if(rs.getInt("isleaf") !=0)
{
tree(conn,rs.getInt("id"),1);
}
}
rs.close();
stmt.close();
conn.close();
%>
<html>
<head>
<title>My JSP 'ShowArticle1.jsp' starting page</title>
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<table border="1">
<%=str %>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -