Hibernate的增删改查

一、搭建Hibernate开发环境，这里就不说了，直接说环境搭好后的事情。

 

二、项目的目录结构

三、base_image.hbm.xml配置文件内容

　　

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC 
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
    <class name="cn.itheima.domain.Image" table="base_image">
        <id name="id" column="IMAGE_ID">
<!--             <generator class="native"></generator> -->
        </id>
        <property name="number" column="AD_NUMBER" type="java.lang.String" />
        <property name="ad_name" column="AD_NAME" type="java.lang.String" />
        <property name="desc" column="AD_DESC" type="java.lang.String" />
        <property name="image_name" column="IMAGE_NAME" type="java.lang.String" />
        <property name="url" column="IMAGE_URL" type="java.lang.String" />
    </class>

</hibernate-mapping>

 

四、Image.java中内容

　　

package cn.itheima.domain;

public class Image {
    public String id;
    public String number;
    public String desc;
    public String ad_name;
    public String image_name;

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public String getNumber() {
        return number;
    }

    public void setNumber(String number) {
        this.number = number;
    }

    public String getDesc() {
        return desc;
    }

    public void setDesc(String desc) {
        this.desc = desc;
    }

    public String getAd_name() {
        return ad_name;
    }

    public void setAd_name(String ad_name) {
        this.ad_name = ad_name;
    }

    public String getImage_name() {
        return image_name;
    }

    public void setImage_name(String image_name) {
        this.image_name = image_name;
    }

    public String getUrl() {
        return url;
    }

    public void setUrl(String url) {
        this.url = url;
    }

    public String url;

}

五、HibernateUtils.java中

　　

package cn.itheima.utils;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

public class HibernateUtils {

    private static final SessionFactory factory;
    
    //只加载一次
    static {
        Configuration config = new Configuration().configure();
        factory = config.buildSessionFactory();
    }

    public static Session getSession() {
        return factory.openSession();
    }
}

六、ImageTest中的增删改查

　　

package cn.itheima.test;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.junit.Test;

import cn.itheima.domain.Image;

public class ImageTest {
    // 添加
    @Test
    public void save() {
        // 1.得到session
        Configuration configuration = new Configuration().configure();
        SessionFactory sessionFactory = configuration.buildSessionFactory();
        Session session = sessionFactory.openSession();
        // 2.开启事务
        Transaction transaction = session.beginTransaction();
        // 3.操作
        Image book = new Image();
        book.setId("3");
        book.setAd_name("aaa");
        book.setDesc("desc");
        book.setImage_name("imagename");
        book.setNumber("number");
        book.setUrl("url");
        session.save(book);
        // 4.提交
        session.getTransaction().commit();
        session.close();
        sessionFactory.close();
    }

    // 删除 by id
    @Test
    public void delete() {
        Configuration configuration = new Configuration().configure();
        SessionFactory sessionFactory = configuration.buildSessionFactory();
        Session session = sessionFactory.openSession();
        Transaction transaction = session.beginTransaction();
        Image image = new Image();
        image.setId("1");
        session.delete(image);
        transaction.commit();
        session.close();
        sessionFactory.close();
    }

    // 修改所有  by id
    @Test
    public void update() {
        Configuration configuration = new Configuration().configure();
        SessionFactory sessionFactory = configuration.buildSessionFactory();
        Session session = sessionFactory.openSession();
        Transaction transaction = session.beginTransaction();
        Image image = new Image();
        image.setId("3");
        image.setAd_name("i");
        image.setDesc("i");
        image.setImage_name("i");
        image.setNumber("i");
        image.setUrl("i");
        session.update(image);
        transaction.commit();
        session.close();
        sessionFactory.close();
    }

    // 查询一个，根据id
    @Test
    public void select() {
        Configuration configuration = new Configuration().configure();
        SessionFactory sessionFactory = configuration.buildSessionFactory();
        Session session = sessionFactory.openSession();
        Transaction transaction = session.beginTransaction();
        Image image = (Image) session.get(Image.class, "8a8ae4fe4fa54c0e014fa6f65c3d0000");
        transaction.commit();
        System.out.println(image.getAd_name());
        session.close();
        sessionFactory.close();
    }

    // 查询所有by sql;
    @Test
    public void SelectAllbySql() {
        Configuration congConfiguration = new Configuration().configure();
        SessionFactory sesseionFactory = congConfiguration
                .buildSessionFactory();
        Session session = sesseionFactory.openSession();
        Transaction transaction = session.beginTransaction();
        String sql = "select * from base_image";
        SQLQuery sqlQuery = session.createSQLQuery(sql);//注意SQLQuery
        sqlQuery.addEntity(Image.class);//指定查询类型为Image
        List<Image> list = sqlQuery.list();
        System.out.println(list.get(0).getAd_name());
        session.close();
        sesseionFactory.close();
    }

    // 查询所有 hql
    @Test
    public void SelectAllByHql() {
        Configuration configuration = new Configuration().configure();
        SessionFactory sessionFactory = configuration.buildSessionFactory();
        Session session = sessionFactory.openSession();
        Transaction transaction = session.beginTransaction();
        String hql = "from Image";// 根据Image类查询
        Query query = session.createQuery(hql);
        List<Image> list = query.list();
        System.out.println(list.get(0).getAd_name());
        session.close();
        sessionFactory.close();
    }

    // 查询所有qbc
    @Test
    public void selectAllByQbc() {
        Configuration configuration = new Configuration().configure();
        SessionFactory sessionFactory = configuration.buildSessionFactory();
        Session session = sessionFactory.openSession();
        Transaction transaction = session.beginTransaction();
            //QBC
        Criteria criteria = session.createCriteria(Image.class);
        List<Image> list = criteria.list();
        
        session.close();
        sessionFactory.close();
    }
}