自行创建controller,mapper,service(impl)等包
controller
@RestController
public class OrderController {
@Autowired
OrderService orderService;
@GetMapping("/test")
public void test(){
Integer test = orderService.test();
System.out.println(test);
}
}
mapper
@Mapper
public interface OrderMapper {
Integer test();
}
service
public interface OrderService {
Integer test ();
}
serviceImpl
@Service
public class OrderServiceImpl implements OrderService {
@Autowired
OrderMapper orderMapper;
@Override
public Integer test() {
return orderMapper.test();
}
}
mappers下的映射文件 记得修改语句喔
<?xml version="1.0" encoding="UTF-8"?> select count(*) from root.ln.wf01.wt01 ```
大致结构如下
接下来运行访问即可得到结果
方案二:使用IotSession
注意:使用此方法就先把mybatis的依赖注释掉不然没有注入数据库会报错