把商品信息部署到页面上

• 创建一个user类，写user的getset方法和toString方法

• dao包写一个Selectdao类查询商品的信息

package com.dao;

import com.bean.User;
import com.util.JDBCUtil;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class Selectdao {
    private Connection con = null;
    private PreparedStatement ps=null;
    private ResultSet rs=null;
    public User doselect(String username, String password) throws SQLException {
        User user = null;
        //加载驱动
        con= JDBCUtil.getCon();
        //创建sql语句
        String sql = "select * from t_user where username=? and  password=?";
        //获取sql语句
        PreparedStatement ps = con.prepareStatement(sql);
        ps.setObject(1, username);
        ps.setObject(2, password);
        //生成一个结果集
        ResultSet rs = ps.executeQuery();
        //进行下一步操作
        while (rs.next()) {
            //根据字段名称获取表中的数据
            int uid = rs.getInt("uid");
            String username1 = rs.getString("username");
            String password1 = rs.getString("password");
            String phone = rs.getString("phone");
            String address = rs.getString("address");
            //把以上数据封装到User对象中
            user = new User();
            //一行数据就封装成了一个Student对象
            user.setUid(uid);
            user.setUsername(username1);
            user.setPassword(password1);
            user.setAddress(address);
            user.setPhone(phone);
        }
        //关闭数据
        JDBCUtil.close(rs,ps,con);
        return user;
    }
}

• 在login主页面跳转时请求转发（登录业务已经处理完毕，应该做请求转发，让别的servlet执行商品信息的查询）

• 创建一个SelectAllGoods类，写查询商品信息请求的servlet代码

package com.servlet;

import com.bean.Goods;
import com.dao.Goodsdao;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
import java.sql.SQLException;
import java.util.List;

@WebServlet("/SelectAllGoods")
public class SelectAllGoods extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doPost(req, resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        //1.设置请求代码的格式
        req.setCharacterEncoding("utf-8");//设置请求代码为中文
        resp.setCharacterEncoding("utf-8");//设置响应的代码为中文

        System.out.println("SelectAllGoods.....dopost");
        //去查询数据库中商品信息表中的数据
        Goodsdao goodsDao=new Goodsdao();
        try {
            List<Goods> goosList = goodsDao.selectAll();
            System.out.println(goosList);
            HttpSession session=req.getSession();//获取HttpSession对象
            //把查询到商品信息集合储存到session对象中，起名为goodsList
            session.setAttribute("goodsList",goosList);
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }

        resp.sendRedirect("zhuye.jsp");


    }
}

• 页面主页部署

• 运行页面展示

• 简化代码

在页面导入jstl的核心类库

优化代码