文章标题

StockMarketProvider.java：

public String selectByStockIdSql(){
BEGIN();
SELECT(“*”);
FROM(TABLE_NAME);
WHERE(“stock_id = #{0}”);
return SQL();
}

public String updateByStockIdSql(){    BEGIN();    UPDATE(TABLE_NAME);    SET("jkp=#{jkp}");    SET("zsp=#{zsp}");    SET("zgj=#{zgj}");    SET("zdj=#{zdj}");    SET("ztj=#{ztj}");    SET("dtj=#{dtj}");    SET("hsl=#{hsl}");    SET("zf=#{zf}");    SET("syl=#{syl}");    SET("sjl=#{sjl}");    SET("cjl=#{cjl}");    SET("cje=#{cje}");    SET("zsz=#{zsz}");    SET("ltsz=#{ltsz}");    SET("mr1=#{mr1}");    SET("mr2=#{mr2}");    SET("mr3=#{mr3}");    SET("mr4=#{mr4}");    SET("mr5=#{mr5}");    SET("mc1=#{mc1}");    SET("mc2=#{mc2}");    SET("mc3=#{mc3}");    SET("mc4=#{mc4}");    SET("mc5=#{mc5}");    SET("mr1_num=#{mr1Num}");    SET("mr2_num=#{mr2Num}");    SET("mr3_num=#{mr3Num}");    SET("mr4_num=#{mr4Num}");    SET("mr5_num=#{mr5Num}");    SET("mc1_num=#{mc1Num}");    SET("mc2_num=#{mc2Num}");    SET("mc3_num=#{mc3Num}");    SET("mc4_num=#{mc4Num}");    SET("mc5_num=#{mc5Num}");    SET("status=#{status}");    SET("dqj=#{dqj}");    SET("bhz=#{bhz}");    SET("bhl=#{bhl}");    WHERE("stock_id=#{stockId}");    return SQL();}//SELECT * FROM market AS a WHERE a.stock_id IN (SELECT id FROM stock AS b WHERE b.`type`=1) //AND a.`status`=0 ORDER BY bhl DESC LIMIT 10;public String selectByOrderAtLimitSql(Map<String,Object> params){    String orderby = (String)params.get("orderby");//使用Params注解，当中的名称作为key        BEGIN();    SELECT("*");    FROM(TABLE_NAME+" AS a");    WHERE("a.stock_id IN (SELECT id FROM stock AS b WHERE b.type=1) and a.status=0");    String order="DESC";    if("bhl".equals(orderby)){        order="DESC";      ORDER_BY("bhl");    }else if("hsl".equals(orderby)){        order="ASC";        ORDER_BY("hsl");    }else if("zf".equals(orderby)){        order="DESC";        ORDER_BY("zf");    }    return SQL()+" "+order+" limit #{limit}";}public String selectDiefuListSql(){    BEGIN();    SELECT("*");    FROM(TABLE_NAME+" AS a");    WHERE("a.stock_id IN (SELECT id FROM stock AS b WHERE b.type=1) AND a.status=0 AND a.bhl<0 ");    ORDER_BY("a.bhl");    return SQL()+" limit #{0}";//我还没有查到怎样使用limit所以干脆直接加到后面了}