结构图:
pom.xml文件引入依赖
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
<version>RELEASE</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
application.properties文件
# 数据库访问配置
# 主数据源,默认的
spring.datasource.url=jdbc:mysql://localhost:3306/springboot
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
# 配置mapper.xml的位置
mybatis.mapper-locations=classpath:mapper/*.xml
# 配置端口
server.port=8080
或者使用application.yml文件也可以
index.html页面
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<form action="/user/login" method="post">
<input type="text" name="username" placeholder="请输入用户名" /> <br/>
<input type="password" name="password" placeholder="请输入密码" /><br/>
<input type="submit" value="登录"><input type="reset" value="重置">
</form>
</body>
</html>
注意:
在SpringBoot中加载静态资源和在普通的web应用中不太一样。静态资源(js、css、图片等资源)默认目录位置需置于classpath下,并且符合以下目录规则:
- /static
- /public
- /resources
- /META-INF/resources
不满足这些规则中的一种,是无法访问到静态资源的
类似于这种结构:
默认规则的优先级顺序:
META-INF/resources > resources > static > public ,也就是说如果在优先级高的包里和优先级低的包里有同名的静态资源,springboot在访问到优先级高的包中的静态资源之后将不再去优先级低包中寻找。
UserController
/**
* Create by zhaihongwei on 2018/3/13
*/
@RestController
public class UserController {
@Autowired
private UserService userService;
@RequestMapping(value = "/user/login", method = RequestMethod.POST)
public void userLogin(User user) {
User userExt = userService.userLogin(user);
if (userExt != null) {
System.out.println("登录成功啦:)");
return;
}
System.out.println("登录失败了:(");
}
}
UserService接口:
/**
* Create by zhaihongwei on 2018/3/13
*/
public interface UserService {
User userLogin(User user);
}
UserService实现类:
/**
* Create by zhaihongwei on 2018/3/13
*/
@Service
@Transactional
public class UserServiceImpl implements UserService {
@Autowired
private UserMapper userMapper;
@Override
public User userLogin(User user) {
return userMapper.userLogin(user);
}
}
UserMapper接口
/**
* Create by zhaihongwei on 2018/3/13
*/
@Mapper
public interface UserMapper {
//@Select("SELECT * FROM user WHERE username=#{username} and password=#{password}")
User userLogin(User user);
}
注意:如果使用注解的形式写SQL语句,需要将application.properties文件中配置mapper.xml的配置注释掉。
UserMapper.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.zhw.study.springboot_demo.dao.UserMapper">
<select id="userLogin" resultType="com.zhw.study.springboot_demo.pojo.User" parameterType="com.zhw.study.springboot_demo.pojo.User">
SELECT * FROM user WHERE username=#{username} AND password=#{password};
</select>
</mapper>
**注意:**mapper.xml文件所在的位置,要和application.properties文件中配置的保持一致
# 配置mapper.xml的位置
mybatis.mapper-locations=classpath:mapper/*.xml
启动类
@SpringBootApplication
@MapperScan("com.zhw.study.springboot_demo.dao")// 扫描Mapper接口所在的包
public class SpringbootDemoApplication {
public static void main(String[] args) {
SpringApplication.run(SpringbootDemoApplication.class, args);
}
}
启动之后直接访问:http://localhost:8080/,就可以直接找到index.html文件了