mybatis配置

mybatis引入配置

<?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:context="http://www.springframework.org/schema/context"xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsdhttp://www.springframework.org/schema/context    http://www.springframework.org/schema/context/spring-context-2.5.xsd"><!-- 加载配置文件 --><context:property-placeholder location="classpath:jdbc.properties"/><bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">          <property name="driverClassName">             <value>${jdbc.default.driverClassName}</value>          </property>          <property name="url">              <value>${jdbc.default.url}</value>          </property>          <property name="username">              <value>${jdbc.default.username}</value>          </property>          <property name="password">              <value>${jdbc.default.password}</value>          </property>          <property name="maxActive">              <value>255</value>          </property>          <property name="maxIdle">              <value>2</value>          </property>          <property name="maxWait">              <value>120000</value>          </property>      </bean>          <bean name="dataSourceMybatis" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close"><property name="url" value="${jdbc.default.url}" /><property name="username" value="${jdbc.default.username}" /><property name="password" value="${jdbc.default.password}" /></bean><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSourceMybatis" /><property name="mapperLocations" value="classpath:sqlmap/*" /></bean><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="basePackage" value="com.hongjia.mis.oracle.database.mybatis.dao" /><property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" /></bean></beans>

注意：

<property name="mapperLocations" value="classpath:sqlmap/*" />

<property name="basePackage" value="com.hongjia.mis.oracle.database.mybatis.dao" />

自动生成model、dao、mapper.xml的文件配置：generatorConfig.xml

<?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><!-- classPathEntry:数据库的JDBC驱动的jar包地址-->     <classPathEntry location="D:\SVN\mis-20170829\realease_02\hongjia-mis-webservice-pojo\lib\ojdbc7.jar" /><context id="MysqlTables" targetRuntime="MyBatis3"><!-- 注释 -->  <commentGenerator><property name="suppressAllComments" value="true"/> <!-- 是否取消注释 --> <property name="suppressDate" value="true" /> <!-- 是否生成注释代时间戳-->  </commentGenerator><!-- JDBC连接 -->  <jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver" connectionURL="jdbc:oracle:thin:@10.1.2.101:1521:misdev"userId="ecology"password="ecology"></jdbcConnection><!-- 类型转换 -->  <javaTypeResolver ><!-- 是否使用bigDecimal， false可自动转化以下类型（Long, Integer, Short, etc.） -->  <property name="forceBigDecimals" value="false" /></javaTypeResolver><!-- 生成实体类地址 -->    <javaModelGenerator targetPackage="com.hongjia.mis.oracle.database.mybatis.pojo" targetProject="D:\SVN\mis-20170829\realease_02\hongjia-mis-webservice-pojo\src\main\java"><property name="enableSubPackages" value="true" /> <!-- 是否在当前路径下新加一层--><property name="trimStrings" value="true" /> <!-- 是否针对string类型的字段在set的时候进行trim调用 --></javaModelGenerator><!-- 生成MAPXML文件 --><sqlMapGenerator targetPackage="sqlmap"  targetProject="D:\SVN\mis-20170829\realease_02\hongjia-mis-webservice-pojo\src\main\resources"><property name="enableSubPackages" value="false" /> <!-- 是否在当前路径下新加一层--></sqlMapGenerator><!-- 生成DAO -->      <javaClientGenerator type="XMLMAPPER" targetPackage="com.hongjia.mis.oracle.database.mybatis.dao"  targetProject="D:\SVN\mis-20170829\realease_02\hongjia-mis-webservice-pojo\src\main\java"><property name="enableSubPackages" value="true" /> <!-- 是否在当前路径下新加一层--></javaClientGenerator><!-- 配置表信息 java -jar D:\SVN\mis-20170829\realease_02\hongjia-mis-webservice-pojo\lib\mybatis-generator-core-1.3.2.jar -configfile D:\SVN\mis-20170829\realease_02\hongjia-mis-webservice-pojo\src\main\resources\generatorConfig.xml -overwrite--><table schema="" tableName="formtable_main_198"   enableCountByExample="true"    enableUpdateByExample="true"    enableDeleteByExample="true"    enableSelectByExample="true"    selectByExampleQueryId="true" ></table></context></generatorConfiguration>