myeclipse中使用hibernate4对接mysql

为什么80%的码农都做不了架构师？>>>   

• 一 驱动准备

1、下载com.mysql.jdbc.Driver

2、在myeclipse window处打开DB Browser

配置信息如下：

注意：jdbc:mysql://localhost:3306/lfdata?serverTimezone=UTC中

?serverTimezone=UTC防止报错。

3、配置com.mysql.jdbc.Driver时，应该放在WEB-INF\lib下面，不要放在工程下面

• 二 配置文件

hibernate.cfg.xml

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>
  <!-- 通常，一个session-factory节点代表一个数据库 -->
    <session-factory>
    <!-- 1. 数据库连接配置 -->
        <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="hibernate.connection.url">jdbc:mysql:///lfdata?serverTimezone=UTC</property>
        <property name="hibernate.connection.username">root</property>
        <property name="hibernate.connection.password">123456</property>
        <!--            数据库方法配置， hibernate在运行的时候，会根据不同的方言生成符合当前数据库语法的sql         -->
        <property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property>


        <!-- 2. 其他相关配置 -->
        <!-- 2.1 显示hibernate在运行时候执行的sql语句 -->
        <property name="hibernate.show_sql">true</property>
        <!-- 2.2 格式化sql -->
        <property name="hibernate.format_sql">true</property>
        <!-- 2.3 自动建表  -->
        <property name="hibernate.hbm2ddl.auto">create</property>
    
     	<mapping resource="com/lf/fservice/bean/User.hbm.xml"/>
    </session-factory>

</hibernate-configuration>

applicationContext.xml 

<?xml version="1.0" encoding="UTF-8"?>
<beans
	xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:p="http://www.springframework.org/schema/p"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.1.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd" xmlns:tx="http://www.springframework.org/schema/tx">

	<!--org.springframework.orm.hibernate5.LocalSessionFactoryBean  -->

	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
		<property name="configLocation"
			value="classpath:hibernate.cfg.xml">
		</property>
	</bean>
	
	<bean id="transactionManager"
		class="org.springframework.orm.hibernate4.HibernateTransactionManager">
		<property name="sessionFactory" ref="sessionFactory" />
	</bean>
	<tx:annotation-driven transaction-manager="transactionManager" />
	
	<bean id="userDao" class="com.lf.fservice.dao.UserDao">
		<property name="sessionFactory" ref="sessionFactory"></property>
	</bean>
	
	<bean id="adminAction" class="com.lf.fservice.action.HelloWorldAction"
		scope="prototype">
		<property name="userDao" ref="userDao"></property>
	</bean>	
	
</beans>

User.hbm.xml 

<?xml version="1.0" encoding="UTF-8"?>
<hibernate-mapping package="com.lf.fservice.bean">


<!--类名为User，表名也为User-->
    <class name="User"  table="user_tb">

        <!--主键映射，属性名为id，列名也为id-->
        <id name="id" column="u_id">
            <!--根据底层数据库主键自动增长-->
            <generator class="native"/>
        </id>
        
        <!--非主键映射，属性和列名一一对应-->
        <property name="username" column="u_name"/>
        <property name="cellphone" column="u_phone"/>
        <property name="password" column="u_password"/>
    </class>




</hibernate-mapping>

每次启动都会删掉数据，解决方法：

<property name="hibernate.hbm2ddl.auto">update</property>

 

转载于:https://my.oschina.net/wfy94/blog/2991724