@Override
	public String getPayRecord(String mid) {
		// TODO Auto-generated method stub
		String payRecordInfo = "";
		ArrayList<PayRecord> payRecords = new ArrayList<>();

		String sql = "select * from payrecord where mid = \'" + mid + "\'";

		try {
			resultSet = statement.executeQuery(sql);
			while (resultSet.next()) {
				payRecords.add(new PayRecord(resultSet.getString(1), resultSet
						.getDate(2), resultSet.getDouble(3)));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		for (PayRecord payRecord : payRecords) {
			payRecordInfo += payRecord.getDate() + "*" + payRecord.getMoney()
					+ "$";
		}

		if (payRecordInfo.length() > 1)
			payRecordInfo = payRecordInfo.substring(0,
					payRecordInfo.length() - 1);

		return payRecordInfo;
	}