网页对数据库进行添加操作

最新推荐文章于 2023-09-11 12:00:56 发布

动感超人emmm

最新推荐文章于 2023-09-11 12:00:56 发布

阅读量439

点赞数

文章标签：数据库 java database

本文链接：https://blog.csdn.net/m0_60265664/article/details/121759794

版权

只具有参考价值，应该不是很正确

servlet

package com.cqy.servlet;

import com.cqy.dao.EmployeeDao;
import com.cqy.entity.Employee;

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.sql.Date;
import java.util.List;

@WebServlet(urlPatterns = "/addEmpServlet")
public class addEmpServlet extends HttpServlet {

    EmployeeDao employeeDao=new EmployeeDao();

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        resp.setContentType("test/html");
        resp.setCharacterEncoding("UTF-8");

        Employee employee=new Employee(null,req.getParameter("name"),req.getParameter("sex"),
                Date.valueOf(req.getParameter("birthday")),req.getParameter("phone"),Integer.parseInt(req.getParameter("salary")),req.getParameter("job"));


        boolean save = employeeDao.saveEmployee(employee);

        List<Employee> list =employeeDao.findAll();
        req.setAttribute("emps",list);
        req.getRequestDispatcher("/list.jsp").forward(req,resp);

    }
}

<form action="addEmpServlet" method="get">
    <p>姓名<input type="text" name="name"></p>
    <p>性别
        <input type="radio" name="sex" value="男" checked="checked">男
        <input type="radio" name="sex" value="女">女
    </p>
    <p>生日<input type="date" name="birthday"></p>
    <p>电话<input type="number" name="phone"></p>
    <p>
        工资<input type="number" name="salary">
    </p>
    <p>工作<input type="text" name="job"></p>
    <p><input type="submit" value="添加员工"></p>
</form>