String sql = "select * from guide where isDeleted = 0 order by id";
pstm = conn.prepareStatement(sql);
rs = pstm.executeQuery();
while(rs.next()){
GuideBean guideBean = new GuideBean();
guideBean.setId(rs.getInt("id"));
guideBean.setGuideId(rs.getString("guide_id"));
guideBean.setGuideName(rs.getString("guide_name"));
guideBean.setParentId(rs.getInt("parent_id"));
guideBean.setDeleted(rs.getBoolean("isDeleted"));
all.add(guideBean);
}
}catch(Exception e)
{
e.printStackTrace();