YYF根据学生编号查询学生签到状态

前端

**Controller
package com.chinasofti.fwgl.ctrl;

import java.util.HashMap;
import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;

import com.chinasofti.fwgl.bean.att_attendance;
import com.chinasofti.fwgl.bean.att_student;
import com.chinasofti.fwgl.service.att_studentService;

@Controller
public class att_studentController {
@Autowired
private att_studentService as;

@RequestMapping("/queryAttendenceBySid")
@ResponseBody
public HashMap<String,Object> query(@RequestParam("sid") int sid){
		List<att_attendance> l = as.queryAttendanceBySid(sid);
		HashMap<String,Object> hm = new HashMap<>();
		if(l.isEmpty()){
			hm.put("statecode", 400);
		
		}else{
			hm.put("statecode", 200);
			hm.put("list", l);
		}
	return hm;
}

}
**

Service
package com.chinasofti.fwgl.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.chinasofti.fwgl.bean.att_attendance;
import com.chinasofti.fwgl.bean.att_student;
import com.chinasofti.fwgl.dao.att_studentMapper;

@Service
public class att_studentService {
@Autowired
private att_studentMapper am;

public List<att_attendance> queryAttendanceBySid(int sid) {
	return am.queryAttendanceBySid(sid);
}

}

Mapper
package com.chinasofti.fwgl.dao;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.chinasofti.fwgl.bean.att_attendance;
import com.chinasofti.fwgl.bean.att_student;

@Mapper
public interface att_studentMapper {

@Select("select * from att_attendance where sid = #{sid}")
public List<att_attendance> queryAttendanceBySid(@Param("sid") int sid);

}