81,094
社区成员
发帖
与我相关
我的任务
分享求助HTTP Status 500 - An exception occurred processing JSP page
HTTP Status 500 - An exception occurred processing JSP page /product.jsp at line 27
...全文
请发表友善的回复…
发表回复
qq_39467761 2017-07-10
- 打赏
- 举报
}
这个变量跟踪的内容是什么？[/quote]
product的id
什么都不能 2017-07-10
- 打赏
- 举报
ProductDAO dao = new ProductDAOImpl();
try {
pro = dao.getProduct(proID);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
HttpSession session=req.getSession();
session.setAttribute("product", pro);
res.sendRedirect("./product.jsp");
}
这个变量跟踪的内容是什么？
qq_39467761 2017-07-10
- 打赏
- 举报
是debugjsp还是Java呀[/quote]
java[/quote]
什么都不能 2017-07-10
- 打赏
- 举报
是debugjsp还是Java呀[/quote]
java
qq_39467761 2017-07-10
- 打赏
- 举报
是debugjsp还是Java呀
什么都不能 2017-07-10
- 打赏
- 举报
猜测pro 报了 NullPointerException，debug看是从数据库里没取到？还是session传丢了？
什么都不能 2017-07-10
- 打赏
- 举报
他用的是session scope 有问题吗?
点滴寸土 2017-07-10
- 打赏
- 举报
http://www.cnblogs.com/CodeGuy/archive/2012/02/13/2349970.html
res.sendRedirect("./product.jsp");
好好理解下这两个
武装 2017-07-10
- 打赏
- 举报
27行方法有问题
qq_32907329 2017-07-10
- 打赏
- 举报
看一下pro对象取到值了吗 是不是空的
qq_39467761 2017-07-10
- 打赏
- 举报
productDAOImpl.java
package jspservlet.dao.impl;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import jspservlet.dao.ProductDAO;
import jspservlet.db.DBConnect;
import jspservlet.vo.Product;
public class ProductDAOImpl implements ProductDAO {
public ArrayList<Product> queryByProduct() throws Exception {
ArrayList<Product> productlist= new ArrayList<Product>();
String sql = "select * from product";
PreparedStatement pstmt = null ;
DBConnect dbc = null;
// 下面是针对数据库的具体操作
try{
// 连接数据库
dbc = new DBConnect() ;
pstmt = dbc.getConnection().prepareStatement(sql) ;
// 进行数据库查询操作
ResultSet rs = pstmt.executeQuery();
while(rs.next()){
Product product = new Product();
product.setID(rs.getString("id"));
product.setLength(rs.getString("length"));
product.setHight(rs.getString("hight"));
product.setFunction(rs.getString("function"));
product.setPrice(rs.getFloat("price"));
productlist.add(product);
}
rs.close();
pstmt.close();
}catch (SQLException e){
System.out.println(e.getMessage());
}finally{
// 关闭数据库连接
dbc.close() ;
}
return productlist;
}
public Product getProduct(String id) throws Exception {
Product product = new Product();
String sql = "select * from product where id = ?";
PreparedStatement pstmt = null;
DBConnect dbc = null;
try{
dbc = new DBConnect();
pstmt = dbc.getConnection().prepareStatement(sql);
pstmt.setString(1,id);
ResultSet rs = pstmt.executeQuery();
// set all attributes of this product corresponding to the name
if(rs.next()){
product.setID(rs.getString("id"));
product.setLength(rs.getString("length"));
product.setHight(rs.getString("hight"));
product.setFunction(rs.getString("function"));
product.setPrice(rs.getFloat("price"));
}
rs.close();
pstmt.close();
}
catch(SQLException e){
System.out.println(e.getMessage());
}
finally{
dbc.close();
}
return product;
}
}
qq_39467761 2017-07-10
- 打赏
- 举报
productDAO.java
package jspservlet.dao;
import java.util.ArrayList;
import jspservlet.vo.Product;
public interface ProductDAO {
public ArrayList<Product> queryByProduct() throws Exception ;
public Product getProduct(String id) throws Exception;
}
qq_39467761 2017-07-10
- 打赏
- 举报
24:
25: <body>
26: <% Product pro = (Product)session.getAttribute("product"); %>
27: <%String id = pro.getID();
28: String hight = pro.getHight();
29: String length = pro.getLength();
30: Float price = pro.getPrice();
vswen5 2017-07-10
- 打赏
- 举报
product.jsp 27 行有问题
李德胜1995 2017-07-10
- 打赏
- 举报
An exception occurred processing JSP page /product.jsp at line 27....
jsp的27行是哪一行？把页面的异常贴出来
qq_39467761 2017-07-10
- 打赏
- 举报
productservlet.java
package jspservlet.servlet;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import jspservlet.dao.ProductDAO;
import jspservlet.dao.impl.ProductDAOImpl;
import jspservlet.vo.Product;
public class ProductServlet extends HttpServlet{
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws IOException, ServletException{
doPost(req,res);
}
public void doPost(HttpServletRequest req, HttpServletResponse res)
throws IOException, ServletException{
String proID = req.getParameter("id");
Product pro = new Product();
ProductDAO dao = new ProductDAOImpl();
try {
pro = dao.getProduct(proID);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
HttpSession session=req.getSession();
session.setAttribute("product", pro);
res.sendRedirect("./product.jsp");
}
}
qq_39467761 2017-07-10
- 打赏
- 举报
product.java
package jspservlet.vo;
public class Product {
private String id;
private String hight;;
private String length;
private String function;
private Float price;
public String getID() {
return id;
}
public void setID(String id) {
this.id = id;
}
public String getHight() {
return hight;
}
public void setHight(String hight) {
this.hight = hight;
}
public String getLength() {
return length;
}
public void setLength(String length) {
this.length = length;
}
public String getFunction() {
return function;
}
public void setFunction(String function) {
this.function = function;
}
public Float getPrice() {
return price;
}
public void setPrice(Float price) {
this.price = price;
}
}
qq_39467761 2017-07-10
- 打赏
- 举报
product.jsp
<%@ page language="java" import="java.util.*,jspservlet.vo.Product" pageEncoding="ISO-8859-1"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'product.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<% Product pro = (Product)session.getAttribute("product"); %>
<%String id = pro.getID();
String hight = pro.getHight();
String length = pro.getLength();
Float price = pro.getPrice();
String function = pro.getFunction(); %>
</body>
</html>
