HIBERNATE连接MySQL数据库简单示例

Person对象

public class Person implements Serializable {

	private static final long serialVersionUID = 1882657656924078522L;
	private Integer personId;
	private String name;
	private Set<Address> adds = new HashSet<Address>();

	public Person() {
		super();
	}

	public Person(String name) {
		super();
		this.name = name;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public Set<Address> getAdds() {
		return adds;
	}

	public void setAdds(Set<Address> adds) {
		this.adds = adds;
	}

	public Integer getPersonId() {
		return personId;
	}

	public void setPersonId(Integer personId) {
		this.personId = personId;
	}

}

Address对象

public class Address implements Serializable {

	private static final long serialVersionUID = 6132530253376016245L;
	private Integer addId;
	private String decription;
	private Person person;

	public Address() {
		super();
	}

	public Address(String decription) {
		super();
		this.decription = decription;
	}

	public Integer getAddId() {
		return addId;
	}

	public void setAddId(Integer addId) {
		this.addId = addId;
	}

	public String getDecription() {
		return decription;
	}

	public void setDecription(String decription) {
		this.decription = decription;
	}

	public Person getPerson() {
		return person;
	}

	public void setPerson(Person person) {
		this.person = person;
	}

}

Person配置文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
	<class name="vivi.test.hibernate.Person" table="person">
		<id name="personId">
			<generator class="identity"></generator>
		</id>
		
		<property name="name" />
		
		<set name="adds" lazy="true" inverse="true" cascade="all-delete-orphan">
			<key column="person_id"></key>
			<one-to-many class="vivi.test.hibernate.Address" />		
		</set>
	</class>
</hibernate-mapping>

 Address配置文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
	<class name="vivi.test.hibernate.Address" table="address">
		<id name="addId">
			<generator class="identity"></generator>
		</id>
		
		<property name="decription" />
		
		<many-to-one name="person" column="person_id" not-null="true" cascade="none"
					 class="vivi.test.hibernate.Person" />
	</class>
</hibernate-mapping>

 Hibernate配置文件

<?xml version="1.0" encoding="UTF-8"?>
<!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/hibernate</property>
        <property name="hibernate.connection.username">root</property>
        <property name="hibernate.connection.password">489702</property>
        
        <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property> 
        <property name="hibernate.current_session_context_class">thread</property>
        <property name="connection.useUnicode">true</property>
    	<property name="connection.characterEncoding">utf8</property>
        <property name="hbm2ddl.auto">update</property>		
        <!--<property name="show_sql">true</property>-->
        
        <mapping resource="./vivi/test/hibernate/Address.hbm.xml"/>
        <mapping resource="./vivi/test/hibernate/Person.hbm.xml"/>  
    </session-factory>
</hibernate-configuration>

 log4j属性文件

log4j.rootLogger = DEBUG, stdout
log4j.appender.stdout = org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %5p %c{1}:%L - %m%n

 Test测试对象

public class Test {
	private final static Log logger = LogFactory.getLog(Test.class);
	
	private static final SessionFactory sessionFactory;
	static{
		try{
			//这里创建SessionFactory将hibernate.cfg.xml文件，放在Src路径下
			sessionFactory = new Configuration().configure().buildSessionFactory();
			logger.debug("============:) 创建SessionFactory实例成功！:) ============");
		}catch(Throwable ex){
			logger.debug("============:( 创建SessionFactory实例失败！:( ============");
			throw new ExceptionInInitializerError(ex);
		}
	}
	
	public static SessionFactory getSessionFactory(){
		return sessionFactory;
	}
	
	public static void main(String[] args) {
		Test test = new Test();
		
		// 实例化一个新的Person对象，并填充内容
		Person person = new Person();
		person.setName("静子");
		
		Set<Address> addrs = new HashSet<Address>();
		Address addr1 = new Address();
		addr1.setDecription("苏州-通安镇同心路");
		addr1.setPerson(person);
		addrs.add(addr1);
		
		Address addr2 = new Address();
		addr2.setDecription("江苏-盐城市射阳县");
		addr2.setPerson(person);
		addrs.add(addr2);
		
		person.setAdds(addrs);
		
		test.Save(person);
		
		//test.update(1);
		//test.delete(2);
		test.select();
	}
	
	/**
	 * 添加新对象
	 * @param person
	 */
	public void Save(Person person){
		try{
			//获取Hibernate的Session
			Session session = Test.getSessionFactory().getCurrentSession();
			session.beginTransaction();
			//保存对象
			session.save(person);
			session.getTransaction().commit();
			logger.debug("============:) 保存Person对象---成功！:) ============");	
		}catch(HibernateException e){
			e.printStackTrace();
			logger.debug("============:( 保存Person对象---失败！:( ============");
		}
	}
	
	/**
	 * 查询对象
	 */
	public void select(){
		try{
			//获取Hibernate的Session
			Session session = Test.getSessionFactory().getCurrentSession();
			session.beginTransaction();
			//注意！！！ hql语句，针对对象的查询语句（不是表table）
			String hql = "from Person";
			
			List<Person> persons = session.createQuery(hql).list();
			//在控制台循环输出
			for(Person person : persons){
				System.out.println();
				System.out.println("***********" + person.getName() +"*****************");
				Set<Address> adds = person.getAdds();
				for(Iterator<Address> iter= adds.iterator(); iter.hasNext(); ){
					Address address = iter.next();
					System.out.println("***　地址： " + address.getDecription() + " ***");
				}
				System.out.println();
			}
			session.getTransaction().commit();
			logger.debug("============:) 查询对象---成功！:) ============");	
		}catch(HibernateException e){
			e.printStackTrace();
			logger.debug("============:( 查询对象---失败！:( ============");
		}
	}
	
	/**
	 * 更新对象
	 * @param id
	 */
	public  void update(Integer id){
		try{
			//获取Hibernate的Session
			Session session = Test.getSessionFactory().getCurrentSession();
			session.beginTransaction();
			//定义要装载对象的ID
			Person person = (Person)session.load(Person.class, id);
			//重设这个对象的名字
			person.setName("vivi_彭伟");
			session.update(person);		
			
			session.getTransaction().commit();
			logger.debug("============:) 更新对象---成功！:) ============");	
		}catch(HibernateException e){
			e.printStackTrace();
			logger.debug("============:( 更新对象---失败！:( ============");
		}
	}
	
	public void delete(Integer id){
		try{
			//获取Hibernate的Session
			Session session = Test.getSessionFactory().getCurrentSession();
			session.beginTransaction();
			//定义要装载对象的ID
			Person person = (Person)session.load(Person.class, id);
			//删除这个对象
			session.delete(person);
			
			session.getTransaction().commit();
			logger.debug("============:) 删除对象---成功！:) ============");	
		}catch(HibernateException e){
			e.printStackTrace();
			logger.debug("============:( 删除对象---失败！:( ============");
		}
	}

}

 

 

1、Hibernate的配置文件放在，src的根目录下

2、*.hbm.xml与持久化对象放在一起

3、字符集问题：hibernate使用JDBC需要设置，与数据库同步

<property name="connection.useUnicode">true</property>
<property name="connection.characterEncoding">utf8</property>

 

mysql>Create DATABASE IF NOT EXISTS my_db default charset utf8 COLLATE utf8_general_ci;