SMM框架简单用户增删改查

用户增删改查

先导入jar包：

编写User实体类：

public class User {
   
    private Integer id;
    private String name;
    private String sex;
    private Integer age;
    private String address;
    @Override
    public String toString() {
   
        return "\nUser{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", sex=" + sex +
                ", age=" + age +
                ", address='" + address + '\'' +
                '}';
    }
//省略get set 构造方法

编写DAO接口：

public interface UserMapper {
   
    //查询所有用户
    public List<User> list();
    //添加用户
    int addUser(User user);
    //根据Id查询指定用户
    User getUserById(int id);
    //更改用户
    int updateUser(User user);
    //删除用户
    int delUser(Integer id);
}

编写SQL映射文件：
命名空间必须为接口完全限定类名，id值必须与接口方法名一致，

<?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.user.dao.UserMapper">
    <resultMap id="BaseresultMap" type="user">
        <id property="id" column="id"/>
        <result property="name" column="name"/>
        <result property="age" column="age"/>
        <result property="sex" column="sex"/>
        <result property="address" column="address"/>
    </resultMap>
    <select id="list" resultMap="BaseresultMap">
        select * from user
    </select>
    <insert id="addUser" parameterType="user">
        insert into user(name,sex,age,address) values (#{name},#{sex},#{age},#{address})
    </insert>
    <select id="getUserById" parameterType="int" resultMap="BaseresultMap">
        select * from user where id=#{id}
    </select>
    <update id="updateUser" parameterType="user">
        update user set name=#{name},sex=#{sex},age=#{age},address=#{address} where id=#{id}
    </update>
    <delete id="delUser" parameterType="int">
        delete from user where id=#{id}
    </delete>
</mapper>

编写MyBatis配置文件：

<?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="cn.user.pojo"/>
</typeAliases>

<mappers>
    <!--加载SQL映射文件-->
    <mapper resource="cn/user/dao/mapper/UserMapper.xml"/>
</mappers>
</configuration>

编写Service业务层：
UserService及实现类：

public interface UserService {
   
    public List<User> list();//查询

    int addUser(User user);//添加

    User getUserById(int id);//根据id查询

    int updateUser(User user);修改

    int delUser(Integer id);//删除
}

实现类：别忘了给类加注解，交给Spring容器管理

@Service("userService")
@Transactional
public class UserServiceImpl implements UserService {
   
//注解方式为mapper赋值
    @Resource(name = "userMapper")
    private UserMapper mapper;
    @Override
    public List<User> list() {
   
        return mapper.list();
    }

    @Override
    public int addUser(User user) {
   
        return mapper.addUser(user);
    }

    @