一个简单的jsp树型结构示例（jsp+weblogic+oracle）

[ejbcreate]

数据表结构：
create table TreeExample(f_id number(9,0) not null unique, f_treename varchar2(16), f_fatherid number(9,0) not null);
commit

insert into TreeExample values(1, '树型结构示例', 0);
insert into TreeExample values(2, '子树一', 1);
insert into TreeExample values(3, '子树二', 1);
insert into TreeExample values(4, '子树三', 1);
insert into TreeExample values(5, '子树一的子树', 2);

连接数据库的javabean代码：
package exampleTree;

import java.sql.*;
import weblogic.jdbc.vendor.oracle.OracleThinClob;
//import oracle.sql.*;
//import oracle.jdbc.driver.*;
import java.io.*;
import java.util.*;

public class DBConn{

protected Connection gConnect;
public Statement gStatement;
protected boolean gConnected=false;
public static final String POOLNAME="TreeExample";

public DBConn(){
}

public boolean connect(){
return this.connect(POOLNAME);
}

public boolean connect(String poolname)
{
return this.connect(poolname, true);
}
public boolean connect(boolean bReadOnly)
{
return this.connect(POOLNAME, bReadOnly);
}
public boolean connect(String poolname, boolean bReadOnly)
{
if (!gConnected)
{
try
{
weblogic.jdbc.pool.Driver myDriver = (weblogic.jdbc.pool.Driver)Class.forName("weblogic.jdbc.pool.Driver").newInstance();
this.gConnect = myDriver.connect("jdbc:weblogic:pool:"+poolname, null);
}
catch (Exception ex)
{
System.out.println((new java.util.Date()) + "sql connect error:"+ex.getMessage());
return false;
}
gConnected = true;
}
return true;
}

public boolean disconnect()
{
if(gStatement==null) return false;
try
{
gConnect.commit();
gStatement.close();
}
catch (java.sql.SQLException ee)
{
return false;
}
finally
{
this.disconnectA();
}
return true;
}

protected boolean disconnectA()
{
if (!gConnected) return true;
gConnected = false;
if(gConnect==null) return true;
try
{
gConnect.close();
}
catch(java.sql.SQLException ee)
{
return false;
}
return true;
}

public java.sql.Statement createStatement()
{
try
{
return this.gConnect.createStatement();
}
catch (Exception e) {}
return this.gStatement;
}

public void close()
{
this.disconnect();
}

public void closeAbort()
{
this.disconnectA();
}
}

[cgliang00]

谢谢～～

[hbuzhang]

才看到，太遗憾，自己做了很长时间，还没能成功，太想学习一下，
搂主能不能在百忙中再发一份，不胜感激，
谢谢！！！！！！
[e-mail]

tomcat4.1.24+sqlserver2000的就可以了

[meluan]

还有我: [e-mail]

[glj1121]

来晚了吗?
[e-mail]

[AHUA1001]

还有俺，[e-mail],多谢.

[「已注销」]

me,too!!!

[e-mail]

[WangLan]

me,too!
thanks.
[e-mail]

[yangxjn]

有这个代码的朋友，能给我发一份吗？[e-mail]

[bp69]

不错
我也想要源代码及运行的效果截图
[e-mail]

[bp69]

源代码及运行的效果截图,3q!
[e-mail]

[jayinseu]

搂主，给一份
[e-mail]

[Sunboyjava]

[e-mail]

[lwk]

学习，[e-mail]

[risker]

好东西,谢谢楼主给我发一份
[e-mail]

[leisuretree]

谢谢
[e-mail]

[xingljx]

楼主太好了，正是有你这样真正的高手，并且无私。软件行业才丰富多彩。

请给份代码和截图，[e-mail]

[CNetol]

好东西,顶

[binghgo]

不错
加入我群来讨论

[m16jerry]

请给份代码和截图，[e-mail]

[liujs1026]

来晚了，麻烦楼主也给我发一份代码和截图
谢谢
[e-mail]