大家看看有什么代码错误??
<body>
<SCRIPT type=text/javascript>
var tree = new tree();
var root = new root(1,"知识点目录","#","");
tree.addRoot(root);
<%
//定义变量和取值相关的
int id, p_id;
String s_name, s_type, s_url, s_open;
//定义变量数据库相关的
String sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String sqlurl="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=tree";
String user = "sa";
String password = "";
String s_sql = "select * from tree";
// String sConnStr="jdbc:odbc:tree";
Connection conn=null;
Statement stmt = null;
ResultSet rs=null;
try
{
Class.forName(sDBDriver).newInstance();
// conn = DriverManager.getConnection(sConnStr);
conn = DriverManager.getConnection(sqlurl, user, password);
stmt = conn.createStatement();
rs = stmt.executeQuery(s_sql);
}
catch(Exception ex)
{
ex.printStackTrace();
}
//取数据库中的纪录;显示到目录树的结构中来
while(rs.next())
{
id = rs.getInt("id");
s_name = rs.getString("name");
p_id = rs.getInt("parentId");
s_type = rs.getString("type");
s_url = rs.getString("url");
s_open = rs.getString("openTarget");
%>
tree.addNode(new node(<%=id%>,<%=s_name%>,<%=p_id%>,<%=s_type%>,<%=s_url%>,<%=s_open%>));
<%
}
finally
{
try
{
if(rs != null)
{
rs.close();
rs = null;
}
else if(stmt != null)
{
stmt.close();
stmt = null;
}
else if(conn != null)
{
conn.close();
conn = null;
}
}
catch(SQLException ex2)
{
System.out.println(ex2.getMessage());
}
}
%>
tree.drawRoot();
tree.drawNodes(tree.root);
</SCRIPT>
</body>