其他数据库操作方法

最新推荐文章于 2011-12-14 09:15:40 发布

RaylnGuan

最新推荐文章于 2011-12-14 09:15:40 发布

阅读量82

点赞数

分类专栏： Spring 文章标签：数据库

本文链接：https://blog.csdn.net/rayln/article/details/84046651

版权

Spring 专栏收录该内容

42 篇文章 0 订阅

订阅专栏

[color=red]MappingSqlQuery(表操作):[/color]

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();
}
@Override
protected 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;
}

[color=red]SqlUpdate(表操作):[/color]

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);
}

[color=red]StoredProcedure(存储过程)[/color]

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>());
}