jsp显示商品列表源码+数据库脚本，适合新手

将数据库中的内容展示到就浏览器页面

package dao;

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

import entity.Items;
import util.DBUtil;

public class ItemsDao {
	//获取所有的商品信息
	public ArrayList getAllItems（）{
		ArrayList result=new ArrayList（）;
		Connection conn=DBUtil.getConnection（）;
	
		String sql=“select *from items ;“;
		try {
			PreparedStatement ptmt=conn.prepareStatement（sql）;
			ResultSet rs=ptmt.executeQuery（）;
			while（rs.next（））{
				Items item=new Items（）;
				item.setId（rs.getInt（“id“））;
				item.setName（rs.getString（“name“））;
				item.setCity（rs.getString（“city“））;
				item.setNumber（rs.getInt（“number“））;
				item.setPrice（rs.getInt（“price“））;
				item.setPicture（rs.getStri

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2020-05-19 10:28  0\
     文件         362  2020-05-19 10:05  0\.classpath
     目录           0  2020-05-19 10:05  0\.myeclipse\
     文件         303  2020-05-19 10:05  0\.mymetadata
     文件        1620  2020-05-19 10:05  0\.project
     目录           0  2020-05-19 10:28  0\.settings\
     文件         613  2020-05-19 10:05  0\.settings\.jsdtscope
     文件         395  2020-05-19 10:05  0\.settings\org.eclipse.jdt.core.prefs
     文件         465  2017-11-13 17:35  0\.settings\org.eclipse.wst.common.component
     文件         339  2017-11-13 17:35  0\.settings\org.eclipse.wst.common.project.facet.core.xml
     文件          49  2020-05-19 10:05  0\.settings\org.eclipse.wst.jsdt.ui.superType.container
     文件           6  2020-05-19 10:05  0\.settings\org.eclipse.wst.jsdt.ui.superType.name
     目录           0  2020-05-19 10:28  0\build\
     目录           0  2020-05-19 10:28  0\build\classes\
     目录           0  2020-05-19 10:28  0\build\classes\dao\
     文件        3085  2017-11-13 17:35  0\build\classes\dao\ItemsDao.class
     目录           0  2020-05-19 10:28  0\build\classes\entity\
     文件        1443  2017-11-13 17:35  0\build\classes\entity\Items.class
     目录           0  2020-05-19 10:28  0\build\classes\util\
     文件        1726  2017-11-13 17:35  0\build\classes\util\DBUtil.class
     文件       35147  2017-11-13 17:35  0\LICENSE
     目录           0  2020-05-19 10:28  0\src\
     目录           0  2020-05-19 10:28  0\src\dao\
     文件        2060  2020-05-19 10:10  0\src\dao\ItemsDao.java
     目录           0  2020-05-19 10:28  0\src\entity\
     文件         851  2017-11-13 17:35  0\src\entity\Items.java
     目录           0  2020-05-19 10:28  0\src\util\
     文件        1036  2020-05-19 10:07  0\src\util\DBUtil.java
     目录           0  2020-05-19 10:28  0\WebRoot\
     文件        4398  2020-05-19 10:26  0\WebRoot\detail.jsp
     目录           0  2020-05-19 10:28  0\WebRoot\images\
............此处省略26个文件信息