7월 ~ 9월) 스프링/프로젝트

(프로젝트) 회원가입은 되는데, 로그인은 안되는경우..

첼로그 2023. 8. 29. 19:38

 

비밀번호/비밀번호 확인 input name 같으면 로그인안됨...

회원가입시 데이터 저장까지 잘되었는데 말입니다

 

 

INFO : jdbc.audit - 2. PreparedStatement.getConnection() returned net.sf.log4jdbc.sql.jdbcapi.ConnectionSpy@9b453b4
INFO : jdbc.audit - 2. Connection.getMetaData() returned oracle.jdbc.driver.OracleDatabaseMetaData@ecef274
INFO : jdbc.audit - 2. PreparedStatement.close() returned 
INFO : jdbc.connection - 2. Connection closed
INFO : jdbc.audit - 2. Connection.close() returned 
INFO : jdbc.connection - 3. Connection opened
INFO : jdbc.audit - 3. Connection.new Connection returned 
INFO : jdbc.audit - 3. Connection.getAutoCommit() returned true
INFO : jdbc.audit - 3. PreparedStatement.new PreparedStatement returned 
INFO : jdbc.audit - 3. Connection.prepareStatement(insert into member (
			MEMBER_ID,
			MEMBER_PW,
			MEMBER_EMAIL,
			MEMBER_PHONE,
			MEMBER_NAME,
			MEMBER_PCODE,
			MEMBER_ADDRESS1,
			MEMBER_ADDRESS2,
			MEMBER_STATUS,
			MEMBER_REG_DATE,
			MEMBER_LAST_LOGIN

			
		) values (
			?,
			?,
			?,
			?,
			?,
			?,
			?,
			?,
		
			1,
			SYSDATE, 
			? 

		)) returned net.sf.log4jdbc.sql.jdbcapi.PreparedStatementSpy@3a84e999
INFO : jdbc.audit - 3. PreparedStatement.setString(1, "plzza") returned 
INFO : jdbc.audit - 3. PreparedStatement.setString(2, "$2a$10$PwhWQTFzcRLk5CcdEc2/i.9iAZbygigfwDSt/PDY9Y1KSf1NKg5Uu") returned 
INFO : jdbc.audit - 3. PreparedStatement.setString(3, "hamplzza@gmail.com") returned 
INFO : jdbc.audit - 3. PreparedStatement.setString(4, "010-1234-5887") returned 
INFO : jdbc.audit - 3. PreparedStatement.setString(5, "핏자") returned 
INFO : jdbc.audit - 3. PreparedStatement.setNull(6, 0) returned 
INFO : jdbc.audit - 3. PreparedStatement.setString(7, "서울 마포구 만리재로 3") returned 
INFO : jdbc.audit - 3. PreparedStatement.setString(8, "파인애플피잣집") returned 
INFO : jdbc.audit - 3. PreparedStatement.setNull(9, 0) returned 
INFO : jdbc.sqlonly - insert into member ( MEMBER_ID, MEMBER_PW, MEMBER_EMAIL, MEMBER_PHONE, MEMBER_NAME, MEMBER_PCODE, 
MEMBER_ADDRESS1, MEMBER_ADDRESS2, MEMBER_STATUS, MEMBER_REG_DATE, MEMBER_LAST_LOGIN ) values 
( 'plzza', '$2a$10$PwhWQTFzcRLk5CcdEc2/i.9iAZbygigfwDSt/PDY9Y1KSf1NKg5Uu', 'hamplzza@gmail.com', 
'010-1234-5887', '핏자', NULL, '서울 마포구 만리재로 3', '파인애플피잣집', 1, SYSDATE, NULL ) 

