hibernatesample1.java

一个比较简单的hibernate工程 简单的实现

package com.myeclipse.hibernate;
import java.util.List;

import org.hibernate.Transaction;
//import org.hibernate.classic.Session;
import org.hibernate.*;
import org.hibernate.Session;
import java.util.*;
import java.beans.*;
import javax.sql.*;
import java.sql.*;
import javax.sql.DataSource;
import javax.naming.*;
import java.io.*;

//import sun.text.CompactShortArray.Iterator;
public class HibernateSample1 {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		//addUser();
		//selectUser1();
		//selectUser2();
		//selectUser3();
		//selectUser4();
		//updateUser();
		//deleteUser1();
		//orderbyUser();
        //groupbyUser();
	}

	private static void addUser() {
		// 1. Create user
		User user = new User();
		//user.setUserId("dfd");
		user.setName("adoe");
		user.setSex("1234");
		user.setAge(12);
		
		// 2. Create DAO
		UserDAO dao = new UserDAO();
		
		// 3. Start the transaction
		Transaction tx = dao.getSession().beginTransaction();
		
		// 4. Add user
		dao.save(user);
		
		// 5. Commit the transaction (write to database)
		tx.commit();
		
		// 6. Close the session (cleanup connections)
		dao.getSession().close();
	}
	
	private static void listUser() {
		// 1. Create DAO
		UserDAO dao = new UserDAO();
		
		// 2. Find user by ID
		User user = dao.findById("jdk");
		
		// 3. Print the user information out
		
		// 4. Close the session (cleanup connections)
		dao.getSession().close();
	}
	
	private static void changeUser() {
		// 1. Create DAO
		UserDAO dao = new UserDAO();
		
		// 2. Find user by ID
		User user = dao.findById("jfkd");
		
		// 3. Change user information
		user.setUserId("jsmith");
		user.setSex("abcd");
		user.setName("Jane");
		user.setAge(23);
		
		// 4. Start the transaction
		Transaction tx = dao.getSession().beginTransaction();
		
		// 5. Update the user record with the changes
		dao.save(user);
		
		// 6. Commit the transaction (write to database)
		tx.commit();
		
		// 7. Load the updated user from the database
		
		// 9. Close the session (cleanup connections)
		dao.getSession().close();
	}
		
	
	//hql="from com.myeclipse.hibernate.User";
	private static void selectUser1()
	{ 
		// 1. Create DAO
		UserDAO dao = new UserDAO();
		
		
		//String hql="from User";
		String hql="from com.myeclipse.hibernate.User";
		
		Session session=dao.getSession();
		Transaction tx=session.beginTransaction();
		Query query=session.createQuery(hql);
		List list=query.list();
		Iterator it=list.iterator();
		while(it.hasNext())
		{
			User user=(User)it.next();
			// 3. Change user information
			System.out.print(user.getUserId()+" ");
			System.out.print(user.getSex()+" ");
			System.out.print(user.getName()+" ");
			System.out.print(user.getAge()+" ");
			System.out.println(" ");
				
		}
				
		// 6. Commit the transaction (write to database)
		tx.commit();
		
		// 7. Load the updated user from the database
		
		// 9. Close the session (cleanup connections)
		dao.getSession().close();
		
	}
		
	//hql="select  user.name from User as user";
	private static void selectUser2()
	{ 
		// 1. Create DAO
		UserDAO dao = new UserDAO();
		
		
		String hql="select  user.name from User as user";
		Session session=dao.getSession();
		Transaction tx=session.beginTransaction();
		Query query=session.createQuery(hql);
		List list=query.list();
		Iterator it=list.iterator();
		while(it.hasNext())
		{
			System.out.println(it.next());//这里it.next（）是
			//一个String类型的数值		
		}
				
		// 6. Commit the transaction (write to database)
		tx.commit();
		
		// 7. Load the updated user from the database
		
		// 9. Close the session (cleanup connections)
		dao.getSession().close();
		
	}
	
	
	//hql="select user.name,user.sex from User as user";
	private static void selectUser3()
	{ 
		// 1. Create DAO
		UserDAO dao = new UserDAO();		
		
		String hql="select user.name,user.sex from User as user";
		Session session=dao.getSession();
		Transaction tx=session.beginTransaction();
		Query query=session.createQuery(hql);
		List list=query.list();
		Iterator it=list.iterator();
		while(it.hasNext())
		{
			Object[] results=(Object[])it.next();
			System.out.print(results[0]+" ");
			System.out.print(results[1]);
			System.out.println(" ");
		}
				
		// 6. Commit the transaction (write to database)
		tx.commit();
		
		// 7. Load the updated user from the database
		
		// 9. Close the session (cleanup connections)
		dao.getSession().close();
		
	}
	
	
	//hql="select new User(user.name,user.sex) from User as user";
	private static void selectUser4()
	{ 
		// 1. Create DAO
		UserDAO dao = new UserDAO();		
		
		String hql="select new User(user.name,user.sex) from User as user";
		Session session=dao.getSession();
		Transaction tx=session.beginTransaction();
		Query query=session.createQuery(hql);
		List list=query.list();
		Iterator it=list.iterator();
		while(it.hasNext())
		{
			User user=(User)it.next();
			
			System.out.print(user.getName()+" ");
			System.out.print(user.getSex()+" ");
			System.out.println(" ");
		}
				
		// 6. Commit the transaction (write to database)
		tx.commit();
		
		// 7. Load the updated user from the database
		
		// 9. Close the session (cleanup connections)
		dao.getSession().close();
		
	}
		
	
	//hql="select new User(User.name,User.sex) from User";
	private static void selectUser5()
	{ 
		// 1. Create DAO
		UserDAO dao = new UserDAO();		
		
		String hql="select new User(User.name,User.sex) from User";
		Session session=dao.getSession();
		Transaction tx=session.beginTransaction();
		Query query=session.createQuery(hql);
		List list=query.list();
		Iterator it=list.iterator();
		while(it.hasNext())
		{
			User user=(User)it.next();
			
			System.out.println(user.getName());
			System.out.println(user.getAge());
		}
				
		// 6. Commit the transaction (write to database)
		tx.commit();
		
		// 7. Load the updated user from the database
		
		// 9. Close the session (cleanup connections)
		dao.getSession().close();
		
	}
		
	
	//hql="update User set age=18 where sex='M'";
	private static void  updateUser()
	{
		// 1. Create DAO
		UserDAO dao = new UserDAO();		
		
		String hql="update User set age=20 where sex='M'";
		Session session=dao.getSession();
		Transaction tx=session.beginTransaction();
		Query query=session.createQuery(hql);
		query.executeUpdate();
				
		// 6. Commit the transaction (write to database)
		tx.commit();
		
		// 7. Load the updated user from the database
		
		// 9. Close the session (cleanup connections)
		dao.getSession().close();
		System.out.println("Update Successfully!!");
		
	}
	
	
	//hql="delete User where name='jdoe'"
	private static void  deleteUser1()
	{
		// 1. Create DAO
		UserDAO dao = new UserDAO();		
		
		String hql="delete User where name='fjddk'";
		Session session=dao.getSession();
		Transaction tx=session.beginTransaction();
		Query query=session.createQuery(hql);
		query.executeUpdate();
				
		// 6. Commit the transaction (write to database)
		tx.commit();
		
		// 7. Load the updated user from the database
		
		// 9. Close the session (cleanup connections)
		dao.getSession().close();
		
		
	}
	
	
	//hql="from User user order by user.userId"
	private static void  orderbyUser()
	{
		// 1. Create DAO
		UserDAO dao = new UserDAO();		
		
		String hql="from User user order by user.name";
		Session session=dao.getSession();
		Transaction tx=session.beginTransaction();
		Query query=session.createQuery(hql);
		List list=query.list();
		Iterator it=list.iterator();
		while(it.hasNext())
		{
			User user=(User)it.next();
			System.out.print(user.getUserId()+" ");
			System.out.print(user.getSex()+" ");
			System.out.print(user.getName()+" ");
			System.out.print(user.getAge()+" ");
			System.out.println(" ");
		}
				
				
		// 6. Commit the transaction (write to database)
		tx.commit();
		
		// 7. Load the updated user from the database
		
		// 9. Close the session (cleanup connections)
		dao.getSession().close();
	}

	
	//hql="select count(*),user.name from User user group by user.name"
    private static void groupbyUser()
    {
    	// 1. Create DAO
		UserDAO dao = new UserDAO();		
		
		String hql="select count(*),user.name from User user group by user.name";
		Session session=dao.getSession();
		Transaction tx=session.beginTransaction();
		Query query=session.createQuery(hql);
		List list=query.list();
		Iterator it=list.iterator();
		while(it.hasNext())
		{
			Object[] results=(Object[])it.next();
			System.out.print(results[0]+" ");
			System.out.print(results[1]+" ");
			
			System.out.println(" ");
		}
				
				
		// 6. Commit the transaction (write to database)
		tx.commit();
		
		// 7. Load the updated user from the database
		
		// 9. Close the session (cleanup connections)
		dao.getSession().close();
    }
}