在上篇中我们创建了SSM框架中的web.xml,在这一篇中我们将创建mybatis
1、在applicationContext.xml中添加mybatis配置
<!-- 配置 MyBatis的工厂 -->
<bean class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 数据源 -->
<property name="dataSource" ref="dataSource" />
<!-- 配置MyBatis的核心配置文件所在位置 -->
<property name="configLocation" value="classpath:mybatis-config.xml" />
</bean>
<!-- 接口开发,扫描 com.zq.dao包 ,写在此包下的接口即可被扫描到 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.zq.dao" />
</bean>
2、创建dao包,在dao包下创建一个class UserDao.java和一个xml文件 UserDao.xml
在class中添加一下代码
import java.util.List;
import com.zq.model.User;
public interface UserDao {
public List<User> list(User user);
}
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">
<!-- 命名空間,xml文件和dao接口对应起來 -->
<mapper namespace="com.zq.dao.UserDao">
<!-- 查询列表 -->
<select id="list" parameterType="user" resultType="user">
select * from user
<where>
<if test="username!=null and username!=''">
and username = #{username}
</if>
<if test="pwd!=null and pwd!=''">
and pwd = #{pwd}
</if>
</where>
</select>
</mapper>
3、创建数据库,建立user表
添加id ,username, pwd, realname四个属性,并为其赋值
4、创建一个model包
public class User {
private Integer id;
private String username;
private String pwd;
private String realname;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
public String getRealname() {
return realname;
}
public void setRealname(String realname) {
this.realname = realname;
}
}
5、创建一个service包
添加一个class UserService和一个接口类 UserServiceImpl
代码分别为
import java.util.List;
import com.zq.model.User;
public interface UserService {
public List<User> list(User user);
}
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.zq.dao.UserDao;
import com.zq.model.User;
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserDao userDao;
@Override
public List<User> list(User user) {
return userDao.list(user);
}
}
6、在UserController中引用
@Autowired
private UserService userService;
@ResponseBody
@RequestMapping("/list.do")
public List<User> list(User user){
return userService.list(user);
}
7、进行测试,在地址栏输入localhost:8080/shop/user/list.do?username=你赋的值&pwd=你赋的值
就好啦