INFO : jdbc.sqltiming - insert into member ( MEMBER_ID, MEMBER_PW, MEMBER_EMAIL, MEMBER_PHONE, MEMBER_NAME, MEMBER_PCODE, 
MEMBER_ADDRESS1, MEMBER_ADDRESS2, MEMBER_STATUS, MEMBER_REG_DATE, MEMBER_LAST_LOGIN ) values 
( 'plzza', '$2a$10$PwhWQTFzcRLk5CcdEc2/i.9iAZbygigfwDSt/PDY9Y1KSf1NKg5Uu', 'hamplzza@gmail.com', 
'010-1234-5887', '핏자', NULL, '서울 마포구 만리재로 3', '파인애플피잣집', 1, SYSDATE, NULL ) 
 {executed in 6 msec}
INFO : jdbc.audit - 3. PreparedStatement.execute() returned false
INFO : jdbc.audit - 3. PreparedStatement.getUpdateCount() returned 1
INFO : jdbc.audit - 3. PreparedStatement.close() returned 
INFO : jdbc.connection - 3. Connection closed
INFO : jdbc.audit - 3. Connection.close() returned 
INFO : jdbc.connection - 4. Connection opened
INFO : jdbc.audit - 4. Connection.new Connection returned 
INFO : jdbc.audit - 4. Connection.getAutoCommit() returned true
INFO : jdbc.audit - 4. PreparedStatement.new PreparedStatement returned 
INFO : jdbc.audit - 4. Connection.prepareStatement(select MEMBER_ID, MEMBER_PW, MEMBER_NAME, MEMBER_STATUS, MEMBER_EMAIL, MEMBER_PHONE, MEMBER_ADDRESS1, MEMBER_ADDRESS2
	 from member where MEMBER_ID=?) returned net.sf.log4jdbc.sql.jdbcapi.PreparedStatementSpy@15e4c150
INFO : jdbc.audit - 4. PreparedStatement.setString(1, "plzza") returned 
INFO : jdbc.sqlonly - select MEMBER_ID, MEMBER_PW, MEMBER_NAME, MEMBER_STATUS, MEMBER_EMAIL, MEMBER_PHONE, MEMBER_ADDRESS1, 
MEMBER_ADDRESS2 from member where MEMBER_ID='plzza' 

INFO : jdbc.sqltiming - select MEMBER_ID, MEMBER_PW, MEMBER_NAME, MEMBER_STATUS, MEMBER_EMAIL, MEMBER_PHONE, MEMBER_ADDRESS1, 
MEMBER_ADDRESS2 from member where MEMBER_ID='plzza' 
 {executed in 8 msec}
INFO : jdbc.audit - 4. PreparedStatement.execute() returned true
INFO : jdbc.audit - 4. PreparedStatement.getResultSet() returned net.sf.log4jdbc.sql.jdbcapi.ResultSetSpy@1684d7cf
INFO : jdbc.resultsettable - 
|----------|-------------------------------------------------------------|------------|--------------|-------------------|--------------|----------------|----------------|
|member_id |member_pw                                                    |member_name |member_status |member_email       |member_phone  |member_address1 |member_address2 |
|----------|-------------------------------------------------------------|------------|--------------|-------------------|--------------|----------------|----------------|
|plzza     |$2a$10$PwhWQTFzcRLk5CcdEc2/i.9iAZbygigfwDSt/PDY9Y1KSf1NKg5Uu |핏자          |1             |hamplzza@gmail.com |010-1234-5887 |서울 마포구 만리재로 3   |파인애플피잣집         |
|----------|-------------------------------------------------------------|------------|--------------|-------------------|--------------|----------------|----------------|

INFO : jdbc.audit - 4. PreparedStatement.getConnection() returned net.sf.log4jdbc.sql.jdbcapi.ConnectionSpy@2e430ce6
INFO : jdbc.audit - 4. Connection.getMetaData() returned oracle.jdbc.driver.OracleDatabaseMetaData@1bcfc44a
INFO : jdbc.audit - 4. PreparedStatement.close() returned 
INFO : jdbc.connection - 4. Connection closed
INFO : jdbc.audit - 4. Connection.close() returned

 

저작자표시 비영리 (새창열림)