页面的修改操作和模糊查询

 页面的修改操作（update t_goods set gname=?,price=?,mark=? where gid=?）

 public int update(Goods goods){
        try {
            Class.forName(driver);
            con= DriverManager.getConnection(url,user,password);
            String sql="update t_goods set gname=?,price=?,mark=? where gid=?";
            pstm=con.prepareStatement(sql);
            pstm.setObject(1,goods.getGname());
            pstm.setObject(2,goods.getPrice());
            pstm.setObject(3,goods.getMark());
            pstm.setObject(4,goods.getGid());
            row=pstm.executeUpdate();
        }catch (Exception e){
            e.printStackTrace();
        }finally {
            try {
                if (pstm != null) {
                    pstm.close();
                }
                if (con != null) {
                    con.close();
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
            return  row;
        }
    }

package com.chen.servlet;

import com.chen.bean.Goods;
import com.chen.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 java.io.IOException;

@WebServlet("/update")
public class UpdateGoods extends HttpServlet {
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);
    }
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");

        //获取表单提交的数据，封装到goods对象中
        Goods goods=new Goods();
        goods.setGid(Integer.parseInt(request.getParameter("gid")));
        goods.setGname(request.getParameter("gname"));
        goods.setPrice(Double.parseDouble(request.getParameter("price")));
        goods.setMark(request.getParameter("mark"));
        //执行JDBC操作
        GoodsDao goodsDao=new GoodsDao();
        int row=goodsDao.update(goods);

        if(row>0){
            request.getRequestDispatcher("selectAllgoods").forward(request,response);

        }else {
            request.setAttribute("error_msg","修改出现了问题");
            request.getRequestDispatcher("error.jsp").forward(request,response);
        }
    }
}

package com.chen.servlet;

import com.chen.bean.Goods;
import com.chen.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 java.io.IOException;

@WebServlet("/update")
public class UpdateGoods extends HttpServlet {
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);
    }
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");

        //获取表单提交的数据，封装到goods对象中
        Goods goods=new Goods();
        goods.setGid(Integer.parseInt(request.getParameter("gid")));
        goods.setGname(request.getParameter("gname"));
        goods.setPrice(Double.parseDouble(request.getParameter("price")));
        goods.setMark(request.getParameter("mark"));
        //执行JDBC操作
        GoodsDao goodsDao=new GoodsDao();
        int row=goodsDao.update(goods);

        if(row>0){
            request.getRequestDispatcher("selectAllgoods").forward(request,response);

        }else {
            request.setAttribute("error_msg","修改出现了问题");
            request.getRequestDispatcher("error.jsp").forward(request,response);
        }
    }
}

 

 

 模糊查询（select * from t_goods where gname like concat('%',?,'%')）

public List<Goods> seach(String keyword){
        List<Goods> goodsList=new ArrayList<>();
        try {
            Class.forName(driver);
            con= DriverManager.getConnection(url,user,password);
            String sql="select * from t_goods where gname like concat('%',?,'%')";//concat()函数表示字符串的拼接
            pstm=con.prepareStatement(sql);
            pstm.setObject(1,keyword);
            rs=pstm.executeQuery();
            while (rs.next()){
                Goods goods=new Goods();
                goods.setGid(rs.getInt("gid"));
                goods.setGname(rs.getString("gname"));
                goods.setPrice(rs.getDouble("price"));
                goods.setMark(rs.getString("mark"));
                goodsList.add(goods);
            }
        }catch (Exception e){
            e.printStackTrace();
        }finally {
            try {
                if (rs != null) {
                    rs.close();
                }
                if (pstm != null) {
                    pstm.close();
                }
                if (con != null) {
                    con.close();
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
            return  goodsList;
        }
    }

package com.chen.servlet;

import com.chen.bean.Goods;
import com.chen.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.util.List;

@WebServlet("/seach")
public class Seach extends HttpServlet {
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);
    }
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");

        String keyword=request.getParameter("keyword");
        //执行JDBC模糊查询 select * from t_goods gname like concat('%',?,'%')
        GoodsDao goodsDao=new GoodsDao();
        List<Goods> goodsList=goodsDao.seach(keyword);
        System.out.println(goodsList);
        //把模糊查询到的商品信息集合到session中
        HttpSession session=request.getSession();
        session.setAttribute("goodsList",goodsList);
        //跳转到主页进行信息展示
        response.sendRedirect("zhuye.jsp");

    }
}