SELECT i.id as itemId, i.item_name as itemName, i.sell_counts as sellCounts, ii.url as imgUrl, tempSpec.price_discount as price, i.updated_time as updated_time FROM items i LEFTJOIN items_img ii on i.id = ii.item_id LEFTJOIN (SELECT item_id,MIN(price_discount) as price_discount from items_spec GROUPBY item_id) tempSpec on i.id = tempSpec.item_id WHERE ii.is_main =1 and i.updated_time >= :sql_last_value --:sql_last_value是记录的最后的一个值
Stu stu = new Stu(); stu.setStuId(1007L); stu.setName("iron man"); stu.setAge(22); stu.setMoney(1000.8f); stu.setSign("I am iron man"); stu.setDescription("I have a spider man");
IndexQuery indexQuery = new IndexQueryBuilder().withObject(stu).build(); esTemplate.index(indexQuery, esTemplate.getIndexCoordinatesFor(stu.getClass())); }