Hibernate的CRUD

将hibernate作为持久层，使用hibernate替换原先的jdbc连接数据库，执行增删改查的操作

创建UserDao接口

package dao;
 
 
 
import pojo.User;
 
 
 
import java.util.List;
 
 
 
public interface UserDao {
 
    public void insert(User u);
 
    public  void delete(int id);
 
    public List queryAll();
 
    public void update(User u);
 
}
 
实现接口内方法
 
package dao;
 
 
 
import org.hibernate.Session;
 
import org.hibernate.SessionFactory;
 
import org.hibernate.query.Query;
 
import pojo.User;
 
 
 
import java.util.List;
 
 
 
public class UserDaoImpl implements UserDao {
 
 
 
    @Override
 
    public void insert(User u){
 
        SessionFactory sf = hibernateUtil.getSessionFactory();
 
        Session session =sf.getCurrentSession();
 
        //开启事务
 
        org.hibernate.Transaction transaction = session.beginTransaction();
 
        session.save(u);
 
        transaction.commit();
 
        sf.close();
 
 
 
    }
 
 
 
    @Override
 
    public void delete(int id){
 
        SessionFactory sf = hibernateUtil.getSessionFactory();
 
        Session session =sf.getCurrentSession();
 
        //开启事务
 
        org.hibernate.Transaction transaction = session.beginTransaction();
 
        session.delete(id);
 
        transaction.commit();
 
        sf.close();
 
    }
 
 
 
    @Override
 
    public List queryAll(){
 
        SessionFactory sf = hibernateUtil.getSessionFactory();
 
        Session session =sf.getCurrentSession();
 
        //开启事务
 
        org.hibernate.Transaction transaction = session.beginTransaction();
 
        Query query = session.createQuery("from  User ");
 
        List users = query.list();
 
        transaction.commit();
 
        sf.close();
 
        return users;
 
 
 
    }
 
 
 
    @Override
 
    public void update(User u){
 
        SessionFactory sf = hibernateUtil.getSessionFactory();
 
        Session session =sf.getCurrentSession();
 
        //开启事务
 
        org.hibernate.Transaction transaction = session.beginTransaction();
 
        session.update(u);
 
        transaction.commit();
 
        sf.close();
 
 
 
    }
 
}
 
创建insert action 去调用insert方法
 
package action;
 
 
 
import dao.UserDao;
 
import dao.UserDaoImpl;
 
import pojo.User;
 
import javax.servlet.ServletException;
 
import javax.servlet.http.HttpServletRequest;
 
import javax.servlet.http.HttpServletResponse;
 
import java.io.IOException;
 
 
 
public class Insert {
 
        public void execute(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 
            User u = new User();
 
            UserDao ud = new UserDaoImpl();
 
            u.setName(request.getParameter("name"));
 
            u.setAge(Integer.parseInt(request.getParameter("age")));
 
            u.setGender(request.getParameter("gender"));
 
            try {
 
                ud.insert(u);
 
            } catch (Exception e) {
 
                // TODO Auto-generated catch block
 
                e.printStackTrace();
 
            }
 
        }
 
        
 
}
 
编写控制器center
 
package service;
 
 
 
import action.Insert;
 
import action.query;
 
 
 
import javax.servlet.ServletException;
 
import javax.servlet.http.HttpServlet;
 
import javax.servlet.http.HttpServletRequest;
 
import javax.servlet.http.HttpServletResponse;
 
import java.io.IOException;
 
 
 
public class center extends HttpServlet {
 
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
 
        String uri = req.getRequestURI();
 
        System.out.println(uri);
 
        if(uri.equals("/u/insert")){
 
            new Insert().execute(req,resp);
 
        }
 
 
 
    }
 
}
 
配置web.xml
 
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
 
         version="4.0">
 
        center
 
        service.center
 
        center
 
        /u/*

在打开的表单中填入数据

成功添加

数据库中数据如下

delete，update，query操作和insert一样