1.Mybatis
配置文件
<?xmlversion="1.0"encoding="UTF-8"?>
<!DOCTYPEconfiguration
PUBLIC"-//mybatis.org//DTDConfig3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<environmentsdefault="development">
<environmentid="development">
<transactionManagertype="JDBC"/>
<dataSourcetype="POOLED">
<propertyname="driver"value="com.mysql.jdbc.Driver"/>
<propertyname="url"value="jdbc:mysql://127.0.0.1:3306/mp?useUnicode=true&characterEncoding=utf8&autoReconnect=true&allowMultiQueries=true&useSSL=false"/>
<propertyname="username"value="root"/>
<propertyname="password"value="root"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapperresource="UserMapper.xml"/>
</mappers>
</configuration>
映射文件
<?xmlversion="1.0"encoding="UTF-8"?>
<!DOCTYPEmapper
PUBLIC"-//mybatis.org//DTDMapper3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mappernamespace="cn.itcast.mp.simple.mapper.UserMapper">
<selectid="findAll"resultType="cn.itcast.mp.simple.pojo.User">
select*fromtb_user
</select>
</mapper>
2.log4j配置文件
log4j.rootLogger=DEBUG,A1
log4j.appender.A1=org.apache.log4j.ConsoleAppender
log4j.appender.A1.layout=org.apache.log4j.PatternLayout
log4j.appender.A1.layout.ConversionPattern=[%t][%c]-[%p]%m%n
3.jdbc配置文件
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/mp?useUnicode=true&characterEncoding=utf8&autoReconnect=true&allowMultiQueries=true&useSSL=false
jdbc.username=root
jdbc.password=root
4.springboot+mybatisPlus
spring:
main:
allow-bean-definition-overriding:true
datasource:
druid:
driver-class-name:com.mysql.jdbc.Driver
username:root
password:123456
url:jdbc:mysql://localhost:3306/fy-exam?useUnicode=true&characterEncoding=utf8&useSSL=false
max-active:60#连接池配置
profiles:
active:dev
jackson:
date-format:yyyy-MM-ddHH:mm:ss
time-zone:Asia/Chongqing
#配置mybatis-plus
mybatis-plus:
configuration:
map-underscore-to-camel-case:true
log-impl:org.apache.ibatis.logging.stdout.StdOutImpl#输出sql语句
mapper-locations:classpath*:/mappers/**/*.xml
type-aliases-package:com.fy.qu.entity
server:
port:8181
qiniu:
ak:Gii1Dxz9Oyx_6rYzyRyN772MWeKuezz0TwJhj7X4
sk:H5jGCYTZBeqVA7LGFysO2_bz5RoS0p9g9gsSxRD_
bucket:jerryzoom
host:http://rdxa8zljl.hn-bkt.clouddn.com
5.springboot+mybaits
#配置数据源
spring:
datasource:
driver-class-name: com.mysql.jdbc.Driver
username: root
password: 123456
url: jdbc:mysql://localhost/day424?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
max-active: 60 #连接池配置
#配置mybatis
mybatis:
configuration:
map-underscore-to-camel-case: true #开启驼峰映射