sql 插入两个字段,但是查询的时候只显示一个字段是怎么回事啊
用jsp做一个系统,做注册的时候,新增的两个字段(用户,密码)成功了,但是发现在sql中新增的两个字段,在查询的时候只显示一个字段,然后登陆失败是怎么回事啊。程序代码:
package dao.impl; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import dao.UserDao; public class UserDaoImpl implements UserDao{ Connection conn=null; PreparedStatement pstmt=null; ResultSet rs=null; @Override public int insert(String username,String password) { int i=0; try { Class.forName("oracle.jdbc.driver.OracleDriver"); conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","user2","admin"); pstmt=conn.prepareStatement("insert into users values(?,?)"); pstmt.setString(1,username); pstmt.setString(2,password); i = pstmt.executeUpdate(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { if(rs!=null)rs.close(); if(pstmt!=null)pstmt.close(); if(conn!=null)conn.close(); } catch (SQLException e) { e.printStackTrace(); } return i; } @Override public boolean login(String username,String password) { boolean b=false; try { Class.forName("oracle.jdbc.driver.OracleDriver"); conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","user2","admin"); pstmt=conn.prepareStatement("select * from users where username=? and password=?"); pstmt.setString(1,username); pstmt.setString(2,password); //pstmt 执行sql语句 //pstmt.execute();//适用于增 删 改 查 //pstmt.executeUpdate();//适用于 增 删 改 ==>int 受影响的行数 rs=pstmt.executeQuery();//适用于 select ==>resultSet if(rs.next()){ b=true; } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } try { if(rs!=null)rs.close(); if(pstmt!=null)pstmt.close(); if(conn!=null)conn.close(); } catch (SQLException e) { e.printStackTrace(); } return b; } }
求助求助