blocks|key|1143595|text|您不能直接使用controller来查询数据库，或者这样做不是一个好的做法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1143596|一个更好的选择是，您可以利用Spring数据存储库，并在您的控制器中@Autowire它。|offset|length|style|BOLD|CODE|1143597|我通常要做的是创建一个服务类，其中存储库接口是自动连接的。在控制器中，我自动连接服务类。|1143598|我在以下帖子中的回答可能会为你澄清更多的事情：|1143599|Structure+of+RESTful+Service+with+Java+Spring+for+Beginner|1143600|entityMap|0|LINK|mutability|MUTABLE|url|https://softwareengineering.stackexchange.com/questions/323571/structure-of-restful-service-with-java-spring-for-beginner/^0|0|E|B|Y|9|0|B|3|H|5|14|3|0|0|0|1M|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@$D|Y|E|Z|F|G]|$D|10|E|11|F|H]]|9|@]|A|$]]|$1|I|3|J|5|6|7|12|8|@$D|13|E|14|F|G]|$D|15|E|16|F|G]|$D|17|E|18|F|G]]|9|@]|A|$]]|$1|K|3|L|5|6|7|19|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|1A|8|@]|9|@$D|1B|E|1C|1|1D]]|A|$]]|$1|O|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

You do not use controller directly to query database OR it is not a good practice to do so.

One better option is that you can utilize Spring data repository and <code>@Autowire</code> it in your controller. 

What I normally do is that I create a service class, in which a repository inteface is autowired. In the controller, I autowire the service class. 

My answer of the following post might clear up more things for you: 
<a href="https://softwareengineering.stackexchange.com/questions/323571/structure-of-restful-service-with-java-spring-for-beginner/">Structure of RESTful Service with Java Spring for Beginner</a>

blocks|key|5371206|text|在控制器上执行数据库调用不被认为是一种好的做法。您可以使用Spring数据存储库，也可以编写利用存储库的服务层代码(执行对数据库的调用)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5371207|你可以这样做：|5371208|@Service
public+class+InventoryService+{
++@Autowire
++private+IInventoryItemRepo+inventoryItemRepo;

++@Transactional
++public+List<Inventory>+getInventories()+{
++++//other+business+rules
++++return+inventoryItemRepo.findAll();
+++}
++//some+other+logic+here
}|code-block|syntax|javascript|5371209|然后在你的控制器上|5371210|++++@RestController
++++public+class+InventoryController+{

++++++++Logger+logger+=++LoggerFactory.getLogger(InventoryController.class);

++++++++@Autowired
++++++++private+InventoryService+inventoryService;
++++++++/**
+++++++++*+@return+all+items+in+inventory
+++++++++*/
++++++++@HystrixCommand(fallbackMethod="failGood")
++++++++@RequestMapping(value+=+"/inventory",+method+=+RequestMethod.GET)
++++++++@ResponseBody+Iterable<Inventory>+getInventory()+{
++++++++++++return+inventoryService.findAll();
++++++++}
+++++++++++....

++++}|5371211|如果您希望避免在Spring上执行调用，可以将服务层代码注入执行调用的组件，假设它是用spring在java上编写的。|5371212|如果没有，您还可以构建一个Message+Queue并将消息发送到那里。|offset|length|5371213|另一种方法是称为Spring+Data+REST的方法|5371214|entityMap|0|LINK|mutability|MUTABLE|url|https://www.rabbitmq.com/|1|http://projects.spring.io/spring-data-rest/^0|0|0|0|0|0|0|D|D|0|0|8|G|1|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|15|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|16|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|17|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|18|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|19|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1A|8|@]|9|@$Q|1B|R|1C|1|1D]]|A|$]]|$1|S|3|T|5|6|7|1E|8|@]|9|@$Q|1F|R|1G|1|1H]]|A|$]]|$1|U|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]]|V|$W|$5|X|Y|Z|A|$10|11]]|12|$5|X|Y|Z|A|$10|13]]]]

It is not considered to be a good practice to perform the database calls on the controller. You can either use a Spring Data Repository, or write a Service Layer code that utilizes the repository(which performs the calls on the database)

One might do it as follows

<pre><code>@Service
public class InventoryService {
 @Autowire
 private IInventoryItemRepo inventoryItemRepo;

 @Transactional
 public List&lt;Inventory&gt; getInventories() {
 //other business rules
 return inventoryItemRepo.findAll();
 }
 //some other logic here
}
</code></pre>

and then on your controller

<pre><code> @RestController
 public class InventoryController {

 Logger logger = LoggerFactory.getLogger(InventoryController.class);

 @Autowired
 private InventoryService inventoryService;
 /**
 * @return all items in inventory
 */
 @HystrixCommand(fallbackMethod="failGood")
 @RequestMapping(value = "/inventory", method = RequestMethod.GET)
 @ResponseBody Iterable&lt;Inventory&gt; getInventory() {
 return inventoryService.findAll();
 }
 ....

 }
</code></pre>

If you want to avoid performing the call on the spring you can inject the service layer code to that component who would be performing the call assuming it is written on java with Spring. 

If not you can also build a <a href="https://www.rabbitmq.com/" rel="nofollow noreferrer">Message Queue</a>
 and send the message there.

An alternative is this one called <a href="http://projects.spring.io/spring-data-rest/" rel="nofollow noreferrer">Spring Data REST</a>

I am fairly new to SpringBoot so please fill free to fill in the details where needed.

I wrote this <a href="https://github.com/fabiogomezdiaz/refarch-cloudnative-micro-inventory/blob/master/src/main/java/inventory/mysql/InventoryController.java" rel="nofollow noreferrer">Rest Controller</a> in a SpringBoot app, which works as expected. My questions is, how can I properly create an instance of this controller so that I can use it to query the database?

I was trying to do something like this, but just kept getting errors.

<pre><code>InventoryController ic = new InventoryController();
System.out.println(ic.getInventory());
</code></pre>

I am trying to avoid a situation where I have to do a REST call on the SpringBoot app itself.

Thanks a lot in advance

How can I use a SpringBoot RestController on a separate Java Class to query database?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我是SpringBoot的新手，所以请随意填写所需的详细信息。我在一个SpringBoot应用程序中编写了这个，它可以正常工作。我的问题是，如何正确地创建此控制器的实例，以便可以使用它来查询数据库？我试着做这样的事情，但是一直收到错误。InventoryController ic = new InventoryCont...

问如何在单独的Java Class上使用SpringBoot RestController来查询数据库？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在单独的Java Class上使用SpringBoot RestController来查询数据库？EN