package library.user;

import java.awt.BorderLayout;
import java.awt.Container;
import java.awt.Dimension;
import java.util.List;
import java.util.Vector;

import javax.swing.JFrame;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;

import library.hibernate.UserTable;
import library.main.HibernateUtil;

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

/**
 * 列出數據庫中注冊的所有用戶信息
 * 
 * @author lianhw
 * 
 */
public class UserList extends JFrame {

	Container container;

	JTable table = null;

	DefaultTableModel defaultModel = null;

	public UserList() {
		super("用戶列表一覽！");
		container = getContentPane();
		container.setLayout(new BorderLayout());
		// 表的兩個列名
		String[] name = { "用戶名", "權限" };
		String[][] data = new String[0][0];
		// 表對應的model
		defaultModel = new DefaultTableModel(data, name);
		// 新建表格
		table = new JTable(defaultModel);
		table.setPreferredScrollableViewportSize(new Dimension(400, 80));
		JScrollPane scrollPane = new JScrollPane(table);
		container.add(scrollPane);
		// 取得SessionFactory
		SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
		// 打開session
		Session session = sessionFactory.openSession();
		// 創建一個事務
		Transaction tx = session.beginTransaction();
		// hsql執行語句
		String hql = "from UserTable";
		// 執行查詢
		Query userList = session.createQuery(hql);
		// 將查詢結果放置到一個list鏈表中
		List list = userList.list();
		// 將鏈表中的數據加入到列表中
		for (int index = 0; index < list.size(); index++) {
			Vector insertRow = new Vector();
			insertRow.addElement(((UserTable) list.get(index)).getUserName());
			insertRow.addElement(((UserTable) list.get(index)).getPower());
			defaultModel.addRow(insertRow);
		}
		table.revalidate();
		// 事務提交
		tx.commit();
		// 關閉session
		session.close();
	}

}