67,513
社区成员
发帖
与我相关
我的任务
分享
@Test
public void test_List() throws InterruptedException
{ // 第一次
String hql = "from Player";
Query query = session.createQuery(hql);
List<Player> plist = query.list();
if (plist.size() > 0)
System.out.println("数据库记录数为 " + plist.size());
for (Player p : plist)
{
System.out.println(p.getName());
}
Thread.sleep(10000);
// 第二次
Query query4 = sessionFactory.openSession().createQuery(hql);
List<Player> plist4 = query4.list();
if (plist4.size() > 0)
System.out.println("数据库记录数为 " + plist4.size());
for (Player p : plist)
{
System.out.println(p.getName());
}
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="hibernate.connection.driver_class">
com.mysql.jdbc.Driver
</property>
<property name="hibernate.connection.url">
jdbc:mysql://localhost:3306/XXXXXX?useUnicode=true&characterEncoding=utf8
</property>
<!-- 数据库连接设置 -->
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password"></property>
<!-- show_sql 生成SQL语句输出到日志以供调式 -->
<property name="hibernate.show_sql">true</property>
<property name="hibernate.format_sql">false</property>
<property name="hibernate.use_sql_comments">false</property>
<!-- SQL dialect 方言 -->
<property name="hibernate.dialect">
org.hibernate.dialect.MySQLDialect
</property>
<!-- 指定session通过当前执行的线程来跟踪和界定 -->
<property name="hibernate.current_session_contecxt_class" >
thread
</property>
<!-- 添加实体类的映射文件 <mapping resource="XXXXX.hbm.xml" /> -->
<!-- <mapping resource="com/aikan/bean/player.hbm.xml"/>-->
<mapping class="com.aikan.bean.Player" />
</session-factory>
</hibernate-configuration>
@Before
public void setUp() throws Exception
{
sessionFactory = HibernateUtil.getSessionFactory();
session = sessionFactory.openSession();
logger.error("【初始化session】");
System.out.println("");
}
@After
public void end()
{
session.close();
sessionFactory.close();
logger.error("【session已关闭】");
}