动态
来源:互联网 发布:电煮锅哪个牌子好 知乎 编辑:程序博客网 时间:2024/04/27 05:08
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所以干脆直接加到后面了
}
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所以干脆直接加到后面了
}
阅读全文
0 0
- 动态
- 动态
- 动态
- 动态磁盘&动态卷
- 动态sql,动态游标
- 动态加载动态库
- 动态加载动态库
- 动态规划!!!动态规划!!!
- 动态内存/动态数组
- 动态类型和动态绑定,动态载入
- 动态生成java、动态编译、动态加载
- 动态语言
- 动态装载
- 近期动态
- 动态方法
- 近日动态!
- 动态代理
- 动态Table
- IP地址如何存放在数据库
- 实现基于深度学习的图像补全(1)图像预处理
- 34. Search for a Range
- jquery uploadify 插件错误 Cannot read property 'queueData' of undefined
- 各种需要的依赖(Android 开发)
- 动态
- 笔记:CSS3的calc()使用
- 实现对象的复用——享元模式(四)
- Educational Codeforces Round 32 F. Connecting Vertices
- win7 64位 安装MySQL5.7.20
- javamail发送邮件、下载邮件核心功能
- JavaScript深入之继承的多种方式和优缺点
- UDP编程原理
- A标签添加是否删除的事件