其他数据库操作方法
MappingSqlQuery(表操作):

public ActorMappingQuery(DataSource ds) {  super(ds, "select id, first_name, last_name from t_actor where id = ?");  super.declareParameter(new SqlParameter("id", Types.INTEGER));  compile();}@Overrideprotected Actor mapRow(ResultSet rs, int rowNumber) throws SQLException {  Actor actor = new Actor();  actor.setId(rs.getLong("id"));  actor.setFirstName(rs.getString("first_name"));  actor.setLastName(rs.getString("last_name"));  return actor;}

SqlUpdate(表操作):

public UpdateCreditRating(DataSource ds) {  setDataSource(ds);  setSql("update customer set credit_rating = ? where id = ?");  declareParameter(new SqlParameter("creditRating", Types.NUMERIC));  declareParameter(new SqlParameter("id", Types.NUMERIC));  compile();}public int execute(int id, int rating) {  return update(rating, id);}

StoredProcedure(存储过程)

private static final String SPROC_NAME = "AllTitlesAndGenres";public TitlesAndGenresStoredProcedure(DataSource dataSource) {  super(dataSource, SPROC_NAME);  declareParameter(new SqlOutParameter("titles", OracleTypes.CURSOR, new TitleMapper()));  declareParameter(new SqlOutParameter("genres", OracleTypes.CURSOR, new GenreMapper()));  compile();}public Map<String, Object> execute() {  return super.execute(new HashMap<String, Object>());}