public static ArrayList<MstxInfo> getFavourite(String uid) {
		ArrayList<MstxInfo> result = new ArrayList<MstxInfo>();
		String sql = "select info_title,info_dis,info_lon,info_lat,info_time,a.uid,a.mid "
				+ "from mstx_info as a,mstx_col as b where a.mid=b.mid and b.uid = " + uid + ";";
		Connection con = DBUtil.getConnection();
		Statement st = null;
		ResultSet rs = null;
		try {
			st = con.createStatement();// 创建语句
			rs = st.executeQuery(sql);
			while (rs.next()) {
				String info_title = rs.getString("info_title");
				String info_dis = rs.getString("info_dis");
				String info_lon = rs.getString("info_lon");
				String info_lat = rs.getString("info_lat");
				String mid = rs.getString("mid");
				Date info_time = rs.getDate("info_time");

				MstxInfo mi = new MstxInfo(info_title, info_dis, info_lon, info_lat, info_time, uid, mid);
				result.add(mi);
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				if (rs != null) {
					rs.close();
					rs = null;
				}
			} catch (Exception e) {
				e.printStackTrace();
			}
			try {
				if (st != null) {
					st.close();
					st = null;
				}
			} catch (Exception e) {
				e.printStackTrace();
			}
			try {
				if (con != null) {
					con.close();
					con = null;
				}
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return result;
	}