JSP+Servlet+Mysql开发
利用递归的方法实现BBS的树状结构。
数据库创建:
为了管理和日后修改部署的方便,我们在应用目录下建一个SQl目录,用于存放建数据库的.sql文件。
在MYsql的命令行窗口中,我们导入.Sql文件
mysql > \.
E:\\workspace\\BBS\\SQL\\bbs.sql
JDBC~MYsql 连接数据库语句
java 代码
- Class.forName("org.gjt.mm.mysql.Driver").newInstance();
- String url ="jdbc:mysql://localhost/bbs?user=root&password=admin&useUnicode=true&characterEncoding=8859_1";
- conn= DriverManager.getConnection(url);
利用递归的方法实现BBS的树状结构。
java 代码
java 代码
- <%!
- 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{
- String sql = "select * from article where pid = "+id+"";
- stmt = conn.createStatement();
- rs = stmt.executeQuery(sql);
- 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();
- }finally
- { try{
- if(rs!=null){
- rs.close();
- rs = null;
- }
- if(stmt!=null){
- stmt.close();
- stmt= null;
- }
- }catch(SQLException e)
- {
- e.printStackTrace();
- }
- }
- }
- %>
- <%
- response.setContentType("text/html;charset=GBK");
- Class.forName("com.mysql.jdbc.Driver");
- String url ="jdbc:mysql://localhost/bbs?user=root&password=admin&useUnicode=true&characterEncoding=gbk";
- Connection conn= DriverManager.getConnection(url);
- Statement stmt = conn.createStatement();
- String sql = "select * from article where pid = 0";
- ResultSet rs = stmt.executeQuery(sql);
- 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();
- %>