关于查找算法-

public ResultSet equipmentList(Connection con,EquipmentType equipmentType) throws Exception{
			StringBuffer sb=new StringBuffer("select * from t_equipmenttype");
			//System.out.print(equipmentType.getEquipmentTypeName());
			if(StringUtil.isNotEmpty(equipmentType.getEquipmentTypeName())){
				sb.append(" and equipmentTypeName like '%"+equipmentType.getEquipmentTypeName()+"%'");
			
			}
			PreparedStatement pstmt=con.prepareStatement(sb.toString().replaceFirst("and", "where"));
			System.out.print(pstmt);
			return pstmt.executeQuery();
		}

挺好,学习到了.