Question

用jsp连接数据库出现了对于PreparedStatement 或 CallableStatement，方法 executeQuery()不能带有参数。

这是出现queryBySql的地方
String sql = "select * from authors "; return queryBySql(sql, new AuthorRowMapper());
List<AuthorModel> models = queryBySql(sql, new AuthorRowMapper());
public List queryBySql(String sql,IRowMapper mapper){ Connection coon = null; Statement stmt = null; ResultSet rs = null; List retList = new ArrayList(); try { coon = dbCoon.getConnection(); stmt = coon.prepareStatement(sql); rs = stmt.executeQuery(sql); while (rs.next()){ Object obj =mapper.mappingRow(rs); //AuthorModel model = new AuthorModel(rs.getInt("authorid"), //rs.getString("firstName"),rs.getString("lastName")); retList.add(obj); } } catch (SQLException e) { e.printStackTrace(); }finally{ dbCoon.closeResultSet(rs); dbCoon.closeStatement(stmt); dbCoon.closeConnectiion(coon); } return retList; } public List queryBySql(String sql,IParamBinding bind,IRowMapper mapper){ Connection coon = null; PreparedStatement pstmt = null; ResultSet rs = null; List retList = new ArrayList(); try { coon = dbCoon.getConnection(); pstmt = coon.prepareStatement(sql); bind.bindParam(pstmt);//参数绑定 rs = pstmt.executeQuery(); while (rs.next()){ Object obj =mapper.mappingRow(rs); //AuthorModel model = new AuthorModel(rs.getInt("authorid"), //rs.getString("firstName"),rs.getString("lastName")); retList.add(obj); } } catch (SQLException e) { e.printStackTrace(); }finally{ dbCoon.closeResultSet(rs); dbCoon.closeStatement(pstmt); dbCoon.closeConnectiion(coon); } return retList; }}

Answer 1

这段代码应该是好的。

那些mapper的类，是如何的