package action;

import java.sql.Connection;
import java.sql.SQLException;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.cache.spi.QueryResultsRegion;
import org.hibernate.jdbc.ReturningWork;

import bean.User;
import util.HibernateUtil;

public class Query_JDBC {
    public static void main(String[] args) {
        Query_JDBC.jdbc();
    }

    /**
     * 在Hibernate中获取Connection接口
     */
    private static void jdbc() {

        Session session = null;
        Transaction tran = null;

        try {

            session = HibernateUtil.getSession();
            tran = session.beginTransaction();

            User user = session.doReturningWork(new ReturningWork<User>() {

                @Override
                public User execute(Connection conn) throws SQLException {
                    QueryRunner queryRunner = new QueryRunner();
                    String sql = "select username,userid,is_admin as isadmin from user where userid=1";   //数据库中的is_admin和bean中的isdmin不一致
                    User user = queryRunner.query(conn, sql,
                            new BeanHandler<User>(User.class));

                    return user;
                }

            });

            System.out.println("username=" + user.getUsername() + "\t"
                    + "userid=" + user.getUserid() + "\t" + "isadmin?"
                    + user.getIsAdmin());

            tran.commit();
        } catch (Exception e) {
            e.printStackTrace();
            tran.rollback();
        } finally {
            HibernateUtil.closeSession();
        }

    }

}