ssm(spring+springmvc+mybatis) 框架搭建

青旅半醒 2022-04-25 01:36 305阅读 0赞

引入开发包

  1. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  2.   xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
  3.   <modelVersion>4.0.0</modelVersion>
  4.   <groupId>SpringMvc</groupId>
  5.   <artifactId>SpringMvc</artifactId>
  6.   <packaging>war</packaging>
  7.   <version>1.0-SNAPSHOT</version>
  8.   <name>SpringMvc Maven Webapp</name>
  9.   <url>http://maven.apache.org</url>
  11.   <properties>
  12.     <spring.version>4.3.6.RELEASE</spring.version>
  13.   </properties>
  15.   <dependencies>
  17.     <!--Spring核心开发包-->
  19.     <!--单元测试-->
  20.     <dependency>
  21.       <groupId>junit</groupId>
  22.       <artifactId>junit</artifactId>
  23.       <version>3.8.1</version>
  24.       <scope>test</scope>
  25.     </dependency>
  26.     <!--freemarker模板引擎-->
  27.     <dependency>
  28.       <groupId>org.freemarker</groupId>
  29.       <artifactId>freemarker</artifactId>
  30.       <version>2.3.23</version>
  31.     </dependency>
  32.     <!--spring核心模块core主要的功能是实现了控制反转与依赖注入、Bean配置以及加载。Core模块中有Beans、BeanFactory、BeanDefinitions、ApplicationContext等概念-->
  33.     <dependency>
  34.       <groupId>org.springframework</groupId>
  35.       <artifactId>spring-core</artifactId>
  36.       <version>${spring.version}</version>
  37.     </dependency>
  38.     <!--Spring ApplicationContext特性时所需的全部类-->
  39.     <dependency>
  40.       <groupId>org.springframework</groupId>
  41.       <artifactId>spring-context</artifactId>
  42.       <version>${spring.version}</version>
  43.     </dependency>
  44.     <!--这个jar文件包含支持缓存Cache（ehcache）、JCA、JMX、邮件服务（Java Mail、COS Mail）、任务计划Scheduling（Timer、Quartz）方面的类-->
  45.     <dependency>
  46.       <groupId>org.springframework</groupId>
  47.       <artifactId>spring-context-support</artifactId>
  48.       <version>${spring.version}</version>
  49.     </dependency>
  50.     <!--springmvc -->
  51.     <dependency>
  52.       <groupId>org.springframework</groupId>
  53.       <artifactId>spring-webmvc</artifactId>
  54.       <version>${spring.version}</version>
  55.     </dependency>
  56.     <dependency>
  57.       <groupId>org.springframework</groupId>
  58.       <artifactId>spring-aop</artifactId>
  59.       <version>${spring.version}</version>
  60.     </dependency>
  61.     <dependency>
  62.       <groupId>org.springframework</groupId>
  63.       <artifactId>spring-aspects</artifactId>
  64.       <version>${spring.version}</version>
  65.     </dependency>
  66.     <dependency>
  67.       <groupId>org.springframework</groupId>
  68.       <artifactId>spring-beans</artifactId>
  69.       <version>${spring.version}</version>
  70.     </dependency>
  71.     <dependency>
  72.       <groupId>org.springframework</groupId>
  73.       <artifactId>spring-jdbc</artifactId>
  74.       <version>${spring.version}</version>
  75.     </dependency>
  76.     <!-- 核心开发包end-->
  78.     <!-- log4j-->
  79.     <dependency>
  80.       <groupId>log4j</groupId>
  81.       <artifactId>log4j</artifactId>
  82.       <version>1.2.14</version>
  83.     </dependency>
  84.     <!-- mybatis包-->
  85.     <dependency>
  86.       <groupId>commons-dbcp</groupId>
  87.       <artifactId>commons-dbcp</artifactId>
  88.       <version>1.4</version>
  89.     </dependency>
  90.     <dependency>
  91.       <groupId>org.mybatis</groupId>
  92.       <artifactId>mybatis</artifactId>
  93.       <version>3.3.1</version>
  94.     </dependency>
  95.     <!--mybatis spring插件-->
  96.     <dependency>
  97.       <groupId>org.mybatis</groupId>
  98.       <artifactId>mybatis-spring</artifactId>
  99.       <version>1.2.4</version>
  100.     </dependency>
  101.     <!-- mysql连接驱动包-->
  102.     <dependency>
  103.       <groupId>mysql</groupId>
  104.       <artifactId>mysql-connector-java</artifactId>
  105.       <version>5.1.26</version>
  106.     </dependency>
  107.     <!-- 连接池-->
  108.     <dependency>
  109.       <groupId>c3p0</groupId>
  110.       <artifactId>c3p0</artifactId>
  111.       <version>0.9.1.2</version>
  112.     </dependency>
  113.   </dependencies>
  114.   <build>
  115.     <finalName>SpringMvc</finalName>
  116.     <plugins>
  117.       <!--内置jetty服务器插件-->
  118.       <plugin>
  119.         <groupId>org.eclipse.jetty</groupId>
  120.         <artifactId>jetty-maven-plugin</artifactId>
  121.         <version>9.3.7.v20160115</version>
  122.         <configuration>
  123.           <!-- 扫描秒数，若非0则为热部署-->
  124.           <scanIntervalSeconds>0</scanIntervalSeconds>
  125.           <reload>automatic</reload>
  126.           <stopPort>19966</stopPort>
  127.           <stopKey>foo</stopKey>
  128.           <stopWait>10</stopWait>
  129.           <webApp>
  130.             <!-- 项目根目录-->
  131.             <contextPath>/</contextPath>
  132.           </webApp>
  133.           <httpConnector>
  134.             <!-- 服务器端口号-->
  135.             <port>19090</port>
  136.             <idleTimeout>60000</idleTimeout>
  137.           </httpConnector>
  138.           <!-- 请求log-->
  139.           <requestLog implementation="org.eclipse.jetty.server.NCSARequestLog">
  140.             <!-- log输出目录-->
  141.             <filename>target/yyyy_mm_dd.request.log</filename>
  142.             <!--<filenameDateformat>yyyy_MM_dd</filenameDateformat>-->
  143.             <!-- log保存天数-->
  144.             <retainDays>90</retainDays>
  145.             <!-- log是否附加在文件后-->
  146.             <append>true</append>
  147.             <extended>false</extended>
  148.             <!-- 时区-->
  149.             <logTimeZone>GMT+8:00</logTimeZone>
  150.           </requestLog>
  151.         </configuration>
  152.       </plugin>
  154.       <!--内置Tomcat7服务器插件-->
  155.       <plugin>
  156.         <groupId>org.apache.tomcat.maven</groupId>
  157.         <artifactId>tomcat7-maven-plugin</artifactId>
  158.         <version>2.2</version>
  159.         <configuration>
  160.           <url>http://localhost:8080/manager/text</url> <!-- tomcat管理路径 -->
  161.           <server>Tomcat7</server> <!-- 与settings.xml文件中Server的id相同 -->
  162.           <path>/</path> <!-- 应用的部署位置 -->
  163.         </configuration>
  164.       </plugin>
  167.       <!--mybatis-generator数据表自动生成-->
  168.       <plugin>
  169.         <groupId>org.mybatis.generator</groupId>
  170.         <artifactId>mybatis-generator-maven-plugin</artifactId>
  171.         <version>1.3.5</version>
  172.         <dependencies>
  173.           <dependency>
  174.             <groupId> mysql</groupId>
  175.             <artifactId>mysql-connector-java</artifactId>
  176.             <version>5.1.26</version>
  177.           </dependency>
  178.           <dependency>
  179.             <groupId>org.mybatis.generator</groupId>
  180.             <artifactId>mybatis-generator-core</artifactId>
  181.             <version>1.3.5</version>
  182.           </dependency>
  183.         </dependencies>
  184.         <configuration>
  185.           <!--允许移动生成的文件 -->
  186.           <verbose>true</verbose>
  187.           <!-- 是否覆盖 -->
  188.           <overwrite>true</overwrite>
  189.           <!-- 自动生成的配置 -->
  190.           <configurationFile>
  191.             src/main/resources/mybatis/generatorConfig.xml</configurationFile>
  192.         </configuration>
  193.       </plugin>
  194.     </plugins>
  195.   </build>
  196. </project>

