package com.example.login;


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

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

import com.gc.dao.TestDAO;
import com.gc.dao.TestDAOHibernate;
import com.gc.dao.impl.TestDAOHibernateImpl;
import com.gc.dao.impl.TestDAOImpl;
import com.gc.vo.Test;


public class Debug {

	/**
	 * @param args
	 */
public void Regedit() throws Exception{
		Test user = new Test();
		user.setPassword("123456");
		user.setUsername("wvtyw");
		SessionFactory sessionFactory = null;
        Transaction transaction = null;
        Session session = null;
       
		try {	
			
	        sessionFactory = new Configuration().configure().buildSessionFactory();
	       
	        session = sessionFactory.openSession(); 
	        Connection con = session.connection();
	        transaction = session.beginTransaction();
	        TestDAOHibernateImpl userDao2 = new TestDAOHibernateImpl(session);
	        List data = userDao2.queryTest(user.getUsername());
	        System.out.println("******************"+data);
	        transaction.commit();  
		}catch(Exception e) {
			e.printStackTrace();
			transaction.rollback();
			
			
		} finally {
			session.close(); 
			sessionFactory.close(); 
		}
  	}	

	public static void main(String[] args) {
		
		try{
       new Debug().Regedit();
		}catch(Exception e) {e.printStackTrace();}
       
	}

}