移动大脑-SpringMVc搭建RestFul后台服务（二）-配置mysql数据库

        在上一篇博客移动大脑-SpringMVc搭建RestFul后台服务（一）中已经搭建好了开发环境，接下来增加Mysql数据库的配置。

一、安装mysql

在mysql官网（https://dev.mysql.com/downloads/mysql/）下载对应的Mysql版本，然后初始化和配置Mysql并修改登录密码（http://blog.csdn.net/ywl5320/article/details/77847878）

并创建好我们需要的数据库：app_service_db

二、接着上次的项目，在maven中添加hibernate和jdbc驱动库

在pom.xml中追加：

<!-- 关系型数据库整合时需配置 如hibernate jpa等 -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-orm</artifactId>
            <version>${spring.version}</version>
        </dependency>

        <!-- hibernate -->
        <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-core</artifactId>
            <version>${hibernate.version}</version>
        </dependency>

        <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-ehcache</artifactId>
            <version>${hibernate.version}</version>
        </dependency>

        <dependency>
            <groupId>org.hibernate.javax.persistence</groupId>
            <artifactId>hibernate-jpa-2.1-api</artifactId>
            <version>1.0.0.Final</version>
        </dependency>

        <!-- mysql连接 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.34</version>
        </dependency>

        <!-- tomcat-jdbc-->
        <dependency>
            <groupId>org.apache.tomcat</groupId>
            <artifactId>tomcat-jdbc</artifactId>
            <version>8.0.33</version>
        </dependency>

        <dependency>
            <groupId>com.mchange</groupId>
            <artifactId>c3p0</artifactId>
            <version>0.9.5-pre8</version>
        </dependency>

然后导入相应的库：

三、添加实体类（也既数据库t_user表）

1、UserBean.java

package com.ywl5320.appservice.bean;


/**
 * Created by ywl5320 on 2017/10/12.
 */
public class UserBean extends BaseBean{

    private Integer id;
    private String phone;
    private String password;
    private String username;
    private Integer sex;
    private Integer age;
    private String token;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public Integer getSex() {
        return sex;
    }

    public void setSex(Integer sex) {
        this.sex = sex;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    public String getToken() {
        return token;
    }

    public void setToken(String token) {
        this.token = token;
    }
}

2、在resource中添加创建数据库表的配置文件：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
    <class name="com.ywl5320.appservice.bean.UserBean" table="t_user">
        <id name="id" column="id">
            <generator class="native"></generator>
        </id>
        <property name="phone" column="phone"></property>
        <property name="password" column="password"></property>
        <property name="username" column="username"></property>
        <property name="sex" column="sex"></property>
        <property name="age" column="age"></property>
    </class>

</hibernate-mapping>

这样启动服务时就会自动创建用户表“t_user”
四、添加hibernate核心配置文件，并引入数据库表的配置

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">
<hibernate-configuration>

	<session-factory>

		<property name="hibernate.show_sql">true</property>
		<property name="hibernate.format_sql">true</property>
		<property name="hibernate.hbm2ddl.auto">update</property>
		<property name="hibernate.dialet">org.hibernate.dialect.MySQLDialect</property>
		
		<mapping resource="entitis.hbm.xml"/>
		
	</session-factory>

</hibernate-configuration>

五、在beans.xml中配置c3p0链接池、配置sessionFactory和配置事物管理器

<!-- 配置c3p0链接池 -->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="com.mysql.jdbc.Driver"></property>
        <property name="jdbcUrl" value="jdbc:mysql:///app_server_db"></property>
        <property name="user" value="root"></property>
        <property name="password" value="123456"></property>
    </bean>

    <!-- 配置sessionFactory -->
    <bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
        <property name="dataSource" ref="dataSource"></property>
        <property name="configLocations" value="classpath:hibernate.cfg.xml"></property>
    </bean>

    <!-- 配置事物管理器 -->
    <bean id="transactionManager" class="org.springframework.orm.hibernate5.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory"></property>
    </bean>
     <!--开启事物注解 -->
    <tx:annotation-driven transaction-manager="transactionManager"/>

六、配置好后，启动服务，就可以在数据库app_service_db中看到我们创建好的t_user表了

这样mysql数据库就已经成功配置完成。下一篇博客将完成用户注册、登录的RestFul接口给移动端调用。

源码：GitHub AppServiceRestFul