DM8达梦数据库Hibernate 框架

package com.pojo;
public class ProductCategory {
    private Long productCategoryId;
    private String name;
    public Long getProductCategoryId() {
        return productCategoryId;
    }
    public void setProductCategoryId(Long productCategoryId) {
        this.productCategoryId = productCategoryId;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    @Override
    public String toString() {
        return "ProductCategory [productCategoryId=" + productCategoryId + ", name=" + name + "]";
    }
    public ProductCategory(Long productCategoryId, String name) {
        super();
        this.productCategoryId = productCategoryId;
        this.name = name;
    }
    public ProductCategory() {
        super();
    }
 }

package com.test;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.classic.Session;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;
import com.pojo.ProductCategory;

public class TestProductCategory {
    SessionFactory sf = null;
    Session session = null;
    @Before
    public void before() {
        //(1)读取并解析hibernate.cfg.xml配置文件
        Configuration config = new Configuration().configure();
        //(2)由hibernate.cfg.xml中的<mapping resource="com/xx/User.hbm.xml"/>读取并解析映射信息*/
        //(3)创建会话SessionFactory对象
        sf = config.buildSessionFactory();
        //(4)加载Session对象
        session = sf.openSession();
    }
    //测试插入
    @Test
    public void testInsert() {
        ProductCategory pCategory = new ProductCategory(null, "美术");
        session.save(pCategory);
    }
    //测试修改
    @Test
    public void testUpdate() {
        ProductCategory pCategory = null; 
        pCategory = (ProductCategory)session.get(ProductCategory.class,new Long(4));
        System.out.println(pCategory);
        pCategory.setName("英语");
        System.out.println(pCategory);
        session.update(pCategory);
    }
    //测试全查
    @Test
    public void testSelectAll() {
        String hql = "from ProductCategory";
        Query query = session.createQuery(hql);
        List<ProductCategory> list = query.list();
        for(ProductCategory pCategory:list) {
            System.out.println(pCategory);
        }
    }
    //测试删除
    @Test
    public  void testDelete(){
        ProductCategory pCategory = null; 
        pCategory = (ProductCategory)session.get(ProductCategory.class,new Long(5));
        if(pCategory!=null) {
            session.delete(pCategory);
        }
    }
    @After
    public void after() {
        if (session != null) { 
            session.flush();
            session.clear();
            //(9) 关闭session对象
            session.close();
            /*
                *关闭session工厂,清空资源.由于sessionFactory对象持有整个持久化操作的资源,
                *关闭之后,下次在使用又需要创建,太耗内存,通过监听器application servletContext对象,
                *当服务器关闭或Web应用被移除时,ServletContext对象跟着销毁,
                *当停止进程时,再清理sessionFactory资源
                */
            //(10) 关闭sessionFactory对象
            sf.close();
        }
    }
    public static void main(String[] args) {
        TestProductCategory test = new TestProductCategory();
        test.before();
        test.testInsert();
        test.testUpdate();
        test.testSelectAll();
        test.testDelete();
        test.after();
    }
}

package com.pojo;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
@TableName(value="PRODUCTION.TEST_BIG_DATE")
public class BigDate {
    @TableId(value = "id",type = IdType.AUTO)
    private Long id;
    private byte[] photo; //mybatis将 Image 和Blob 映射成byte[]
    private byte[] describe;
    private String txt; //mybatis 将 Clob 映射成 String
    public Long getId() {
        return id;
    }
    public void setId(Long id) {
        this.id = id;
    }
    public byte[] getPhoto() {
        return photo;
    }
    public void setPhoto(byte[] photo) {
        this.photo = photo;
    }
    public byte[] getDescribe() {
        return describe;
    }
    public void setDescribe(byte[] describe) {
        this.describe = describe;
    }
    public String getTxt() {
        return txt;
    }
    public void setTxt(String txt) {
        this.txt = txt;
    }
    @Override
    public String toString() {
        return "TestBigDate [id=" + id + ", txt=" + txt + "]";
    }
    public BigDate(Long id, byte[] photo, byte[] describe, String txt) {
        super();
        this.id = id;
        this.photo = photo;
        this.describe = describe;
        this.txt = txt;
    }
    public BigDate() {
        super();
    }
}