mysql 模糊查询参数化

import mysql.connector

# 连接数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 用户输入的搜索关键词
search_keyword = "%admin%"

# 参数化查询
query = "SELECT * FROM users WHERE username LIKE %s"
cursor.execute(query, (search_keyword,))

# 获取查询结果
results = cursor.fetchall()

for row in results:
    print(row)

# 关闭连接
cursor.close()
db.close()

import java.sql.*;

public class FuzzySearch {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/yourdatabase";
        String user = "yourusername";
        String password = "yourpassword";

        try (Connection conn = DriverManager.getConnection(url, user, password)) {
            String searchKeyword = "%admin%";
            String query = "SELECT * FROM users WHERE username LIKE ?";

            try (PreparedStatement pstmt = conn.prepareStatement(query)) {
                pstmt.setString(1, searchKeyword);
                ResultSet rs = pstmt.executeQuery();

                while (rs.next()) {
                    System.out.println(rs.getString("username"));
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}