hibernate测试案例

hibernate测试案例

三个步骤出现结果

• 导包
• 编写实体类
• 实体类配置文件
• 编写hibernate配置文件
• 测试类

项目截图

导入hibernate和数据库 jar包

百度有 下载导入ok

编写实体类

Student

package com.pxg.model;
public class Student {

	private int sid;
	private String sname;
	public int getSid() {
		return sid;
	}
	public void setSid(int sid) {
		this.sid = sid;
	}
	public String getSname() {
		return sname;
	}
	public void setSname(String sname) {
		this.sname = sname;
	}
	@Override
	public String toString() {
		return "Student [sid=" + sid + ", sname=" + sname + "]";
	}

	
}

实体类配置文件

Student.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC 
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd" >
<hibernate-mapping >
<!-- name:类路径 table：数据库表名 -->
	<class name="com.pxg.model.Student" table="student">
	<!-- id：主键 --> <!-- name:实体类属性名称 column:对应表字段名称 type：类型 -->
		<id name="sid" column="sid" type="java.lang.Integer"></id>
		<property name="sname" column="sname" type="java.lang.String"></property>
	</class>
</hibernate-mapping>

编写hibernate配置文件

hibernate.cfg.xml

<!DOCTYPE hibernate-configuration PUBLIC
	"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
	"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
	<session-factory>
		<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
		<property name="connection.url">jdbc:mysql://localhost:3306/hibernate?useUnicode=true&amp;characterEncoding=utf-8</property>
		<property name="connection.username">root</property>
		<property name="connection.password">123456</property>
		<!-- 方言 -->
		<property name="dialect">org.hibernate.dialect.MySQL5Dialect</property>
		<!-- 显示sql语句 -->
		<property name="show_sql">true</property>
		<!-- 注册映射文件 -->
		<mapping resource="com/pxg/model/Student.hbm.xml"/>
	</session-factory>
</hibernate-configuration>

日志文件

log4j.properties

#
# Hibernate, Relational Persistence for Idiomatic Java
#
# License: GNU Lesser General Public License (LGPL), version 2.1 or later.
# See the lgpl.txt file in the root directory or <http://www.gnu.org/licenses/lgpl-2.1.html>.
#

### direct log messages to stdout ###
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### direct messages to file hibernate.log ###
#log4j.appender.file=org.apache.log4j.FileAppender
#log4j.appender.file.File=hibernate.log
#log4j.appender.file.layout=org.apache.log4j.PatternLayout
#log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### set log levels - for more verbose logging change 'info' to 'debug' ###

log4j.rootLogger=warn, stdout

#log4j.logger.org.hibernate=info
log4j.logger.org.hibernate=debug

### log HQL query parser activity
#log4j.logger.org.hibernate.hql.ast.AST=debug

### log just the SQL
#log4j.logger.org.hibernate.SQL=debug

### log JDBC bind parameters ###
log4j.logger.org.hibernate.type=info
#log4j.logger.org.hibernate.type=debug

### log schema export/update ###
log4j.logger.org.hibernate.tool.hbm2ddl=debug

### log HQL parse trees
#log4j.logger.org.hibernate.hql=debug

### log cache activity ###
#log4j.logger.org.hibernate.cache=debug

### log transaction activity
#log4j.logger.org.hibernate.transaction=debug

### log JDBC resource acquisition
#log4j.logger.org.hibernate.jdbc=debug

### enable the following line if you want to track down connection ###
### leakages when using DriverManagerConnectionProvider ###
#log4j.logger.org.hibernate.connection.DriverManagerConnectionProvider=trace

测试类

StudentTest

package com.pxg.test;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

import com.pxg.model.Student;

public class StudentTest {

	public static void main(String[] args) {
		//创建会话工厂
		SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
		//创建会话
		Session session = sessionFactory.openSession();
		//创建事务
		Transaction transaction = session.beginTransaction();
		//开启事务
		//transaction.begin();
		try {
			/*
			 * Student s = new Student(); 
			 * s.setSid(1); 
			 * s.setSname("李四"); 
			 * session.save(s);
			 *提交事务
			 * transaction.commit();
			 */
			Student student = session.find(Student.class, 2);
			System.out.println(student.toString());
		} catch (Exception e) {
			//事务回滚
			transaction.rollback();
			e.printStackTrace();
		} finally {
			//关闭连接
			if (session != null) {
				session.close();
				sessionFactory.close();
			}
		}

	}

}