質問編集履歴
1
ソースコード編集
title
CHANGED
File without changes
|
body
CHANGED
@@ -95,7 +95,9 @@
|
|
95
95
|
Account account =null;
|
96
96
|
|
97
97
|
try(Connection conn=DriverManager.getConnection(JDBC_URL,DB_USER,DB_PASS)){
|
98
|
-
String sql="select * from account where user_id=? and pass=?";
|
98
|
+
//String sql="select * from account where user_id=? and pass=?";
|
99
|
+
String sql="select trim(user_id)as user_id,rtrim(pass) as pass,rtrim(mail) as mail,rtrim(name) as name,age from account where user_id=? and pass=?";
|
100
|
+
|
99
101
|
PreparedStatement pStmt=conn.prepareStatement(sql);
|
100
102
|
pStmt.setString(1,login.getUserId());
|
101
103
|
pStmt.setString(2,login.getPass());
|