一.lang3包

//null \"\"
public static boolean isEmpty(CharSequence cs)
//null \"\" \" \"
public static boolean isBlank(CharSequence cs
//符串在另外一个字符串里，出现第Ordinal次的位置
public static int ordinalIndexOf(CharSequence str, CharSequence searchStr,int ordinal)
StringUtils.ordinalIndexOf(\"aabaabaa\", \"ab\", 1) = 1
 

二.DbUtils包

//普通方式
String sql = \"SELECT t.stationNo,b.station_name,b.latitude,b.longitude,t.pre,  \"
					+ \"	b.region_id_two,b.basin_id,b.region_id  FROM t_mete_climate_first_soaker t  \"
					+ \"	JOIN t_mete_station b ON t.stationNo = b.device_id  WHERE  \"
					+ \"	b.region_id_two IN (\'1\', \'2\', \'3\')  \" + \"	AND t.event_year = \'\" + date + \"\'\";
			PreparedStatement ps = conn.prepareStatement(sql);
			ResultSet rs = ps.executeQuery();
			while (rs.next()) {
				Map<String,  > obj = new HashMap<>();
				obj.put(\"stationNo\", rs.get (1));
				obj.put(\"station_name\", rs.get (2));
				obj.put(\"latitude\", rs.get (3));
				obj.put(\"longitude\", rs.get (4));
				obj.put(\"value\", rs.get (5));
				obj.put(\"region_id_two\", rs.get (6));
				obj.put(\"basin_id\", rs.get (7));
				obj.put(\"region_id\", rs.get (8));
				xyzs_param.add(obj);
			}
//dbutils
String sql = \"SELECT t.stationNo,b.station_name as stationName,b.longitude as lon,b.latitude as lat,b.region_id,\\n\" +
		            \"DATE_FORMAT(t.ObserverTime,\'%Y-%m-%d\') as observerTime,s.WEP_Name,s.WEP_Code\\n\" +
		            \"FROM\\n\" +
		            \"t_mete_ns_day_data t,t_mete_station b,t_mete_ns_day_wea s\\n\" +
		            \"WHERE t.stationNo = b.device_id\\n\" +
		            \"AND t.stationNo = s.stationNo AND t.ObserverTime = s.ObserverTime\\n\" +
		            \"AND b.station_type = 1\\n\" +
		            \"AND t.ObserverTime > \'\"+ObserverTime+\"\'\";
			QueryRunner queryRunner = new QueryRunner();
			resultList = queryRunner.query(conn, sql, new BeanListHandler<>(AlarmThresholdsBean.class));