Springboot整合mybatis连接数据库
1.导入相关jar包
使用maven导入,pom.xml配置如下
<!--继承父类-->
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>1.5.18.RELEASE</version>
<relativePath />
</parent>
<groupId>cn</groupId>
<artifactId>springboot</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>jar</packaging>
<properties>
<java.version>1.8</java.version>
</properties>
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
<dependency>
<groupId>org.apache.tomcat.embed</groupId>
<artifactId>tomcat-embed-jasper</artifactId>
<!--<scope>provided</scope> -->
</dependency>
<!-- jstl标签库 -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
</dependency>
</dependencies>
2.编写dao层接口以及mapper.xml文件
dao层接口
@Repository("userDao")
@Mapper
public interface UserDao {
public User selectUserByUnameAndPsw(@Param("uname")String uname,@Param("psw")String psw);
}
map.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="cn.dao.UserDao">
<resultMap type="cn.entity.User" id="userMap">
<id column="uid" property="uid" />
<result column="uname" property="uname" />
<result column="psw" property="psw" />
</resultMap>
<select id="selectUserByUnameAndPsw" parameterType="java.lang.String" resultMap="userMap">
select *
from user
where uname=#{uname} and psw=#{psw}
</select>
</mapper>
3.配置application.properties文件
#四大件
#驱动
spring.datasource.driverClassName=com.mysql.jdbc.Driver
#URL
spring.datasource.url=jdbc:mysql://localhost:3306/car?useUnicode=true&characterEncoding=UTF-8
#用户名
spring.datasource.username=root
#密码
spring.datasource.password=1218
# 加载mapper文件
mybatis.mapper-locations: classpath:mapper/*.xml
4.编写service层与controller层
service层
@Service("userSer")
public class UserSerImpl implements UserSer{
@Autowired(required=false)
private UserDao userDao;
@Override
public User login(String uname,String psw){
System.out.println(uname+"aaaaaaaaaaa");
System.out.println("sssssssssssss"+userDao);
User user = userDao.selectUserByUnameAndPsw(uname, psw);
if(user==null){
return null;
}
return user;
}
//userdao的set方法
}
controller类
@Controller
public class UserController {
@Autowired
private UserSer userSer;
@RequestMapping("/login")
public String login(String uname,String psw){
User user = userSer.login(uname, psw);
if(user!=null){
System.out.println("姓名:"+user.getUname());
return "success";
}
return "index";
}
public void setUserSer(UserSer userSer) {
this.userSer = userSer;
}
}
目录结构如下
然后运行main方法就可以进行访问了