用java代码里检测mysql正常_java使用jdbc连接mysql数据库，使用java代码测试时正常，但当通过web调用时，出现异常，求大神帮忙。...

publicclassProductDao{//获得所有的商品信息publicArrayListgetAllProducts(){Connectionconnection=null;PreparedStatementpreparedStatement=null;ResultSetresultSet=nu...

public class ProductDao {

//获得所有的商品信息

public ArrayList getAllProducts(){

Connection connection = null;

PreparedStatement preparedStatement = null;

ResultSet resultSet = null;

ArrayList products = null;

try {

connection = DBHelper.getConnection();

String sql = "select * from items;";

preparedStatement = connection.prepareStatement(sql);

resultSet = preparedStatement.executeQuery();

products = new ArrayList<>();

while (resultSet.next()) {

//省略

}

} catch (SQLException e) {

e.printStackTrace();

} finally {

//省略

}

return products;

}

public static void main(String[] args) {

ProductDao productDao = new ProductDao();

ArrayList allProducts = productDao.getAllProducts();

int size = allProducts.size();

for (int i = 0; i < size; i++) {

Product product = allProducts.get(i);

System.out.println(product.getName());

}

}

}

这是没问题的。

Title

ProductDao productDao = new ProductDao();

ArrayList products = productDao.getAllProducts();

int i;

if (products == null) {

out.print("null");

}

int size = products.size();

%>

此时出错，错误为

org.apache.jasper.JasperException: An exception occurred processing JSP page /detail.jsp at line 24

21: if (products == null) {

22: out.print("null");

23: }

24: int size = products.size();

25: %>

26: