81,091
社区成员
发帖
与我相关
我的任务
分享
public ArrayList<Experiment> getAdminExperiment()throws Exception
{
return experimentDaoImpl.getAdminExperiment();
}
public ArrayList<Experiment> getAdminExperiment() throws Exception{
ArrayList<Experiment> result=new ArrayList<Experiment>();
Connection conn=null;
PreparedStatement stmt=null;
ResultSet rs=null;
try{
conn=DBConn.getCon();
String sql="select * from experiment where status = ?";
stmt=conn.prepareStatement(sql);
stmt.setInt(1, 0);
while(rs.next()){
//查询结果转化为Experiment对象
Experiment experiment=new Experiment();
experiment.setId(rs.getInt("id"));
experiment.setAim(rs.getString("aim"));
experiment.setDescribe(rs.getString("describes"));
experiment.setComments(rs.getString("comments"));
experiment.setName(rs.getString("name"));
experiment.setStatus(rs.getInt("status"));
experiment.setInitiatedId(rs.getInt("initiatedId"));
result.add(experiment);
}
//取得初始状态的实验列表
}catch(SQLException sqle){
throw new SQLException("select data exception:"+
sqle.getMessage());
}catch(Exception e){
}
return result;
}