编写这样一个方法:
<pre name="code" class="java">public static User getUser(String str) throws SQLException{
<span style="white-space:pre"> </span>User user = new User();
<span style="white-space:pre"> </span>Connection conn = JDBCUtil.getConnection();
<span style="white-space:pre"> </span>String sql = "select * from usertable where name = ?";
<span style="white-space:pre"> </span>PreparedStatement ps = conn.prepareStatement(sql);
<span style="white-space:pre"> </span>ps.setString(1, userName);
<span style="white-space:pre"> </span>ResultSet rs = ps.executeQuery();
<span style="white-space:pre"> </span>if (rs.next()){
<span style="white-space:pre"> </span>user.setId(rs.getInt("id");
<span style="white-space:pre"></span><pre name="code" class="java"><span> </span>user.setName(rs.getString("name");
<pre name="code" class="java"><span> </span>user.setPassword(rs.getString("password");
<span style="white-space:pre"> </span>}
<span style="white-space:pre"> </span>return user;
}
这里需要注意的是,初始化的时候,如果这样初始化
User user = null;
那么下面的set方法虽然可以成功执行,但是user依然是null,导致返回的user也是个null,在使用的时候会提示空指针。