引入了内置服务器 jetty 和 Tomcat7 当然也支持自己配置Tomcat

新建freemarker.properties

  1. tag_syntax=auto_detect
  2. template_update_delay=60  
  3. #  //模板更新时间
  4. default_encoding=UTF-8 
  5. #  //默认编码
  6. output_encoding=UTF-8 
  7. #  //输出编码
  8. locale=zh_CN 
  9. #  //使用语言
  10. date_format=yyyy-MM-dd
  11. time_format=HH:mm:ss
  12. datetime_format=yyyy-MM-dd HH:mm:ss
  13. number_format=0.##########
  14. classic_compatible=true
  15. template_exception_handler=ignore
  16. #   //模板类型处理

新建log4j.properties

  1. ##define output style
  2. ConversionPattern=%d %-5p [%t] %c - %m%n
  3. log4j.rootLogger=DEBUG,Console,D,E
  4. log4j.logger.com.cnblogs.lzrabbit=ERROR
  5. log4j.logger.org.springframework=ERROR
  6. log4j.logger.org.mybatis=DEBUG
  7. log4j.logger.org.apache.ibatis=ERROR
  8. log4j.logger.org.quartz=ERROR
  9. log4j.logger.org.apache.axis2=ERROR
  10. log4j.logger.org.apache.axiom=ERROR
  11. log4j.logger.org.apache=ERROR
  12. log4j.logger.httpclient=ERROR
  13. #log4j.additivity.org.springframework=false
  14. #Console
  15. log4j.appender.Console=org.apache.log4j.ConsoleAppender
  16. log4j.appender.Console.Threshold=DEBUG 
  17. log4j.appender.Console.Target=System.out 
  18. log4j.appender.Console.layout=org.apache.log4j.PatternLayout 
  19. log4j.appender.Console.layout.ConversionPattern=${ConversionPattern}
  20. #log4j.appender.Console.encoding=UTF-8
  22. #org.apache.log4j.DailyRollingFileAppender
  23. log4j.appender.D=org.apache.log4j.DailyRollingFileAppender
  24. log4j.appender.D.File = D://logs/log.log
  25. log4j.appender.D.Append = true
  26. log4j.appender.D.Threshold = DEBUG
  27. log4j.appender.D.layout = org.apache.log4j.PatternLayout
  28. log4j.appender.D.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss}  [ %t:%r:%l ] - [ %p ]  %m%n
  30. #    %c 输出日志信息所属的类的全名
  31. #    %d 输出日志时间点的日期或时间，默认格式为ISO8601，也可以在其后指定格式，比如：%d{yyy-MM-dd HH:mm:ss}，
  32. #      输出类似：2016-03-10 22:10:11
  33. #    %f 输出日志信息所属的类的类名
  34. #    %l 输出日志事件的发生位置，即输出日志信息的的语句处于它所在的类的第几行
  35. #    %m 输出代码中指定的信息，如log(message)中的message
  36. #    %n 输出一个回车换行符，Windows平台为"rn",Unix平台为"n"
  37. #    %p 输出优先级，即DEBUG.INFO,WARN,ERROR,FATAL.如果是调用debug()输出的，则为DEBUG,以此类推
  38. #    %r 输出自应用启动到输出该日志信息所耗费的毫秒数
  39. #    %t 输出产生该日志的线程名

