treejsp
来源:互联网 发布:java远程电脑开关机 编辑:程序博客网 时间:2024/05/16 03:28
<%@ page contentType="text/html; charset=gb2312" language="java"%>
<%@ page import = "java.sql.*"%>
<html>
<head>
<title>#.Admin</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="StyleSheet" href="css/dtree.css" type="text/css">
<script type="text/javascript" src="js/dtree.js"></script>
<script type="text/javascript" src="js/op.js"></script>
</head>
<body bgcolor="ffffff" text="#000000" >
<a href="javascript: d.openAll();">open all</a> | <a href="javascript: d.closeAll();">close all</a>
<script type="text/javascript">
<!--
d = new dTree('d');
d.config.folderLinks=true;
//id, pid, name, url, title, target, icon, iconOpen, open
d.add(0,-1,'Website','http://www.easydone.cn','easydone','_blank');
<%
String sql = "select * from tree";
Connection conn = null;
try{
conn = getConnection();
ResultSet rst = executeQuery(conn,sql);
while(rst.next()){
%>
d.add(<%=rst.getString("id")%>,<%=rst.getString("pid")%>,'<%=rst.getString("name")%>','<%=rst.getString("url")%>','<%=rst.getString("name")%>','<%=rst.getString("target")%>');
<%
}
rst.close();
rst = null;
conn.close();
conn = null;
}catch(Exception ex){
out.println(ex.toString());
}
%>
document.write(d);
//-->
</script>
</body>
</html>
<%!
//这里建议您在 bean 里面操作
public ResultSet executeQuery(Connection conn,String sql) throws SQLException {
ResultSet rs = null;
Statement stmt = null;
try {
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
} catch (SQLException ex) {
System.out.println("查询异常:" + ex.getMessage());
}
return rs;
}
//这里建议您在 bean 里面操作
public synchronized Connection getConnection() throws Exception {
String driverName="org.gjt.mm.mysql.Driver";
String url="jdbc:mysql://localhost:3306/tree?useUnicode=true&characterEncoding=gb2312";
Driver driver = (Driver) Class.forName(driverName).newInstance();
Connection conn = DriverManager.getConnection(url, "root","123456");
return conn;
}
%>