package com.example.login;

import java.io.PrintWriter;
import java.sql.Connection;
import java.util.List;

import javax.servlet.http.HttpServletResponse;

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;
import com.opensymphony.webwork.ServletActionContext;
import com.opensymphony.xwork.Action;

public class LoginAction implements Action {
	private String username;

	private String password;
	
	public String execute() throws Exception {
		
		
		
		if (username != null && password == null) {
			
			//this.Regedit();
			try {
				 HttpServletResponse response = ServletActionContext
					.getResponse();
			        PrintWriter out = response.getWriter();
			        
				if(!checkUseNameIfExist(username)){
				
			        out.write("Y");
			       
				}else
					out.write("N");
				 out.close();
			} catch (Exception e) {

			}
			
		}else{
			Regedit(username,password);
		}
		return SUCCESS;

	}

	public String getUsername() {
		return username;
	}

	public void setUsername(String username) {
		this.username = username;
	}

	public String getPassword() {
		return password;
	}

	public void setPassword(String password) {
		this.password = password;
	}

	private boolean checkUseNameIfExist(String usename)throws Exception{
		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 userDao = new TestDAOHibernateImpl(session);
	        List dataList = userDao.queryTest(usename);
	        //System.out.println("******************"+data);
	        transaction.commit(); 
	        if(!dataList.isEmpty()){
	        	return true;
	        }
		}catch(Exception e) {
			e.printStackTrace();
			transaction.rollback();
			
			
		} finally {
			session.close(); 
			sessionFactory.close(); 
		}
		
		return false;
	}
	public void Regedit(String username,String password ) throws Exception{
		SessionFactory sessionFactory = null;
        Transaction transaction = null;
        Session session = null;
        Test userData = new Test(username,password);
		try {	
			
	        sessionFactory = new Configuration().configure().buildSessionFactory();
	       
	        session = sessionFactory.openSession(); 
	        Connection con = session.connection();
	        transaction = session.beginTransaction();
	        TestDAOHibernateImpl userDao = new TestDAOHibernateImpl(session);
	        userDao.createTest(userData);
	       
	        transaction.commit();  
		}catch(Exception e) {
			e.printStackTrace();
			transaction.rollback();
			
			
		} finally {
			session.close(); 
			sessionFactory.close(); 
		}
		
  	}	
		
		
	
	}