使用JDBC和hibernateSessionFactory访问数据库

最新推荐文章于 2022-10-19 10:19:43 发布

木须炒蛋

最新推荐文章于 2022-10-19 10:19:43 发布

阅读量1.5k

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/dongzhouT/article/details/43951183

本文介绍了一种结合JDBC和Hibernate进行数据库查询的方法。通过示例代码展示了如何使用JDBC执行SQL查询以及利用Hibernate执行HQL查询。此外，还对比了两种方式的不同之处。

package test.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;

import test.vo.User;




public class TestDao {
	@SuppressWarnings("deprecation")
	public void querySql(Integer id){
		Session session= HibernateSessionFactory.getSession();
		Connection conn = session.connection();
		PreparedStatement ps=null;
		ResultSet rs=null;
		
		try {
			String sql = "select username,password from shdb.user";
			ps =conn.prepareStatement(sql);
			rs = ps.executeQuery();
			while(rs.next()){
				String nameString = rs.getString(1);
				String passString = rs.getString(2);
				System.out.println(nameString+"--------"+passString);
			}
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}finally{
			try {
				if(rs != null)
					rs.close();
				if(ps != null)
					ps.close();
				if(conn != null)
					conn.close();
			} catch (Exception e2) {
				// TODO: handle exception
			}
		}
	}
	
	public void queryHql(Integer id){
		Session session= HibernateSessionFactory.getSession();
		User user = (User)session.get(User.class, id);
		System.out.println("hql get........"+user.getUsername()+"     "+user.getPassword());
		session.close();
	}
	
	@SuppressWarnings("unchecked")
	public void queryHql1(Integer id){
		Session session= HibernateSessionFactory.getSession();
		String hql="from User";
		Query query=session.createQuery(hql);
		List<User> userList = query.list();
		
		for(User user :userList){
			System.out.println("hql list........"+user.getUsername()+"     "+user.getPassword());
		}
		
		session.close();
	}
}

使用JDBC和hibernateSessionFactory