搞了一个javaweb,读mysql数据库,就出现了这个bug,急qaq
javax.el.PropertyNotFoundException: No public static field named [productName] was found on class [jspservlet.product.product]
//连接数据库代码
package jspservlet.dao.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import jspservlet.dao.productdetailsDAO;
import jspservlet.db.DBConnect;
import jspservlet.product.product;
public class productdetailsDAOImpl implements productdetailsDAO {
public ArrayList<product> Viewproductinformation(String s) throws Exception{
ArrayList<product> pd = new ArrayList<product>();
String sql = "SELECT * FROM productinfo WHERE productID=?";
PreparedStatement pstmt = null ;
int j = Integer.parseInt(s);
DBConnect dbc = null;
System.out.println(s+"productdetailsDAO");
try{
dbc = new DBConnect() ;
pstmt = dbc.getConnection().prepareStatement(sql) ;
pstmt.setInt(1,j);
ResultSet rs = pstmt.executeQuery();
while(rs.next()) {
product product1 = new product();
product1.setproductName(rs.getString("productName"));
product1.setproductID(rs.getString("productID"));
product1.setprice(rs.getString("price"));
product1.setremaining(rs.getString("remaining"));
product1.setimage(rs.getString("SRC"));
product1.setclassification(rs.getString("classification"));
product1.setsuitfor(rs.getString("suitfor"));
product1.setmoredetails(rs.getString("moredetails"));
pd.add(product1);
}
System.out.println(pd);
rs.close();
pstmt.close();
}catch(SQLException e) {
System.out.println(e.getMessage());
}finally {
dbc.close();
}
return pd;
}
操作jsp代码(jspservlet)
package jspservlet.servlet;
import java.io.IOException;
import java.util.ArrayList;
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.productdetailsDAO;
import jspservlet.dao.impl.productdetailsDAOImpl;
import jspservlet.product.product;
public class productdetails extends HttpServlet {
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws IOException, ServletException{
this.doPost(req, res);
}
public void doPost(HttpServletRequest req, HttpServletResponse res)
throws IOException, ServletException{
System.out.println("aaaa");
product product = new product();
String s = req.getParameter("productID");
productdetailsDAO dao = new productdetailsDAOImpl();
System.out.println(s);
try {
ArrayList<product> pd = dao.Viewproductinformation(s);
HttpSession session = req.getSession();
session.setAttribute("pd", pd);
System.out.println(pd);
res.sendRedirect("./productdetails.jsp");
}catch(Exception e) {
e.printStackTrace();
}
}
}
```html代码
<%@ page language="java" import="java.util.*" import="jspservlet.dao.impl.productdetailsDAOImpl" import="jspservlet.servlet.productdetails" import="jspservlet.dao.productdetailsDAO" import="jspservlet.product.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 'productdetails.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>
<%List product = (List)session.getAttribute("pd"); %>
<c:forEach items="${pd}" var="product">
<p>"${product.productName}"</p>
${product.productID}<br/>
${product.price}<br/>
${product.remaining}<br/>
${product.images}<br/>
${product.classification}<br/>
${product.suitfor}<br/>
${product.moredetails}<br/>
</c:forEach>
</body>
</html>