SQLServerException: 没有为参数号 1 设置值。

Question

public List getAllNotice(){
    Connection con=null;
    PreparedStatement stm=null;
    ResultSet rs=null;
    List list=new ArrayList();

    try{
        con=ConnectionManager.getConnection();
        String sql="select * from notice where ntype=?";
        stm=con.prepareStatement(sql);
        rs=stm.executeQuery();
        while(rs.next()){
            int no=rs.getInt("Nno");
            String title=rs.getString("Ntitle");
            Notice notice=new Notice(no);
            notice.setId(no);
            notice.setTitle(title);
            list.add(notice);
        }
    }catch(Exception e){
        e.printStackTrace();
    }finally{
        ConnectionManager.closeResultSet(rs);
        ConnectionManager.closeStatement(stm);
        ConnectionManager.closeConnection(con);
    }
    return list;
}

这个问题出在哪里了？

Answer 1

String sql="select * from notice where ntype=?";
stm=con.prepareStatement(sql);
stm.setInt(1, 参数); //给ntype一个参数