private final static String QUERYPAGE="SELECT R_ID,ROOM_ID,R_STATE,R_DATE,R_ENDDATE,R_GOODCOST,R_SERVE,R_CONTENTS,R_EMPLOYEE,OWNER_NAME,RN FROM"
+" (SELECT R_ID,ROOM_ID,R_STATE,R_DATE,R_ENDDATE,R_GOODCOST,R_SERVE,R_CONTENTS,R_EMPLOYEE,OWNER_NAME,RN FROM "
+" (SELECT o.OWNER_NAME,"
+" r.R_ID,r.ROOM_ID,r.R_STATE,r.R_DATE,r.R_ENDDATE,r.R_GOODCOST,r.R_SERVE,r.R_CONTENTS,r.R_EMPLOYEE,ROWNUM RN FROM OWNER o,REPAIR r "
+" WHERE o.ROOM_ID=r.ROOM_ID AND ? AND ?) WHERE RN>=?) WHERE RN<=?";
-----------------------
pstmt = conn.prepareStatement(QUERYPAGE);
if(r_date!=null&&!"".equals(r_date)&&r_sDate!=null&&!"".equals(r_sDate)){
pstmt.setString(1, " r.r_date between"+" to_date("+r_date+",yyyy-mm-dd)"+" and "+" to_date("+r_sDate+",yyyy-mm-dd) "); }else{
pstmt.setString(1, " 1=1");
}
if(r_state!=null&&!"".equals(r_state)){
pstmt.setString(2, " r.R_STATE LIKE "+r_state); }else{
pstmt.setString(2, " 1=1");
}
pstmt.setInt(3, start);
pstmt.setInt(4, end);
rs = pstmt.executeQuery();
为什么第一第二占位符 赋不上值呢？求解！！！谢谢
PS:去掉1,2占位符 运行正确
------解决方案--------------------
晕，不知道楼上怎么回答的，这怎么可能对，用？号就不行，除非改成拼sql的办法。
首先setString的索引是从1开始的，不是0.
当然问题不在这个，是因为？号，比如" r.R_STATE LIKE "+r_state解析完是 r.R_STATE LIKE 123
这是sql变成
WHERE o.ROOM_ID=r.ROOM_ID AND 'r.R_STATE LIKE 123'
注意，它把你传的值都作为字符串来处理了，包括你想当然的r.R_STATE字段，
它不会把它当做表的字段，而是普通的一个字符串而已。