public String getIds(long contractId){
StringBuilder sb=new StringBuilder();
sb.append("select engineering.project_contract.id from engineering.project_contract ");
sb.append("where main_contract_id=").append(contractId);
System.out.println(sb.toString());
ResultSet rs=qr.query(sb.toString());
String ids="";
try {
while(rs.next()){
System.out.println("77777");
if(ids==""){
ids+=String.valueOf(rs.getInt(1));
}else{
ids+=","+String.valueOf(rs.getInt(1));
}
}
} catch (SQLException e) {
e.printStackTrace();
}
System.out.println(ids);
return ids;
}根据输出的语句(select engineering.project_contract.id from engineering.project_contract where main_contract_id=169)我放入数据库查询会得到结果,可是,ids始终得不到值(主要是while(rs.next())它都不执行的,77777是不会输出的)求解答
StringBuilder sb=new StringBuilder();
sb.append("select engineering.project_contract.id from engineering.project_contract ");
sb.append("where main_contract_id=").append(contractId);
System.out.println(sb.toString());
ResultSet rs=qr.query(sb.toString());
String ids="";
try {
while(rs.next()){
System.out.println("77777");
if(ids==""){
ids+=String.valueOf(rs.getInt(1));
}else{
ids+=","+String.valueOf(rs.getInt(1));
}
}
} catch (SQLException e) {
e.printStackTrace();
}
System.out.println(ids);
return ids;
}根据输出的语句(select engineering.project_contract.id from engineering.project_contract where main_contract_id=169)我放入数据库查询会得到结果,可是,ids始终得不到值(主要是while(rs.next())它都不执行的,77777是不会输出的)求解答
解决方案 »
- struts2中的多个action可以写到一个类吗?
- 客户端调用webservice报错
- 求请教:根据引用站内图片得到引用页面地址
- HibernateException: Hibernate Dialect must be explicitly set
- Myeclipse+tomcat开发JSP网站时遇到的问题,在线等待
- 十万火急,websphere6上传文件大小有限制吗?
- RIA主流技术——Flex 3.0技术概述
- Spring配置文件fetch_size、batch_size时出现的断言运行时异常,请高手帮忙!
- 请问hibernate中的两种实体类映射
- 在windows xp 下配置tomcat 5.0 和apache 2.0 的问题
- Struts1中,我想去数组中的值,类似这样的
- C客户端调用java webservice
今天离职,弄完这个就走人了呢