根据这个字段orgName来进行模糊查询, 但不知道如何将这条sql语句连接起来,是用这个spend吧,具体不知道怎么用,如何将这条语句拼接起来?先谢谢各位朋友了!
String orgName_d = "";//列表显示、模糊查询
String sql = "select distinct a.id,a.adrName,a.orgName,a.degree,a.result,"
+ "a.happendate,a.signOfReporter,a.reportdate,a.sufferName,a.opinionOfProvince, "
+ "a.provinceReceiveTime from adrReport a, adrMedDetail b where "
+ "a.id = b.reportid "if (orgName != null && !orgName.equals("")) {
orgName_d = orgName_d + " and a.orgName like '%" + orgName + "%' ";
}
String orgName_d = "";//列表显示、模糊查询
String sql = "select distinct a.id,a.adrName,a.orgName,a.degree,a.result,"
+ "a.happendate,a.signOfReporter,a.reportdate,a.sufferName,a.opinionOfProvince, "
+ "a.provinceReceiveTime from adrReport a, adrMedDetail b where "
+ "a.id = b.reportid "if (orgName != null && !orgName.equals("")) {
orgName_d = orgName_d + " and a.orgName like '%" + orgName + "%' ";
}
解决方案 »
- 求帮助:jdeveloper无法验证weblogic
- 高手请看 图片与servlet的关系。
- 菜鸟来问是学ASP.NET还是JAVA的什么spring什么的框架,~~~~~标题要长~~~~~标题要长
- 请问怎么让网页连接变得不可用(变灰),如图。
- post跨域提交问题,百分相送,谢谢大家
- JDBC2.0连接池如何在不同的程序/页面间共享?大家一起来创建一个完美的连接池解决方案。
- Ext.MessageBox
- 前端需要学习数据库吗?
- 关于RESULTSET insertRow方法????(急)!up有分,各位大大帮忙UP一下!谢谢!
- 这是用什么技术实现的啊
- list在下拉框中的问题?
- 关于Jsp页面运行的问题!!
String sql = "select distinct a.id,a.adrName,a.orgName,a.degree,a.result,"
+ "a.happendate,a.signOfReporter,a.reportdate,a.sufferName,a.opinionOfProvince, "
+ "a.provinceReceiveTime from adrReport a, adrMedDetail b where "
+ "a.id = b.reportid "if (orgName != null && !orgName.equals("")) {
sql+= " and a.orgName like '%" + orgName + "%' ";
}