while ( !ParentID.equals("") ) {
pParentID = ParentID;
ResultSet rs = dbc.executeQuery(
"SELECT CategoryID FROM information WHERE ParentID='" + pParentID + "'");
while (rs.next()) {
ParentID.add(rs.getString(0));
CategoryID.add(rs.getString(0));
}
ParentID.remove( pParentID ); //就是刚刚取出的parentID中非空元素
}
while ( !CategoryID.equals("") ) //非空
{
cCategoryID = CategoryID; //中非空元素
dbc.prepareStatement("DELETE FROM information WHERE CategoryID='" +
cCategoryID + "'");
}