blocks|key|614227|text|转到Java+13%2B。这里有文本块。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|614228|或者使用一些ORM库。|614229|entityMap|0|LINK|mutability|MUTABLE|url|https://openjdk.java.net/jeps/355|1|https://stackoverflow.com/questions/452385/what-java-orm-do-you-prefer-and-why^0|E|3|0|0|6|4|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

Move to Java 13+. There are <a href="https://openjdk.java.net/jeps/355" rel="nofollow noreferrer">Text Blocks</a> for this.
Or use some <a href="https://stackoverflow.com/questions/452385/what-java-orm-do-you-prefer-and-why">ORM library</a>.

blocks|key|614248|text|从Java+15开始，您可以使用文本块|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|614249|String+query+=+"""
+++++++++++++++SELECT+CASE+
++++++++++++++++++WHEN+
++++++++++++++++++++++EXISTS+(
+++++++++++++++++++++++++SELECT+*+
+++++++++++++++++++++++++FROM+users+
+++++++++++++++++++++++++WHERE+
+++++++++++++++++++++++++++++username+=+'username'+
+++++++++++++++++++++++++++++AND+user_password+=+crypt('password',+user_password)
++++++++++++++++++++++)+
++++++++++++++++++THEN+'match'+
++++++++++++++++++ELSE+'differ'+
++++++++++++++++++END
++++++++++++++++""";|code-block|syntax|javascript|614250|entityMap|0|LINK|mutability|MUTABLE|url|https://openjdk.java.net/jeps/378^0|G|3|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

Since Java 15, you can use <a href="https://openjdk.java.net/jeps/378" rel="nofollow noreferrer">text blocks</a>:
<pre class="lang-java prettyprint-override"><code>String query = &quot;&quot;&quot;
 SELECT CASE 
 WHEN 
 EXISTS (
 SELECT * 
 FROM users 
 WHERE 
 username = 'username' 
 AND user_password = crypt('password', user_password)
 ) 
 THEN 'match' 
 ELSE 'differ' 
 END
 &quot;&quot;&quot;;
</code></pre>

blocks|key|614268|text|在不习惯将SQL和JAVA混合的情况下，可以将SQL查询放在.sql文件中。在需要的时候拿到这条短信。
公共类QueryUtil+{静态公共字符串getQuery(String+fileName)抛出IOException+{+Path+=+Paths.get("src/test/resources//“%2B+fileName+%2B+".sql")；返回Files.readAllLines(路径).get(0)；}|type|ordered-list-item|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|614269|如果您可以将SQL和JAVA混合起来，那么从JDK15开始，就可以使用文本块。|614270|此外，您还可以使用JOOQ从数据库中生成Java代码，这带来了许多好处。|614271|unstyled|entityMap|0|LINK|mutability|MUTABLE|url|https://www.jooq.org/^0|U|4|0|0|9|4|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|V|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|W|8|@]|D|@$9|X|A|Y|1|Z]]|E|$]]|$1|J|3|-4|5|K|7|10|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R]]]]

<ol>
<li>In cases when you don't wont to blend SQL and JAVA you can put SQL queries in an <code>.sql</code> file. And get this text when needed.
<pre><code>public class QueryUtil {
 static public String getQuery(String fileName) throws IOException {
 Path path = Paths.get(&quot;src/test/resources//&quot; + fileName + &quot;.sql&quot;);
 return Files.readAllLines(path).get(0);
 }
}
</code></pre>
</li>
<li>If you can mix SQL and JAVA then starting from JDK15 you can use text blocks for this.
</li>
<li>Also you can generates Java code from your database by using <a href="https://www.jooq.org/" rel="nofollow noreferrer">JOOQ</a>, it gives many benefits.
</li>
</ol>

blocks|key|614293|text|假设您不能移动到一个新的超过-8版本的Java+(或者即使您可以)，到目前为止最好的解决方案是使用奥姆。对于Java来说，这很大程度上取决于Hibernate，或jOOQ。jOOQ+(可能还有Hibernate，我还没有使用它，所以不能说，对不起)允许您使用一个流畅的编程接口，这非常符合现有的Java代码风格和模式。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|614294|使用ORM的另一个具体优点是，您可以非常容易地更改您使用的哪个DB引擎，而不必更改您编写的Java代码，而不是在安装函数中更改SQL方言。见https://www.jooq.org/javadoc/latest/org.jooq/org/jooq/SQLDialect.html。|614295|entityMap|0|LINK|mutability|MUTABLE|url|https://en.wikipedia.org/wiki/Object%25E2%2580%2593relational_mapping|1|https://en.wikipedia.org/wiki/Hibernate_(framework))|2|https://en.wikipedia.org/wiki/JOOQ_Object_Oriented_Querying|3|https://www.jooq.org/javadoc/latest/org.jooq/org/jooq/SQLDialect.html^0|1D|2|0|1Y|9|1|29|4|2|0|1Y|1X|3|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]|$A|X|B|Y|1|Z]|$A|10|B|11|1|12]]|C|$]]|$1|D|3|E|5|6|7|13|8|@]|9|@$A|14|B|15|1|16]]|C|$]]|$1|F|3|-4|5|6|7|17|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]|P|$5|I|J|K|C|$L|Q]]|R|$5|I|J|K|C|$L|S]]]]

Assuming that you can't move to a newer-than-8 version of Java (or even if you can), by far the best solution is to use an <a href="https://en.wikipedia.org/wiki/Object%E2%80%93relational_mapping" rel="nofollow noreferrer">ORM</a>. For Java it pretty much comes down to <a href="https://en.wikipedia.org/wiki/Hibernate_(framework)" rel="nofollow noreferrer">Hibernate</a>, or <a href="https://en.wikipedia.org/wiki/JOOQ_Object_Oriented_Querying" rel="nofollow noreferrer">jOOQ</a>. jOOQ (and possibly Hibernate, I haven't used it so can't say, sorry) allows you to use a fluent programming interface, which is very much in keeping with existing Java code style and patterns.
Another specific advantage of using an ORM is that you can very easily change which DB engine you use without having to change the Java code that you've written beyond changing the SQL dialect in your setup functions. See <a href="https://www.jooq.org/javadoc/latest/org.jooq/org/jooq/SQLDialect.html" rel="nofollow noreferrer">https://www.jooq.org/javadoc/latest/org.jooq/org/jooq/SQLDialect.html</a>.

blocks|key|614321|text|您可以使用JOOQ，并获得多种其他好处，如类型安全，自动完成，易于映射和伟大的支持。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|614322|到目前为止，它已经被用于几个项目，也有像Kotlin这样的竞争对手，但总是回到JOOQ。|614323|entityMap|0|LINK|mutability|MUTABLE|url|https://www.jooq.org/^0|5|4|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

You can use <a href="https://www.jooq.org/" rel="nofollow noreferrer">JOOQ</a> and get multiple other benefits like type safety, auto-complete, easy mapping and great support.
Have used it for several projects so far and also competition like Kotlin Exposed but always came back to JOOQ.

How to make long queries more readable?
For example I have this one:
<pre><code>String query = &quot;SELECT CASE WHEN EXISTS (SELECT * FROM users WHERE username = 'username' AND user_password = crypt('password', user_password)) THEN 'match' ELSE 'differ' END&quot;;
</code></pre>
And it's completely unreadable, are there any ways to beautify it?

How to add multiline Strings in Java?

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

如何提高长查询的可读性？例如，我有一个：String query = "SELECT CASE WHEN EXISTS (SELECT * FROM users WHERE username = 'username' AND user_password = crypt('password', user_password...

问如何在Java中添加多行字符串？
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Java中添加多行字符串？EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Java中添加多行字符串？
EN