{"id":62538,"date":"2026-01-20T07:49:49","date_gmt":"2026-01-19T23:49:49","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/62538.html"},"modified":"2026-01-20T07:49:49","modified_gmt":"2026-01-19T23:49:49","slug":"deepseek-preparedstatement-%e4%b8%8e-statement-%e5%85%a8%e9%9d%a2%e5%af%b9%e6%af%94","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/62538.html","title":{"rendered":"DeepSeek PreparedStatement \u4e0e Statement \u5168\u9762\u5bf9\u6bd4"},"content":{"rendered":"

PreparedStatement \u4e0e Statement \u5168\u9762\u5bf9\u6bd4<\/h2>\n

1. \u57fa\u7840\u533a\u522b<\/h3>\n

import<\/span> java.<\/span>sql.<\/span><\/span>*<\/span><\/span>;<\/span><\/p>\n

public<\/span> class<\/span> StatementVsPreparedStatement<\/span> {<\/span><\/p>\n

public<\/span> static<\/span> void<\/span> main<\/span>(<\/span>String<\/span>[<\/span>]<\/span> args)<\/span> {<\/span>
\n String<\/span> url =<\/span> "jdbc:mysql:\/\/localhost:3306\/testdb"<\/span>;<\/span>
\n String<\/span> user =<\/span> "root"<\/span>;<\/span>
\n String<\/span> password =<\/span> "password"<\/span>;<\/span><\/p>\n

try<\/span> {<\/span>
\n Class<\/span>.<\/span>forName<\/span>(<\/span>"com.mysql.cj.jdbc.Driver"<\/span>)<\/span>;<\/span>
\n Connection<\/span> conn =<\/span> DriverManager<\/span>.<\/span>getConnection<\/span>(<\/span>url,<\/span> user,<\/span> password)<\/span>;<\/span><\/p>\n

demoStatement<\/span>(<\/span>conn)<\/span>;<\/span>
\n demoPreparedStatement<\/span>(<\/span>conn)<\/span>;<\/span>
\n demoBatchOperations<\/span>(<\/span>conn)<\/span>;<\/span><\/p>\n

conn.<\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span> catch<\/span> (<\/span>Exception<\/span> e)<\/span> {<\/span>
\n e.<\/span>printStackTrace<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span>
\n }<\/span><\/p>\n

\/**
\n * Statement \u57fa\u672c\u7528\u6cd5
\n *\/<\/span>
\n public<\/span> static<\/span> void<\/span> demoStatement<\/span>(<\/span>Connection<\/span> conn)<\/span> throws<\/span> SQLException<\/span> {<\/span>
\n System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"=== Statement \u6f14\u793a ==="<\/span>)<\/span>;<\/span><\/p>\n

Statement<\/span> stmt =<\/span> null<\/span>;<\/span>
\n try<\/span> {<\/span>
\n stmt =<\/span> conn.<\/span>createStatement<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

\/\/ 1. \u6267\u884c\u67e5\u8be2<\/span>
\n String<\/span> query =<\/span> "SELECT id, name, email FROM users WHERE status = 'ACTIVE'"<\/span>;<\/span>
\n ResultSet<\/span> rs =<\/span> stmt.<\/span>executeQuery<\/span>(<\/span>query)<\/span>;<\/span><\/p>\n

while<\/span> (<\/span>rs.<\/span>next<\/span>(<\/span>)<\/span>)<\/span> {<\/span>
\n System<\/span>.<\/span>out.<\/span>printf<\/span>(<\/span>"ID: %d, Name: %s, Email: %s%n"<\/span>,<\/span>
\n rs.<\/span>getInt<\/span>(<\/span>"id"<\/span>)<\/span>,<\/span>
\n rs.<\/span>getString<\/span>(<\/span>"name"<\/span>)<\/span>,<\/span>
\n rs.<\/span>getString<\/span>(<\/span>"email"<\/span>)<\/span>)<\/span>;<\/span>
\n }<\/span>
\n rs.<\/span>close<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

\/\/ 2. \u6267\u884c\u66f4\u65b0<\/span>
\n String<\/span> update =<\/span> "UPDATE users SET last_login = NOW() WHERE status = 'ACTIVE'"<\/span>;<\/span>
\n int<\/span> rowsUpdated =<\/span> stmt.<\/span>executeUpdate<\/span>(<\/span>update)<\/span>;<\/span>
\n System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"\u66f4\u65b0\u884c\u6570: "<\/span> +<\/span> rowsUpdated)<\/span>;<\/span><\/p>\n

\/\/ 3. \u6267\u884c\u4efb\u610fSQL<\/span>
\n String<\/span> sql =<\/span> "CREATE TABLE IF NOT EXISTS temp_table (id INT, name VARCHAR(50))"<\/span>;<\/span>
\n stmt.<\/span>execute<\/span>(<\/span>sql)<\/span>;<\/span><\/p>\n

}<\/span> finally<\/span> {<\/span>
\n if<\/span> (<\/span>stmt !=<\/span> null<\/span>)<\/span> stmt.<\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span>
\n }<\/span><\/p>\n

\/**
\n * PreparedStatement \u57fa\u672c\u7528\u6cd5
\n *\/<\/span>
\n public<\/span> static<\/span> void<\/span> demoPreparedStatement<\/span>(<\/span>Connection<\/span> conn)<\/span> throws<\/span> SQLException<\/span> {<\/span>
\n System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"\\\\n=== PreparedStatement \u6f14\u793a ==="<\/span>)<\/span>;<\/span><\/p>\n

\/\/ 1. \u67e5\u8be2\u793a\u4f8b<\/span>
\n String<\/span> query =<\/span> "SELECT * FROM users WHERE id = ? AND status = ?"<\/span>;<\/span>
\n PreparedStatement<\/span> pstmt =<\/span> null<\/span>;<\/span><\/p>\n

try<\/span> {<\/span>
\n pstmt =<\/span> conn.<\/span>prepareStatement<\/span>(<\/span>query)<\/span>;<\/span>
\n pstmt.<\/span>setInt<\/span>(<\/span>1<\/span>,<\/span> 1001<\/span>)<\/span>;<\/span> \/\/ \u8bbe\u7f6e\u7b2c\u4e00\u4e2a\u53c2\u6570<\/span>
\n pstmt.<\/span>setString<\/span>(<\/span>2<\/span>,<\/span> "ACTIVE"<\/span>)<\/span>;<\/span> \/\/ \u8bbe\u7f6e\u7b2c\u4e8c\u4e2a\u53c2\u6570<\/span><\/p>\n

ResultSet<\/span> rs =<\/span> pstmt.<\/span>executeQuery<\/span>(<\/span>)<\/span>;<\/span>
\n while<\/span> (<\/span>rs.<\/span>next<\/span>(<\/span>)<\/span>)<\/span> {<\/span>
\n System<\/span>.<\/span>out.<\/span>printf<\/span>(<\/span>"User: %s, Email: %s%n"<\/span>,<\/span>
\n rs.<\/span>getString<\/span>(<\/span>"name"<\/span>)<\/span>,<\/span>
\n rs.<\/span>getString<\/span>(<\/span>"email"<\/span>)<\/span>)<\/span>;<\/span>
\n }<\/span>
\n rs.<\/span>close<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

}<\/span> finally<\/span> {<\/span>
\n if<\/span> (<\/span>pstmt !=<\/span> null<\/span>)<\/span> pstmt.<\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

\/\/ 2. \u63d2\u5165\u793a\u4f8b<\/span>
\n String<\/span> insert =<\/span> "INSERT INTO users (name, email, password, created_at) VALUES (?, ?, ?, ?)"<\/span>;<\/span>
\n try<\/span> (<\/span>PreparedStatement<\/span> insertStmt =<\/span> conn.<\/span>prepareStatement<\/span>(<\/span>insert,<\/span>
\n Statement<\/span>.<\/span>RETURN_GENERATED_KEYS<\/span>)<\/span>)<\/span> {<\/span><\/p>\n

insertStmt.<\/span>setString<\/span>(<\/span>1<\/span>,<\/span> "\u5f20\u4e09"<\/span>)<\/span>;<\/span>
\n insertStmt.<\/span>setString<\/span>(<\/span>2<\/span>,<\/span> "zhangsan@example.com"<\/span>)<\/span>;<\/span>
\n insertStmt.<\/span>setString<\/span>(<\/span>3<\/span>,<\/span> "encrypted_password"<\/span>)<\/span>;<\/span>
\n insertStmt.<\/span>setTimestamp<\/span>(<\/span>4<\/span>,<\/span> new<\/span> Timestamp<\/span>(<\/span>System<\/span>.<\/span>currentTimeMillis<\/span>(<\/span>)<\/span>)<\/span>)<\/span>;<\/span><\/p>\n

int<\/span> affectedRows =<\/span> insertStmt.<\/span>executeUpdate<\/span>(<\/span>)<\/span>;<\/span>
\n System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"\u63d2\u5165\u884c\u6570: "<\/span> +<\/span> affectedRows)<\/span>;<\/span><\/p>\n

\/\/ \u83b7\u53d6\u81ea\u589eID<\/span>
\n ResultSet<\/span> keys =<\/span> insertStmt.<\/span>getGeneratedKeys<\/span>(<\/span>)<\/span>;<\/span>
\n if<\/span> (<\/span>keys.<\/span>next<\/span>(<\/span>)<\/span>)<\/span> {<\/span>
\n int<\/span> generatedId =<\/span> keys.<\/span>getInt<\/span>(<\/span>1<\/span>)<\/span>;<\/span>
\n System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"\u751f\u6210\u7684ID: "<\/span> +<\/span> generatedId)<\/span>;<\/span>
\n }<\/span>
\n keys.<\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

\/\/ 3. \u66f4\u65b0\u793a\u4f8b<\/span>
\n String<\/span> update =<\/span> "UPDATE users SET last_login = ?, login_count = login_count + 1 WHERE id = ?"<\/span>;<\/span>
\n try<\/span> (<\/span>PreparedStatement<\/span> updateStmt =<\/span> conn.<\/span>prepareStatement<\/span>(<\/span>update)<\/span>)<\/span> {<\/span>
\n updateStmt.<\/span>setTimestamp<\/span>(<\/span>1<\/span>,<\/span> new<\/span> Timestamp<\/span>(<\/span>System<\/span>.<\/span>currentTimeMillis<\/span>(<\/span>)<\/span>)<\/span>)<\/span>;<\/span>
\n updateStmt.<\/span>setInt<\/span>(<\/span>2<\/span>,<\/span> 1001<\/span>)<\/span>;<\/span><\/p>\n

int<\/span> rows =<\/span> updateStmt.<\/span>executeUpdate<\/span>(<\/span>)<\/span>;<\/span>
\n System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"\u66f4\u65b0\u7528\u6237\u767b\u5f55\u4fe1\u606f，\u5f71\u54cd\u884c\u6570: "<\/span> +<\/span> rows)<\/span>;<\/span>
\n }<\/span>
\n }<\/span>
\n}<\/span><\/p>\n

2. SQL\u6ce8\u5165\u6f14\u793a\u4e0e\u9632\u62a4<\/h3>\n

import<\/span> java.<\/span>sql.<\/span><\/span>*<\/span><\/span>;<\/span><\/p>\n

public<\/span> class<\/span> SQLInjectionDemo<\/span> {<\/span><\/p>\n

\/**
\n * Statement \u7684 SQL \u6ce8\u5165\u6f0f\u6d1e\u6f14\u793a
\n *\/<\/span>
\n public<\/span> static<\/span> void<\/span> vulnerableLogin<\/span>(<\/span>Connection<\/span> conn,<\/span> String<\/span> username,<\/span> String<\/span> password)<\/span>
\n throws<\/span> SQLException<\/span> {<\/span><\/p>\n

\/\/ \u274c \u5371\u9669\u5199\u6cd5：\u5bb9\u6613\u53d7\u5230SQL\u6ce8\u5165\u653b\u51fb<\/span>
\n String<\/span> sql =<\/span> "SELECT * FROM users WHERE username = '"<\/span> +<\/span> username +<\/span>
\n "' AND password = '"<\/span> +<\/span> password +<\/span> "'"<\/span>;<\/span><\/p>\n

System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"\u6267\u884c\u7684SQL: "<\/span> +<\/span> sql)<\/span>;<\/span><\/p>\n

Statement<\/span> stmt =<\/span> conn.<\/span>createStatement<\/span>(<\/span>)<\/span>;<\/span>
\n ResultSet<\/span> rs =<\/span> stmt.<\/span>executeQuery<\/span>(<\/span>sql)<\/span>;<\/span><\/p>\n

if<\/span> (<\/span>rs.<\/span>next<\/span>(<\/span>)<\/span>)<\/span> {<\/span>
\n System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"\u767b\u5f55\u6210\u529f！"<\/span>)<\/span>;<\/span>
\n }<\/span> else<\/span> {<\/span>
\n System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"\u767b\u5f55\u5931\u8d25！"<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

rs.<\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n stmt.<\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

\/**
\n * PreparedStatement \u9632\u6b62 SQL \u6ce8\u5165
\n *\/<\/span>
\n public<\/span> static<\/span> void<\/span> safeLogin<\/span>(<\/span>Connection<\/span> conn,<\/span> String<\/span> username,<\/span> String<\/span> password)<\/span>
\n throws<\/span> SQLException<\/span> {<\/span><\/p>\n

\/\/ \u2705 \u5b89\u5168\u5199\u6cd5：\u4f7f\u7528 PreparedStatement<\/span>
\n String<\/span> sql =<\/span> "SELECT * FROM users WHERE username = ? AND password = ?"<\/span>;<\/span><\/p>\n

PreparedStatement<\/span> pstmt =<\/span> conn.<\/span>prepareStatement<\/span>(<\/span>sql)<\/span>;<\/span>
\n pstmt.<\/span>setString<\/span>(<\/span>1<\/span>,<\/span> username)<\/span>;<\/span>
\n pstmt.<\/span>setString<\/span>(<\/span>2<\/span>,<\/span> password)<\/span>;<\/span><\/p>\n

System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"\u6267\u884c\u7684SQL: "<\/span> +<\/span> pstmt)<\/span>;<\/span><\/p>\n

ResultSet<\/span> rs =<\/span> pstmt.<\/span>executeQuery<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

if<\/span> (<\/span>rs.<\/span>next<\/span>(<\/span>)<\/span>)<\/span> {<\/span>
\n System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"\u5b89\u5168\u767b\u5f55\u6210\u529f！"<\/span>)<\/span>;<\/span>
\n }<\/span> else<\/span> {<\/span>
\n System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"\u5b89\u5168\u767b\u5f55\u5931\u8d25！"<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

rs.<\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n pstmt.<\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

\/**
\n * SQL\u6ce8\u5165\u653b\u51fb\u793a\u4f8b
\n *\/<\/span>
\n public<\/span> static<\/span> void<\/span> demonstrateInjection<\/span>(<\/span>)<\/span> throws<\/span> SQLException<\/span> {<\/span>
\n String<\/span> url =<\/span> "jdbc:mysql:\/\/localhost:3306\/testdb"<\/span>;<\/span>
\n String<\/span> user =<\/span> "root"<\/span>;<\/span>
\n String<\/span> password =<\/span> "password"<\/span>;<\/span><\/p>\n

Connection<\/span> conn =<\/span> DriverManager<\/span>.<\/span>getConnection<\/span>(<\/span>url,<\/span> user,<\/span> password)<\/span>;<\/span><\/p>\n

System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"=== SQL\u6ce8\u5165\u653b\u51fb\u6f14\u793a ==="<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u6b63\u5e38\u8f93\u5165<\/span>
\n System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"\\\\n1. \u6b63\u5e38\u767b\u5f55:"<\/span>)<\/span>;<\/span>
\n vulnerableLogin<\/span>(<\/span>conn,<\/span> "admin"<\/span>,<\/span> "123456"<\/span>)<\/span>;<\/span><\/p>\n

\/\/ SQL\u6ce8\u5165\u653b\u51fb<\/span>
\n System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"\\\\n2. SQL\u6ce8\u5165\u653b\u51fb:"<\/span>)<\/span>;<\/span>
\n \/\/ \u8f93\u5165: admin' —<\/span>
\n \/\/ SQL\u4f1a\u53d8\u6210: SELECT * FROM users WHERE username = 'admin' –' AND password = 'xxx'<\/span>
\n vulnerableLogin<\/span>(<\/span>conn,<\/span> "admin' –"<\/span>,<\/span> "\u4efb\u610f\u5bc6\u7801"<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u66f4\u5371\u9669\u7684\u6ce8\u5165<\/span>
\n System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"\\\\n3. \u66f4\u5371\u9669\u7684\u6ce8\u5165:"<\/span>)<\/span>;<\/span>
\n \/\/ \u8f93\u5165: ' OR '1'='1<\/span>
\n vulnerableLogin<\/span>(<\/span>conn,<\/span> "' OR '1'='1"<\/span>,<\/span> "' OR '1'='1"<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u4f7f\u7528 PreparedStatement \u9632\u6b62\u6ce8\u5165<\/span>
\n System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"\\\\n4. \u4f7f\u7528 PreparedStatement \u9632\u6b62\u6ce8\u5165:"<\/span>)<\/span>;<\/span>
\n safeLogin<\/span>(<\/span>conn,<\/span> "admin' –"<\/span>,<\/span> "\u4efb\u610f\u5bc6\u7801"<\/span>)<\/span>;<\/span><\/p>\n

conn.<\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

\/**
\n * \u6279\u91cf\u6ce8\u5165\u98ce\u9669
\n *\/<\/span>
\n public<\/span> static<\/span> void<\/span> batchInjectionRisk<\/span>(<\/span>Connection<\/span> conn)<\/span> throws<\/span> SQLException<\/span> {<\/span>
\n \/\/ \u274c \u5371\u9669：\u76f4\u63a5\u62fc\u63a5SQL<\/span>
\n String<\/span> userInput =<\/span> "test'; DROP TABLE users; –"<\/span>;<\/span>
\n String<\/span> sql =<\/span> "INSERT INTO logs (message) VALUES ('"<\/span> +<\/span> userInput +<\/span> "')"<\/span>;<\/span><\/p>\n

Statement<\/span> stmt =<\/span> conn.<\/span>createStatement<\/span>(<\/span>)<\/span>;<\/span>
\n stmt.<\/span>execute<\/span>(<\/span>sql)<\/span>;<\/span> \/\/ \u53ef\u80fd\u6267\u884c\u6076\u610fSQL<\/span><\/p>\n

\/\/ \u2705 \u5b89\u5168：\u4f7f\u7528 PreparedStatement<\/span>
\n String<\/span> safeSql =<\/span> "INSERT INTO logs (message) VALUES (?)"<\/span>;<\/span>
\n PreparedStatement<\/span> pstmt =<\/span> conn.<\/span>prepareStatement<\/span>(<\/span>safeSql)<\/span>;<\/span>
\n pstmt.<\/span>setString<\/span>(<\/span>1<\/span>,<\/span> userInput)<\/span>;<\/span> \/\/ \u53ea\u4f1a\u4f5c\u4e3a\u5b57\u7b26\u4e32\u503c\u5904\u7406<\/span>
\n pstmt.<\/span>executeUpdate<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

public<\/span> static<\/span> void<\/span> main<\/span>(<\/span>String<\/span>[<\/span>]<\/span> args)<\/span> {<\/span>
\n try<\/span> {<\/span>
\n demonstrateInjection<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span> catch<\/span> (<\/span>SQLException<\/span> e)<\/span> {<\/span>
\n e.<\/span>printStackTrace<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span>
\n }<\/span>
\n}<\/span><\/p>\n

3. \u6027\u80fd\u5bf9\u6bd4\u4e0e\u6279\u91cf\u64cd\u4f5c<\/h3>\n

import<\/span> java.<\/span>sql.<\/span><\/span>*<\/span><\/span>;<\/span>
\nimport<\/span> java.<\/span>util.<\/span><\/span>*<\/span><\/span>;<\/span><\/p>\n

public<\/span> class<\/span> PerformanceComparison<\/span> {<\/span><\/p>\n

\/**
\n * Statement \u6279\u91cf\u63d2\u5165 – \u6027\u80fd\u8f83\u5dee
\n *\/<\/span>
\n public<\/span> static<\/span> void<\/span> batchInsertWithStatement<\/span>(<\/span>Connection<\/span> conn,<\/span> List<\/span><<\/span>User<\/span>><\/span><\/span> users)<\/span>
\n throws<\/span> SQLException<\/span> {<\/span><\/p>\n

long<\/span> startTime =<\/span> System<\/span>.<\/span>currentTimeMillis<\/span>(<\/span>)<\/span>;<\/span>
\n Statement<\/span> stmt =<\/span> conn.<\/span>createStatement<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

for<\/span> (<\/span>User<\/span> user :<\/span> users)<\/span> {<\/span>
\n \/\/ \u6bcf\u6b21\u90fd\u9700\u8981\u62fc\u63a5SQL<\/span>
\n String<\/span> sql =<\/span> String<\/span>.<\/span>format<\/span>(<\/span>
\n "INSERT INTO users (name, email, age) VALUES ('%s', '%s', %d)"<\/span>,<\/span>
\n user.<\/span>name.<\/span>replace<\/span>(<\/span>"'"<\/span>,<\/span> "''"<\/span>)<\/span>,<\/span> \/\/ \u9700\u8981\u624b\u52a8\u8f6c\u4e49<\/span>
\n user.<\/span>email.<\/span>replace<\/span>(<\/span>"'"<\/span>,<\/span> "''"<\/span>)<\/span>,<\/span>
\n user.<\/span>age
\n )<\/span>;<\/span>
\n stmt.<\/span>executeUpdate<\/span>(<\/span>sql)<\/span>;<\/span>
\n }<\/span><\/p>\n

stmt.<\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n long<\/span> endTime =<\/span> System<\/span>.<\/span>currentTimeMillis<\/span>(<\/span>)<\/span>;<\/span>
\n System<\/span>.<\/span>out.<\/span>printf<\/span>(<\/span>"Statement \u6279\u91cf\u63d2\u5165 %d \u6761\u6570\u636e\u8017\u65f6: %d ms%n"<\/span>,<\/span>
\n users.<\/span>size<\/span>(<\/span>)<\/span>,<\/span> endTime –<\/span> startTime)<\/span>;<\/span>
\n }<\/span><\/p>\n

\/**
\n * PreparedStatement \u6279\u91cf\u63d2\u5165 – \u6027\u80fd\u8f83\u597d
\n *\/<\/span>
\n public<\/span> static<\/span> void<\/span> batchInsertWithPreparedStatement<\/span>(<\/span>Connection<\/span> conn,<\/span> List<\/span><<\/span>User<\/span>><\/span><\/span> users)<\/span>
\n throws<\/span> SQLException<\/span> {<\/span><\/p>\n

long<\/span> startTime =<\/span> System<\/span>.<\/span>currentTimeMillis<\/span>(<\/span>)<\/span>;<\/span>
\n String<\/span> sql =<\/span> "INSERT INTO users (name, email, age) VALUES (?, ?, ?)"<\/span>;<\/span><\/p>\n

PreparedStatement<\/span> pstmt =<\/span> conn.<\/span>prepareStatement<\/span>(<\/span>sql)<\/span>;<\/span><\/p>\n

for<\/span> (<\/span>User<\/span> user :<\/span> users)<\/span> {<\/span>
\n pstmt.<\/span>setString<\/span>(<\/span>1<\/span>,<\/span> user.<\/span>name)<\/span>;<\/span> \/\/ \u81ea\u52a8\u5904\u7406\u8f6c\u4e49<\/span>
\n pstmt.<\/span>setString<\/span>(<\/span>2<\/span>,<\/span> user.<\/span>email)<\/span>;<\/span> \/\/ \u81ea\u52a8\u5904\u7406\u8f6c\u4e49<\/span>
\n pstmt.<\/span>setInt<\/span>(<\/span>3<\/span>,<\/span> user.<\/span>age)<\/span>;<\/span>
\n pstmt.<\/span>addBatch<\/span>(<\/span>)<\/span>;<\/span> \/\/ \u6dfb\u52a0\u5230\u6279\u5904\u7406<\/span>
\n }<\/span><\/p>\n

int<\/span>[<\/span>]<\/span> results =<\/span> pstmt.<\/span>executeBatch<\/span>(<\/span>)<\/span>;<\/span>
\n pstmt.<\/span>close<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

long<\/span> endTime =<\/span> System<\/span>.<\/span>currentTimeMillis<\/span>(<\/span>)<\/span>;<\/span>
\n System<\/span>.<\/span>out.<\/span>printf<\/span>(<\/span>"PreparedStatement \u6279\u91cf\u63d2\u5165 %d \u6761\u6570\u636e\u8017\u65f6: %d ms%n"<\/span>,<\/span>
\n users.<\/span>size<\/span>(<\/span>)<\/span>,<\/span> endTime –<\/span> startTime)<\/span>;<\/span><\/p>\n

\/\/ \u68c0\u67e5\u6267\u884c\u7ed3\u679c<\/span>
\n int<\/span> successCount =<\/span> 0<\/span>;<\/span>
\n for<\/span> (<\/span>int<\/span> result :<\/span> results)<\/span> {<\/span>
\n if<\/span> (<\/span>result >=<\/span> 0<\/span> ||<\/span> result ==<\/span> Statement<\/span>.<\/span>SUCCESS_NO_INFO<\/span>)<\/span> {<\/span>
\n successCount++<\/span>;<\/span>
\n }<\/span>
\n }<\/span>
\n System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"\u6210\u529f\u63d2\u5165: "<\/span> +<\/span> successCount +<\/span> " \u6761\u8bb0\u5f55"<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

\/**
\n * \u4f7f\u7528\u4e8b\u52a1\u7684\u6279\u91cf\u63d2\u5165
\n *\/<\/span>
\n public<\/span> static<\/span> void<\/span> batchInsertWithTransaction<\/span>(<\/span>Connection<\/span> conn,<\/span> List<\/span><<\/span>User<\/span>><\/span><\/span> users)<\/span>
\n throws<\/span> SQLException<\/span> {<\/span><\/p>\n

boolean<\/span> originalAutoCommit =<\/span> conn.<\/span>getAutoCommit<\/span>(<\/span>)<\/span>;<\/span>
\n long<\/span> startTime =<\/span> System<\/span>.<\/span>currentTimeMillis<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

try<\/span> {<\/span>
\n conn.<\/span>setAutoCommit<\/span>(<\/span>false<\/span>)<\/span>;<\/span> \/\/ \u5f00\u59cb\u4e8b\u52a1<\/span><\/p>\n

String<\/span> sql =<\/span> "INSERT INTO users (name, email, age) VALUES (?, ?, ?)"<\/span>;<\/span>
\n PreparedStatement<\/span> pstmt =<\/span> conn.<\/span>prepareStatement<\/span>(<\/span>sql)<\/span>;<\/span><\/p>\n

for<\/span> (<\/span>int<\/span> i =<\/span> 0<\/span>;<\/span> i <<\/span> users.<\/span>size<\/span>(<\/span>)<\/span>;<\/span> i++<\/span>)<\/span> {<\/span>
\n User<\/span> user =<\/span> users.<\/span>get<\/span>(<\/span>i)<\/span>;<\/span>
\n pstmt.<\/span>setString<\/span>(<\/span>1<\/span>,<\/span> user.<\/span>name)<\/span>;<\/span>
\n pstmt.<\/span>setString<\/span>(<\/span>2<\/span>,<\/span> user.<\/span>email)<\/span>;<\/span>
\n pstmt.<\/span>setInt<\/span>(<\/span>3<\/span>,<\/span> user.<\/span>age)<\/span>;<\/span>
\n pstmt.<\/span>addBatch<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u6bcf1000\u6761\u6267\u884c\u4e00\u6b21\u6279\u5904\u7406<\/span>
\n if<\/span> (<\/span>i %<\/span> 1000<\/span> ==<\/span> 0<\/span> &&<\/span> i ><\/span> 0<\/span>)<\/span> {<\/span>
\n pstmt.<\/span>executeBatch<\/span>(<\/span>)<\/span>;<\/span>
\n pstmt.<\/span>clearBatch<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span>
\n }<\/span><\/p>\n

pstmt.<\/span>executeBatch<\/span>(<\/span>)<\/span>;<\/span> \/\/ \u6267\u884c\u5269\u4f59\u7684\u6279\u5904\u7406<\/span>
\n conn.<\/span>commit<\/span>(<\/span>)<\/span>;<\/span> \/\/ \u63d0\u4ea4\u4e8b\u52a1<\/span><\/p>\n

pstmt.<\/span>close<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

}<\/span> catch<\/span> (<\/span>SQLException<\/span> e)<\/span> {<\/span>
\n conn.<\/span>rollback<\/span>(<\/span>)<\/span>;<\/span> \/\/ \u53d1\u751f\u5f02\u5e38\u65f6\u56de\u6eda<\/span>
\n throw<\/span> e;<\/span>
\n }<\/span> finally<\/span> {<\/span>
\n conn.<\/span>setAutoCommit<\/span>(<\/span>originalAutoCommit)<\/span>;<\/span>
\n }<\/span><\/p>\n

long<\/span> endTime =<\/span> System<\/span>.<\/span>currentTimeMillis<\/span>(<\/span>)<\/span>;<\/span>
\n System<\/span>.<\/span>out.<\/span>printf<\/span>(<\/span>"\u5e26\u4e8b\u52a1\u7684\u6279\u91cf\u63d2\u5165 %d \u6761\u6570\u636e\u8017\u65f6: %d ms%n"<\/span>,<\/span>
\n users.<\/span>size<\/span>(<\/span>)<\/span>,<\/span> endTime –<\/span> startTime)<\/span>;<\/span>
\n }<\/span><\/p>\n

\/**
\n * Statement \u4e0e PreparedStatement \u6027\u80fd\u5bf9\u6bd4
\n *\/<\/span>
\n public<\/span> static<\/span> void<\/span> performanceTest<\/span>(<\/span>)<\/span> throws<\/span> SQLException<\/span> {<\/span>
\n String<\/span> url =<\/span> "jdbc:mysql:\/\/localhost:3306\/testdb"<\/span>;<\/span>
\n String<\/span> user =<\/span> "root"<\/span>;<\/span>
\n String<\/span> password =<\/span> "password"<\/span>;<\/span><\/p>\n

Connection<\/span> conn =<\/span> DriverManager<\/span>.<\/span>getConnection<\/span>(<\/span>url,<\/span> user,<\/span> password)<\/span>;<\/span><\/p>\n

\/\/ \u51c6\u5907\u6d4b\u8bd5\u6570\u636e<\/span>
\n List<\/span><<\/span>User<\/span>><\/span><\/span> testUsers =<\/span> generateTestUsers<\/span>(<\/span>1000<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u6e05\u7406\u6d4b\u8bd5\u8868<\/span>
\n Statement<\/span> stmt =<\/span> conn.<\/span>createStatement<\/span>(<\/span>)<\/span>;<\/span>
\n stmt.<\/span>execute<\/span>(<\/span>"CREATE TABLE IF NOT EXISTS users (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50), email VARCHAR(100), age INT)"<\/span>)<\/span>;<\/span>
\n stmt.<\/span>execute<\/span>(<\/span>"TRUNCATE TABLE users"<\/span>)<\/span>;<\/span>
\n stmt.<\/span>close<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"=== \u6027\u80fd\u5bf9\u6bd4\u6d4b\u8bd5 ==="<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u6d4b\u8bd51: Statement<\/span>
\n batchInsertWithStatement<\/span>(<\/span>conn,<\/span> testUsers)<\/span>;<\/span><\/p>\n

\/\/ \u6e05\u7406\u6570\u636e<\/span>
\n stmt =<\/span> conn.<\/span>createStatement<\/span>(<\/span>)<\/span>;<\/span>
\n stmt.<\/span>execute<\/span>(<\/span>"TRUNCATE TABLE users"<\/span>)<\/span>;<\/span>
\n stmt.<\/span>close<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u6d4b\u8bd52: PreparedStatement<\/span>
\n batchInsertWithPreparedStatement<\/span>(<\/span>conn,<\/span> testUsers)<\/span>;<\/span><\/p>\n

\/\/ \u6e05\u7406\u6570\u636e<\/span>
\n stmt =<\/span> conn.<\/span>createStatement<\/span>(<\/span>)<\/span>;<\/span>
\n stmt.<\/span>execute<\/span>(<\/span>"TRUNCATE TABLE users"<\/span>)<\/span>;<\/span>
\n stmt.<\/span>close<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u6d4b\u8bd53: PreparedStatement + \u4e8b\u52a1<\/span>
\n batchInsertWithTransaction<\/span>(<\/span>conn,<\/span> testUsers)<\/span>;<\/span><\/p>\n

conn.<\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

private<\/span> static<\/span> List<\/span><<\/span>User<\/span>><\/span><\/span> generateTestUsers<\/span>(<\/span>int<\/span> count)<\/span> {<\/span>
\n List<\/span><<\/span>User<\/span>><\/span><\/span> users =<\/span> new<\/span> ArrayList<\/span><<\/span>><\/span><\/span>(<\/span>)<\/span>;<\/span>
\n Random<\/span> random =<\/span> new<\/span> Random<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

for<\/span> (<\/span>int<\/span> i =<\/span> 0<\/span>;<\/span> i <<\/span> count;<\/span> i++<\/span>)<\/span> {<\/span>
\n User<\/span> user =<\/span> new<\/span> User<\/span>(<\/span>)<\/span>;<\/span>
\n user.<\/span>name =<\/span> "User"<\/span> +<\/span> i;<\/span>
\n user.<\/span>email =<\/span> "user"<\/span> +<\/span> i +<\/span> "@example.com"<\/span>;<\/span>
\n user.<\/span>age =<\/span> 20<\/span> +<\/span> random.<\/span>nextInt<\/span>(<\/span>50<\/span>)<\/span>;<\/span>
\n users.<\/span>add<\/span>(<\/span>user)<\/span>;<\/span>
\n }<\/span>
\n return<\/span> users;<\/span>
\n }<\/span><\/p>\n

static<\/span> class<\/span> User<\/span> {<\/span>
\n String<\/span> name;<\/span>
\n String<\/span> email;<\/span>
\n int<\/span> age;<\/span>
\n }<\/span><\/p>\n

public<\/span> static<\/span> void<\/span> main<\/span>(<\/span>String<\/span>[<\/span>]<\/span> args)<\/span> {<\/span>
\n try<\/span> {<\/span>
\n performanceTest<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span> catch<\/span> (<\/span>SQLException<\/span> e)<\/span> {<\/span>
\n e.<\/span>printStackTrace<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span>
\n }<\/span>
\n}<\/span><\/p>\n

4. \u9ad8\u7ea7\u529f\u80fd\u4e0e\u6700\u4f73\u5b9e\u8df5<\/h3>\n

import<\/span> java.<\/span>sql.<\/span><\/span>*<\/span><\/span>;<\/span>
\nimport<\/span> java.<\/span>math.<\/span><\/span>BigDecimal<\/span><\/span>;<\/span><\/p>\n

public<\/span> class<\/span> AdvancedFeatures<\/span> {<\/span><\/p>\n

\/**
\n * PreparedStatement \u9ad8\u7ea7\u529f\u80fd
\n *\/<\/span>
\n public<\/span> static<\/span> void<\/span> demoAdvancedFeatures<\/span>(<\/span>Connection<\/span> conn)<\/span> throws<\/span> SQLException<\/span> {<\/span><\/p>\n

\/\/ 1. \u8bbe\u7f6e\u67e5\u8be2\u8d85\u65f6<\/span>
\n String<\/span> sql =<\/span> "SELECT * FROM large_table WHERE status = ?"<\/span>;<\/span>
\n PreparedStatement<\/span> pstmt =<\/span> conn.<\/span>prepareStatement<\/span>(<\/span>sql)<\/span>;<\/span>
\n pstmt.<\/span>setQueryTimeout<\/span>(<\/span>30<\/span>)<\/span>;<\/span> \/\/ 30\u79d2\u8d85\u65f6<\/span>
\n pstmt.<\/span>setString<\/span>(<\/span>1<\/span>,<\/span> "ACTIVE"<\/span>)<\/span>;<\/span><\/p>\n

\/\/ 2. \u8bbe\u7f6e\u83b7\u53d6\u884c\u6570\u9650\u5236<\/span>
\n pstmt.<\/span>setMaxRows<\/span>(<\/span>1000<\/span>)<\/span>;<\/span> \/\/ \u6700\u591a\u83b7\u53d61000\u884c<\/span><\/p>\n

\/\/ 3. \u8bbe\u7f6e\u83b7\u53d6\u5927\u5c0f<\/span>
\n pstmt.<\/span>setFetchSize<\/span>(<\/span>100<\/span>)<\/span>;<\/span> \/\/ \u6bcf\u6b21\u4ece\u6570\u636e\u5e93\u83b7\u53d6100\u884c<\/span><\/p>\n

\/\/ 4. \u5904\u7406\u5404\u79cd\u6570\u636e\u7c7b\u578b<\/span>
\n String<\/span> insertSQL =<\/span> """
\n INSERT INTO products (
\n name, price, quantity, available,
\n created_at, description, metadata
\n ) VALUES (?, ?, ?, ?, ?, ?, ?)
\n """<\/span>;<\/span><\/p>\n

try<\/span> (<\/span>PreparedStatement<\/span> insertStmt =<\/span> conn.<\/span>prepareStatement<\/span>(<\/span>insertSQL)<\/span>)<\/span> {<\/span>
\n \/\/ \u5b57\u7b26\u4e32<\/span>
\n insertStmt.<\/span>setString<\/span>(<\/span>1<\/span>,<\/span> "\u7b14\u8bb0\u672c\u7535\u8111"<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u6d6e\u70b9\u6570<\/span>
\n insertStmt.<\/span>setBigDecimal<\/span>(<\/span>2<\/span>,<\/span> new<\/span> BigDecimal<\/span>(<\/span>"5999.99"<\/span>)<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u6574\u6570<\/span>
\n insertStmt.<\/span>setInt<\/span>(<\/span>3<\/span>,<\/span> 100<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u5e03\u5c14\u503c<\/span>
\n insertStmt.<\/span>setBoolean<\/span>(<\/span>4<\/span>,<\/span> true<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u65e5\u671f\u65f6\u95f4<\/span>
\n insertStmt.<\/span>setTimestamp<\/span>(<\/span>5<\/span>,<\/span> new<\/span> Timestamp<\/span>(<\/span>System<\/span>.<\/span>currentTimeMillis<\/span>(<\/span>)<\/span>)<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u957f\u6587\u672c<\/span>
\n insertStmt.<\/span>setClob<\/span>(<\/span>6<\/span>,<\/span> new<\/span> javax.<\/span>sql.<\/span>rowset.<\/span>serial.<\/span><\/span>SerialClob<\/span>(<\/span>
\n "\u8fd9\u662f\u4e00\u6b3e\u9ad8\u6027\u80fd\u7b14\u8bb0\u672c\u7535\u8111…"<\/span>.<\/span>toCharArray<\/span>(<\/span>)<\/span>)<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u4e8c\u8fdb\u5236\u6570\u636e<\/span>
\n byte<\/span>[<\/span>]<\/span> metadata =<\/span> "{'color': 'silver', 'weight': '2.5kg'}"<\/span>.<\/span>getBytes<\/span>(<\/span>)<\/span>;<\/span>
\n insertStmt.<\/span>setBytes<\/span>(<\/span>7<\/span>,<\/span> metadata)<\/span>;<\/span><\/p>\n

\/\/ NULL\u503c\u5904\u7406<\/span>
\n insertStmt.<\/span>setNull<\/span>(<\/span>3<\/span>,<\/span> Types<\/span>.<\/span>INTEGER<\/span>)<\/span>;<\/span> \/\/ \u8bbe\u7f6equantity\u4e3aNULL<\/span><\/p>\n

insertStmt.<\/span>executeUpdate<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

\/\/ 5. \u53ef\u6eda\u52a8\u7684\u7ed3\u679c\u96c6<\/span>
\n sql =<\/span> "SELECT * FROM users ORDER BY id"<\/span>;<\/span>
\n pstmt =<\/span> conn.<\/span>prepareStatement<\/span>(<\/span>
\n sql,<\/span>
\n ResultSet<\/span>.<\/span>TYPE_SCROLL_INSENSITIVE<\/span>,<\/span> \/\/ \u53ef\u6eda\u52a8<\/span>
\n ResultSet<\/span>.<\/span>CONCUR_READ_ONLY<\/span> \/\/ \u53ea\u8bfb<\/span>
\n )<\/span>;<\/span><\/p>\n

ResultSet<\/span> rs =<\/span> pstmt.<\/span>executeQuery<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u79fb\u52a8\u5230\u7ed3\u679c\u96c6\u672b\u5c3e<\/span>
\n if<\/span> (<\/span>rs.<\/span>last<\/span>(<\/span>)<\/span>)<\/span> {<\/span>
\n System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"\u603b\u8bb0\u5f55\u6570: "<\/span> +<\/span> rs.<\/span>getRow<\/span>(<\/span>)<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u79fb\u52a8\u5230\u7b2c\u4e00\u884c<\/span>
\n rs.<\/span>first<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u76f8\u5bf9\u79fb\u52a8<\/span>
\n rs.<\/span>relative<\/span>(<\/span>5<\/span>)<\/span>;<\/span> \/\/ \u5411\u524d\u79fb\u52a85\u884c<\/span><\/p>\n

\/\/ \u7edd\u5bf9\u79fb\u52a8<\/span>
\n rs.<\/span>absolute<\/span>(<\/span>10<\/span>)<\/span>;<\/span> \/\/ \u79fb\u52a8\u5230\u7b2c10\u884c<\/span><\/p>\n

\/\/ \u79fb\u52a8\u5230\u63d2\u5165\u884c（\u7528\u4e8e\u63d2\u5165\u65b0\u8bb0\u5f55）<\/span>
\n \/\/ rs.moveToInsertRow();<\/span>
\n \/\/ rs.updateString("name", "New User");<\/span>
\n \/\/ rs.insertRow();<\/span>
\n \/\/ rs.moveToCurrentRow();<\/span>
\n }<\/span>
\n rs.<\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n pstmt.<\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

\/**
\n * \u52a8\u6001SQL\u6784\u5efa（\u5b89\u5168\u7684\u53c2\u6570\u5316\u67e5\u8be2）
\n *\/<\/span>
\n public<\/span> static<\/span> List<\/span><<\/span>Map<\/span><<\/span>String<\/span>,<\/span> Object<\/span>><\/span>><\/span><\/span> dynamicQuery<\/span>(<\/span>
\n Connection<\/span> conn,<\/span>
\n Map<\/span><<\/span>String<\/span>,<\/span> Object<\/span>><\/span><\/span> filters)<\/span> throws<\/span> SQLException<\/span> {<\/span><\/p>\n

StringBuilder<\/span> sql =<\/span> new<\/span> StringBuilder<\/span>(<\/span>"SELECT * FROM products WHERE 1=1"<\/span>)<\/span>;<\/span>
\n List<\/span><<\/span>Object<\/span>><\/span><\/span> parameters =<\/span> new<\/span> ArrayList<\/span><<\/span>><\/span><\/span>(<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u52a8\u6001\u6784\u5efaWHERE\u6761\u4ef6<\/span>
\n if<\/span> (<\/span>filters.<\/span>containsKey<\/span>(<\/span>"category"<\/span>)<\/span>)<\/span> {<\/span>
\n sql.<\/span>append<\/span>(<\/span>" AND category = ?"<\/span>)<\/span>;<\/span>
\n parameters.<\/span>add<\/span>(<\/span>filters.<\/span>get<\/span>(<\/span>"category"<\/span>)<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

if<\/span> (<\/span>filters.<\/span>containsKey<\/span>(<\/span>"minPrice"<\/span>)<\/span>)<\/span> {<\/span>
\n sql.<\/span>append<\/span>(<\/span>" AND price >= ?"<\/span>)<\/span>;<\/span>
\n parameters.<\/span>add<\/span>(<\/span>filters.<\/span>get<\/span>(<\/span>"minPrice"<\/span>)<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

if<\/span> (<\/span>filters.<\/span>containsKey<\/span>(<\/span>"maxPrice"<\/span>)<\/span>)<\/span> {<\/span>
\n sql.<\/span>append<\/span>(<\/span>" AND price <= ?"<\/span>)<\/span>;<\/span>
\n parameters.<\/span>add<\/span>(<\/span>filters.<\/span>get<\/span>(<\/span>"maxPrice"<\/span>)<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

if<\/span> (<\/span>filters.<\/span>containsKey<\/span>(<\/span>"name"<\/span>)<\/span>)<\/span> {<\/span>
\n sql.<\/span>append<\/span>(<\/span>" AND name LIKE ?"<\/span>)<\/span>;<\/span>
\n parameters.<\/span>add<\/span>(<\/span>"%"<\/span> +<\/span> filters.<\/span>get<\/span>(<\/span>"name"<\/span>)<\/span> +<\/span> "%"<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

\/\/ \u6392\u5e8f<\/span>
\n if<\/span> (<\/span>filters.<\/span>containsKey<\/span>(<\/span>"sortBy"<\/span>)<\/span>)<\/span> {<\/span>
\n String<\/span> sortField =<\/span> (<\/span>String<\/span>)<\/span> filters.<\/span>get<\/span>(<\/span>"sortField"<\/span>)<\/span>;<\/span>
\n \/\/ \u9632\u6b62SQL\u6ce8\u5165：\u9a8c\u8bc1\u6392\u5e8f\u5b57\u6bb5<\/span>
\n if<\/span> (<\/span>isValidSortField<\/span>(<\/span>sortField)<\/span>)<\/span> {<\/span>
\n sql.<\/span>append<\/span>(<\/span>" ORDER BY "<\/span>)<\/span>.<\/span>append<\/span>(<\/span>sortField)<\/span>;<\/span>
\n if<\/span> (<\/span>"DESC"<\/span>.<\/span>equalsIgnoreCase<\/span>(<\/span>(<\/span>String<\/span>)<\/span> filters.<\/span>get<\/span>(<\/span>"sortOrder"<\/span>)<\/span>)<\/span>)<\/span> {<\/span>
\n sql.<\/span>append<\/span>(<\/span>" DESC"<\/span>)<\/span>;<\/span>
\n }<\/span>
\n }<\/span>
\n }<\/span><\/p>\n

\/\/ \u5206\u9875<\/span>
\n if<\/span> (<\/span>filters.<\/span>containsKey<\/span>(<\/span>"pageSize"<\/span>)<\/span>)<\/span> {<\/span>
\n sql.<\/span>append<\/span>(<\/span>" LIMIT ? OFFSET ?"<\/span>)<\/span>;<\/span>
\n int<\/span> pageSize =<\/span> (<\/span>int<\/span>)<\/span> filters.<\/span>get<\/span>(<\/span>"pageSize"<\/span>)<\/span>;<\/span>
\n int<\/span> page =<\/span> (<\/span>int<\/span>)<\/span> filters.<\/span>getOrDefault<\/span>(<\/span>"page"<\/span>,<\/span> 1<\/span>)<\/span>;<\/span>
\n parameters.<\/span>add<\/span>(<\/span>pageSize)<\/span>;<\/span>
\n parameters.<\/span>add<\/span>(<\/span>(<\/span>page –<\/span> 1<\/span>)<\/span> *<\/span> pageSize)<\/span>;<\/span>
\n }<\/span><\/p>\n

\/\/ \u6267\u884c\u67e5\u8be2<\/span>
\n PreparedStatement<\/span> pstmt =<\/span> conn.<\/span>prepareStatement<\/span>(<\/span>sql.<\/span>toString<\/span>(<\/span>)<\/span>)<\/span>;<\/span>
\n for<\/span> (<\/span>int<\/span> i =<\/span> 0<\/span>;<\/span> i <<\/span> parameters.<\/span>size<\/span>(<\/span>)<\/span>;<\/span> i++<\/span>)<\/span> {<\/span>
\n pstmt.<\/span>setObject<\/span>(<\/span>i +<\/span> 1<\/span>,<\/span> parameters.<\/span>get<\/span>(<\/span>i)<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

ResultSet<\/span> rs =<\/span> pstmt.<\/span>executeQuery<\/span>(<\/span>)<\/span>;<\/span>
\n List<\/span><<\/span>Map<\/span><<\/span>String<\/span>,<\/span> Object<\/span>><\/span>><\/span><\/span> results =<\/span> new<\/span> ArrayList<\/span><<\/span>><\/span><\/span>(<\/span>)<\/span>;<\/span><\/p>\n

ResultSetMetaData<\/span> metaData =<\/span> rs.<\/span>getMetaData<\/span>(<\/span>)<\/span>;<\/span>
\n int<\/span> columnCount =<\/span> metaData.<\/span>getColumnCount<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

while<\/span> (<\/span>rs.<\/span>next<\/span>(<\/span>)<\/span>)<\/span> {<\/span>
\n Map<\/span><<\/span>String<\/span>,<\/span> Object<\/span>><\/span><\/span> row =<\/span> new<\/span> HashMap<\/span><<\/span>><\/span><\/span>(<\/span>)<\/span>;<\/span>
\n for<\/span> (<\/span>int<\/span> i =<\/span> 1<\/span>;<\/span> i <=<\/span> columnCount;<\/span> i++<\/span>)<\/span> {<\/span>
\n String<\/span> columnName =<\/span> metaData.<\/span>getColumnName<\/span>(<\/span>i)<\/span>;<\/span>
\n row.<\/span>put<\/span>(<\/span>columnName,<\/span> rs.<\/span>getObject<\/span>(<\/span>i)<\/span>)<\/span>;<\/span>
\n }<\/span>
\n results.<\/span>add<\/span>(<\/span>row)<\/span>;<\/span>
\n }<\/span><\/p>\n

rs.<\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n pstmt.<\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n return<\/span> results;<\/span>
\n }<\/span><\/p>\n

private<\/span> static<\/span> boolean<\/span> isValidSortField<\/span>(<\/span>String<\/span> field)<\/span> {<\/span>
\n \/\/ \u767d\u540d\u5355\u9a8c\u8bc1<\/span>
\n Set<\/span><<\/span>String<\/span>><\/span><\/span> validFields =<\/span> Set<\/span>.<\/span>of<\/span>(<\/span>"id"<\/span>,<\/span> "name"<\/span>,<\/span> "price"<\/span>,<\/span> "created_at"<\/span>,<\/span> "category"<\/span>)<\/span>;<\/span>
\n return<\/span> validFields.<\/span>contains<\/span>(<\/span>field.<\/span>toLowerCase<\/span>(<\/span>)<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

\/**
\n * \u5b58\u50a8\u8fc7\u7a0b\u8c03\u7528
\n *\/<\/span>
\n public<\/span> static<\/span> void<\/span> callStoredProcedure<\/span>(<\/span>Connection<\/span> conn)<\/span> throws<\/span> SQLException<\/span> {<\/span>
\n \/\/ \u8c03\u7528\u65e0\u8fd4\u56de\u503c\u7684\u5b58\u50a8\u8fc7\u7a0b<\/span>
\n String<\/span> callSQL =<\/span> "{call update_user_status(?, ?)}"<\/span>;<\/span><\/p>\n

try<\/span> (<\/span>CallableStatement<\/span> cstmt =<\/span> conn.<\/span>prepareCall<\/span>(<\/span>callSQL)<\/span>)<\/span> {<\/span>
\n cstmt.<\/span>setInt<\/span>(<\/span>1<\/span>,<\/span> 1001<\/span>)<\/span>;<\/span>
\n cstmt.<\/span>setString<\/span>(<\/span>2<\/span>,<\/span> "INACTIVE"<\/span>)<\/span>;<\/span>
\n cstmt.<\/span>execute<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

\/\/ \u8c03\u7528\u6709\u8fd4\u56de\u503c\u7684\u5b58\u50a8\u8fc7\u7a0b<\/span>
\n callSQL =<\/span> "{? = call calculate_order_total(?)}"<\/span>;<\/span><\/p>\n

try<\/span> (<\/span>CallableStatement<\/span> cstmt =<\/span> conn.<\/span>prepareCall<\/span>(<\/span>callSQL)<\/span>)<\/span> {<\/span>
\n cstmt.<\/span>registerOutParameter<\/span>(<\/span>1<\/span>,<\/span> Types<\/span>.<\/span>DECIMAL<\/span>)<\/span>;<\/span>
\n cstmt.<\/span>setInt<\/span>(<\/span>2<\/span>,<\/span> 5001<\/span>)<\/span>;<\/span>
\n cstmt.<\/span>execute<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

BigDecimal<\/span> total =<\/span> cstmt.<\/span>getBigDecimal<\/span>(<\/span>1<\/span>)<\/span>;<\/span>
\n System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"\u8ba2\u5355\u603b\u989d: "<\/span> +<\/span> total)<\/span>;<\/span>
\n }<\/span><\/p>\n

\/\/ \u8c03\u7528\u6709\u7ed3\u679c\u96c6\u7684\u5b58\u50a8\u8fc7\u7a0b<\/span>
\n callSQL =<\/span> "{call get_user_orders(?)}"<\/span>;<\/span><\/p>\n

try<\/span> (<\/span>CallableStatement<\/span> cstmt =<\/span> conn.<\/span>prepareCall<\/span>(<\/span>callSQL)<\/span>)<\/span> {<\/span>
\n cstmt.<\/span>setInt<\/span>(<\/span>1<\/span>,<\/span> 1001<\/span>)<\/span>;<\/span>
\n boolean<\/span> hasResults =<\/span> cstmt.<\/span>execute<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

if<\/span> (<\/span>hasResults)<\/span> {<\/span>
\n ResultSet<\/span> rs =<\/span> cstmt.<\/span>getResultSet<\/span>(<\/span>)<\/span>;<\/span>
\n while<\/span> (<\/span>rs.<\/span>next<\/span>(<\/span>)<\/span>)<\/span> {<\/span>
\n System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"\u8ba2\u5355: "<\/span> +<\/span> rs.<\/span>getString<\/span>(<\/span>"order_no"<\/span>)<\/span>)<\/span>;<\/span>
\n }<\/span>
\n rs.<\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span>
\n }<\/span>
\n }<\/span><\/p>\n

\/**
\n * \u6279\u91cf\u66f4\u65b0\u7684\u6700\u4f73\u5b9e\u8df5
\n *\/<\/span>
\n public<\/span> static<\/span> void<\/span> batchUpdateBestPractice<\/span>(<\/span>Connection<\/span> conn,<\/span>
\n List<\/span><<\/span>Map<\/span><<\/span>String<\/span>,<\/span> Object<\/span>><\/span>><\/span><\/span> updates)<\/span>
\n throws<\/span> SQLException<\/span> {<\/span><\/p>\n

boolean<\/span> originalAutoCommit =<\/span> conn.<\/span>getAutoCommit<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

try<\/span> {<\/span>
\n conn.<\/span>setAutoCommit<\/span>(<\/span>false<\/span>)<\/span>;<\/span><\/p>\n

String<\/span> sql =<\/span> "UPDATE products SET price = ?, stock = ? WHERE id = ?"<\/span>;<\/span>
\n PreparedStatement<\/span> pstmt =<\/span> conn.<\/span>prepareStatement<\/span>(<\/span>sql)<\/span>;<\/span><\/p>\n

int<\/span> batchSize =<\/span> 0<\/span>;<\/span>
\n for<\/span> (<\/span>Map<\/span><<\/span>String<\/span>,<\/span> Object<\/span>><\/span><\/span> update :<\/span> updates)<\/span> {<\/span>
\n pstmt.<\/span>setBigDecimal<\/span>(<\/span>1<\/span>,<\/span> (<\/span>BigDecimal<\/span>)<\/span> update.<\/span>get<\/span>(<\/span>"price"<\/span>)<\/span>)<\/span>;<\/span>
\n pstmt.<\/span>setInt<\/span>(<\/span>2<\/span>,<\/span> (<\/span>Integer<\/span>)<\/span> update.<\/span>get<\/span>(<\/span>"stock"<\/span>)<\/span>)<\/span>;<\/span>
\n pstmt.<\/span>setInt<\/span>(<\/span>3<\/span>,<\/span> (<\/span>Integer<\/span>)<\/span> update.<\/span>get<\/span>(<\/span>"id"<\/span>)<\/span>)<\/span>;<\/span>
\n pstmt.<\/span>addBatch<\/span>(<\/span>)<\/span>;<\/span>
\n batchSize++<\/span>;<\/span><\/p>\n

\/\/ \u5b9a\u671f\u6267\u884c\u6279\u5904\u7406，\u907f\u514d\u5185\u5b58\u6ea2\u51fa<\/span>
\n if<\/span> (<\/span>batchSize %<\/span> 1000<\/span> ==<\/span> 0<\/span>)<\/span> {<\/span>
\n pstmt.<\/span>executeBatch<\/span>(<\/span>)<\/span>;<\/span>
\n pstmt.<\/span>clearBatch<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span>
\n }<\/span><\/p>\n

\/\/ \u6267\u884c\u5269\u4f59\u7684\u6279\u5904\u7406<\/span>
\n int<\/span>[<\/span>]<\/span> updateCounts =<\/span> pstmt.<\/span>executeBatch<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

\/\/ \u9a8c\u8bc1\u66f4\u65b0\u7ed3\u679c<\/span>
\n for<\/span> (<\/span>int<\/span> i =<\/span> 0<\/span>;<\/span> i <<\/span> updateCounts.<\/span>length;<\/span> i++<\/span>)<\/span> {<\/span>
\n if<\/span> (<\/span>updateCounts[<\/span>i]<\/span> ==<\/span> Statement<\/span>.<\/span>EXECUTE_FAILED<\/span>)<\/span> {<\/span>
\n System<\/span>.<\/span>err.<\/span>println<\/span>(<\/span>"\u7b2c "<\/span> +<\/span> (<\/span>i+<\/span>1<\/span>)<\/span> +<\/span> " \u6761\u66f4\u65b0\u5931\u8d25"<\/span>)<\/span>;<\/span>
\n \/\/ \u53ef\u4ee5\u8003\u8651\u8bb0\u5f55\u5931\u8d25\u7684\u6570\u636e\u4ee5\u4fbf\u91cd\u8bd5<\/span>
\n }<\/span>
\n }<\/span><\/p>\n

conn.<\/span>commit<\/span>(<\/span>)<\/span>;<\/span>
\n pstmt.<\/span>close<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

}<\/span> catch<\/span> (<\/span>SQLException<\/span> e)<\/span> {<\/span>
\n conn.<\/span>rollback<\/span>(<\/span>)<\/span>;<\/span>
\n throw<\/span> e;<\/span>
\n }<\/span> finally<\/span> {<\/span>
\n conn.<\/span>setAutoCommit<\/span>(<\/span>originalAutoCommit)<\/span>;<\/span>
\n }<\/span>
\n }<\/span><\/p>\n

public<\/span> static<\/span> void<\/span> main<\/span>(<\/span>String<\/span>[<\/span>]<\/span> args)<\/span> {<\/span>
\n try<\/span> {<\/span>
\n String<\/span> url =<\/span> "jdbc:mysql:\/\/localhost:3306\/testdb"<\/span>;<\/span>
\n String<\/span> user =<\/span> "root"<\/span>;<\/span>
\n String<\/span> password =<\/span> "password"<\/span>;<\/span><\/p>\n

Connection<\/span> conn =<\/span> DriverManager<\/span>.<\/span>getConnection<\/span>(<\/span>url,<\/span> user,<\/span> password)<\/span>;<\/span><\/p>\n

demoAdvancedFeatures<\/span>(<\/span>conn)<\/span>;<\/span><\/p>\n

\/\/ \u6d4b\u8bd5\u52a8\u6001\u67e5\u8be2<\/span>
\n Map<\/span><<\/span>String<\/span>,<\/span> Object<\/span>><\/span><\/span> filters =<\/span> new<\/span> HashMap<\/span><<\/span>><\/span><\/span>(<\/span>)<\/span>;<\/span>
\n filters.<\/span>put<\/span>(<\/span>"category"<\/span>,<\/span> "electronics"<\/span>)<\/span>;<\/span>
\n filters.<\/span>put<\/span>(<\/span>"minPrice"<\/span>,<\/span> 1000<\/span>)<\/span>;<\/span>
\n filters.<\/span>put<\/span>(<\/span>"sortField"<\/span>,<\/span> "price"<\/span>)<\/span>;<\/span>
\n filters.<\/span>put<\/span>(<\/span>"sortOrder"<\/span>,<\/span> "DESC"<\/span>)<\/span>;<\/span>
\n filters.<\/span>put<\/span>(<\/span>"pageSize"<\/span>,<\/span> 10<\/span>)<\/span>;<\/span>
\n filters.<\/span>put<\/span>(<\/span>"page"<\/span>,<\/span> 1<\/span>)<\/span>;<\/span><\/p>\n

List<\/span><<\/span>Map<\/span><<\/span>String<\/span>,<\/span> Object<\/span>><\/span>><\/span><\/span> results =<\/span> dynamicQuery<\/span>(<\/span>conn,<\/span> filters)<\/span>;<\/span>
\n System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>"\u67e5\u8be2\u7ed3\u679c\u6570\u91cf: "<\/span> +<\/span> results.<\/span>size<\/span>(<\/span>)<\/span>)<\/span>;<\/span><\/p>\n

conn.<\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span> catch<\/span> (<\/span>SQLException<\/span> e)<\/span> {<\/span>
\n e.<\/span>printStackTrace<\/span>(<\/span>)<\/span>;<\/span>
\n }<\/span>
\n }<\/span>
\n}<\/span><\/p>\n

5. \u7efc\u5408\u5bf9\u6bd4\u8868\u683c<\/h3>\n\n\u7279\u6027StatementPreparedStatement<\/tr>\n\n\n\n\n\n\n\n\n\n\n\n
SQL\u6ce8\u5165\u9632\u62a4<\/td>\n\u274c \u4e0d\u5b89\u5168<\/td>\n\u2705 \u5b89\u5168（\u53c2\u6570\u5316\u67e5\u8be2）<\/td>\n<\/tr>\n
\u6027\u80fd<\/td>\n\u5dee（\u6bcf\u6b21\u89e3\u6790SQL）<\/td>\n\u597d（\u9884\u7f16\u8bd1，\u53ef\u91cd\u7528）<\/td>\n<\/tr>\n
\u53ef\u8bfb\u6027<\/td>\n\u5dee（\u5b57\u7b26\u4e32\u62fc\u63a5）<\/td>\n\u597d（\u53c2\u6570\u5360\u4f4d\u7b26）<\/td>\n<\/tr>\n
\u6570\u636e\u7c7b\u578b\u5904\u7406<\/td>\n\u624b\u52a8\u8f6c\u4e49<\/td>\n\u81ea\u52a8\u5904\u7406<\/td>\n<\/tr>\n
\u6279\u5904\u7406\u652f\u6301<\/td>\n\u6709\u9650<\/td>\n\u4f18\u79c0（addBatch\/executeBatch）<\/td>\n<\/tr>\n
\u5185\u5b58\u4f7f\u7528<\/td>\n\u9ad8（\u91cd\u590d\u89e3\u6790）<\/td>\n\u4f4e（\u9884\u7f16\u8bd1）<\/td>\n<\/tr>\n
\u6570\u636e\u5e93\u7f13\u5b58<\/td>\n\u65e0\u6cd5\u5229\u7528<\/td>\n\u53ef\u5229\u7528\u67e5\u8be2\u7f13\u5b58<\/td>\n<\/tr>\n
\u4e8b\u52a1\u5904\u7406<\/td>\n\u76f8\u540c<\/td>\n\u76f8\u540c<\/td>\n<\/tr>\n
\u5b58\u50a8\u8fc7\u7a0b\u8c03\u7528<\/td>\n\u4e0d\u652f\u6301<\/td>\n\u652f\u6301（CallableStatement）<\/td>\n<\/tr>\n
\u52a8\u6001SQL<\/td>\n\u5bb9\u6613\u6784\u5efa<\/td>\n\u9700\u8981\u5c0f\u5fc3\u6784\u5efa<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

6. \u6700\u4f73\u5b9e\u8df5\u603b\u7ed3<\/h3>\n
  • \u59cb\u7ec8\u4f7f\u7528 PreparedStatement，\u907f\u514dSQL\u6ce8\u5165<\/li>\n
  • \u91cd\u7528 PreparedStatement，\u63d0\u9ad8\u6027\u80fd<\/li>\n
  • \u4f7f\u7528try-with-resources，\u786e\u4fdd\u8d44\u6e90\u91ca\u653e<\/li>\n
  • \u6279\u91cf\u64cd\u4f5c\u65f6\u4f7f\u7528\u4e8b\u52a1，\u63d0\u9ad8\u6548\u7387<\/li>\n
  • \u8bbe\u7f6e\u5408\u9002\u7684fetchSize，\u4f18\u5316\u5927\u6570\u636e\u67e5\u8be2<\/li>\n
  • \u9a8c\u8bc1\u52a8\u6001SQL\u53c2\u6570，\u9632\u6b62SQL\u6ce8\u5165<\/li>\n
  • \u4f7f\u7528\u8fde\u63a5\u6c60，\u7ba1\u7406\u6570\u636e\u5e93\u8fde\u63a5<\/li>\n
  • \u76d1\u63a7SQL\u6267\u884c\u65f6\u95f4，\u4f18\u5316\u6162\u67e5\u8be2<\/li>\n

    \/\/ \u6700\u4f73\u5b9e\u8df5\u793a\u4f8b<\/span>
    \npublic<\/span> class<\/span> BestPracticeExample<\/span> {<\/span>
    \n public<\/span> void<\/span> queryUsers<\/span>(<\/span>DataSource<\/span> dataSource,<\/span> int<\/span> departmentId)<\/span> throws<\/span> SQLException<\/span> {<\/span>
    \n String<\/span> sql =<\/span> "SELECT id, name, email FROM users WHERE department_id = ? AND active = ?"<\/span>;<\/span><\/p>\n

    \/\/ \u4f7f\u7528try-with-resources\u81ea\u52a8\u5173\u95ed\u8d44\u6e90<\/span>
    \n try<\/span> (<\/span>Connection<\/span> conn =<\/span> dataSource.<\/span>getConnection<\/span>(<\/span>)<\/span>;<\/span>
    \n PreparedStatement<\/span> pstmt =<\/span> conn.<\/span>prepareStatement<\/span>(<\/span>sql)<\/span>)<\/span> {<\/span><\/p>\n

    \/\/ \u8bbe\u7f6e\u53c2\u6570<\/span>
    \n pstmt.<\/span>setInt<\/span>(<\/span>1<\/span>,<\/span> departmentId)<\/span>;<\/span>
    \n pstmt.<\/span>setBoolean<\/span>(<\/span>2<\/span>,<\/span> true<\/span>)<\/span>;<\/span><\/p>\n

    \/\/ \u8bbe\u7f6e\u67e5\u8be2\u8d85\u65f6<\/span>
    \n pstmt.<\/span>setQueryTimeout<\/span>(<\/span>10<\/span>)<\/span>;<\/span><\/p>\n

    \/\/ \u6267\u884c\u67e5\u8be2<\/span>
    \n try<\/span> (<\/span>ResultSet<\/span> rs =<\/span> pstmt.<\/span>executeQuery<\/span>(<\/span>)<\/span>)<\/span> {<\/span>
    \n while<\/span> (<\/span>rs.<\/span>next<\/span>(<\/span>)<\/span>)<\/span> {<\/span>
    \n \/\/ \u5904\u7406\u7ed3\u679c<\/span>
    \n System<\/span>.<\/span>out.<\/span>println<\/span>(<\/span>rs.<\/span>getString<\/span>(<\/span>"name"<\/span>)<\/span>)<\/span>;<\/span>
    \n }<\/span>
    \n }<\/span>
    \n }<\/span> catch<\/span> (<\/span>SQLException<\/span> e)<\/span> {<\/span>
    \n \/\/ \u8bb0\u5f55\u65e5\u5fd7\u5e76\u91cd\u65b0\u629b\u51fa<\/span>
    \n logger.<\/span>error<\/span>(<\/span>"\u67e5\u8be2\u7528\u6237\u5931\u8d25"<\/span>,<\/span> e)<\/span>;<\/span>
    \n throw<\/span> e;<\/span>
    \n }<\/span>
    \n }<\/span>
    \n}<\/span><\/p>\n

    \u9009\u62e9 PreparedStatement \u53ef\u4ee5\u83b7\u5f97\u66f4\u597d\u7684\u5b89\u5168\u6027\u3001\u6027\u80fd\u548c\u53ef\u7ef4\u62a4\u6027\u3002\u53ea\u6709\u5728\u6267\u884c\u52a8\u6001DDL\u8bed\u53e5\u6216\u786e\u5b9e\u9700\u8981\u5b57\u7b26\u4e32\u62fc\u63a5\u7684\u7279\u6b8a\u60c5\u51b5\u4e0b\u624d\u8003\u8651\u4f7f\u7528 Statement\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

    PreparedStatement \u4e0e Statement \u5168\u9762\u5bf9\u6bd4
    \n1. \u57fa\u7840\u533a\u522b
    \nimport java.sql.*;public class StatementVsPreparedStatement {public static void main(String[] args) {String url \\”jdbc:mysql:\/\/localhost:3306\/testdb\\”;String user \\”root\\”;String password \\”password\\”<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[99,58,763,427,176],"topic":[],"class_list":["post-62538","post","type-post","status-publish","format-standard","hentry","category-server","tag-java","tag-linux","tag-763","tag-427","tag-176"],"yoast_head":"\nDeepSeek PreparedStatement \u4e0e Statement \u5168\u9762\u5bf9\u6bd4 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/62538.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DeepSeek PreparedStatement \u4e0e Statement \u5168\u9762\u5bf9\u6bd4 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"PreparedStatement \u4e0e Statement \u5168\u9762\u5bf9\u6bd4 1. \u57fa\u7840\u533a\u522b import java.sql.*;public class StatementVsPreparedStatement {public static void main(String[] args) {String url "jdbc:mysql:\/\/localhost:3306\/testdb";String user "root";String password "password"\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/62538.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-19T23:49:49+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/62538.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/62538.html\",\"name\":\"DeepSeek PreparedStatement \u4e0e Statement \u5168\u9762\u5bf9\u6bd4 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-01-19T23:49:49+00:00\",\"dateModified\":\"2026-01-19T23:49:49+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/62538.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/62538.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/62538.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DeepSeek PreparedStatement \u4e0e Statement \u5168\u9762\u5bf9\u6bd4\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DeepSeek PreparedStatement \u4e0e Statement \u5168\u9762\u5bf9\u6bd4 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/62538.html","og_locale":"zh_CN","og_type":"article","og_title":"DeepSeek PreparedStatement \u4e0e Statement \u5168\u9762\u5bf9\u6bd4 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"PreparedStatement \u4e0e Statement \u5168\u9762\u5bf9\u6bd4 1. \u57fa\u7840\u533a\u522b import java.sql.*;public class StatementVsPreparedStatement {public static void main(String[] args) {String url \"jdbc:mysql:\/\/localhost:3306\/testdb\";String user \"root\";String password \"password\"","og_url":"https:\/\/www.wsisp.com\/helps\/62538.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-01-19T23:49:49+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"9 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/62538.html","url":"https:\/\/www.wsisp.com\/helps\/62538.html","name":"DeepSeek PreparedStatement \u4e0e Statement \u5168\u9762\u5bf9\u6bd4 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-01-19T23:49:49+00:00","dateModified":"2026-01-19T23:49:49+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/62538.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/62538.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/62538.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"DeepSeek PreparedStatement \u4e0e Statement \u5168\u9762\u5bf9\u6bd4"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/62538","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=62538"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/62538\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=62538"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=62538"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=62538"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=62538"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}