jsp+servlet+mysql

lookProduct.jsp: 运行无法查看mysql表

<%@page import="javax.servlet.http.HttpServletRequest"%>
<%@page import="productManager.LookProductBean" %>
<%@page import="loginRegister.LoginBean"%>
<%@page import="java.util.ArrayList"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>亲子游戏系统--活动浏览页面title>
    head>
   
    <body style="background: url(../images/bbv.png) ; background-size:100% 100% ; background-attachment: fixed">
    <div align="center">
        <Font color=red><H3>“有趣好玩，梦想乐园”亲子活动平台 H3>Font>
        <table  cellSpacing="1" cellPadding="1" width="660" align="center" border="0" style=" color:#CC3300">
            <tr valign="bottom">
                <td><A href="../main/index.jsp">主页A>td>
                <td>浏览亲子活动td>
                <td><A href="../product/searchProduct.jsp">查询亲子活动A>td>
                <td><A href="lookShoppingCar.jsp">查看购物车A>td>
                <td><A href="lookOrderForm.jsp">查看订单A>td>
                <td>td><td>td><td>td><td>td><td>td><td>td><td>td><td>td><td>td><td>td>
                <td>欢迎，小可爱登录系统td>
                <td><A href="../login/login.jsp">退出A>td>
            tr>
        table>   
        <hr>
    div>
    <br><br>
        <table border="2" cellspacing="0"cellpadding="0" width="60%"align="center">
            <tr>
                <th height="30">编号th>
                <th height="30">活动名称th>
                <th height="30">活动地址th>
                <th height="30">商家电话th>
                <th height="30">商家th>
                <th height="30">活动时间th>
                <th height="30">价格/人th>
            tr>
            <%
                ArrayList productlist=(ArrayList)session.getAttribute("productlist");
                if(productlist==null||productlist.size()==0){
            %>
            <div align="center">
               <h1>目前没有活动！h1>
            div>
            <%
                }else{
                    for(int i=productlist.size()-1;i>=0;i--){
                        LookProductBean pp=(LookProductBean)productlist.get(i);

            %>
            <tr>
                <td><%=pp.getId()%>td>
                <td><%=pp.getName()%>td>
                <td><%=pp.getAddress()%>td>
                <td><%=pp.getPhone()%>td>
                <td><%=pp.getBusiness()%>td>
                <td><%=pp.getBegintime()%>td>
                <td><%=pp.getPrice()%>td>
            tr>
            <%
                  }
                }
            %>
        table>
    body>
html>

LookProductServlet.java 运行这个会出现mysql表格

package productManager;
import java.io.IOException;
import java.sql.*;
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.*;
import loginRegister.LoginBean;
/**
 *
 * @author Administrator
 */
public class LookProductServlet extends HttpServlet {
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        try{
                Connection con=null;
                Statement stmt=null;
                ResultSet rs=null;
                Class.forName("com.mysql.jdbc.Driver"); 
                String url="jdbc:mysql://localhost:3306/family?useUnicode=true&characterEncoding=gbk";
                con=DriverManager.getConnection(url,"root","1234");
                stmt=con.createStatement(); 
                HttpSession session=request.getSession();
                String sql="select * from product"; 
                rs=stmt.executeQuery(sql);
                ArrayList productlist=new ArrayList();
                    while(rs.next()){
                        LookProductBean pp=new LookProductBean();
                        pp.setId(rs.getString("id"));
                        pp.setName(rs.getString("name"));
                        pp.setAddress(rs.getString("address"));
                        pp.setPhone(rs.getString("phone"));
                        pp.setBusiness(rs.getString("business"));
                        pp.setBegintime(rs.getString("begintime"));
                        pp.setPrice(rs.getString("price"));
                        productlist.add(pp);
                        session.setAttribute("productlist", productlist);
                    }
                    rs.close();
                    stmt.close();
                    con.close();
                    response.sendRedirect("http://localhost:8080/familys/product/lookProduct.jsp");
            }catch(Exception e){
                e.printStackTrace();
            }
    } 


    protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        doGet(request, response);
    }

}

所以问题出在哪，怎么让jsp页面页出现表格

有报错信息吗

你可以看下这个问题的回答https://ask.csdn.net/questions/374955
这篇博客也不错, 你可以看下jsp+servlet+javabean+mysql实现分页。
除此之外, 这篇博客: jsp+servlet+mysql实现分页处理中的 引用分页的jsp 部分也许能够解决你的问题, 你可以仔细阅读以下内容或跳转源博客中阅读:

		   <jsp:include page="/WEB-INF/jsp/pagination.jsp">
                            <jsp:param name="url" value="${pageContext.request.contextPath}/admin/HandleFind?oper=load" />
                            <jsp:param name="curPage" value="${paging.curPage }"/>
                            <jsp:param name="pageSize" value="${paging.pageSize }" />
                            <jsp:param name="total" value="${paging.total }" />
                            <jsp:param name="totalPage" value="${paging.totalPage}"/> 
                        </jsp:include>