Java新手,请教大神:

2025-06-24 05:41:13
推荐回答(2个)
回答1:

String sql = "SELECT * FROM books WHERE name LIKE ' %%'+?+'%% ' AND author LIKE ' %%'+?+'%% ' AND publisher LIKE' %%'+?' %% '";

换成:
String sql = "SELECT * FROM books WHERE name LIKE ? AND author LIKE ? AND publisher LIKE ?";

ptsmt.setString(1, "%" + name + "%");
ptsmt.setString(2, "%" + author + "%");
ptsmt.setString(3, "%" + publisher + "%");

回答2:

附上报错日志信息