关于List的问题

Question

本帖最后由 erin0225 于 2011-05-07 19:51:41 编辑

Answer 1

改写了一下你的代码。
public List findExecutingSQL(String sql, Object[] sqlParams) {
        // TODO Auto-generated method stub
        //List pslist=null;
List pslist= new ArrayList();        connect myconn=new connect();
        Connection conn=myconn.getmyconnect();
        stolist tl=new stolist();
        try {
            PreparedStatement pstmt=conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
            for(int i=0;i<sqlParams.length;i++)
            {
                pstmt.setObject(i+1,sqlParams[i]);
            }
                ResultSet rs=pstmt.executeQuery();                    // pslist=tl.fetchMultiResults(rs);
//那两个方法不要，改用while循环    
             while(rs.next()){
students bean =new students();
 bean.setSclass(rs.getString("cls_name"));
      bean.setSname(rs.getString("stu_name"));
      bean.setStuid(rs.getString("stu_id"));
     bean.setSubid(rs.getString("sub_id"));
     bean.setGrade(rs.getInt("ssgrade"));
 pslist.add(bean);
}
                pstmt.close();
                conn.close();
                rs.close();
                        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        
        return pslist;
    }