/** 对执行数据增加的PreparedStatement中的参数进行赋值 */ public void prepareInsertStatement(PreparedStatement ps, BaseVO bean) throws Exception { HomePageVO vo = (HomePageVO) bean; ps.setInt(1, vo.getTempl_id()); ps.setString(2, vo.getCaption()); ps.setString(3, vo.getUrl()); }
/** 获取明细信息 */ public BaseVO detail(ResultSet rs) throws Exception { HomePageVO vo = new HomePageVO(); vo.setTempl_id(rs.getInt("TEMPL_ID")); vo.setCaption(rs.getString("CAPTION").trim()); vo.setUrl(rs.getString("URL").trim()); return vo; }
/** 对执行数据修改的PreparedStatement中的参数进行赋值 */ public void prepareUpdateStatement(PreparedStatement ps, BaseVO bean) throws Exception { HomePageVO vo = (HomePageVO) bean; ps.setString(1, vo.getCaption()); ps.setString(2, vo.getUrl()); }