回答編集履歴

1

select文修正

2019/06/03 01:55

投稿

nyoi
nyoi

スコア14

test CHANGED
@@ -30,7 +30,7 @@
30
30
 
31
31
  preparedStatement = connection.prepareStatement(
32
32
 
33
- "SELECT * FROM P_TABLE WHERE A_NAME LIKE ? ORDER BY + n +" "+ c);
33
+ "SELECT * FROM P_TABLE WHERE A_NAME LIKE ? ORDER BY " + n + " " + c);
34
34
 
35
35
  preparedStatement.setString(1, a + "%");
36
36