新建 jdbc.properties

  1. #============================================================================
  2. # MySQL
  3. #============================================================================
  4. jdbc.mysql.driver=com.mysql.jdbc.Driver
  5. jdbc.mysql.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8
  6. jdbc.mysql.username=liuzhiqiang
  7. jdbc.mysql.password=lzq199528
  9. #============================================================================
  10. # MS SQL Server
  11. #============================================================================
  12. #jdbc.sqlserver.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
  13. #jdbc.sqlserver.url=jdbc:sqlserver://127.0.0.1:1433;database=angular-demo;
  14. #jdbc.sqlserver.username=root
  15. #jdbc.sqlserver.password=root
  17. #============================================================================
  18. # ORACLE
  19. #============================================================================
  20. jdbc.orcl.driver=oracle.jdbc.OracleDriver
  21. jdbc.orcl.url=jdbc:oracle:thin:@localhost:1526:angular-demo
  22. jdbc.orcl.username=root
  23. jdbc.orcl.password=root
  25. #============================================================================
  26. # common settings
  27. #============================================================================
  28. jdbc.initialSize=5
  29. jdbc.minIdle=5
  30. jdbc.maxIdle=20
  31. jdbc.maxActive=100
  32. jdbc.maxWait=100000
  33. jdbc.defaultAutoCommit=false
  34. jdbc.removeAbandoned=true
  35. jdbc.removeAbandonedTimeout=600
  36. jdbc.testWhileIdle=true
  37. jdbc.timeBetweenEvictionRunsMillis=60000
  38. jdbc.numTestsPerEvictionRun=20
  39. jdbc.minEvictableIdleTimeMillis=300000

