整合SSM框架步骤
导入配置文件
1.在xml文件中导入配置文件
<dependencies>
<!--junit-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency>
<!--数据库驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
<!--连接池-->
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.5</version>
</dependency>
<!--servlet-->
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.2</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<version>2.5</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!--mybatis-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.5</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>2.0.5</version>
</dependency>
<!--spring-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.2.8.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.2.8.RELEASE</version>
</dependency>
</dependencies>
2.有些时候会出现静态资源导出问题,在xml文件中导入以下代码可以解决问题
<build>
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>true</filtering>
</resource>
<resource>
<directory>src/main/resources</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>true</filtering>
</resource>
</resources>
</build>
编写mybatis层
1.在resources文件夹下创建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>
<typeAliases>
<package name="com.qst.pojo"/>
</typeAliases>
<mappers>
<mapper class="com.qst.dao.UserMapper"></mapper>
</mappers>
</configuration>
typeAliases:可以用来取别名
2.创建实体类
在com.qst.pojo包下创建一个实体类User
package com.qst.pojo;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
private int id;
private String username;
private String sex;
private String address;
}
这里用到了lombok,可以去配置文件里配置并使用
3.创建dao层
在com.qst.dao包下创建UserMapper接口
package com.qst.dao;
import com.qst.pojo.User;
import java.util.List;
public interface UserMapper {
//查询全部用户
List<User> getUserList();
}
同样在该包下创建UserMapper.xml文件
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.qst.dao.UserMapper">
<select id="getUserList" resultType="user">
select * from eesy_mybatis.user
</select>
</mapper>
4.创建service层
实现service调用dao层
package com.qst.service;
import com.qst.pojo.User;
import java.util.List;
public interface UserService {
List<User> getUserList();
}
在编写实现该接口的类
package com.qst.service;
import com.qst.dao.UserMapper;
import com.qst.pojo.User;
import java.util.List;
public class UserServiceImpl implements UserService{
private UserMapper usermapper;
public List<User> getUserList() {
return usermapper.getUserList();
}
}
以上就是ssm框架mybatis层的编写