客户关于queryBySQL使用添加遍历后代码如下- var rtn="";
- var id = request.getSession().getAttribute("id");
- var num = 0;
- var djl = "";
- var gjxbfh = "";
- var zdxbfh = "";
- var ybxbfh = "";
- var hlqx = "";
-
- var sql1_1="select * from tlk_第一类 where PARENT='"+id+"'";
- var sql1_2="select * from tlk_第二类 where PARENT='"+id+"'";
- var sql1_3="select * from tlk_第三类 where PARENT='"+id+"'";
- var doc1_1 = queryBySQL (sql1_1);
- var doc1_2 = queryBySQL (sql1_2);
- var doc1_3 = queryBySQL (sql1_3);
- println(sql1_1);
- println(sql1_2);
- println(sql1_3);
- if (doc1_1 != null && doc1_1.size() >0 ) {
- for (var iter = doc1_1.iterator();iter.hasNext();){
- djl = "一";
- gjxbfh = doc1_1.getItemValueAsString("关键项");
- zdxbfh = doc1_1.getItemValueAsString("重点项");
- ybxbfh = doc1_1.getItemValueAsString("一般项");
- for (var i=1;i<51;i++) {
- var zhi1_1 = doc1_1.getItemValueAsString("结果判定"+i);
- if ("不适用(合理缺项)".equals(zhi1_1)) {num = num + 1;}
- }
- hlqx = num;
- println("888888888888888888888");
- }
- }
-
- if (doc1_2 != null && doc1_2.size() >0 ) {
- for (var iter = doc1_2.iterator();iter.hasNext();){
- djl = "二";
- gjxbfh = doc1_2.getItemValueAsString("关键项");
- zdxbfh = doc1_2.getItemValueAsString("重点项");
- ybxbfh = doc1_2.getItemValueAsString("一般项");
- for (var j=1;j<41;j++) {
- var zhi1_2 = doc1_2.getItemValueAsString("结果判定"+j);
- if ("不适用(合理缺项)".equals(zhi1_2)) {num = num + 1;}
- }
- hlqx = num;
- println("44444444444444444444444");
- }
- }
- if (doc1_3 != null && doc1_3.size() >0 ) {
- for (var iter = doc1_3.iterator();iter.hasNext();){
- djl = "三";
- gjxbfh = doc1_3.getItemValueAsString("关键项");
- zdxbfh = doc1_3.getItemValueAsString("重点项");
- ybxbfh = doc1_3.getItemValueAsString("一般项");
- for (var k=1;k<31;k++) {
- var zhi1_3 = doc1_3.getItemValueAsString("结果判定"+k);
- if ("不适用(合理缺项)".equals(zhi1_3)) {num = num + 1;}
- }
- hlqx = num;
- println("2222222222222222222");
- }
- }
- rtn=rtn+djl+gjxbfh+zdxbfh+ybxbfh;
- rtn;
复制代码 |