日期:2014-05-16  浏览次数:20726 次

hebernate与mysql整合

1.下载mysql,

如何安装

2.开始在myeclipse 整合hebernate

hebernate 需要的一些包:

配置文件:(Mysql 已开启远程连接)

<?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">

<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>

<session-factory>

	<property name="connection.username">root</property>
	<property name="connection.url">jdbc:mysql://192.168.1.135:3306/SolarWorkFlowDb?useUnicode=true&amp;characterEncoding=utf8</property>
	<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
	<property name="myeclipse.connection.profile">mysqll</property>
	<property name="connection.password">solar</property>
	<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
	<property name="show_sql">true</property>
	<property name="format_sql">true</property>
	<property name="cache.use_query_cache">true</property>
	<property name="cache.provider_class">org.hibernate.cache.EhCacheProvider</property>
    <mapping resource="Mytest.hbm.xml" />

</session-factory>

</hibernate-configuration>
 

配置文件2

<?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">
<!--
    Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
    <class name="test.Person" table="SLWF_PERSON" >
        <comment>测试数据</comment>
        <id name="ID" type="java.lang.Integer">
            <column name="ID" />
            <generator class="native" />
        </id>
        
         <property name="FULL_NAME" type="java.lang.String">
            <column name="FULL_NAME"  />
        </property>   
        
        <property name="LAST_NAME" type="java.lang.String">
            <column name="LAST_NAME"  />
        </property>        
    </class>
</hibernate-mapping>

实体类:

package test;

public class Person {
	private int ID ;
	private String FULL_NAME;
	private String LAST_NAME;
	
	public Person(){}

	public Person(int iD, String fULLNAME, String lASTNAME) {
		super();
		ID = iD;
		FULL_NAME = fULLNAME;
		LAST_NAME = lASTNAME;
	}

	public int getID() {
		return ID;
	}

	public void setID(int iD) {
		ID = iD;
	}

	public String getFULL_NAME() {
		return FULL_NAME;
	}

	public void setFULL_NAME(String fULLNAME) {
		FULL_NAME = fULLNAME;
	}

	public String getLAST_NAME() {
		return LAST_NAME;
	}

	public void setLAST_NAME(String lASTNAME) {
		LAST_NAME = lASTNAME;
	}
    
	
	
}
测试类