pom
parent
1 <?xml version="1.0" encoding="UTF-8"?> 2 <project xmlns="http://maven.apache.org/POM/4.0.0" 3 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 4 xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> 5 <modelVersion>4.0.0</modelVersion> 6 7 <groupId>com.laolang.mybatisstudy</groupId> 8 <artifactId>mybatisstudy-parent</artifactId> 9 <version>1.0-SNAPSHOT</version> 10 <modules> 11 <module>../mybatisstudy-one</module> 12 </modules> 13 <packaging>pom</packaging> 14 15 16 <!-- 集中定义依赖版本号 --> 17 <properties> 18 <!-- test --> 19 <junit.version>4.10</junit.version> 20 <hamcrest.version>1.3</hamcrest.version> 21 22 23 <!-- java ee --> 24 <javaee-api.version>7.0</javaee-api.version> 25 <servlet-api.version>3.0.1</servlet-api.version> 26 <persistence-api.version>1.0</persistence-api.version> 27 <jstl.version>1.2</jstl.version> 28 <standard.version>1.1.2</standard.version> 29 30 31 <!-- spring --> 32 <spring.version>4.2.0.RELEASE</spring.version> 33 34 <!-- mybatis --> 35 <mybatis.version>3.3.0</mybatis.version> 36 <mybatis.spring.version>1.2.2</mybatis.spring.version> 37 <mybatis.paginator.version>1.2.15</mybatis.paginator.version> 38 <pagehelper.version>4.0.3</pagehelper.version> 39 <tk.mapper.version>3.2.2</tk.mapper.version> 40 41 42 <mysql.version>5.1.38</mysql.version> 43 44 <!-- log --> 45 <slf4j.version>1.7.12</slf4j.version> 46 <logback.version>1.1.3</logback.version> 47 <logback.ext.version>0.1.2</logback.ext.version> 48 49 <!-- json --> 50 <jackson.version>2.4.2</jackson.version> 51 <jackson.mapper.version>1.9.13</jackson.mapper.version> 52 53 <!-- google --> 54 <gson.version>2.2.2</gson.version> 55 <guava.version>18.0</guava.version> 56 57 <!-- alibaba --> 58 <druid.version>1.0.12</druid.version> 59 60 <!-- ehcache --> 61 <ehcache.version>2.7.5</ehcache.version> 62 63 <!-- apache --> 64 <httpclient.version>4.5</httpclient.version> 65 <commons-lang3.version>3.3.2</commons-lang3.version> 66 <commons-io.version>2.5</commons-io.version> 67 <commons-fileupload.version>1.3.2</commons-fileupload.version> 68 <commons-net.version>3.3</commons-net.version> 69 <commons-codec.version>1.9</commons-codec.version> 70 <shiro.version>1.3.2</shiro.version> 71 <activemq-all.version>5.11.2</activemq-all.version> 72 <activemq-core.version>5.7.0</activemq-core.version> 73 <activemq-pool.version>5.11.2</activemq-pool.version> 74 75 <!-- beetl --> 76 <beetl.version>2.7.5</beetl.version> 77 78 <!-- jedis --> 79 <jedis.version>2.6.3</jedis.version> 80 81 <!-- JSR 303 --> 82 <hibernate-validator.version>5.1.3.Final</hibernate-validator.version> 83 <validator-api.version>1.1.0.Final</validator-api.version> 84 85 <joda-time.version>2.5</joda-time.version> 86 <cglib.versoin>3.1</cglib.versoin> 87 88 <quartz.versoin>2.2.1</quartz.versoin> 89 90 <spring-rabbit.version>1.4.0.RELEASE</spring-rabbit.version> 91 </properties> 92 93 <dependencyManagement> 94 <dependencies> 95 <!-- test --> 96 <dependency> 97 <groupId>junit</groupId> 98 <artifactId>junit</artifactId> 99 <version>${junit.version}</version> 100 <scope>test</scope> 101 </dependency> 102 <dependency> 103 <groupId>org.hamcrest</groupId> 104 <artifactId>hamcrest-all</artifactId> 105 <version>${hamcrest.version}</version> 106 <scope>test</scope> 107 </dependency> 108 109 <!-- java ee--> 110 <dependency> 111 <groupId>javax</groupId> 112 <artifactId>javaee-api</artifactId> 113 <version>${javaee-api.version}</version> 114 <scope>provided</scope> 115 </dependency> 116 <dependency> 117 <groupId>javax.servlet</groupId> 118 <artifactId>javax.servlet-api</artifactId> 119 <version>${servlet-api.version}</version> 120 <scope>provided</scope> 121 </dependency> 122 <dependency> 123 <groupId>javax.persistence</groupId> 124 <artifactId>persistence-api</artifactId> 125 <version>1.0</version> 126 </dependency> 127 <dependency> 128 <groupId>jstl</groupId> 129 <artifactId>jstl</artifactId> 130 <version>${jstl.version}</version> 131 </dependency> 132 <dependency> 133 <groupId>taglibs</groupId> 134 <artifactId>standard</artifactId> 135 <version>${standard.version}</version> 136 </dependency> 137 138 <!-- Spring --> 139 <dependency> 140 <groupId>org.springframework</groupId> 141 <artifactId>spring-context</artifactId> 142 <version>${spring.version}</version> 143 </dependency> 144 <dependency> 145 <groupId>org.springframework</groupId> 146 <artifactId>spring-oxm</artifactId> 147 <version>${spring.version}</version> 148 </dependency> 149 <dependency> 150 <groupId>org.springframework</groupId> 151 <artifactId>spring-tx</artifactId> 152 <version>${spring.version}</version> 153 </dependency> 154 <dependency> 155 <groupId>org.springframework</groupId> 156 <artifactId>spring-jdbc</artifactId> 157 <version>${spring.version}</version> 158 </dependency> 159 <dependency> 160 <groupId>org.springframework</groupId> 161 <artifactId>spring-beans</artifactId> 162 <version>${spring.version}</version> 163 </dependency> 164 <dependency> 165 <groupId>org.springframework</groupId> 166 <artifactId>spring-aop</artifactId> 167 <version>${spring.version}</version> 168 </dependency> 169 <dependency> 170 <groupId>org.springframework</groupId> 171 <artifactId>spring-test</artifactId> 172 <version>${spring.version}</version> 173 </dependency> 174 <dependency> 175 <groupId>org.springframework</groupId> 176 <artifactId>spring-aspects</artifactId> 177 <version>${spring.version}</version> 178 </dependency> 179 <dependency> 180 <groupId>org.springframework</groupId> 181 <artifactId>spring-web</artifactId> 182 <version>${spring.version}</version> 183 </dependency> 184 <dependency> 185 <groupId>org.springframework</groupId> 186 <artifactId>spring-webmvc</artifactId> 187 <version>${spring.version}</version> 188 </dependency> 189 <dependency> 190 <groupId>org.springframework</groupId> 191 <artifactId>spring-core</artifactId> 192 <version>${spring.version}</version> 193 </dependency> 194 <dependency> 195 <groupId>org.springframework</groupId> 196 <artifactId>spring-jms</artifactId> 197 <version>${spring.version}</version> 198 </dependency> 199 <dependency> 200 <groupId>org.springframework</groupId> 201 <artifactId>spring-context-support</artifactId> 202 <version>${spring.version}</version> 203 </dependency> 204 205 206 207 <!-- JSR 303 --> 208 <dependency> 209 <groupId>javax.validation</groupId> 210 <artifactId>validation-api</artifactId> 211 <version>${validator-api.version}</version> 212 </dependency> 213 214 <dependency> 215 <groupId>org.hibernate</groupId> 216 <artifactId>hibernate-validator</artifactId> 217 <version>${hibernate-validator.version}</version> 218 </dependency> 219 220 221 <!-- beetl --> 222 <dependency> 223 <groupId>com.ibeetl</groupId> 224 <artifactId>beetl</artifactId> 225 <version>${beetl.version}</version> 226 </dependency> 227 228 <!-- Mybatis --> 229 <dependency> 230 <groupId>org.mybatis</groupId> 231 <artifactId>mybatis</artifactId> 232 <version>${mybatis.version}</version> 233 </dependency> 234 <dependency> 235 <groupId>org.mybatis</groupId> 236 <artifactId>mybatis-spring</artifactId> 237 <version>${mybatis.spring.version}</version> 238 </dependency> 239 <dependency> 240 <groupId>com.github.pagehelper</groupId> 241 <artifactId>pagehelper</artifactId> 242 <version>${pagehelper.version}</version> 243 </dependency> 244 <dependency> 245 <groupId>tk.mybatis</groupId> 246 <artifactId>mapper</artifactId> 247 <version>${tk.mapper.version}</version> 248 </dependency> 249 250 251 <!-- MySql --> 252 <dependency> 253 <groupId>mysql</groupId> 254 <artifactId>mysql-connector-java</artifactId> 255 <version>${mysql.version}</version> 256 </dependency> 257 258 <!-- alibaba --> 259 <dependency> 260 <groupId>com.alibaba</groupId> 261 <artifactId>druid</artifactId> 262 <version>${druid.version}</version> 263 </dependency> 264 265 <!-- Jackson Json处理工具包 --> 266 <dependency> 267 <groupId>org.codehaus.jackson</groupId> 268 <artifactId>jackson-mapper-asl</artifactId> 269 <version>${jackson.mapper.version}</version> 270 </dependency> 271 <dependency> 272 <groupId>com.fasterxml.jackson.core</groupId> 273 <artifactId>jackson-core</artifactId> 274 <version>${jackson.version}</version> 275 </dependency> 276 <dependency> 277 <groupId>com.fasterxml.jackson.core</groupId> 278 <artifactId>jackson-databind</artifactId> 279 <version>${jackson.version}</version> 280 </dependency> 281 <dependency> 282 <groupId>com.fasterxml.jackson.core</groupId> 283 <artifactId>jackson-annotations</artifactId> 284 <version>${jackson.version}</version> 285 </dependency> 286 287 <!-- google --> 288 <dependency> 289 <groupId>com.google.code.gson</groupId> 290 <artifactId>gson</artifactId> 291 <version>${gson.version}</version> 292 </dependency> 293 <dependency> 294 <groupId>com.google.guava</groupId> 295 <artifactId>guava</artifactId> 296 <version>${guava.version}</version> 297 </dependency> 298 299 <!-- ehcache --> 300 <dependency> 301 <groupId>net.sf.ehcache</groupId> 302 <artifactId>ehcache</artifactId> 303 <version>${ehcache.version}</version> 304 </dependency> 305 306 <!-- apache --> 307 <dependency> 308 <groupId>org.apache.commons</groupId> 309 <artifactId>commons-lang3</artifactId> 310 <version>${commons-lang3.version}</version> 311 </dependency> 312 <dependency> 313 <groupId>commons-io</groupId> 314 <artifactId>commons-io</artifactId> 315 <version>${commons-io.version}</version> 316 </dependency> 317 <dependency> 318 <groupId>commons-fileupload</groupId> 319 <artifactId>commons-fileupload</artifactId> 320 <version>${commons-fileupload.version}</version> 321 </dependency> 322 <dependency> 323 <groupId>org.apache.httpcomponents</groupId> 324 <artifactId>httpclient</artifactId> 325 <version>${httpclient.version}</version> 326 </dependency> 327 <dependency> 328 <groupId>commons-net</groupId> 329 <artifactId>commons-net</artifactId> 330 <version>${commons-net.version}</version> 331 </dependency> 332 <dependency> 333 <groupId>commons-codec</groupId> 334 <artifactId>commons-codec</artifactId> 335 <version>${commons-codec.version}</version> 336 </dependency> 337 <!--<dependency>--> 338 <!--<groupId>org.apache.shiro</groupId>--> 339 <!--<artifactId>shiro-core</artifactId>--> 340 <!--<version>${shiro.version}}</version>--> 341 <!--</dependency>--> 342 <!--<dependency>--> 343 <!--<groupId>org.apache.shiro</groupId>--> 344 <!--<artifactId>shiro-web</artifactId>--> 345 <!--<version>${shiro.version}</version>--> 346 <!--</dependency>--> 347 <!--<dependency>--> 348 <!--<groupId>org.apache.shiro</groupId>--> 349 <!--<artifactId>shiro-cas</artifactId>--> 350 <!--<version>${shiro.version}</version>--> 351 <!--</dependency>--> 352 <!--<dependency>--> 353 <!--<groupId>org.apache.shiro</groupId>--> 354 <!--<artifactId>shiro-spring</artifactId>--> 355 <!--<version>${shiro.version}</version>--> 356 <!--</dependency>--> 357 <dependency> 358 <groupId>org.apache.shiro</groupId> 359 <artifactId>shiro-all</artifactId> 360 <version>${shiro.version}</version> 361 </dependency> 362 <!-- 363 会和logback冲突 364 参考：http://blog.csdn.net/carychengzubin/article/details/53326158 365 --> 366 <dependency> 367 <groupId>org.apache.activemq</groupId> 368 <artifactId>activemq-all</artifactId> 369 <version>${activemq-all.version}</version> 370 </dependency> 371 <dependency> 372 <groupId>org.apache.activemq</groupId> 373 <artifactId>activemq-core</artifactId> 374 <version>${activemq-core.version}</version> 375 </dependency> 376 <dependency> 377 <groupId>org.apache.activemq</groupId> 378 <artifactId>activemq-pool</artifactId> 379 <version>${activemq-pool.version}</version> 380 </dependency> 381 382 383 384 385 386 <!-- logback --> 387 <dependency> 388 <groupId>org.slf4j</groupId> 389 <artifactId>slf4j-api</artifactId> 390 <version>${slf4j.version}</version> 391 </dependency> 392 <dependency> 393 <groupId>org.slf4j</groupId> 394 <artifactId>jcl-over-slf4j</artifactId> 395 <version>${slf4j.version}</version> 396 </dependency> 397 <dependency> 398 <groupId>ch.qos.logback</groupId> 399 <artifactId>logback-core</artifactId> 400 <version>${logback.version}</version> 401 </dependency> 402 <dependency> 403 <groupId>ch.qos.logback</groupId> 404 <artifactId>logback-classic</artifactId> 405 <version>${logback.version}</version> 406 </dependency> 407 <dependency> 408 <groupId>org.logback-extensions</groupId> 409 <artifactId>logback-ext-spring</artifactId> 410 <version>${logback.ext.version}</version> 411 </dependency> 412 413 414 <!-- 时间操作组件 --> 415 <dependency> 416 <groupId>joda-time</groupId> 417 <artifactId>joda-time</artifactId> 418 <version>${joda-time.version}</version> 419 </dependency> 420 421 <!-- jedis --> 422 <dependency> 423 <groupId>redis.clients</groupId> 424 <artifactId>jedis</artifactId> 425 <version>${jedis.version}</version> 426 </dependency> 427 428 <!-- 动态代理 --> 429 <dependency> 430 <groupId>cglib</groupId> 431 <artifactId>cglib</artifactId> 432 <version>${cglib.versoin}</version> 433 </dependency> 434 435 <!-- quartz --> 436 <dependency> 437 <groupId>org.quartz-scheduler</groupId> 438 <artifactId>quartz</artifactId> 439 <version>${quartz.versoin}</version> 440 </dependency> 441 442 <!-- RabbitMQ --> 443 <dependency> 444 <groupId>org.springframework.amqp</groupId> 445 <artifactId>spring-rabbit</artifactId> 446 <version>${spring-rabbit.version}</version> 447 </dependency> 448 449 450 </dependencies> 451 </dependencyManagement> 452 453 <build> 454 <finalName>${project.artifactId}</finalName> 455 456 <resources> 457 <resource> 458 <directory>src/main/java</directory> 459 <includes> 460 <include>**/*.xml</include> 461 </includes> 462 </resource> 463 <resource> 464 <directory>src/main/reources</directory> 465 <includes> 466 <include>**/*.xml</include> 467 </includes> 468 </resource> 469 </resources> 470 <plugins> 471 <!-- 资源文件拷贝插件 --> 472 <plugin> 473 <groupId>org.apache.maven.plugins</groupId> 474 <artifactId>maven-resources-plugin</artifactId> 475 <version>2.7</version> 476 <configuration> 477 <encoding>UTF-8</encoding> 478 </configuration> 479 </plugin> 480 <!-- java编译插件 --> 481 <plugin> 482 <groupId>org.apache.maven.plugins</groupId> 483 <artifactId>maven-compiler-plugin</artifactId> 484 <version>3.2</version> 485 <configuration> 486 <source>1.7</source> 487 <target>1.7</target> 488 <encoding>UTF-8</encoding> 489 </configuration> 490 </plugin> 491 </plugins> 492 <pluginManagement> 493 <plugins> 494 <!-- 配置Tomcat插件 --> 495 <plugin> 496 <groupId>org.apache.tomcat.maven</groupId> 497 <artifactId>tomcat7-maven-plugin</artifactId> 498 <version>2.2</version> 499 </plugin> 500 <!-- 运行 java 类 --> 501 <!-- 必须先使用 mvc compile 编译 --> 502 <!-- mvn exec:java --> 503 <plugin> 504 <groupId>org.codehaus.mojo</groupId> 505 <artifactId>exec-maven-plugin</artifactId> 506 <version>1.4.0</version> 507 </plugin> 508 </plugins> 509 </pluginManagement> 510 </build> 511 512 513 </project>
项目pom
1 <?xml version="1.0" encoding="UTF-8"?> 2 <project xmlns="http://maven.apache.org/POM/4.0.0" 3 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 4 xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> 5 <parent> 6 <artifactId>mybatisstudy-parent</artifactId> 7 <groupId>com.laolang.mybatisstudy</groupId> 8 <version>1.0-SNAPSHOT</version> 9 <relativePath>../mybatisstudy-parent/pom.xml</relativePath> 10 </parent> 11 <modelVersion>4.0.0</modelVersion> 12 13 <artifactId>mybatisstudy-one</artifactId> 14 15 <dependencies> 16 <!-- test --> 17 <dependency> 18 <groupId>junit</groupId> 19 <artifactId>junit</artifactId> 20 <scope>test</scope> 21 </dependency> 22 <dependency> 23 <groupId>org.hamcrest</groupId> 24 <artifactId>hamcrest-all</artifactId> 25 <scope>test</scope> 26 </dependency> 27 28 <!-- logback --> 29 <dependency> 30 <groupId>org.slf4j</groupId> 31 <artifactId>slf4j-api</artifactId> 32 </dependency> 33 <dependency> 34 <groupId>org.slf4j</groupId> 35 <artifactId>jcl-over-slf4j</artifactId> 36 </dependency> 37 <dependency> 38 <groupId>ch.qos.logback</groupId> 39 <artifactId>logback-core</artifactId> 40 </dependency> 41 <dependency> 42 <groupId>ch.qos.logback</groupId> 43 <artifactId>logback-classic</artifactId> 44 </dependency> 45 46 <!-- MySql --> 47 <dependency> 48 <groupId>mysql</groupId> 49 <artifactId>mysql-connector-java</artifactId> 50 </dependency> 51 52 <!-- Mybatis --> 53 <dependency> 54 <groupId>org.mybatis</groupId> 55 <artifactId>mybatis</artifactId> 56 </dependency> 57 58 </dependencies> 59 60 61 </project>
包结构
E:\code\idea\mybatis-study\mybatisstudy-one\src>tree /f
卷 code 的文件夹 PATH 列表
卷序列号为 349E-A444
E:.
├─main
│ ├─java
│ │ └─com
│ │ └─laolang
│ │ └─mybatisstudy
│ │ └─one
│ │ └─domain
│ │ Country.java
│ │
│ └─resources
│ │ logback.xml
│ │
│ ├─com
│ │ └─laolang
│ │ └─mybatisstudy
│ │ └─one
│ │ └─mapper
│ │ CountryMapper.xml
│ │
│ └─mybatis
│ mybatis-config.xml
│
└─test
└─java
└─com
└─laolang
└─mybatisstudy
└─one
└─mapper
CountryMapperTest.java
E:\code\idea\mybatis-study\mybatisstudy-one\src>
代码
Country.java
1 package com.laolang.mybatisstudy.one.domain; 2 3 import java.util.Date; 4 5 /** 6 * Created by Administrator on 2017/12/9. 7 */ 8 public class Country { 9 10 public Country() { 11 } 12 13 14 @Override 15 public String toString() { 16 return "Country{" + 17 "id=" + id + 18 ", countryname='" + countryname + '\'' + 19 ", countrycode='" + countrycode + '\'' + 20 '}'; 21 } 22 23 public Long getId() { 24 return id; 25 } 26 27 public void setId(Long id) { 28 this.id = id; 29 } 30 31 public String getCountryname() { 32 return countryname; 33 } 34 35 public void setCountryname(String countryname) { 36 this.countryname = countryname; 37 } 38 39 public String getCountrycode() { 40 return countrycode; 41 } 42 43 public void setCountrycode(String countrycode) { 44 this.countrycode = countrycode; 45 } 46 47 private Long id; 48 private String countryname; 49 private String countrycode; 50 51 }
CountryMapper.xml
1 <?xml version="1.0" encoding="UTF-8"?> 2 <!DOCTYPE mapper 3 PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 4 "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> 5 <mapper namespace="com.laolang.mybatisstudy.one.mapper.CountryMapper"> 6 <select id="selectAll" resultType="Country"> 7 select id,countryname,countrycode from country 8 </select> 9 10 11 12 </mapper>
mybatis-config.xml
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <settings> <!-- 输出sql --> <setting name="logPrefix" value="dao."></setting> </settings> <!-- 别名配置。这样在配置文件中就不需要写全限定名，只需要写类名就可以了。 --> <typeAliases> <package name="com.laolang.mybatisstudy.one.domain" /> </typeAliases> <environments default="development"> <environment id="development"> <transactionManager type="JDBC"> <property name="" value="" /> </transactionManager> <dataSource type="UNPOOLED"> <property name="driver" value="com.mysql.jdbc.Driver" /> <property name="url" value="jdbc:mysql://localhost:3306/mybatis" /> <property name="username" value="root" /> <property name="password" value="root" /> </dataSource> </environment> </environments> <mappers> <mapper resource="com/laolang/mybatisstudy/one/mapper/CountryMapper.xml" /> </mappers> </configuration>
CountryMapper.java
1 package com.laolang.mybatisstudy.one.mapper; 2 3 import com.laolang.mybatisstudy.one.domain.Country; 4 import org.apache.ibatis.io.Resources; 5 import org.apache.ibatis.session.SqlSession; 6 import org.apache.ibatis.session.SqlSessionFactory; 7 import org.apache.ibatis.session.SqlSessionFactoryBuilder; 8 import org.junit.BeforeClass; 9 import org.junit.Test; 10 11 import java.io.IOException; 12 import java.io.Reader; 13 import java.util.List; 14 15 16 public class CountryMapperTest { 17 18 private static SqlSessionFactory sqlSessionFactory; 19 20 @BeforeClass 21 public static void init(){ 22 try { 23 Reader reader = Resources.getResourceAsReader("mybatis/mybatis-config.xml"); 24 sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader); 25 reader.close(); 26 } catch (IOException ignore) { 27 ignore.printStackTrace(); 28 } 29 } 30 31 @Test 32 public void testSelectAll(){ 33 SqlSession sqlSession = sqlSessionFactory.openSession(); 34 try { 35 List<Country> countryList = sqlSession.selectList("selectAll"); 36 printCountryList(countryList); 37 } finally { 38 sqlSession.close(); 39 } 40 } 41 42 private void printCountryList(List<Country> countryList){ 43 for(Country country : countryList){ 44 System.out.printf("%-4d%4s%4s\n",country.getId(), country.getCountryname(), country.getCountrycode()); 45 } 46 } 47 }
注意
在idea 中创建文件夹
在idea中的src/main/resources中新建文件夹时，要用如下方式：
不能使用org.springframe.web的方式，否则创建的文件夹会成为：org.springframe/web
日志
1. logback 中有乱码
2. 日志文件中有重复，且和控制台输出不一致
78
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
