Question

Oracle 并非所有变量都已绑定 问题

public User selectById(int id) { ResultSet rs=null; User u=null; sql="select * from users where user_id=?"; try { ps=con.prepareStatement(sql); ps.setInt(1, id); rs=ps.executeQuery(sql); while(rs.next()) { u=new User(); u.setUser_id(rs.getInt(1)); u.setUsername(rs.getString(2)); u.setPassword(rs.getString(3)); } } catch (SQLException e) { e.printStackTrace(); }finally{ try { rs.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return u; }

Answer 1

你把rs=ps.executeQuery(sql);改成rs=ps.executeQuery();试试。