springjdbctemplate

    final Person per = new Person();

       String sql = "SELECT * FROM person WHERE id=?";

       Object[] parames = new Object[] { new Integer(id) };

 

       /**

        * 匿名内部类如果要访问本方法中的属性，它需要将属性定义为final

        */

       jt.query(sql, parames, new RowCallbackHandler() {

 

           public void processRow(ResultSet rs) throws SQLException {

 

              per.setId(rs.getInt(1));

              per.setName(rs.getString(2));

              per.setPassword(rs.getString(3));

           }

 

       });

 

       return per;

 

    }

 

    public void update(Person per) {

 

       String sql = "UPDATE person SET name=?,password=? WHERE id=?";

 

       Object[] parames = new Object[] { per.getName(), per.getPassword(),

              per.getId() };

 

       jt.update(sql, parames);

 

    }