public static ArrayList<MstxInfo> getMstxRecommend() {
		ArrayList<MstxInfo> result = new ArrayList<MstxInfo>();
		Connection con = DBUtil.getConnection();
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		try {
			pstmt = con
					.prepareStatement("select info_title,info_dis,info_lon,info_lat,a.info_time,a.uid,a.mid from mstx_info as a, mstx_recommend as b where a.mid = b.mid");
			rs = pstmt.executeQuery();

			while (rs.next()) {
				String info_title = rs.getString(1);
				String info_dis = rs.getString(2);
				String info_lon = rs.getString(3);
				String info_lat = rs.getString(4);
				Date info_time = rs.getDate(5);
				String uid = rs.getString(6);
				String mid = rs.getString(7);
				MstxInfo mi = new MstxInfo(info_title, info_dis, info_lon, info_lat, info_time, uid, mid);
				result.add(mi);
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			if (rs != null) {
				rs.close();
				rs = null;
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			if (pstmt != null) {
				pstmt.close();
				pstmt = null;
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			if (con != null) {
				con.close();
				con = null;
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return result;
	}