新建spring-mvc.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.        xmlns:mvc="http://www.springframework.org/schema/mvc"
  5.        xmlns:context="http://www.springframework.org/schema/context"
  6.        xsi:schemaLocation="
  7.        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
  8.        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
  9.        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">
  11.     <!-- 启动Spring MVC的注解功能，完成请求和注解POJO的映射 -->
  12.     <mvc:annotation-driven />
  13.     <!--自动扫描-->
  14.     <context:component-scan base-package="com.liuzhiqiang.controller" />
  15.     <!-- 解决js,css,images访问不到的问题-->
  16.     <mvc:resources mapping="/js/**" location="/js/" />
  17.     <mvc:resources mapping="/css/**" location="/css/" />
  18.     <mvc:resources mapping="/images/**" location="/images/" />
  20.     <!-- 视图解析器 -->
  21.     <bean id="freemarkerConfiguration"
  22.           class="org.springframework.beans.factory.config.PropertiesFactoryBean">
  23.         <property name="location" value="classpath:config/freemarker.properties" />
  24.     </bean>
  26.     <bean id="freemarkerConfig"
  27.           class="org.springframework.web.servlet.view.freemarker.FreeMarkerConfigurer">
  28.         <property name="freemarkerSettings" ref="freemarkerConfiguration" />
  29.         <property name="templateLoaderPath">
  30.             <value>/WEB-INF/templates</value>
  31.         </property>
  32.         <property name="freemarkerVariables">
  33.             <map>
  34.                 <entry key="xml_escape" value-ref="fmXmlEscape" />
  35.             </map>
  36.         </property>
  37.         <property name="defaultEncoding">
  38.             <value>utf-8</value>
  39.         </property>
  40.     </bean>
  41.     <bean id="fmXmlEscape" class="freemarker.template.utility.XmlEscape" />
  43.     <!-- 配置freeMarker视图解析器 -->
  44.     <bean
  45.             class="org.springframework.web.servlet.view.freemarker.FreeMarkerViewResolver">
  46.         <property name="viewClass"
  47.                   value="org.springframework.web.servlet.view.freemarker.FreeMarkerView" />
  48.         <property name="contentType" value="text/html; charset=utf-8" />
  49.         <property name="suffix" value=".ftl" />
  50.         <property name="order" value="0" />
  51.     </bean>
  52. </beans>

