DataController.java 1.8 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970
  1. package com.robot.remote.smartrobotremote.controller;
  2. import com.robot.remote.smartrobotremote.domain.BizDevice;
  3. import com.robot.remote.smartrobotremote.domain.TXinyiRobot;
  4. import com.robot.remote.smartrobotremote.mapper.BizDeviceMapper;
  5. import com.robot.remote.smartrobotremote.mapper.TXinyiRobotMapper;
  6. import lombok.extern.slf4j.Slf4j;
  7. import org.springframework.beans.factory.annotation.Autowired;
  8. import org.springframework.jdbc.core.JdbcTemplate;
  9. import org.springframework.web.bind.annotation.GetMapping;
  10. import org.springframework.web.bind.annotation.RequestParam;
  11. import org.springframework.web.bind.annotation.RestController;
  12. import java.util.List;
  13. import java.util.Map;
  14. @Slf4j
  15. @RestController
  16. public class DataController {
  17. /*@Autowired
  18. private JdbcTemplate jdbcTemplate;
  19. @Autowired
  20. private BizDeviceMapper bizDeviceMapper;*/
  21. @Autowired
  22. private TXinyiRobotMapper tXinyiRobotMapper;
  23. @GetMapping("/hello")
  24. public String hello(String name) {
  25. return "hello " + name;
  26. }
  27. /**
  28. * jdbcTemplate 模拟查询数据
  29. *
  30. */
  31. /*@GetMapping("/testQuerySqlServerByJDBC")
  32. public List<Map<String, Object>> testQuerySqlServerByJDBC() {
  33. String sql = "SELECT * FROM biz_device";
  34. return jdbcTemplate.queryForList(sql);
  35. }*/
  36. /**
  37. * mybatis 模拟查询数据
  38. *
  39. */
  40. /*@GetMapping("/testQuerySqlServerByMybatis")
  41. public List<BizDevice> testQuerySqlServerByMybatis() {
  42. return this.bizDeviceMapper.selectBizDeviceList(null);
  43. }*/
  44. /**
  45. * mybatis 模拟查询数据
  46. *
  47. */
  48. @GetMapping("/selectTXinyiRobotListByTime")
  49. public List<TXinyiRobot> selectTXinyiRobotListByTime(@RequestParam String lastTime) {
  50. return this.tXinyiRobotMapper.selectTXinyiRobotListByTime(lastTime);
  51. }
  52. }