使用Maven实现添加客户信息

• 整体结构

-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[