Java查询数据全部列表

public class TbItemsService {

    //查询数据列表
    public List<TbItems> findTbItemsListAll(){
        //使用JDBC架构查询数据
        Connection connection = null;
        PreparedStatement preparedStatement = null;
        ResultSet resultSet = null;
        List<TbItems> list = new ArrayList<>();
        try{
            //查询数据
            connection = JDBCUtils.getConnection();
            preparedStatement = connection.prepareStatement("SELECT * FROM tb_items");
            //执行查询 execute  增删改
            //preparedStatement.execute();
            //Query执行查询
            resultSet = preparedStatement.executeQuery();
            //往下读一行
            while (resultSet.next()){
                TbItems tbItems = new TbItems();
                tbItems.setId(resultSet.getInt("id"));
                tbItems.setItemName(resultSet.getString("item_name"));
                tbItems.setMemberPrice(resultSet.getDouble("member_price"));
                tbItems.setUnitPrice(resultSet.getDouble("unit_price"));
                list.add(tbItems);
            }
        }catch (Exception e){
            e.printStackTrace();
        }finally {
            //关闭资源
            JDBCUtils.close(connection,preparedStatement,resultSet);
        }
        return list;
    }
    }