新建applicationContext.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.        xmlns:aop="http://www.springframework.org/schema/aop"
  5.        xmlns:tx="http://www.springframework.org/schema/tx" xmlns:context="http://www.springframework.org/schema/context"
  6.        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
  7.        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd
  8.        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">
  10.     <!-- 引入文件属性 -->
  11.     <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
  12.         <property name="location" value="classpath:config/jdbc.properties"/>
  13.     </bean>
  15.     <!-- sqlServer数据源-->
  16.     <!--<bean id="sqlServerDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">-->
  17.         <!--<property name="driverClassName" value="${jdbc.sqlserver.driver}"/>-->
  18.         <!--<property name="url" value="${jdbc.sqlserver.url}"/>-->
  19.         <!--<property name="username" value="${jdbc.sqlserver.username}"/>-->
  20.         <!--<property name="password" value="${jdbc.sqlserver.password}"/>-->
  21.         <!--<property name="initialSize" value="${jdbc.initialSize}"/>-->
  22.         <!--<property name="minIdle" value="${jdbc.minIdle}"/>-->
  23.         <!--<property name="maxIdle" value="${jdbc.maxIdle}"/>-->
  24.         <!--<property name="maxActive" value="${jdbc.maxActive}"/>-->
  25.         <!--<property name="maxWait" value="${jdbc.maxWait}"/>-->
  26.         <!--<property name="defaultAutoCommit" value="${jdbc.defaultAutoCommit}"/>-->
  27.         <!--<property name="removeAbandoned" value="${jdbc.removeAbandoned}"/>-->
  28.         <!--<property name="removeAbandonedTimeout" value="${jdbc.removeAbandonedTimeout}"/>-->
  29.         <!--<property name="testWhileIdle" value="${jdbc.testWhileIdle}"/>-->
  30.         <!--<property name="timeBetweenEvictionRunsMillis" value="${jdbc.timeBetweenEvictionRunsMillis}"/>-->
  31.         <!--<property name="numTestsPerEvictionRun" value="${jdbc.numTestsPerEvictionRun}"/>-->
  32.         <!--<property name="minEvictableIdleTimeMillis" value="${jdbc.minEvictableIdleTimeMillis}"/>-->
  33.     <!--</bean>-->
  35.     <!-- mysql数据源-->
  36.     <bean id="mySqlDataSource" class="org.apache.commons.dbcp.BasicDataSource"
  37.           destroy-method="close">
  38.         <property name="driverClassName" value="${jdbc.mysql.driver}"/>
  39.         <property name="url" value="${jdbc.mysql.url}"/>
  40.         <property name="username" value="${jdbc.mysql.username}"/>
  41.         <property name="password" value="${jdbc.mysql.password}"/>
  42.         <property name="initialSize" value="${jdbc.initialSize}"/>
  43.         <property name="minIdle" value="${jdbc.minIdle}"/>
  44.         <property name="maxIdle" value="${jdbc.maxIdle}"/>
  45.         <property name="maxActive" value="${jdbc.maxActive}"/>
  46.         <property name="maxWait" value="${jdbc.maxWait}"/>
  47.         <property name="defaultAutoCommit" value="${jdbc.defaultAutoCommit}"/>
  48.         <property name="removeAbandoned" value="${jdbc.removeAbandoned}"/>
  49.         <property name="removeAbandonedTimeout" value="${jdbc.removeAbandonedTimeout}"/>
  50.         <property name="testWhileIdle" value="${jdbc.testWhileIdle}"/>
  51.         <property name="timeBetweenEvictionRunsMillis" value="${jdbc.timeBetweenEvictionRunsMillis}"/>
  52.         <property name="numTestsPerEvictionRun" value="${jdbc.numTestsPerEvictionRun}"/>
  53.         <property name="minEvictableIdleTimeMillis" value="${jdbc.minEvictableIdleTimeMillis}"/>
  54.     </bean>
  56.     <!-- 数据源选择，targetDataSources中选择数据源，若找不到，则使用defaultTargetDataSource-->
  57.     <bean id="multipleDataSource" class="com.liuzhiqiang.config.MultipleDataSource">
  58.         <property name="defaultTargetDataSource" ref="mySqlDataSource"/>
  59.         <property name="targetDataSources">
  60.             <map>
  61.                 <entry key="mySqlDataSource" value-ref="mySqlDataSource"/>
  62.                 <!--<entry key="sqlServerDataSource" value-ref="sqlServerDataSource"/>-->
  63.             </map>
  64.         </property>
  65.     </bean>
  67.     <!-- 配置mybatis的sqlSessionFactory -->
  68.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  69.         <property name="dataSource" ref="multipleDataSource" />
  70.         <!-- mybatis配置文件 -->
  71.         <property name="configLocation" value="classpath:config/mybatis-config.xml"></property>
  72.         <!-- 自动扫描mappers.xml文件 ，要加上classpath:com/...-->
  73.         <property name="mapperLocations" value="classpath:mappers/*.xml"></property>
  74.     </bean>
  76.     <!-- DAO接口所在包名，Spring会自动查找其下的类 -->
  77.     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  78.         <property name="basePackage" value="com.liuzhiqiang.dao" />
  79.         <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
  80.     </bean>
  82.     <!-- (事务管理)transaction manager, use JtaTransactionManager for global tx -->
  83.     <bean id="transactionManager"
  84.           class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  85.         <property name="dataSource" ref="mySqlDataSource" />
  86.     </bean>
  88.     <!-- 配置事务通知属性 -->
  89.     <tx:advice id="txAdvice" transaction-manager="transactionManager">
  90.         <!-- 定义事务传播属性 -->
  91.         <tx:attributes>
  92.             <tx:method name="insert*" propagation="REQUIRED" />
  93.             <tx:method name="update*" propagation="REQUIRED" />
  94.             <tx:method name="edit*" propagation="REQUIRED" />
  95.             <tx:method name="save*" propagation="REQUIRED" />
  96.             <tx:method name="add*" propagation="REQUIRED" />
  97.             <tx:method name="new*" propagation="REQUIRED" />
  98.             <tx:method name="set*" propagation="REQUIRED" />
  99.             <tx:method name="remove*" propagation="REQUIRED" />
  100.             <tx:method name="delete*" propagation="REQUIRED" />
  101.             <tx:method name="change*" propagation="REQUIRED" />
  102.             <tx:method name="get*" propagation="REQUIRED" read-only="true" />
  103.             <tx:method name="find*" propagation="REQUIRED" read-only="true" />
  104.             <tx:method name="load*" propagation="REQUIRED" read-only="true" />
  105.             <tx:method name="*" propagation="REQUIRED" read-only="true" />
  106.         </tx:attributes>
  107.     </tx:advice>
  109.     <!-- 配置事务切面 -->
  110.     <aop:config>
  111.         <aop:pointcut id="serviceOperation"
  112.                       expression="execution(* com.liuzhiqiang.controller.*.*(..))" />
  113.         <aop:advisor advice-ref="txAdvice" pointcut-ref="serviceOperation" />
  114.     </aop:config>
  115. </beans>

