Collection c = new ArrayList();
c.add("abc");
c.add("xyz");
for(Iterator it = c.iterator(); it.hasNext(); ) {
String s = (String)it.next();
System.out.println(s); }
++++++++++++++++++++++++++++返回集保存到Bean,以List形式返回+++++++++++++++++++++
String sql = "SELECT NO,NAME FROM TABLE_NAME WHERE NO = ? AND NAME = ?";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, No);
ps.setString(2, Name);
ResultSet rs = ps.executeQuery();
List list = new LinkedList();
while (rs.next()) {
no = rs.getString("NO").trim();
name = rs.getString("NAME").trim();
Bean personBean = new PersonBean();
personBean.setNo(no);
personBean.setName(name);
list.add(personBean);
}
return list;
}
c.add("abc");
c.add("xyz");
for(Iterator it = c.iterator(); it.hasNext(); ) {
String s = (String)it.next();
System.out.println(s); }
++++++++++++++++++++++++++++返回集保存到Bean,以List形式返回+++++++++++++++++++++
String sql = "SELECT NO,NAME FROM TABLE_NAME WHERE NO = ? AND NAME = ?";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, No);
ps.setString(2, Name);
ResultSet rs = ps.executeQuery();
List list = new LinkedList();
while (rs.next()) {
no = rs.getString("NO").trim();
name = rs.getString("NAME").trim();
Bean personBean = new PersonBean();
personBean.setNo(no);
personBean.setName(name);
list.add(personBean);
}
return list;
}