teratail header banner
teratail header banner
質問するログイン新規登録

質問編集履歴

1

ソースコード編集

2020/04/10 16:23

投稿

karakorum
karakorum

スコア20

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());