java if里面并列_我用java写了两个if()并列语句，可是只有第二个执行了，为什么会这样子呢？...

具体代码如下：Stringmake;if(Xueyuan!=null){make=Xueyuan;sqlString="selectS.XH,S.XM,S.ZYDM,P.LWMC,P.SHZTFROMxsjbxxS,xlssPWHERES.XH=P.XHANDsubstring(P.SHZT,2,1)='"+make+"'"...

具体代码如下：

String make;

if (Xueyuan != null) {

make = Xueyuan;

sqlString = "select S.XH,S.XM,S.ZYDM,P.LWMC,P.SHZT FROM xsjbxx S,xlss P WHERE S.XH = P.XH AND substring(P.SHZT,2,1)='" + make + "' "

+ "UNION select S.XH,S.XM,S.ZYDM,P.LWMC,P.SHZT FROM xsjbxx S,tdxlss P WHERE S.XH = P.XH AND substring(P.SHZT,2,1)='" + make + "' "

+ "UNION select S.XH,S.XM,S.ZYDM,P.LWMC,P.SHZT FROM xsjbxx S,xlbs P WHERE S.XH = P.XH AND substring(P.SHZT,2,1)='" + make + "' "

+ "UNION select S.XH,S.XM,S.ZYDM,P.LWMC,P.SHZT FROM xsjbxx S,bs P WHERE S.XH = P.XH AND substring(P.SHZT,2,1)='" + make + "' "

+ "UNION select S.XH,S.XM,S.ZYDM,P.LWMC,P.SHZT FROM xsjbxx S,ss P WHERE S.XH = P.XH AND substring(P.SHZT,2,1)='" + make + "' ";

}

if (Xuexiao != null) {

make = Xuexiao;

sqlString = "select S.XH,S.XM,S.ZYDM,P.LWMC,P.SHZT FROM xsjbxx S,xlss P WHERE S.XH = P.XH AND substring(P.SHZT,3,1)='" + make + "' "

+ "UNION select S.XH,S.XM,S.ZYDM,P.LWMC,P.SHZT FROM xsjbxx S,tdxlss P WHERE S.XH = P.XH AND substring(P.SHZT,3,1)='" + make + "' "

+ "UNION select S.XH,S.XM,S.ZYDM,P.LWMC,P.SHZT FROM xsjbxx S,xlbs P WHERE S.XH = P.XH AND substring(P.SHZT,3,1)='" + make + "' "

+ "UNION select S.XH,S.XM,S.ZYDM,P.LWMC,P.SHZT FROM xsjbxx S,bs P WHERE S.XH = P.XH AND substring(P.SHZT,3,1)='" + make + "' "

+ "UNION select S.XH,S.XM,S.ZYDM,P.LWMC,P.SHZT FROM xsjbxx S,ss P WHERE S.XH = P.XH AND substring(P.SHZT,3,1)='" + make + "' ";

}

rs = sql.executeQuery(sqlString); //读取学生基本信息

Xueyuan != null时候，第一个if也没有执行，sqlString也得不到值，只能执行第二个if()语句，各位高手，指点迷津啊！谢谢啦！

我忘了说，Xueyuan和Xuexiao是上一个页面提交来的两个值，其中必有一个是空值，另一个有值，我用javascript限定了哦

各位谢谢啊！我的问题已经解决了！

展开