新建mybatis-config.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE configuration PUBLIC
  3.         "-//mybatis.org//DTD Config 3.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
  5. <configuration>
  6.     <settings>
  7.         <!-- setting name="cacheEnable" value="true"/-->
  8.         <setting name="useGeneratedKeys" value="false"/>
  9.         <setting name="logImpl" value="LOG4J"/><!--增加mybatis日志-->
  10.     </settings>
  11.     <mappers>
  12.     </mappers>
  13. </configuration>

新建generatorConfig.xml 数据库映射出dao xml等

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE generatorConfiguration
  3.         PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
  5. <generatorConfiguration>
  6.     <context id="MysqlContext" targetRuntime="MyBatis3" defaultModelType="flat">
  7.         <property name="beginningDelimiter" value="`"/>
  8.         <property name="endingDelimiter" value="`"/>
  10.         <commentGenerator>
  11.             <property name="suppressDate" value="true"/>
  12.         </commentGenerator>
  14.         <jdbcConnection driverClass="com.mysql.jdbc.Driver"
  15.                         connectionURL="jdbc:mysql://localhost:3306/test"
  16.                         userId="liuzhiqiang"
  17.                         password="lzq199528">
  18.         </jdbcConnection>
  20.         <javaModelGenerator targetPackage="com.liuzhiqiang.model" targetProject="src\main\java">
  21.             <property name="trimStrings" value="true" />
  22.         </javaModelGenerator>
  24.         <sqlMapGenerator targetPackage="mappers"  targetProject="src\main\resources"/>
  26.         <javaClientGenerator type="XMLMAPPER" targetPackage="com.liuzhiqiang.dao"  targetProject="src\main\java"/>
  28.         <table tableName="%">
  29.             <generatedKey column="id" sqlStatement="Mysql"/>
  30.         </table>
  31.     </context>
  32. </generatorConfiguration>

到此配置完毕

项目地址:
https://github.com/2425358736/ProjectPackage/tree/master/SpringMvc

发表评论

表情：
评论列表 （有 0 条评论，305人围观）

还没有评论，来说两句吧...

相关阅读

    相关 SSM框架搭建

     自己配置了一个SSM框架，打算做个小网站，这里把SSM的配置流程详细的写了出来，方便很少接触这个框架的朋友使用，文中各个资源均免费提供！（后续读写分离：[https://bl

    秒速五厘米秒速五厘米/ 0 赞/ 476 阅读