                        课程
                    
                        /后端开发
                        
                            /Java
                        
                        /JAVA遇见HTML——JSP篇

界面无法读取数据库并显示，数据库配置没问题，测试过，可以正常查询

package dao;

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

import util.DBUtils;

import entity.Items;

public class DBItems {
public ArrayList<Items> getAllItems(){
Connection conn = null ;
PreparedStatement pst = null ;
ResultSet rs = null ;
ArrayList<Items> itemList = new ArrayList<Items>();

try {
conn=DBUtils.getConnection();
String sql = "select * from items";
pst = conn.prepareStatement(sql);
rs=pst.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.getString("picture"));
itemList.add(item);
}
return itemList;
} catch(Exception ex)
{
ex.printStackTrace();
return null;
}
/*
* 释放资源
* */
finally{
if (pst!=null) {
try {
pst.close();
pst=null;
}catch(Exception ex)
{
ex.printStackTrace();
}

}
if (rs!=null) {
try {
rs.close();
rs=null;
} catch(Exception ex)
{
ex.printStackTrace();
}

}
}

}

}