前面我们已经在IDEA中配置了maven与tomcat
配置maven与tomcat教程
IEDA集成Spring
IEDA集成SpringMVC
这一章节我们来在IDEA中集成MyBatis框架
1.配置pom.xml
<!--MyBatis-->
<mybatis.version>3.4.6</mybatis.version>
<mysql.connector.java.version>5.1.32</mysql.connector.java.version>
<druid.version>1.1.9</druid.version>
<mybatis.spring.version>1.3.2</mybatis.spring.version>
<!--MyBatis-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>${mysql.connector.java.version}</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>${druid.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${mybatis.version}</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>${mybatis.spring.version}</version>
</dependency>
2.创建jdbc.properties配置文件
在/src/main/resource中创建,该配置文件主要设置驱动和连接数据库配置信息
//驱动
jdbc.driverClassName=com.mysql.jdbc.Driver
//mysql连接信息
jdbc.url=jdbc.mysql://127.0.0.1:3306/idea_db?serverTimezone=GMT
//用户名
jdbc.username=root
//密码
jdbc.password=123
3.配置applicationContext.xml
添加如下代码:
<!--集成MyBatis -->
<!--1.配置数据库相关参数 -->
<context:property-placeholder location="classpath:jdbc.properties" ignore-unresolvable="true"/>
<!--2.数据源druid -->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
init-method="init" destroy-method="close">
<property name="driverClassName" value="${jdbc.driverClassName}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="jdbc.username"/>
<property name="password" value="jdbc.password"/>
</bean>
<!--3.配置SqlSessionFactory对象 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!--注入数据库连接池 -->
<property name="dataSource" ref="dataSource"/>
<!--扫描sql配置文件:mapper需要的xml文件 -->
<property name="mapperLocations" value="classpath:mapper/*.xml"/>
</bean>
<!--扫描basePackage下所有的@MyBatisDao注解的接口 -->
<bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
<property name="basePackage" value="com.hermit.dao"/>
</bean>
4.创建数据库
在MySQL中创建表hermit_user
id bigint 自增 主键
username varchar
password varchar
5.创建实体类对象HermitUser
创建对象位置:/src/main/java/com.hermit.model
public class HermitUser implements Serializable {
private Integer id;
private String username;
private String password;
public void setId(int id){
this.id = id;
}
public int getId(){
return id;
}
public void setUsername(String username){
this.username = username;
}
public String getUsername(){
return username;
}
public void setPassword(String password){
this.password = password;
}
public String getPassword(){
return password;
}
}
6.创建接口HermitUserDao
创建对象位置:/src/main/java/com.hermit.dao
HermitUserDao是一个接口,我们在这个接口里提供一个findAll的方法
package com.hermit.dao;
import com.hermit.model.HermitUser;
import org.springframework.stereotype.Repository;
import java.util.List;
@Repository
public interface HermitUserDao {
List<HermitUser> findAll();
}
7.创建服务层接口HermitUserService
创建对象位置:/src/main/java/com.hermit.service
package com.hermit.service;
import com.hermit.model.HermitUser;
import java.util.List;
public interface HermitUserService {
List<HermitUser> findAll();
}
8.创建服务层实现类HermitUserServiceImpl
创建对象位置:/src/main/java/com.hermit.service.impl
package com.hermit.service.impl;
import com.hermit.dao.HermitUserDao;
import com.hermit.model.HermitUser;
import com.hermit.service.HermitUserService;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
import java.util.List;
@Service
public class HermitUserServiceImpl implements HermitUserService {
@Resource
private HermitUserDao hermitUserDao;
public List<HermitUser> findAll(){
return hermitUserDao.findAll();
}
}
实现类注入HermitUserDao接口,实现finAll方法,在findAll方法中调用HermitUserDao的findAll方法
9.创建控制层HermitUserController
创建对象位置:/src/main/java/com.hermit.controller
package com.hermit.controller;
import com.hermit.model.HermitUser;
import com.hermit.service.HermitUserService;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import javax.annotation.Resource;
import java.util.List;
@Controller
@RequestMapping(value = "/user")
public class HermitUserController {
@Resource
private HermitUserService hermitUserService;
@GetMapping("/findAll")
public String finAll(Model model){
List<HermitUser> hermitUserList = hermitUserService.findAll();
for(HermitUser hermitUser:hermitUserList){
System.out.println("id"+hermitUser.getId());
System.out.println("username"+hermitUser.getUsername());
}
return "hello";
}
}
10.创建HermitUserMapper.xml
创建对象位置:/src/main/resources/mapper
<?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.hermit.dao.HermitUserDao">
<sql id="userField">
a.id as "id",
a.username = "username",
a.password = "password"
</sql>
<!--获取所有用户 -->
<select id="findAll" resultType="com.hermit.model.HermitUser">
select
<include refid="userField"/>
from hermit_user as a
</select>
</mapper>
用tomca运行 可以在控制台看到输出的数据库信息,集成MyBatis成功。