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_student;
import com.chinasofti.fwgl.service.att_studentService;
@Controller
public class att_studentController {
@Autowired
private att_studentService as;
@RequestMapping("/login")
@ResponseBody
public HashMap<String,Object> login(@RequestParam("sid") int sid){
List<att_student> l = as.login(sid);
HashMap<String,Object> hm = new HashMap<>();
if(l.isEmpty()){
hm.put("statecode", 400);
hm.put("state", "学号错误!");
}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_student;
import com.chinasofti.fwgl.dao.att_studentMapper;
@Service
public class att_studentService {
@Autowired
private att_studentMapper am;
public List<att_student> login(int sid){
return am.login(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_student;
@Mapper
public interface att_studentMapper {
@Select("select * from att_student where sid = #{sid}")
public List<att_student> login(@Param("sid") int sid);
}