java——mybatis——Mybatis注解开发——@Update——修改数据

「爱情、让人受尽委屈。」 2024-03-31 14:59 43阅读 0赞

![3c1bf6396ae9decf6ff134ac0fafc6c4.png][]

DAO接口：

package com.sunxl.dao;
    
    import com.sunxl.pojo.User;
    import org.apache.ibatis.annotations.Insert;
    import org.apache.ibatis.annotations.Select;
    import org.apache.ibatis.annotations.SelectKey;
    import org.apache.ibatis.annotations.Update;
    
    import java.util.List;
    
    public interface UserDao {
    
        @Select("select * from users")
        List<User> findAll();
    
        @Insert("insert into users (name,age) values(#{name},#{age})")
        @SelectKey(statement = "select last_insert_id()", keyProperty = "id", keyColumn = "id", resultType = int.class ,before = false)
        int saveUser(User user);
    
    
        @Update("update users set name = #{name},age = #{age} where id = #{id}")
        int updateUser(User user);
    //
    //    int deleteUser(Integer id);
    //
    //    User findById(Integer id);
    //
    //    List<User> findByName(String name);
    //
    //    int findTotal();
    //
    //    int saveInsertUser(User user);
    
    }

![ba8600efc700d4d00ee82511e19d81d8.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("mei_guo");
            as.setAge(1005);
            as.setId(1005);
    
            int a = userdao.updateUser(as);
            System.out.println(a);
            System.out.println(as.toString());
    
    
    
            ss.commit();
            ss.close();
            config.close();
    
    
        }
    }

![e0318a627a8b551052c62bf11886bdc1.png][]

![79e0e1a0114cf7b110322ce6df789de5.png][]

![15eaab6f478232cf7d3e3d7f843cf734.png][]

[3c1bf6396ae9decf6ff134ac0fafc6c4.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/369ee7a82726485cb3c8d0825f91e427.png
[ba8600efc700d4d00ee82511e19d81d8.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/edf2a9831e2e4dac8f70fee1c6dc5993.png
[e0318a627a8b551052c62bf11886bdc1.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/58267ecee009467f9da45b754f220ba1.png
[79e0e1a0114cf7b110322ce6df789de5.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/e0c8e7fbe33f4beeb307380cbc008a21.png
[15eaab6f478232cf7d3e3d7f843cf734.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/3a25db386dea49a38051b6969227e29e.png