今天主要了解了公司的bm项目,昨天在同事代码的参考下完成了一个简单的流程,今天将数据库中的数据取出,但是没有完成数据在页面的展示。
LthController.java
@Controller
public class LthController {
private static final Logger logger = LoggerFactory.getLogger(LthController.class);
@Autowired
protected SqlSessionTemplate sqlSessionTemplate;
private LthService lthService;
@RequestMapping(value = "/Lth", method = RequestMethod.GET)
public String Lth() {
logger.info("执行lth界面!!! ");
return "lth";
}
@RequestMapping(value = "/selectLth", method = RequestMethod.POST)
public @ResponseBody String selectLth() {
logger.info("执行selectlth界面!!! ");
String str=lthService.selectLth();
return str;
}
LthMapper.xml
<mapper namespace="LthDao">
<select id="selectAll" resultType="map">
select * from jc_dwxx
</select>
</mapper>
LthServiceImpl.java
public class LthServiceImpl implements LthService{
@Autowired
protected SqlSessionTemplate sqlSessionTemplate;
@Override
public String selectLth() {
List<Map<String, Object>> list = sqlSessionTemplate.selectList("ZwxxDao.selectAll");
for (Map<String, Object> m : list){
for (String k : m.keySet()){
System.out.println(k + " : " + m.get(k));
}
}
JSONObject jsonObj = new JSONObject();
jsonObj.accumulate("data", JSONArray.fromObject(list).toString());
System.out.println(jsonObj.toString());
return jsonObj.toString();
}
}