03--MyBatis基本增删查改操作

最新推荐文章于 2023-09-07 15:36:42 发布

喜欢写bug嘻嘻嘻

最新推荐文章于 2023-09-07 15:36:42 发布

阅读量136

点赞数 2

分类专栏： MyBatis 文章标签： mybatis java spring

本文链接：https://blog.csdn.net/m0_61523691/article/details/127314746

版权

MyBatis 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

1、搭建mybatis框架

a)导入相关jar包

b)编写核心配置文件（配置数据库连接的相关信息以及配置了mapper映射文件）

c)编写dao操作

d)编写mapper映射文件

e)编写实体类

2，核心配置文件Mybatis.cfg.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>
    <environments default="development">
        <environment id="development">

            <transactionManager type="JDBC" />

            <dataSource type="POOLED">

                <property name="driver" value="com.mysql.jdbc.Driver" />

                <property name="url" value="jdbc:mysql://localhost:3306/test" />

                <property name="username" value="root" />

                <property name="password" value="root" />

            </dataSource>

        </environment>

    </environments>

    <mappers>

        <mapper resource="cn/sxt/entity/user.mapper.xml"/>

    </mappers> 

</configuration>

3，User.mapper.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.sxt.entity.UserMapper">

    <!-- 查询单个用户 -->

    <select id="selectUser" resultType="cn.sxt.entity.User">
        select * from user where id = #{id}

    </select>

    <!-- 查询所有用户 -->

    <select id="selectAll" resultType="cn.sxt.entity.User">

        select * from user

    </select>

    <!-- 添加用户 -->

    <insert id="addUser" parameterType="cn.sxt.entity.User" 

                                         useGeneratedKeys="true">

        insert into user(name,pwd) values(#{name},#{pwd})

    </insert>

    <!-- 更新用户信息 -->

    <update id="updateUser" parameterType="cn.sxt.entity.User">

        update user set name=#{name},pwd=#{pwd} where id=#{id}
    </update>

    <!-- 删除用户 -->

    <delete id="deleteUser">

        delete from user where id=#{id}

    </delete>

</mapper>

4，User.java (封装类)


public class User {

    private int id;


    private String name;

    private String pwd;

    public int getId() {

        return id;

    }

    public void setId(int id) {

        this.id = id;

    }


    public String getName() {

        return name;
    }

    public void setName(String name) {

        this.name = name;

    }

    public String getPwd() {

        return pwd;

    }

    public void setPwd(String pwd) {

        this.pwd = pwd;

    }

    @Override

    public String toString() {

        return "User [id=" + id + ", name=" + name + ", pwd=" + pwd + "]";

    }

}

5，UserDAO



public class UserDAO {

    public List<User> getAll() throws IOException{


        SqlSession session=MyBatisUtil.getSession();

        List<User> list = session.selectList("cn.sxt.entity.UserMapper.selectAll");

        session.close();

        return list;

    }

    public User getById(int id) throws IOException{

        SqlSession session=MyBatisUtil.getSession();

        User user = session.selectOne("cn.sxt.entity.UserMapper.selectUser", id);

        session.close();

        return user;
    }

    public int add(User user) throws IOException{

        SqlSession session=MyBatisUtil.getSession();

        int result = session.insert("cn.sxt.entity.UserMapper.addUser", user);

        session.commit();

        session.close();

        return result;
    }

    public int update(User user) throws IOException{

        SqlSession session=MyBatisUtil.getSession();

        int result = session.update("cn.sxt.entity.UserMapper.updateUser", user);

        session.commit();

        session.close();
        return result;

    }

    public int delete(int id) throws IOException{

        SqlSession session=MyBatisUtil.getSession();

        int result = session.delete("cn.sxt.entity.UserMapper.deleteUser", id);

        session.commit();

        session.close();

        return result;

    }

}