2011-4-19学员消费记录

	/**
	 * 查看消费记录 
	 * @param int 
	 * @return Boolean


	 */
	public List<AdminOpenCourseRecord> findStdCourseRecord(int uid,int cid ,int type) {
		String sql = "select * from adminopencourse_record where userid=? and courseid=? and type=? ";

		Object[] args = new Object[] { uid, cid ,type };
		BeanPropertyRowMapper<AdminOpenCourseRecord> argTypes = new BeanPropertyRowMapper<AdminOpenCourseRecord>(AdminOpenCourseRecord.class);
		List<AdminOpenCourseRecord> list = getJdbcTemplate().query(sql, args, argTypes );


		return list;

	}
	/**
	 * 删除消费记录 
	 * @param int uid, int cid,int type
	 * @return Boolean


	 */
	public boolean deleteStdCourseRecord(int uid, int cid,int type) {

		String sql = "delete from adminopencourse_record where userid=? and courseid=? and type=?";

		Object[] args = new Object[] { uid, cid ,type};

		getJdbcTemplate().update(sql,args);

		return true;
	}

	/**
	 * 增加消费记录 
	 * @param int uid, int cid,int type
	 * @return Boolean


	 */
	public boolean saveStdCourseRecord(int uid, int cid,int type) {

		String sql = "insert into adminopencourse_record(userid,courseid,type) values(?,?,?) ";

		Object[] args = new Object[] { uid, cid ,type};

		getJdbcTemplate().update(sql,args);

			return true;
	}