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>

log 4 jプロパティファイル

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;