Mybatis实现对单表的增删查改

Mybatis实现对单表的增删查改

1.创建一个maven项目

2.导入依赖

<dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.5.1</version>
    </dependency>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.38</version>
    </dependency>
    

3.配置mybatis.config.XML

xml配置数据库连接
记得在提前创建一个users表

<?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/mybatis?characterEncoding=utf8&amp;useSSL=false"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>
    
**配置mapper**
   <mappers>
        <mapper resource="com.lp.mabatis.config/UserMapper.xml"/>
    </mappers>
</configuration>

4.配置UserMapper.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">
<!--命名空间-->
<!--书写user表的sql语句
比如：增删查改-->
<!--每一个sql语句都有一个唯一id-->
<!--查找操作-->
<mapper namespace="com.lp.mybatis.demo.UserMapper">
    <select id="selectUser" parameterType="int" resultType="com.lp.mybatis.demo.User">
    select * from users where id = #{id}
  </select>
</mapper>

<!--插入操作-->
<mapper namespace="com.lp.mybatis.demo.UserMapper">
<insert id="insertPerson" parameterType="com.lp.mybatis.demo.User">
		insert into users(username) values(#{username});
		</insert>
</mapper>

<!--删除操作-->
<mapper namespace="com.lp.mybatis.demo.UserMapper">
<delete id="deleteAll">
    delete from users WHERE id=#{id} ;
</delete>
</mapper>

<!--修改操作-->
<mapper namespace="com.lp.mybatis.demo.UserMapper">
<update id="updateById" parameterType="com.lp.mybatis.demo.User">
update users set id=#{id},username=#{username} where 	id=#{id};
</update>
</mapper>

5.创建实体类User

根据数据类型私有化属性

package com.lp.mybatis.demo;

public class User {
    private  Integer id;
    private String username;

    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;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                '}';
    }

}

6.创建接口UserMapper

声明增删查改方法

package com.lp.mybatis.demo;

public interface UserMapper {
    /*查找用户*/
    User selectUser(int id);
    /*根据id修改用户信息*/
    int updateById(User user);
    /*插入数据*/
    int insertPerson(User user);
    /*删除用户信息*/
    int deleteAll(User user);

}

7.创建测试类Test

package com.lp.mybatis.demo;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.IOException;
import java.io.InputStream;

public class test {
    public static void main(String[] args) throws IOException {
        String resource = "com.lp.mabatis.config/mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        
        
/*
    <--查找数据-->
        try (SqlSession session = sqlSessionFactory.openSession()) {
            User user = (User) session.selectOne("com.lp.mybatis.demo.UserMapper.selectUser", 1);
            System.out.println(user);
        }
            <--插入数据-->
        try (SqlSession session= sqlSessionFactory.openSession()) {
        User user = new User();
        user.setUsername("马云");
        int insert = session.insert("com.lp.mybatis.demo.UserMapper.insertPerson", user);
        System.out.println(insert);
            session.commit();

        }
            <--删除数据-->
        try (SqlSession session= sqlSessionFactory.openSession()) {

             int delete = sqlSession.delete("com.lp.mybatis.demo.UserMapper.deleteAll", 1);
            System.out.println(delete);
            session.commit();

        }*/
        <--修改数据-->
        try (SqlSession session= sqlSessionFactory.openSession()) {
            User user = new User();
            user.setId(1);
            user.setUsername("lp");
              int update= session.insert("com.lp.mybatis.demo.UserMapper.updateById", user);
            System.out.println(user);
            session.commit();
        }
    }
}

8.数据库结果

初学ssm的第一个实验，欢迎大家交流学习！