javabean和Jsp？

时代问答问答社区

package dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import util.DBHelper;
import enity.Items;

public class ItemsDAO {
/**
   * 获得所有商品信息利用ArrayList
   * @param conn获得连接对象
   * @param stmt调用sql中数据库信息
   * @param res返回Result数据集
   * @param sql获得所有数据库信息
   * @param conn获得连接对象
   * @param list接受res的返回数据集
   *
   */
public ArrayList getAllshangping(){
Connection conn=null;//数据库连接
PreparedStatement stmt=null;//调用连接的数据库信息
ResultSet res=null;
ArrayList list=new ArrayList();
try{
conn=DBHelper.getConnection();
String sql="select * from items";
stmt=conn.prepareStatement(sql);
res=stmt.executeQuery();
/**
   * 设置商品信息
   */
while(res.next()){
Items item=new Items();
item.setId(res.getInt("id"));
item.setName(res.getString("name"));
item.setCity(res.getString("city"));
item.setNumber(res.getInt("number"));
item.setJiage(res.getInt("jiage"));
item.setPicture(res.getString("pitcture"));
list.add(item);//加入集合
}

}catch(Exception ex){

ex.printStackTrace();
return null;
}
/**
   * 释放所有资源，从小到大关闭
   * 先关闭res，在是stmt
   */
finally{
if(res!=null){
try {
res.close();
res=null;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(stmt!=null){
try {
stmt.close();
stmt=null;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
return list;

}
}
package enity;

public class Items {
/**
   * 商品实体类
   */
private int id;
private String name;
private String city;
private int jiage;
private int number;
private String picture;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getCity() {
return city;
}
public void setCity(String city) {
this.city = city;
}
public int getJiage() {
return jiage;
}
public void setJiage(int jiage) {
this.jiage = jiage;
}
public int getNumber() {
return number;
}
public void setNumber(int number) {
this.number = number;
}
public String getPicture() {
return picture;
}
public void setPicture(String picture) {
this.picture = picture;
}

My JSP 'index.jsp' starting page

div {
float: left;
margin: 10px;
}

div dd {
margin: 0px;
font-size: 10pt;
}

div dd.dd_name {
color: blue;
}

div dd.dd_city {
color: #000;
}

商品展示

<hr>