hibernate框架学习之增删改查helloworld

package cn.itcast.h3.helloworld;

import org.hibernate.Session;

import org.hibernate.SessionFactory;

import org.hibernate.Transaction;

import org.hibernate.cfg.Configuration;

import cn.itcast.h3.helloworld.vo.UserModel;

public class HelloWordApp {

    public static void main(String[] args) {

        //1.加载配置文件hibernate.cfg.xml，得到一个配置对象

        Configuration conf = new Configuration().configure();

        //2.由配置创建一个SessionFactory

        SessionFactory sf = conf.buildSessionFactory();

        //3.由SessionFactory得到Session

        Session s = sf.openSession();

        //4.由Session对象获取事务对象Transaction

        Transaction t = s.beginTransaction();

        //5.完成任务

        //5.1创建一个要存储的对象

        UserModel um = new UserModel();

        um.setUuid("1");

        um.setUserName("李若亮");

        um.setAge(34);

        um.setAddress("传智播客");

        //5.2保存

        s.save(um);

        //6.提交事务

        t.commit();

        //7.关闭Session

        s.close();

        //8.关闭SessionFactory(略)

        sf.close();

    }

}

package cn.itcast.h3.helloworld;

import java.util.List;

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 cn.itcast.h3.helloworld.vo.UserModel;

public class BaseOperApp {

    //测试插入数据

    void testAdd(){

        Configuration conf = new Configuration().configure();

        SessionFactory sf = conf.buildSessionFactory();

        Session s = sf.openSession();

        Transaction t = s.beginTransaction();

        //1.准备一个要添加的数据

        UserModel um = new UserModel();

        um.setUuid("3");

        um.setUserName("李若亮");

        um.setAge(34);

        um.setAddress("传智播客");

        //2.调用save方法

        String res = (String) s.save(um);

        System.out.println(res);

        t.commit();

        s.close();

    }

    //测试修改数据

    void testUpdate(){

        Configuration conf = new Configuration().configure();

        SessionFactory sf = conf.buildSessionFactory();

        Session s = sf.openSession();

        Transaction t = s.beginTransaction();

        //1.准备一个要添加的数据

        UserModel um = new UserModel();

        um.setUuid("3");

        um.setUserName("Jock");

        um.setAge(34);

        um.setAddress("itcast");

        //2.调用update方法

        s.update(um);

        t.commit();

        s.close();

    }

    //测试删除数据

    void testDelete(){

        Configuration conf = new Configuration().configure();

        SessionFactory sf = conf.buildSessionFactory();

        Session s = sf.openSession();

        Transaction t = s.beginTransaction();

        //1.准备一个要添加的数据

        UserModel um = new UserModel();

        um.setUuid("1");

        //2.调用delete方法

        s.delete(um);        //um对象只要有uuid就可以了

        t.commit();

        s.close();

    }

    //测试单个数据

    void testQueryOne(){

        Configuration conf = new Configuration().configure();

        SessionFactory sf = conf.buildSessionFactory();

        Session s = sf.openSession();

        //1.查询单个数据需要依赖主键进行查询

        //2.get(模型类.Class,uuid)方法得到一个对象，这个对象被包装成了Class格式

        //3.load(模型类.Class,uuid)方法得到一个对象，这个对象被包装成了Class格式

        UserModel um = (UserModel) s.load(UserModel.class, "3");

        System.out.println(um);

        s.close();

    }

    //测试全部数据

    void testQueryAll(){

        Configuration conf = new Configuration().configure();

        SessionFactory sf = conf.buildSessionFactory();

        Session s = sf.openSession();

        //1.获取Query对象

        //创建Query对象时，需要使用Hibernate专用的查询语句HQL

        String hql = "from UserModel";

        Query q = s.createQuery(hql);

        //2.将结果查询出来，使用list方法，得到一个查询的结果集合

        List<UserModel> queryList = q.list();

        for(UserModel um:queryList){

            System.out.println(um);

        }

        s.close();

    }

    //测试全部数据2

    void testQueryAll2(){

        Configuration conf = new Configuration().configure();

        SessionFactory sf = conf.buildSessionFactory();

        Session s = sf.openSession();

        //1.使用本地SQL语句查询

        String sql = "select * from tbl_user";

        //2.使用SQL查询，需要使用SQLQuery对象，该对象使用Session获得

        SQLQuery sq = s.createSQLQuery(sql);

        //3.查询结果也可以使用list将结果封装成一个集合

        List<Object[]> queryList = sq.list();

        for(Object[] objs: queryList){

            for(Object obj:objs){

                System.out.println(obj);

            }

            System.out.println("------------------");

        }

        s.close();

    }

    public static void main(String[] args) {

        new BaseOperApp().testQueryAll2();

    }

}