关于sql cannot be resolved的问题,急等!!!
我要在JSP页面中对一个数据库表进行查询操作,我在DAO中写的是:
mport java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.rzyh.qdfh.javabean.SAV_ALL;
import com.rzyh.qdfh.util.DBUtils;
public List<SAV_ALL> getSAV_ALLList(String acno,String cunm){ //查询sav_all表
DBUtils db=new DBUtils();
ResultSet rs=null;
List<SAV_ALL> list=new ArrayList<SAV_ALL>();
if(acno==null&&cunm==null){
String sql="select * from SAV_ALL";
}
else if(acno!=null&&cunm==null){
String sql="select * from SAV_ALL where SAV_ALL.ACNO="+acno;
}
else if(acno==null&&cunm!=null){
String sql="select * from SAV_ALL where SAV_ALL.CUNM="+cunm;
}
else{
String sql="select * from SAV_ALL where SAV_ALL.CUNM like'%"+cunm+"%' and SAV_ALL.ACNO="+acno;
}
// String sql = request.getParameter("sql");
try{
rs=db.executeQuery(sql);
while(rs.next()){
SAV_ALL sav_all=new SAV_ALL();
sav_all.setACNO(rs.getString("acno")==null?"":rs.getString("acno").trim());
sav_all.setRCTL(rs.getString("rctl")==null?"":rs.getString("rctl").trim());
sav_all.setCUNM(rs.getString("cunm")==null?"":rs.getString("cunm").trim());
sav_all.setACBL(rs.getFloat("acbl"));
sav_all.setRJYE(rs.getFloat("rjye"));
list.add(sav_all);
}
}catch (Exception e){
e.printStackTrace();
}finally{
db.closeConnection();
}
return list;
}
}
ACNO,CUNM是表中要根据其查询的两个字段。我在DBUtils中也定义了executeQuery(sql)方法:
public ResultSet executeQuery(String sqlStr){
try{
this.getConnection();
this.stmt=this.conn.createStatement();
rs=stmt.executeQuery(sqlStr);
}catch(SQLException e){
e.printStackTrace();
}
return this.rs;
}
现在的问题是出现了sql cannot be resolved的错误
java.lang.Error: Unresolved compilation problem:
sql cannot be resolved
com.rzyh.qdfh.dao.SAV_ALLDAO.getSAV_ALLList(SAV_ALLDAO.java:32)
com.rzyh.qdfh.servlet.SAV_ALLServlet.doPost(SAV_ALLServlet.java:88)
com.rzyh.qdfh.servlet.SAV_ALLServlet.doGet(SAV_ALLServlet.java:45)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
我不知道问题在哪,请各位高手帮忙解答,拜托说的详细点,万分感谢!!