public ArrayList<Yqjkxx> getNewsResources() {
DBConn db = new DBConn();
Statement st = null;
ResultSet rs = null;
Connection con = null;
ArrayList<Yqjkxx> al = new ArrayList<Yqjkxx>();
con = db.getConn();
String sql = "select * from yqjk_task";
try {
st = con.createStatement();
rs = (ResultSet) st.executeQuery(sql);
while (rs.next()) {
Yqjkxx yqjkxx = new Yqjkxx();
yqjkxx.setRoleId(rs.getInt(1));
yqjkxx.setRoleName(rs.getString(2));
yqjkxx.setNewsResource(rs.getString(3));
yqjkxx.setFindStyle(rs.getString(4));
yqjkxx.setCollectDate(rs.getString(5));
yqjkxx.setCollectCondition(rs.getString(6));
yqjkxx.setContentMate(rs.getString(7));
yqjkxx.setSite_collection(rs.getString(8));
yqjkxx.setRoleState(rs.getString(9));
al.add(yqjkxx);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
db.close();
}
return al;
}
