<% java.lang.Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // java.sql.Connection ConnectionX = java.sql.DriverManager.getConnection("jdbc:ODBC:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\Resin\doc\examples\Tree\tree.mdb","admin", ""); // java.sql.Statement StatementX = ConnectionX.createStatement(); java.sql.ResultSet ResultSetX = java.sql.DriverManager.getConnection("jdbc:ODBC:driver={Microsoft Access Driver (*.mdb)};DBQ=e:\resin-2.1.6\doc\examples\Tree\tree.mdb","admin", "").createStatement().executeQuery("select *,(select count(*) from tree where parentid = T.id) as children from tree T where parentid = 0"); int i=0; int children; int ID; while (ResultSetX.next()) { children=ResultSetX.getInt("children"); ID=ResultSetX.getInt("id"); %>
