有1-4的规律,可是就是不知道怎么加进去~~~~
if (!materiel1.equals("")){
sql1="select * from a nolock where substring(aufnr,1,1)='n' and bdmng>0";
sql1=sql1+ " and convert(int,matnr)='" + materiel2 + "'";
sql1=sql1+ " and substring(aufnr,4,5) >='" + tempstart_date + "'";
sql1=sql1+ " and substring(aufnr,4,5) >='" + tempend_date + "'";
}
if (!materiel2.equals("")){
sql2="select * from a nolock where substring(aufnr,1,1)='n' and bdmng>0";
sql2=sql2+ " and convert(int,matnr)='" + materiel2 + "'";
sql2=sql2+ " and substring(aufnr,4,5) >='" + tempstart_date + "'";
sql2=sql2+ " and substring(aufnr,4,5) >='" + tempend_date + "'";
}if (!materiel3.equals("")){
sql3="select * from a nolock where substring(aufnr,1,1)='n' and bdmng>0";
sql3=sql3+ " and convert(int,matnr)='" + materiel3 + "'";
sql3=sql3+ " and substring(aufnr,4,5) >='" + tempstart_date + "'";
sql3=sql3+ " and substring(aufnr,4,5) >='" + tempend_date + "'";
}
if (!materiel4.equals("")){
sql4="select * from a nolock where substring(aufnr,1,1)='n' and bdmng>0";
sql4=sql4+ " and convert(int,matnr)='" + materiel4 + "'";
sql4=sql4+ " and substring(aufnr,4,5) >='" + tempstart_date + "'";
sql4=sql4+ " and substring(aufnr,4,5) >='" + tempend_date + "'";
}
if (!materiel1.equals("")){
sql1="select * from a nolock where substring(aufnr,1,1)='n' and bdmng>0";
sql1=sql1+ " and convert(int,matnr)='" + materiel2 + "'";
sql1=sql1+ " and substring(aufnr,4,5) >='" + tempstart_date + "'";
sql1=sql1+ " and substring(aufnr,4,5) >='" + tempend_date + "'";
}
if (!materiel2.equals("")){
sql2="select * from a nolock where substring(aufnr,1,1)='n' and bdmng>0";
sql2=sql2+ " and convert(int,matnr)='" + materiel2 + "'";
sql2=sql2+ " and substring(aufnr,4,5) >='" + tempstart_date + "'";
sql2=sql2+ " and substring(aufnr,4,5) >='" + tempend_date + "'";
}if (!materiel3.equals("")){
sql3="select * from a nolock where substring(aufnr,1,1)='n' and bdmng>0";
sql3=sql3+ " and convert(int,matnr)='" + materiel3 + "'";
sql3=sql3+ " and substring(aufnr,4,5) >='" + tempstart_date + "'";
sql3=sql3+ " and substring(aufnr,4,5) >='" + tempend_date + "'";
}
if (!materiel4.equals("")){
sql4="select * from a nolock where substring(aufnr,1,1)='n' and bdmng>0";
sql4=sql4+ " and convert(int,matnr)='" + materiel4 + "'";
sql4=sql4+ " and substring(aufnr,4,5) >='" + tempstart_date + "'";
sql4=sql4+ " and substring(aufnr,4,5) >='" + tempend_date + "'";
}
解决方案 »
- 大家麻烦帮看下 jdbc 问题 运行也不抱错误也没什么反应 控制台什么也不显示
- 有谁用Swt Designer的吗?我用的是6.7,新建JFrame总会生成N多代码,大家帮我分析下。
- java中的字符串截取
- 求教各位高手,给个思路即可
- java应用,顶者有分:)
- 真心求JAVA源码~~~~给高分(这里只能给100,但我给300,做好后另外开帖给)
- 小弟才学java,下载的注册机想注册jbx,注册时,输入注册码后,finish按钮总是不可选的,请问如何注册啊?
- 这个applet小程序编译成功,但用appletviewer查看或直接用IE打开时报错,请指教!(附原程序与出错提示在后)
- 关于变量的作用范围
- 如何使用javax.swing包?
- 有人详细解答下为什么错误吗?
- 后缀名是.asf的视频文件怎么播放啊?
{ sql[i]="select * from a nolock where substring(aufnr,1,1)='n' and bdmng>0";
sql[i]=sql3+ " and convert(int,matnr)='" + materiel3 + "'";
sql[i]=sql3+ " and substring(aufnr,4,5) >='" + tempstart_date + "'";
sql[i]=sql3+ " and substring(aufnr,4,5) >='" + tempend_date + "'";
}
至于materiel也要循环判断是否为空。楼主记得结贴给分哦
我有四个变量分别为materiel1,materiel2,materiel3,materiel4
根据这四个变量要生成四个sql语句sql1,sql2,sql3,sql4
看出命名来了吗,很有规律(刻意的),就是想让通过类似循环的语句生成sql语句,可这个循环不会写
int i;
String materiel;
for(i=1;i<5;i++)
{
if(materiel+(i).equals("")){
sql+(i)="select * from a nolock where substring(aufnr,1,1)='n' and bdmng>0";
sql+(i)=sql+(i)+ " and convert(int,matnr)='" + materiel+(i) + "'";
sql+(i)=sql+(i)+ " and substring(aufnr,4,5) >='" + tempstart_date + "'";
sql+(i)=sql+(i)+ " and substring(aufnr,4,5) >='" + tempend_date + "'";
}
}类似这样的循环,不过这个循环肯定不对了