JSP梅花雪树

最新推荐文章于 2024-08-14 09:04:24 发布

杀猪刀客

最新推荐文章于 2024-08-14 09:04:24 发布

阅读量399

点赞数

分类专栏： jsp 文章标签： jsp string tree import javascript url

jsp 专栏收录该内容

0 篇文章 0 订阅

订阅专栏

梅花雪树JSP实现

1.创建数据库
create table tree
(
id int primary key,
parentId int,
text varchar(50),
hint varchar(100),
icon varchar(20),
data varchar(20),
url varchar(50),
target varchar(20),
method varchar(50)
)
2.下载梅花雪树控件（放在根目录）

控件下载: http://www.meizz.com/Web/Download/MzTreeView10.rar

3.创建连接数据库类DBfactory.java
package com.service;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBfactory {

public static Connection getConnection() throws SQLException ,
java.lang.ClassNotFoundException{
String url = "jdbc:mysql://localhost:3306/test";
Class.forName("com.mysql.jdbc.Driver");
String userName = "root";
String password = "aidemama";
Connection con = DriverManager.getConnection(url,userName,password);
return con;
}

}

4.创建操作类TreeService.java

package com.service;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class TreeService {
Connection con = null;
public String getTree() throws SQLException {

try {
  con = DBfactory.getConnection();
  String sql = "select * from tree";
  PreparedStatement pre = con.prepareStatement(sql);
  ResultSet rs =pre.executeQuery();
  String tree ="";

  while(rs.next()) {
   String id = String.valueOf(rs.getInt("id"));
   String pid = String.valueOf(rs.getInt("parentId"));
   String text = rs.getString("text");
   String hint = rs.getString("hint");
   String url = rs.getString("target");
   String target = rs.getString("target");
   tree +="\n"+"tree"+".nodes[\""+pid+"_"+id+"\"]=\"";

   if(text != null && text.trim()!="") {
    tree +="text:"+text+";";

   }
   if(hint != null && hint.trim()!="") {
    tree +="hint:"+hint+";";

   }
   if(url != null && url.trim()!="") {
    tree +="url:"+url+";";

   }
   if(target != null && target.trim()!="") {
    tree +="target:"+target+";";

   }


   tree += "\"";
  }
  return tree;

}catch(Exception e){
  System.out.println("can't create tree");
  return null;

}finally {

  con.close();
}
}

}
5.创建jsp

<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page import="com.service.TreeService"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<html>
<head>
    <title>梅花雪中文网 - 网页脚本控件集 MzTreeView10</title>
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
    <meta name="author" content="黄方荣(meizz·梅花雪)://www.meizz.com">
    <script language="JavaScript" src="MzTreeView10/MzTreeView10.js"></script>
    
    <style>
    A.MzTreeview
    {
      font-size: 9pt;
      padding-left: 3px;
    }
    </style>
</head>

<body bgcolor="#FFFFDB" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" align="center">
    <SCRIPT LANGUAGE="JavaScript">
    <!--
    window.tree = new MzTreeView("tree");

    tree.icons["property"] = "property.gif";
    tree.icons["css"] = "collection.gif";
    tree.icons["book"] = "book.gif";
    tree.iconsExpand["book"] = "bookopen.gif"; //展开时对应的图片
    tree.setIconPath("MzTreeView10/"); //可用相对路径
<%
TreeService ts=new TreeService();
String tree=ts.getTree();
out.print(tree);
%>

    tree.setURL("#");
    tree.setTarget("MzMain");
    document.write(tree.toString());    //亦可用 obj.innerHTML = tree.toString();
    //-->
    </SCRIPT>
</body>
</html>

杀猪刀客

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
JSP梅花雪树

梅花雪树JSP实现1.创建数据库create table tree ( id int primary key, parentId int, text varchar(50), hint varchar(100), icon varchar(20), data varchar(20), url varchar(50), target varchar(2
复制链接

扫一扫

专栏目录