81,091
社区成员
发帖
与我相关
我的任务
分享大家看看有什么代码错误？？
<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>
<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>
...全文
请发表友善的回复…
发表回复
coderStone 2003-10-20
- 打赏
- 举报
弄出来了；
呵呵
高兴！！结贴
谢谢各位！！
呵呵
高兴！！结贴
谢谢各位！！
coderStone 2003-10-20
- 打赏
- 举报
谢谢各位！
本来使用数据库连结池的；
但我现在只是在测试某些东西能不能显示出来；
我的<%=**%>是嵌入在javascript中的。
本来使用数据库连结池的；
但我现在只是在测试某些东西能不能显示出来；
我的<%=**%>是嵌入在javascript中的。
ppopopp 2003-10-19
- 打赏
- 举报
同上
yll6865 2003-10-19
- 打赏
- 举报
赞同，最好写个servlet与后台交互，比较安全。如果是查询，利用request.setAttribute回送查询的结果集
fj20059 2003-10-19
- 打赏
- 举报
同意,至少写个bean ,这样很不安全,而且效率太底了
whodsow 2003-10-19
- 打赏
- 举报
老大，不要在JSP里面查询数据库好不好？
