mybatis(一)
1. Mybatis配置
1.1mybatis-config.xml
db.properties引用下列文件
1.2db.properties
配置数据库连接参数
1.3pom.xml依赖包配置
1 <dependency> 2 3 <groupId>org.mybatis</groupId> 4 5 <artifactId>mybatis</artifactId> 6 7 <version>3.4.4</version> 8 9 </dependency> 10 11 <dependency> 12 13 <groupId>mysql</groupId> 14 15 <artifactId>mysql-connector-java</artifactId> 16 17 <version>5.1.18</version> 18 19 </dependency> 20 21 22 23 <dependency> 24 25 <groupId>org.slf4j</groupId> 26 27 <artifactId>slf4j-api</artifactId> 28 29 <version>1.7.25</version> 30 31 </dependency> 32 33 <dependency> 34 35 <groupId>org.slf4j</groupId> 36 37 <artifactId>slf4j-log4j12</artifactId> 38 39 <version>1.7.25</version> 40 41 <scope>runtime</scope> 42 43 </dependency> 44 45 <dependency> 46 47 <groupId>log4j</groupId> 48 49 <artifactId>log4j</artifactId> 50 51 <version>1.2.17</version> 52 53 <scope>runtime</scope> 54 55 </dependency> 56 57 <dependency> 58 59 <groupId>junit</groupId> 60 61 <artifactId>junit</artifactId> 62 63 <version>4.11</version> 64 65 <scope>test</scope> 66 67 </dependency>
1.4Log4j.properties配置
log4j.rootLogger=DEBUG, stdout
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d [%-5p] %c - %m%n
2. 测试案例(向数据库中插入一列数据)
2.1 创建xml映射文件,sql语句在这写
(1) namspace指向包和文件名
(2) insert标签里面有id(等下要用),paramerType指向要插入的类型
(3) #{}括号里面的值要与pojo里面的变量一样
2.2配置文件里面加载映射文件资源
2.3重要步骤