package com.yjl.pojo;
import java.sql.Blob;
import java.util.Date;
 @author:两个蝴蝶飞
 @date: 2019年3月8日 上午10:33:16
 @Description 类型转换。
public class Book {
     * @param id 主键编号  是int 型
     * @param name 书名  是varchar 型
     * @param price 价钱  是number或者float型
     * @param publishDate 出版日期   是timestamp 或者date 型
     * @param author 作者  是varchar 型
     * @param specialPrice 是否是降价  是boolean 型
     * @param description 描述  是长字段 text型
     * @param bookImage 图片  是Blod 型。  开发中存储的是地址
    private Integer id;
    private String name;
    private Double price;
    private Date publishDate;
    private String author;
    private Boolean specialPrice;
    private String description;
    private Blob bookImage;
    public Integer getId() {
        return id;
    public void setId(Integer id) {
        this.id = id;





    
    public String getName() {
        return name;
    public void setName(String name) {
        this.name = name;
    public Double getPrice() {
        return price;
    public void setPrice(Double price) {
        this.price = price;
    public Date getPublishDate() {
        return publishDate;
    public void setPublishDate(Date publishDate) {
        this.publishDate = publishDate;
    public String getAuthor() {
        return author;
    public void setAuthor(String author) {
        this.author = author;
    public Boolean getSpecialPrice() {
        return specialPrice;
    public void setSpecialPrice(Boolean specialPrice) {
        this.specialPrice = specialPrice;
    public String getDescription() {
        return description;
    public void setDescription(String description) {
        this.description = description;
    public Blob getBookImage() {
        return bookImage;
    public void setBookImage(Blob bookImage) {
        this.bookImage = bookImage;
    @Override
    public String toString() {





    
        return "Book [id=" + id + ", name=" + name + ", price=" + price + ", publishDate=" + publishDate + ", author="
                + author + ", specialPrice=" + specialPrice + ", description=" + description + "]";

<?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 package="com.yjl.pojo">
    <class name="Book">
        <id name="id" column="id">
            <generator class="native"></generator>
        <!--后面的type 可以写java类型，也可以写hibernate类型。 但不能写sql类型。
        如果不写的话，会默认读取属性的类型，即java类型。-->
        <!-- 用的是java类型 -->
        <property name="name" column="name" type="java.lang.String"></property>
        <!-- 用的是java类型 -->
        <property name="price" column="price" type="java.lang.Double"></property>
        <!-- 用的是hibernate类型 -->
        <property name="publishDate" column="publishDate" type="timestamp"></property>
        <!-- 用hibernate类型 -->
        <property name="author" column="author" type="string"></property>
        <!-- 用的是java类型 -->
        <property name="specialPrice" column="specialPrice" type="java.lang.Boolean"></property>
        <!-- 用的是hibernate类型。  -->
        <property name="description" column="description" type="text"></property>
        <!-- 用的是java类型 -->





    
        <property name="bookImage" column="bookImage" type="java.sql.Blob"></property>
    </class>
</hibernate-mapping>

  /*测试创建表是否正确。*/
    @Test
    public void createTest(){
        Session session=HibernateUtil.getSession();
        session.close();

/*插入的测试*/
    @Test
    public void saveTest(){
        Session session=HibernateUtil.getSession();
        Transaction transaction=session.beginTransaction();
        /*创建对象。*/
        Book book=new Book();
        book.setName("蝴蝶飞往Java");
        book.setPrice(23.5D);
        book.setAuthor("两个蝴蝶飞");
        book.setPublishDate(new java.util.Date());
        book.setSpecialPrice(true); //是否是特价
        book.setDescription("也许，有的时候，就是那么一个人的存在，拯救了他的世界");
        File file=new File("D:"+File.separator+"java编程思想.jpg");
        InputStream input=null;
        try {





    
            input=new FileInputStream(file);
            //获取LobHelper接口
            LobHelper lobHelper=session.getLobHelper();  //可以创建Blob,也可以创建Clob. LobHelper
            Blob blob=lobHelper.createBlob(input,input.available());
            book.setBookImage(blob);
        } catch (Exception e) {
            e.printStackTrace();
        session.save(book);
        transaction.commit();
        //要放在事务提交的后面。
        try {
            input.close();  //关闭input
        } catch (IOException e) {
            e.printStackTrace();
        //关闭session
        session.close();

/*读取的测试*/
    @Test
    public void readTest() throws Exception{
        Session session=HibernateUtil.getSession();
        Book book=session.get(Book.class,1);
        System.out.println(book.toString());
        //将图片的信息，存储到另外一个文件下。





    
        Blob blob=book.getBookImage();
        BufferedInputStream bis=null; 
        BufferedOutputStream bos=null;
        InputStream is=null;
        OutputStream os=null;
        is=blob.getBinaryStream();
        bis=new BufferedInputStream(is);
        os=new FileOutputStream("D:"+File.separator+"java编程思想数据库读取.jpg");
        bos=new BufferedOutputStream(os);
        int index=0;
        byte [] b=new byte[10240];
        while((index=is.read(b))!=-1){
            bos.write(b,0,index);
        bis.close();
        bos.close();
        session.close();

public class Student {
    private Integer id;
    private String name;





    
    /*存入其他的类型*/
    private Set<String> images1;
    public Integer getId() {
        return id;
    public void setId(Integer id) {
        this.id = id;
    public String getName() {
        return name;
    public void setName(String name) {
        this.name = name;
    public Set<String> getImages1() {
        return images1;
    public void setImages1(Set<String> images1) {
        this.images1 = images1;

<hibernate-mapping package="com.yjl.pojo">
    <class name="Student">
        <id name="id" column="id">
            <generator class="native"></generator>
        <!-- 用的是java类型 -->
        <property name="name" column="name" type="java.lang.String"></property>
        <!-- 同样用set 标签来表示   table为要保存的表。-->
        <set name="images1" table="image">
            <key column="stuId"></key>
            <!-- 这里用element 元素来表示 -->
            <element column="imageName" type="string"></element>
    </class>
</hibernate-mapping>





    

/*set 类型的测试*/
    @Test
    public void setTest(){
        Session session=HibernateUtil.getSession();
        Transaction transaction=session.beginTransaction();
        Set<String> imageSet=new HashSet<String>();
        imageSet.add("image1.png");
        imageSet.add("image2.png");
        imageSet.add("image3.png");
        imageSet.add("image3.png");
        Student s1=new Student();
        s1.setName("两个蝴蝶飞");
        s1.setImages1(imageSet);
        session.save(s1);
        transaction.commit();

/*读取的测试*/
    @Test
    public void setReadTest(){
        Session session=HibernateUtil.getSession();
        Student stu=session.get(Student.class,1);
        Set<String> imageSet=stu.getImages1();
        Iterator <String> images=imageSet.iterator();
        while(images.hasNext()){





    
            System.out.println(images.next());

public class Student {
    private Integer id;
    private String name;
    /*存入其他的类型*/
    private List<String> hobby;
    public Integer getId() {
        return id;
    public void setId(Integer id) {
        this.id = id;
    public String getName() {
        return name;
    public void setName(String name) {
        this.name = name;
    public List<String> getHobby() {
        return hobby;
    public void setHobby(List<String> hobby) {
        this.hobby = hobby;

<hibernate-mapping package="com.yjl.pojo">
    <class name="Student">
        <id name="id" column="id">
            <generator class="native"></generator>
        <!-- 用的是java类型 -->





    
        <property name="name" column="name" type="java.lang.String"></property>
        <!-- 用list 标签来表示 -->
        <list name="hobby" table="hobby">
            <key column="stuId"></key>
            <!-- 有顺序。 把顺序放置进来 -->
            <list-index column="hobbyIndex"></list-index>
            <!-- 这里用element 元素来表示 -->
            <element column="hobbyName" type="string"></element>
        </list>
    </class>
</hibernate-mapping>

@Test
    public void listTest(){
        Session session=HibernateUtil.getSession();
        Transaction transaction=session.beginTransaction();
        List<String> hobbyList=new ArrayList<String>();
        hobbyList.add("编程");
        hobbyList.add("五音不全的唱歌");
        hobbyList.add("打游戏");
        Student s1=new Student();
        s1.setName("两个蝴蝶飞");
        s1.setHobby(hobbyList);
        session.save(s1);
        transaction.commit();

/*读取的测试*/
    @Test
    public void listReadTest(){
        Session session=HibernateUtil.getSession();
        Student stu=session.get(Student.class,1);
        List<String> hobbyList=stu.getHobby();
        Iterator <String> images=hobbyList.iterator();
        while(images.hasNext()){
            System.out.println(images.next());

<hibernate-mapping package="com.yjl.pojo">
    <class name="Student">
        <id name="id" column="id">
            <generator class="native"></generator>
        <!-- 用的是java类型 -->
        <property name="name" column="name" type="java.lang.String"></property>
        <!-- 用idbag 包标签来表示 -->
        <idbag name="hobby" table="hobby">
            <collection-id type="long" column="hobbyId">
                <generator class="increment"></generator>
            </collection-id>
            <key column="stuId"></key>
            <!-- 这里用element 元素来表示 -->
            <element column="hobbyName" type="string"></element>
        </idbag>





    
    </class>
</hibernate-mapping>

/*栈 bag 类型的测试*/
    @Test
    public void bagTest(){
        Session session=HibernateUtil.getSession();
        Transaction transaction=session.beginTransaction();
        List<String> hobbyList=new ArrayList<String>();
        hobbyList.add("编程1");
        hobbyList.add("五音不全的唱歌1");
        hobbyList.add("打游戏1");
        Student s1=new Student();
        s1.setName("两个蝴蝶飞");
        s1.setHobby(hobbyList);
        session.save(s1);
        transaction.commit();

/*读取的测试*/
    @Test
    public void bagReadTest(){
        Session session=HibernateUtil.getSession();
        Student stu=session.get(Student.class,1);
        List<String> hobbyList=stu.getHobby();
        Iterator <String> images=hobbyList.iterator();





    
        while(images.hasNext()){
            System.out.println(images.next());

public class Student {
    private Integer id;
    private String name;
    /*存入其他的类型*/
    private Map<String,String> girls;
    public Integer getId() {
        return id;
    public void setId(Integer id) {
        this.id = id;
    public String getName() {
        return name;
    public void setName(String name) {
        this.name = name;
    public Map<String, String> getGirls() {
        return girls;
    public void setGirls(Map<String, String> girls) {
        this.girls = girls;

<hibernate-mapping package="com.yjl.pojo">
    <class name="Student">
        <id name="id" column="id">
            <generator class="native"></generator>
        <!-- 用的是java类型 -->





    
        <property name="name" column="name" type="java.lang.String"></property>
        <!-- 用map 标签来表示 -->
        <map name="girls" table="girls">
            <key column="stuId"></key>
            <map-key column="girlId" type="string"></map-key>
            <!-- 这里用element 元素来表示 -->
            <element column="girlName" type="string"></element>
    </class>
</hibernate-mapping>

@Test
    public void MapTest(){
        Session session=HibernateUtil.getSession();
        Transaction transaction=session.beginTransaction();
        Map<String,String> girlList=new HashMap<String,String>();
        girlList.put("Java","一个非常文静的女孩");
        girlList.put("Python","一个非常聪明的女孩");
        girlList.put("Go","听说很有钱的女孩");
        Student s1=new Student();
        s1.setName("两个蝴蝶飞");
        s1.setGirls(girlList);
        session.save(s1);
        transaction.commit();

@Test
    public void MapReadTest(){
        Session session=HibernateUtil.getSession();
        Student stu=session.get(Student.class,1);
        Map<String,String> girlList=stu.getGirls();
        for(Map.Entry<String,String> m:girlList.entrySet()){
            System.out.println(m.getKey()+"----"+m.getValue());