請教各位前輩高手我這個方法出現空白頁面
private void selectorder(String customer,String orderdate) throws SQLException{
String sqlstr = "select o_company,o_customers, o_date, o_product, o_unitprice , o_quantity,ROUND(o_unitprice*o_quantity) as total, o_invoicenumber from orders where o_company like ? and o_date like ?";
PreparedStatement prepareState=conn.prepareStatement(sqlstr);
prepareState.setString(1, customer);
prepareState.setString(2, orderdate);
ResultSet rs=prepareState.executeQuery();
while (rs.next())
{
total+=rs.getInt("total");
orderslist.add(new orders(rs.getString("o_customers"),rs.getString("o_date"),rs.getDouble("o_unitprice"),rs.getInt("o_quantity"),rs.getInt("total"),rs.getString("invoicenumber")));
}
}
使用debug到 prepareState.setString(1, customer); 發現
但是我其他頁面的類似的方法卻可以正常使用