当前位置：首页 > 后端开发 > 正文

Java中如何编写实现多个条件复合查询的SQL语句？

admin
后端开发
2025-09-27
7

在Java中，实现多个条件查询语句通常使用SQL语句结合条件运算符,以下是一些常见的查询场景和相应的Java代码示例。

基本查询

假设我们有一个名为users的表，其中包含以下字段：id、name、age、email。

Java中如何编写实现多个条件复合查询的SQL语句？第1张

查询条件

查询年龄大于20的用户。
查询邮箱以@example.com结尾的用户。

SQL语句

SELECT * FROM users WHERE age > 20; SELECT * FROM users WHERE email LIKE '%@example.com';

Java代码

String query1 = "SELECT * FROM users WHERE age > 20"; String query2 = "SELECT * FROM users WHERE email LIKE '%@example.com'";

复合查询

查询条件

查询年龄大于20且邮箱以@example.com结尾的用户。
查询年龄小于30或邮箱以@example.com结尾的用户。

SQL语句

SELECT * FROM users WHERE age > 20 AND email LIKE '%@example.com'; SELECT * FROM users WHERE age < 30 OR email LIKE '%@example.com';

Java代码

String query1 = "SELECT * FROM users WHERE age > 20 AND email LIKE '%@example.com'"; String query2 = "SELECT * FROM users WHERE age < 30 OR email LIKE '%@example.com'";

使用IN语句

查询条件

查询年龄为25、30或35的用户。

SQL语句

SELECT * FROM users WHERE age IN (25, 30, 35);

Java代码

String query = "SELECT * FROM users WHERE age IN (25, 30, 35)";

使用BETWEEN语句

查询条件

查询年龄在20到30之间的用户。

SQL语句

SELECT * FROM users WHERE age BETWEEN 20 AND 30;

Java代码

String query = "SELECT * FROM users WHERE age BETWEEN 20 AND 30";

使用LIKE和通配符

查询条件

查询名字以“张”开头的用户。

Java中如何编写实现多个条件复合查询的SQL语句？第2张

SQL语句

SELECT * FROM users WHERE name LIKE '张%';

Java代码

String query = "SELECT * FROM users WHERE name LIKE '张%'";

使用子查询

查询条件

查询所有在子查询中年龄大于25的用户。

Java中如何编写实现多个条件复合查询的SQL语句？第3张

SQL语句

SELECT * FROM users WHERE age > (SELECT MAX(age) FROM users WHERE age < 30);

Java代码

String query = "SELECT * FROM users WHERE age > (SELECT MAX(age) FROM users WHERE age < 30)";

查询条件	SQL语句	Java代码
年龄大于20	SELECT * FROM users WHERE age > 20	String query1 = “SELECT * FROM users WHERE age > 20”;
邮箱以@example.com结尾	SELECT * FROM users WHERE email LIKE ‘%@example.com’	String query2 = “SELECT * FROM users WHERE email LIKE ‘%@example.com'”;
年龄大于20且邮箱以@example.com结尾	SELECT * FROM users WHERE age > 20 AND email LIKE ‘%@example.com’	String query1 = “SELECT * FROM users WHERE age > 20 AND email LIKE ‘%@example.com'”;
年龄小于30或邮箱以@example.com结尾	SELECT * FROM users WHERE age < 30 OR email LIKE ‘%@example.com’	String query2 = “SELECT * FROM users WHERE age < 30 OR email LIKE ‘%@example.com'”;
年龄为25、30或35	SELECT * FROM users WHERE age IN (25, 30, 35)	String query = “SELECT * FROM users WHERE age IN (25, 30, 35)”;
年龄在20到30之间	SELECT * FROM users WHERE age BETWEEN 20 AND 30	String query = “SELECT * FROM users WHERE age BETWEEN 20 AND 30”;
名字以张开头	SELECT * FROM users WHERE name LIKE ‘张%’	String query = “SELECT * FROM users WHERE name LIKE ‘张%'”;
所有在子查询中年龄大于25的用户	SELECT * FROM users WHERE age > (SELECT MAX(age) FROM users WHERE age < 30)	String query = “SELECT * FROM users WHERE age > (SELECT MAX(age) FROM users WHERE age < 30)”;