此乃本人大二精品系列,请学习的朋友们酌情使用
public ArrayList getproinfos() { } }
// TODO Auto-generated method stub
Statement stm = DBConnection.getStatement(); //链接数据库 String sql = "select * from sl_pro";//搜寻数据库里商品表的全部信息 ArrayList al = new ArrayList(); //创建一个数组 proBean pb = null; ResultSet rs = null; try { }
return al;
rs = stm.executeQuery(sql); while(rs.next()){ }
// TODO Auto-generated catch block e.printStackTrace(); try { }
rs.close(); stm.close();
// TODO Auto-generated catch block e.printStackTrace();
pb = new proBean(); //将数据放在bean里，以数组为载体进行传递 pb.setId(rs.getInt("Id"));
pb.setProname(rs.getString("pro_name")); pb.setProsize(rs.getString("pro_size")); pb.setProprice(rs.getString("pro_price")); al.add(pb);
} catch (SQLException e) {
}finally{
} catch (SQLException e) {
3．柠檬网上商城子系统展示功能功能的测试
成功显示