java——mybatis——Mybatis注解开发——@Insert——更新数据

刺骨的言语ヽ痛彻心扉 2024-03-31 14:57 64阅读 0赞

pom：

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
    
        <groupId>org.example</groupId>
        <artifactId>sunxl</artifactId>
        <version>1.0-SNAPSHOT</version>
    
        <properties>
            <maven.compiler.source>8</maven.compiler.source>
            <maven.compiler.target>8</maven.compiler.target>
        </properties>
    <dependencies>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.11</version>
            <scope>test</scope>
        </dependency>
    
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.27</version>
        </dependency>
    
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.1</version>
        </dependency>
        <dependency>
            <groupId>org.apache.logging.log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>2.17.2</version>
        </dependency>
    </dependencies>
    </project>

![6a8807100b60b089887e0bfb6976d1a6.png][]

工程配置：

<?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.sunxl.pojo"/>
        </typeAliases>
        
        <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/mysql8?characterEncoding=utf8" />
                    <property name="username" value="root" />
                    <property name="password" value="123456" />
                </dataSource>
            </environment>
        </environments>
        
        <mappers>
            <package name="com.sunxl.dao"></package>
        </mappers>
    </configuration>

![31329d2c4d81c8872689cca1084d26de.png][]

POJO类：

package com.sunxl.pojo;
    
    public class User {
    
        Integer id;
        String name;
        Integer age;
    
        public Integer getId() {
            return id;
        }
    
        public void setId(Integer id) {
            this.id = id;
        }
    
        public String getName() {
            return name;
        }
    
        public void setName(String name) {
            this.name = name;
        }
    
        public Integer getAge() {
            return age;
        }
    
        public void setAge(Integer age) {
            this.age = age;
        }
    
        @Override
        public String toString() {
            return "Users{" +
                    "id=" + id +
                    ", name='" + name + '\'' +
                    ", age=" + age +
                    '}';
        }
    
    }

![336dc1cc0898595c27bb4862db43dc1c.png][]

DAO接口：

package com.sunxl.dao;
    
    import com.sunxl.pojo.User;
    import org.apache.ibatis.annotations.Insert;
    import org.apache.ibatis.annotations.Select;
    
    import java.util.List;
    
    public interface UserDao {
    
        @Select("select * from users")
        List<User> findAll();
    
        @Insert("insert into users (name,age) values(#{name},#{age})")
        void saveUser(User user);
    
    
    //
    //    int updateUser(User user);
    //
    //    int deleteUser(Integer id);
    //
    //    User findById(Integer id);
    //
    //    List<User> findByName(String name);
    //
    //    int findTotal();
    //
    //    int saveInsertUser(User user);
    
    }

![ddfec733ab24d9db93668ffce9c04510.png][]

测试执行：

import com.sunxl.dao.UserDao;
    import com.sunxl.pojo.User;
    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;
    import java.util.List;
    
    public class MybatisTest {
    
        public static void main(String[] args) throws IOException {
    
    //        InputStream config = Resources.getResourceAsStream("mybatis-config.xml");
    //
    //        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
    //        SqlSessionFactory factory = builder.build(config);
    //        SqlSession ss = factory.openSession();
    //        UserDao userdao = ss.getMapper(UserDao.class);
    //
    //
    //        List<User> users = userdao.findAll();
    //
    //        for (User user: users){
    //            System.out.println(user);
    //        }
    //
    //
    //        ss.commit();
    //        ss.close();
    //        config.close();
    
    
    
            InputStream config = Resources.getResourceAsStream("mybatis-config.xml");
    
            SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
            SqlSessionFactory factory = builder.build(config);
            SqlSession ss = factory.openSession();
            UserDao userdao = ss.getMapper(UserDao.class);
    
            User as = new User();
            as.setName("zhon_guo");
            as.setAge(1003);
    
            userdao.saveUser(as);
    
    
    
            ss.commit();
            ss.close();
            config.close();
    
    
        }
    }

![156d4a5d2abfef56dfdf403b7fbf9990.png][]

![fdee201383a67048dcc9d02490a0ac8b.png][]

PS：

@Insert("insert into users (name,age) values(#{name},#{age})")
    void saveUser(User user);

如果反正类型是int，则返回修改了几天数据的值

@Insert("insert into users (name,age) values(#{name},#{age})")
    int saveUser(User user);

![b20007eda4b41be9fcb3a4f4fed5b97f.png][]

[6a8807100b60b089887e0bfb6976d1a6.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/84eb911676d14b0e89ef247df7c046c5.png
[31329d2c4d81c8872689cca1084d26de.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/ada17d5f5b9a4c8bbe3e4c086acf6ce3.png
[336dc1cc0898595c27bb4862db43dc1c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/f9044c296eca4252b8e00707d94e5908.png
[ddfec733ab24d9db93668ffce9c04510.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/a674d20231264ada8dfe500be927be22.png
[156d4a5d2abfef56dfdf403b7fbf9990.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/621cc45265a240d9a58a398f63b283c9.png
[fdee201383a67048dcc9d02490a0ac8b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/b852c25c84b64db1b5a32b128e8a4c5b.png
[b20007eda4b41be9fcb3a4f4fed5b97f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/b21fcd452b974a2a810ff82d348144bd.png