Question

JSP如果调取数据库中表的数据 用的是ArrayList方法

Answer 1

给你一个参照：
public Iterator ListAddress(int m_id){
ConnectionDB gs=new ConnectionDB();
Connection con;
ArrayList<Address> arraylist = new ArrayList<Address>();
String str = "select * from address where m_id="+m_id;
try
{
con=gs.getConnection();
stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(str);
while(rs.next())
{
Address address=new Address();
address.setA_id(rs.getInt(1));
address.setM_id(rs.getInt(2));
address.setName(rs.getString(3));
address.setAddress(rs.getString(4));
address.setPostalcose(rs.getInt(5));
address.setPnumber(rs.getString(6));
arraylist.add(address);
}
rs.close();
}
catch(Exception ee)
{
ee.printStackTrace();
}
return arraylist.iterator();

}

Answer 2

jdbc