5.11作业

查询页面

添加页面



    
    


    数据库查询操作：
    

        
商品编号：
        
商品名称：
        
单价：
        
商品描述：
        
    







添加商品
package com.qiku.web;

import com.qiku.dao.ProductDao;
import com.qiku.entity.Product;

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;
import java.io.PrintWriter;
import java.sql.SQLException;
@WebServlet(name="addproduct",urlPatterns = "/add")
public class Add extends HttpServlet {
   private ProductDao productDao = new ProductDao();

    @Override
    protected void doGet (HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        try {
            Product product = new Product();
            product.setPid("32");
            product.setPname("大概是");
            product.setPrice(22.2);
            product.setPdesc("阿萨德个风格");
            int add = productDao.add(product);
            if(add>0){
                System.out.println("添加商品成功");
            }else{
                System.out.println("添加失败");
            }

        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

添加商品dao层

/    添加商品
    public int add(Product product) throws SQLException {
        QueryRunner qr=new QueryRunner(DruidUtils.dataSource);
        String sql="insert into product (pid,pname,price,pdesc)values(?,?,?,?)";
        int update= qr.update(sql,product.getPid(),product.getPname(),product.getPrice(),product.getPdesc());
        return update;
    }

 查询商品dao层

package com.qiku.web;

import com.qiku.dao.ProductDao;
import com.qiku.entity.Product;

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;
import java.io.PrintWriter;
import java.sql.SQLException;
import java.util.List;

@WebServlet(name="findAllProductServlet",urlPatterns = "/findAllProduct")
public class FindAllProductServlet extends HttpServlet {
    //由于我们需要访问ProductDao中的方法，所有将其作为成员变量
    private ProductDao productDao = new ProductDao();

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        try {
            //执行查询所有商品的操作
            List allProduct = productDao.findAllProduct();
            //将allProduct 写出到页面上
            resp.setContentType("text/html;charset=utf-8");
            PrintWriter writer = resp.getWriter();
            for (Product p : allProduct) {
                writer.println(
                        "" + p.getPname() + "t" + p.getPrice() + "t" + p.getPdesc() + "");
            }
            writer.println("");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}