比较笨的问题 本人新手 不好意思 关于jsp调用DAO层方法的
public ArrayList getFoodOrder() {
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
ArrayList orderList = new ArrayList();
String sql = "select t_order.userName '姓名'," +
"t_order.address '客户地址'," +
"t_order.telephone '客户电话', " +
"t_food.foodName '菜名'," +
"t_food.foodPrice '菜的价格(圆/份)'," +
"t_food_order.quantity '份数'," +
"t_order.orderSuggest '客户的要求'" +
"from t_food,t_order,t_food_order " +
"where t_food.foodId=" +
"t_food_order.foodId and t_food_order.orderId=t_order.orderId";
try {
conn = DButil2.getConnection();
pstmt = DButil2.getPreparedStatement(conn, sql);
rs = pstmt.executeQuery();
while(rs.next()){
orderList.add(rs.getString(1));//userName
orderList.add(rs.getString(2));//address
orderList.add(rs.getString(3));//telephone
orderList.add(rs.getString(7)); //suggest
orderList.add(rs.getString(4));//foodName
orderList.add(rs.getFloat(5));//foodPrice
System.out.println(rs.getFloat(5));
orderList.add(rs.getInt(6));//quantity
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DButil2.closeStatement(pstmt);
DButil2.closeConnection(conn);
}
return orderList;
}
着是 DAO层里面 DAOIMP的查询代码
我想在JSP中调用这个方法 达到显示数据库数据的目的
希望能有实际代码 我仔细的研究一下。。。我在网上也查了很多 都是用框架的 老师告诉我不需要框架 直接做就可以了
谢谢!