Hibernate插入对象实战详解

拼搏现实的明天。 2022-02-24 05:24 194阅读 0赞

1.目标数据库及maven目录  
![百度百度百度][20190403102455541.png]  
![百度百度百度][20190403102543807.png]  
2.设计：  
对象dept：

private int deptno;
    private String dname;
    private String loc;
    
    /**
    	 * 构造dept方法
    	 * */
    	public Dept(int deptno,String dname,String loc) {
    	//	spuer;
    		this.deptno = deptno;
    		this.dname = dname;
    		this.loc = loc;
    	}

3.xml：  
映射文件

配置文件hibernate.cfg.xml：

<session-factory>
    
    		
    		<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
    		<property name="connection.url">jdbc:oracle:thin:@192.168.1.74:1521:orcl</property>
    		<property name="connection.username">scott</property>
    		<property name="connection.password">tiger</property>
    
    		
    		<property name="dialect">org.hibernate.dialect.Oracle10gDialect</property>
    
    		
    		<property name="show_sql">true</property>
    
    		
    		<property name="hbm2ddl.auto">update</property>
    		<property name="format_sql">true</property>
    
    		
    		<mapping resource="hbm/Emp.hbm.xml" />
    		<mapping resource="hbm/Dept.hbm.xml" />
    
    	</session-factory>

4.test  
dao层：

/**
    	 * add dept
    	 * */
    	public void addDept(Dept dept) {
    		Session session = BaseDao.getSession();//获取session
    		transaction = session.beginTransaction();//开启事务
    		// <sql-insert>INSERT INTO PERSON (NAME, ID) VALUES ( UPPER(?), ? )</sql-insert>
    		String hql = "insert into new com.hxzy.entity.Dept dept (deptno,dname,loc) values (dept.deptno,dept.dname,dept.loc)";//
    		try {
    		//	session.createQuery(hql).executeUpdate();//执行sql
    			session.save(dept);
    			transaction.commit();//提交事务
    		}catch(Exception e) {
    			e.printStackTrace();
    			transaction.rollback();//事务异常则回滚
    		}
    	}
    	
    	/**
    	 * select all
    	 * */
    	public List<Dept> getDeptList(){
    		Session session = BaseDao.getSession();//获取会话
    		transaction = session.beginTransaction();//开启事务
    		List<Dept> deptList = new ArrayList<Dept>();
    		String hql = "select new com.hxzy.hql.entity.Dept(dept.deptno,dept.dname,dept.loc) from Dept dept ";
    		try {
    			Query query = session.createQuery(hql);//创建hql query
    			deptList = query.list();//查出结果集并接收
    			transaction.commit();//提交事务
    		}catch(Exception e) {
    			e.printStackTrace();//输出异常信息
    			transaction.rollback();//有异常则回滚
    		}finally {
    			destory();//关闭资源
    		}
    		return deptList;
    	}

Test：

DeptDao deptDao = new DeptDaoImpl();
    		Dept dept = new Dept(50, "gz", "hxyz");
    		deptDao.addDept(dept);
    		List<Dept> deptList = deptDao.getDeptList();
    		System.out.println(" deptno\tdname\tloc");
    		for(Dept d:deptList) {
    			System.out.println(d.getDeptno()+"\t"+d.getDname()+"\t"+d.getLoc());
    		}

输出结果：  
![百度百度百度][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L29MZW5nWXVlSHVu_size_16_color_FFFFFF_t_70]

[20190403102455541.png]: /images/20220224/e6d262cc30ba40f08ae4badf9c572f46.png
[20190403102543807.png]: /images/20220224/5101413430ca417eb09ede5683a7243c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L29MZW5nWXVlSHVu_size_16_color_FFFFFF_t_70]: /images/20220224/5a6a574063394be5a04585779a5a5610.png