12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970 |
- package com.robot.remote.smartrobotremote.controller;
- import com.robot.remote.smartrobotremote.domain.BizDevice;
- import com.robot.remote.smartrobotremote.domain.TXinyiRobot;
- import com.robot.remote.smartrobotremote.mapper.BizDeviceMapper;
- import com.robot.remote.smartrobotremote.mapper.TXinyiRobotMapper;
- import lombok.extern.slf4j.Slf4j;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.jdbc.core.JdbcTemplate;
- import org.springframework.web.bind.annotation.GetMapping;
- import org.springframework.web.bind.annotation.RequestParam;
- import org.springframework.web.bind.annotation.RestController;
- import java.util.List;
- import java.util.Map;
- @Slf4j
- @RestController
- public class DataController {
- /*@Autowired
- private JdbcTemplate jdbcTemplate;
- @Autowired
- private BizDeviceMapper bizDeviceMapper;*/
- @Autowired
- private TXinyiRobotMapper tXinyiRobotMapper;
- @GetMapping("/hello")
- public String hello(String name) {
- return "hello " + name;
- }
- /**
- * jdbcTemplate 模拟查询数据
- *
- */
- /*@GetMapping("/testQuerySqlServerByJDBC")
- public List<Map<String, Object>> testQuerySqlServerByJDBC() {
- String sql = "SELECT * FROM biz_device";
- return jdbcTemplate.queryForList(sql);
- }*/
- /**
- * mybatis 模拟查询数据
- *
- */
- /*@GetMapping("/testQuerySqlServerByMybatis")
- public List<BizDevice> testQuerySqlServerByMybatis() {
- return this.bizDeviceMapper.selectBizDeviceList(null);
- }*/
- /**
- * mybatis 模拟查询数据
- *
- */
- @GetMapping("/selectTXinyiRobotListByTime")
- public List<TXinyiRobot> selectTXinyiRobotListByTime(@RequestParam String lastTime) {
- return this.tXinyiRobotMapper.selectTXinyiRobotListByTime(lastTime);
- }
- }
|