/** * 功能:检查指定的线能否被删除, * * <p>参数:指定线的id * * <p>返回值:能删除返回true,否则返回false; */ public boolean valiLineCanDele(String lineid) { ResultSet rst = null; String sql = "select count(*) aa from sublineinfo where lineid='" + lineid + "'"; try { QueryUtil excu = new QueryUtil(); rst = excu.executeQuery(sql); rst.next(); if (rst.getInt("aa") == 0) { rst.close(); return true; } else { rst.close(); return false; } } catch (Exception e) { logger.error("检查指定的线能否被删除出错:" + e.getMessage()); return false; } }
/** * 检验LineName 是否存在 * * @param name String * @return boolean */ public boolean validateLineName(String name, String type, String region) { String sql = "select count(lineid) i from lineinfo where linename='" + name + "' and regionid='" + region + "'"; ResultSet rs = null; try { QueryUtil query = new QueryUtil(); logger.info("validateLineName() sql :" + sql); rs = query.executeQuery(sql); rs.next(); int i = rs.getInt("i"); logger.info("i=" + i); if ("edit".equals(type)) { if (i < 1) { rs.close(); return true; } else { rs.close(); return false; } } else { if (i == 0) { rs.close(); return true; } else { rs.close(); return false; } } } catch (Exception ex) { logger.error("检查线路是否重名时出错: " + ex.getMessage()); return false; } }