Servlet登录界面增加了新增和删除功能

一.删除

新建了几个JAVA文件 deleteServlet addservlet findservlet 还有jsp文件adduser

deleteservlet中代码

public class DeleteServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        String id1=req.getParameter("id");
        int id2=Integer.parseInt(id1);
        IUserService userService=new UserServiceImpl();
        userService.delete(id2);

        req.getRequestDispatcher("/find").forward(req, resp);
    }
}

web中添加以下代码

<servlet>
        <servlet-name>DeleteServlet</servlet-name>
        <servlet-class>com.zhongruan.servlet.DeleteServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>DeleteServlet</servlet-name>
        <url-pattern>/delete</url-pattern>
    </servlet-mapping>

IcosumerDao中添加以下代码

void delete(int id);

再在CousumerDaoImpl中添加以下代码

public void delete(int id) {
        Connection connection=null;
        PreparedStatement statement=null;
        try{
            connection=DBUtil.getConnection();
            statement=connection.prepareStatement("delete from consumer where id=?");
            statement.setInt(1,id);
            statement.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            DBUtil.closeAll(null,statement,connection);