尚筹网项目

1. 创建数据库

   CREATE DATABASE `project_crowd` CHARACTER SET utf8

2. 创建管理员数据库表

   USE project_crowd;
   DROP TABLE IF EXISTS t_admin;
   CREATE TABLE t_admin(
       id INT NOT NULL AUTO_INCREMENT,
       login_acct VARCHAR(255) NOT NULL,
       user_pswd CHAR(32) NOT NULL,
       email VARCHAR(255) NOT NULL,
       create_time CHAR(19),
       PRIMARY KEY(id)
   );

3. mybatis逆向工程

   <?xml version="1.0" encoding="UTF-8"?>
   <!DOCTYPE generatorConfiguration
           PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
           "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
   <generatorConfiguration>
       <!-- mybatis-generator:generate -->
       <context id="atguiguTables" targetRuntime="MyBatis3">
           <commentGenerator>
               <!-- 是否去除自动生成的注释 true:是;false:否 -->
               <property name="suppressAllComments" value="true" />
           </commentGenerator>
   
           <!--数据库连接的信息：驱动类、连接地址、用户名、密码 -->
           <jdbcConnection
                   driverClass="com.mysql.jdbc.Driver"
                   connectionURL="jdbc:mysql://localhost:3306/project_crowd"
                   userId="root"
                   password="root">
           </jdbcConnection>
   
           <!-- 默认false，把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer，为 true时把JDBC DECIMAL
               和 NUMERIC 类型解析为java.math.BigDecimal -->
           <javaTypeResolver>
               <property name="forceBigDecimals" value="false" />
           </javaTypeResolver>
   
           <!-- targetProject:生成Entity类的路径 -->
           <javaModelGenerator targetProject=".\src\main\java"
                               targetPackage="com.atguigu.crowd.entity">
               <!-- enableSubPackages:是否让schema作为包的后缀 -->
               <property name="enableSubPackages" value="false" />
               <!-- 从数据库返回的值被清理前后的空格 -->
               <property name="trimStrings" value="true" />
           </javaModelGenerator>
   
           <!-- targetProject:XxxMapper.xml映射文件生成的路径 -->
           <sqlMapGenerator targetProject=".\src\main\java"
                            targetPackage="com.atguigu.crowd.mapper">
               <!-- enableSubPackages:是否让schema作为包的后缀 -->
               <property name="enableSubPackages" value="false" />
           </sqlMapGenerator>
   
           <!-- targetPackage：Mapper接口生成的位置 -->
           <javaClientGenerator type="XMLMAPPER"
                                targetProject=".\src\main\java"
                                targetPackage="com.atguigu.crowd.mapper">
               <!-- enableSubPackages:是否让schema作为包的后缀 -->
               <property name="enableSubPackages" value="false" />
           </javaClientGenerator>
   
           <!-- 数据库表名字和我们的entity类对应的映射指定 -->
           <table tableName="t_admin" domainObjectName="Admin" />
   
       </context>
   </generatorConfiguration>

   执行逆向生成操作的Maven命令 mybatis-generator:generate