コード例 #1
0
 /** We may decide to implement this later but for now, every call to here returns null. */
 @Override
 public PreparedStatement loadParameters(PreparedStatement ps, ReviewsBean bean)
     throws SQLException {
   int i = 1;
   ps.setLong(i++, bean.getMID());
   ps.setLong(i++, bean.getPID());
   ps.setString(i++, bean.getDescriptiveReview());
   ps.setDouble(i++, bean.getRating());
   ps.setString(i++, bean.getTitle());
   return ps;
 }
コード例 #2
0
 /**
  * ReviewsBeans are built and returned, when possible from info in ResultSet.
  *
  * @param ResultSet from query, holds DB info for ReviewsBean
  * @return the loaded ReviewsBean
  */
 @Override
 public ReviewsBean loadSingle(ResultSet rs) throws SQLException {
   ReviewsBean rev = new ReviewsBean();
   rev.setMID(rs.getLong("mid"));
   rev.setPID(rs.getLong("pid"));
   rev.setDateOfReview(rs.getDate("reviewdate"));
   rev.setDescriptiveReview(rs.getString("descriptivereview"));
   rev.setRating(rs.getInt("rating"));
   rev.setTitle(rs.getString("title"));
   return rev;
 }