public CategoryForm getForm(Integer catId) {
String sql = "SELECT DISTINCT *, (SELECT keyword FROM " +quoteTable("url_alias")
+ " WHERE query = ?) AS keyword FROM "
+ quoteTable("category")+" WHERE category_id = ?";
CategoryForm catForm = (CategoryForm)getJdbcOperations().queryForObject(
sql, new Object[]{"category_id="+catId, catId},
new CategoryRowMapper(){
@Override
public Category mapRow(ResultSet rs, int rowNum)
throws SQLException {
CategoryForm form = (CategoryForm)super.mapRow(rs, rowNum);
form.setKeyword(rs.getString("keyword"));
return form;
}
}.setTargetClass(CategoryForm.class));
catForm.setDescs(getDescriptions(catId));
catForm.setStores(getCatStores(catId));