代码如下!! public ArrayList selectCourseBean(String userdep) //查询
{
ArrayList list = new ArrayList();
// if (!checkParameter(userdep))
// {
// userdep = "";
// }
try
{
String sql = "select * from CHOOSECOURSE";
prepar = conn.prepareStatement(sql);
res = prepar.executeQuery(); //接收存储过程的结果集
while (res.next()) //提取结果集的每条记录
{
CourseInforBean cb = new CourseInforBean();
cb.setCourseID(res.getString("COURSEID"));
cb.setCourseName(res.getString("COURSENAME"));
cb.setTeacherID(res.getString("TEACHERID"));
cb.setTeacherName(res.getString("TEACHERNAME"));
cb.setCourseDepart(res.getString("DEPARTMENT"));
list.add(cb);
}
}
catch (SQLException ex)
{
ex.printStackTrace();
}
return list; }谢谢!!!
{
ArrayList list = new ArrayList();
// if (!checkParameter(userdep))
// {
// userdep = "";
// }
try
{
String sql = "select * from CHOOSECOURSE";
prepar = conn.prepareStatement(sql);
res = prepar.executeQuery(); //接收存储过程的结果集
while (res.next()) //提取结果集的每条记录
{
CourseInforBean cb = new CourseInforBean();
cb.setCourseID(res.getString("COURSEID"));
cb.setCourseName(res.getString("COURSENAME"));
cb.setTeacherID(res.getString("TEACHERID"));
cb.setTeacherName(res.getString("TEACHERNAME"));
cb.setCourseDepart(res.getString("DEPARTMENT"));
list.add(cb);
}
}
catch (SQLException ex)
{
ex.printStackTrace();
}
return list; }谢谢!!!
CourseInforBean cb = (CourseInforBean)it.next();
//Test
out.print(cb.getCourseID());
}
这样就取出来了
Channel channel = (_list.isEmpty())?null:(Channel)_list.get(i);
if ( channel == null ) continue;
exceptFlag = chnDao.updChannel( channel );
if ( !exceptFlag ) {
retList.add( "频道<b>["+channel.getChnName()+"]</b>更新失败" );
}
}