使用Maven实现添加客户信息

最新推荐文章于 2022-04-19 11:22:17 发布

Theearlybirdcatchw

最新推荐文章于 2022-04-19 11:22:17 发布

阅读量252

点赞数 1

文章标签： java 后端 servlet jsp tomcat

本文链接：https://blog.csdn.net/theearlybirdcatchw/article/details/115145162

版权

本文档详细介绍了如何在Idea中利用Maven构建项目，包括CustomerDao、CustomerService、addCustomerServlet等关键组件，配合DruidUtils进行数据库操作，通过jsp页面实现客户信息的输入和展示，最终将数据成功写入数据库并跳转至success.jsp的流程。

摘要由CSDN通过智能技术生成

整体结构

在这里插入图片描述

-Idea代码放置位置

在这里插入图片描述

CustomerDao

 - package com.itheima.dao;

import com.itheima.pojo.Customer;
import com.itheima.utils.DruidUtils;
import org.apache.commons.dbutils.QueryRunner;

import java.sql.SQLException;

public class CustomerDao {
   
    QueryRunner qr = new QueryRunner(DruidUtils.getDataSource());
    public void addCustomer(Customer customer) throws SQLException {
   
        String sql = "insert into customer values(?,?,?,?,?,?)";
        Object[] pamars = {
   customer.getId(),customer.getName(),customer.getSource(),customer.getLevel()
                            ,customer.getIndustry(),customer.getPhone()};
        qr.update(sql,pamars);
    }

}

CustomerService

package com.itheima.service;

import com.itheima.dao.CustomerDao;
import com.itheima.pojo.Customer;

import java.sql.SQLException;

public class CustomerService {
   
    CustomerDao dao = new CustomerDao();
    public boolean addCustomer(Customer customer){
   
        try {
   
            dao.addCustomer(customer);
            return true;
        } catch (SQLException e) {
   
            e.printStackTrace();
        }
        return false;
    }
}

addCustomerServlet

package com.itheima.web;

import com.itheima.pojo.Customer;
import com.itheima.service.CustomerService;
import org.apache.commons.beanutils.BeanUtils;

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.lang.reflect.InvocationTargetException;
import java.util.Map;
import java.util.UUID;

@WebServlet("/add")
public class AddCustomerServlet extends HttpServlet {
   
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
   
        request.setCharacterEncoding("utf-8");
        Customer customer = new Customer();
        Map<String, String[]> map = request.