package com.service;

import java.util.ArrayList;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.hibernate.HibernateUtil;

//Generated by MyEclipse

public class wsaHibernateImpl implements Iwsa {

	
	Session session = HibernateUtil.getSession();
	//private List<User> users = new ArrayList<User>();

	public void init_users() {
		User user1 = new User();
		user1.setName("aaa");
		user1.setPassword("aaa");

		User user2 = new User();
		user2.setName("bbb");
		user2.setPassword("bbb");

		User user3 = new User();
		user3.setName("ccc");
		user3.setPassword("ccc");

		try {
			Transaction tx = session.beginTransaction();
			session.save(user1);
			session.save(user2);
			session.save(user3);
			tx.commit();
		} catch (HibernateException e) {
			// TODO 自動(dòng)生成 catch 塊
			e.printStackTrace();
		}finally{
			if(session != null)
				session.close();
		}
	}

	public String example(String message) {
		return "hello world.This is a WebService Test. \n\r"
				+ "Your input is : " + message;
	}

	public boolean addUser(User user) {
		try {
			Transaction tx = session.beginTransaction();
			session.save(user);
			tx.commit();
		} catch (HibernateException e) {
			// TODO 自動(dòng)生成 catch 塊
			e.printStackTrace();
			return false;
		}finally{
			if(session != null)
				session.close();
		}
		return true;
	}

	public boolean author(User user) {
		System.out.println("Your input user name : " + user.getName());
		System.out.println("Your input user password : " + user.getPassword());
		
		String hql = "from User as user where user.name = :name";
		Query query = (Query) session.createQuery(hql);
		query.setString("name", user.getName());
		List<User> users = query.list();
		if(users == null){
			System.out.println("驗(yàn)證失敗---service----！！！");
			return false;
		}
		
		System.out.println("驗(yàn)證通過(guò)---service----");
		System.out.println("The User name: " + users.get(0).getName());
		System.out.println("The User name: " + users.get(0).getPassword());
		return true;
	}

	public boolean delUser(int i) {
		return true;
	}

	public List<User> showUsers() {
		String hql = "from User";
		Query query = (Query) session.createQuery(hql);
		List<User> users = query.list();
		return users;
	}

	public User getUserByName(String name) {
		String hql = "from User as user where user.name = :name";
		Query query = (Query) session.createQuery(hql);
		query.setString("name", name);
		User user = (User)query.uniqueResult();
		return user;
	}

	public User getUser(int i) {
		User user = (User)session.get(User.class, i);
		return user;
	}

}