一、创建项目:就是用maven构建springmvc项目
详情可见:IDEA使用maven构建spring项目
使用的pom.xml代码为:
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>org.example</groupId>
<artifactId>firstMvc</artifactId>
<version>1.0-SNAPSHOT</version>
<packaging>war</packaging>
<name>firstMvc Maven Webapp</name>
<!-- FIXME change it to the project's website -->
<url>http://www.example.com</url>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>1.7</maven.compiler.source>
<maven.compiler.target>1.7</maven.compiler.target>
<!--spring 版本号-->
<spring.version>5.1.6.RELEASE</spring.version>
<!--mybatis 版本号-->
<mybatis.version>3.2.4</mybatis.version>
<jackson.version>2.9.8</jackson.version>
</properties>
<dependencies>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-core</artifactId>
<version>${jackson.version}</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>${jackson.version}</version>
</dependency>
<dependency>
<groupId>org.hibernate.validator</groupId>
<artifactId>hibernate-validator</artifactId>
<version>6.0.0.Final</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-annotations</artifactId>
<version>${jackson.version}</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-oxm</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context-support</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- spring end -->
<!--mybatis核心包-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${mybatis.version}</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
<scope>test</scope>
</dependency>
<!--日志-->
<!-- https://mvnrepository.com/artifact/org.slf4j/slf4j-log4j12 -->
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>1.8.0-alpha0</version>
<scope>test</scope>
</dependency>
<!--j2ee相关包 servlet、jsp、jstl-->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>4.0.0</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.2</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!--mybatis/spring 包-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.2.2</version>
</dependency>
<!--MySQL 驱动包-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.22</version>
</dependency>
<dependency>
<groupId>org.apache.maven</groupId>
<artifactId>maven-model</artifactId>
<version>3.0</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.18</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>compile</scope>
</dependency>
</dependencies>
<build>
<finalName>firstMvc</finalName>
<pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
<plugins>
<plugin>
<artifactId>maven-clean-plugin</artifactId>
<version>3.1.0</version>
</plugin>
<!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
<plugin>
<artifactId>maven-resources-plugin</artifactId>
<version>3.0.2</version>
</plugin>
<plugin>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.8.0</version>
</plugin>
<plugin>
<artifactId>maven-surefire-plugin</artifactId>
<version>2.22.1</version>
</plugin>
<plugin>
<artifactId>maven-war-plugin</artifactId>
<version>3.2.2</version>
</plugin>
<plugin>
<artifactId>maven-install-plugin</artifactId>
<version>2.5.2</version>
</plugin>
<plugin>
<artifactId>maven-deploy-plugin</artifactId>
<version>2.8.2</version>
</plugin>
</plugins>
</pluginManagement>
</build>
</project>
然后我们在java文件夹下建立一个com.spring_mybatis包,并且在这个包下建立一个dao包。并且我们在resource文件夹建立一个mappers文件夹用来存放用于绑定接口的***mapper.xml。
文件结构如图:
我们只需要关注spring_mybatis包就可以。
注:这里会出现几个坑:
- 最大的一个就是接口一定要放在dao层中,并且在后续的@MapperScan()一定要确定到这个dao包,不然会出现接口无法绑定的情况。原因就是@MapperScan会把基础包内的所有类和接口都视为要实现绑定的接口,自然会报错。
- 第二个坑: mysql-connector-java的版本与mysql版本不同,这个会爆一个无法连接到数据库的错误,没有原因就是说连不到数据库。因为最开始用的版本时5.1.的版本,自己的mysql是8.0。修改 mysql-connector-java版本为8.0.22就ok了。
- 第三个坑:上面的坑解决之后,运行还是会报错,这个爆的错是时区不对,这里我们要修改数据源。我们在后面加个serverTimezone=GMT就ok了
jdbc:mysql://localhost:3306/testmvc?serverTimezone=GMT
二、代码编写:
1.用户类:
@Data
public class Spittle {
@NotNull
private int id;
@NotNull
@Size(min = 3, max = 16)
private String message;
private Double latitude;
private Double longitude;
@Override
public boolean equals(Object o) {
if (this == o) return true;
if (o == null || getClass() != o.getClass()) return false;
Spittle spittle = (Spittle) o;
return id == spittle.id;
}
@Override
public int hashCode() {
return Objects.hash(id);
}
}
这里使用了个@Data注解,这个注解是lombok插件提供的。
加载lombok插件:
- 首先我们使用maven加入lombok插件的包,具体的在上面都有。
- 我们要在IDEA中下载lombok插件。在File->Setting->Plugins中搜索lombok即可。
这个@Data注解非常好用,加了之后,pojo类会自动添加get,set,toString方法。
2 . Mapper方法
public interface SpittleMapper {
List<Spittle> findAll();
}
3 .Service方法
这个service方法本来应该再讲个service包的,这个项目主要是测试这个整合方法是否可行我就没搞。搞一个不会有影响。
@Service
public class SpittleService {
@Autowired
private SpittleMapper spittleMapper;
public List<Spittle> getAll(){
return spittleMapper.findAll();
}
}
这个@Service注解和@Controller注解效果一样,就是便于阅读
4 .最主要的配置类
@Configuration
@MapperScan(basePackages = "com.spring_mybatis.dao") // 指定为mapper接口所在的dao层
@ComponentScan("com.spring_mybatis") // 指定要在哪个包下扫描组件
public class BeanConfig {
@Value("com.mysql.jdbc.Driver")
private String driverClassName;
@Value("jdbc:mysql://localhost:3306/testmvc?serverTimezone=GMT")
private String jdbcUrl;
@Value("root")
private String username;
@Value("Geeklxp0")
private String password;
@Bean
public DataSource dataSource(){
MysqlDataSource dataSource = new MysqlDataSource();
dataSource.setUrl(jdbcUrl);
dataSource.setUser(username);
dataSource.setPassword(password);
return dataSource;
}
@Bean
public SqlSessionFactory sqlSessionFactory() throws Exception {
SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
factoryBean.setDataSource(dataSource()); // 设置数据源
PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
factoryBean.setMapperLocations(resolver.getResources("classpath:mappers/*.xml"));
// 这里指定的xml文件是在resource目录下;classpath指编译后的文件路径
return factoryBean.getObject();
}
}
在编译后com与mapper都是在classes目录下,所以用classpath:mappers/*.xml
至此所有的配置都已经完成,在加上控制器和视图解析器就可以构建一个完整的项目了
5.测试代码:
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(classes = {BeanConfig.class})
public class test {
@Autowired
private SpittleService spittleService;
@Test
public void testSpittle(){
assertNotNull(spittleService);
System.out.println(spittleService.getAll());
}
}
就是普通的测试代码,没什么意思。
注:遇到的最难受的问题:路径问题,主要就体现在配置类
@CompontScan() 要指定的路径为大路径,需要这个注解来发现那些组件,没有的话那些组件找不到
@MapperScan() 要指定的路径为mapper接口所在的路径,注解标识这些接口并在运行时将它们加载为类
setMapperLocations 指定的是resource文件夹下的mapper.xml的路径