为什么会出现"无效字符"错误!oracle
jbas 2004-12-13 04:22:42 我在sqlplus上可以执行这个语句的,结果为0,但当我有jdbc调用,写在javabean中时,出现"无效字符"错误!
public int getResponsNumberByPkey(String pkey){
int responseNumber=0;
String sql="select count(*) as num from TWORKITEMPERSON a";
sql=sql+" where a.personKey="+pkey+" and a.workstat=1 and exists(select 1 from TWORKITEM where workitemkey=a.workitemkey and state<>(select PKey from TSTATE where Label='close'));";
System.out.println(sql);
try {
java.sql.ResultSet rs=dbPoll.executeQuery(sql);
if(rs.next()){
responseNumber=rs.getInt("num");
}
} catch (SQLException e) {
System.out.println(e);
}finally{
dbPoll.close();
}
return responseNumber;
}