Mybatis/Ibatis例子(添加,修改,删除)

最新推荐文章于 2024-07-10 08:45:00 发布

转载最新推荐文章于 2024-07-10 08:45:00 发布 · 768 阅读

文章标签：

#java #iBatis

JavaWeb-Mybatis/Ibatis增/删/改专栏收录该内容

3 篇文章

订阅专栏

本文介绍使用MyBatis实现数据库的基本操作：查询、更新、插入及删除，并提供具体的Java代码示例。

1.获得结果集

Java代码

<select id="selectUserFromId" parameterType="int" resultType="com.zakisoft.ibt.UserVo">  
        select * from user where id = #{id}  
    </select>  

    <select id="selectAllUsers" resultType="com.zakisoft.ibt.UserVo">  
        select * from user  
    </select>

Java代码

public List<?> selectUserFromId(int id) {  
        SqlSession session = sqlSessionFactory.openSession();  
        List<?> users = null;  
        try {  
            UserOp mapper = session.getMapper(UserOp.class);  
            users = mapper.selectUserFromId(id);  
            if (0 < users.size()) {  
                UserVo user = (UserVo) users.get(0);  
                System.out.println("Get User Name: " + user.getName());  
            }  
        } finally {  
            session.close();  
        }  
        return users;  
    }  

    public List<?> selectAllUsers() {  
        SqlSession session = sqlSessionFactory.openSession();  
        try {  
            UserOp mapper = session.getMapper(UserOp.class);  
            List<?> users = mapper.selectAllUsers();  
            if (0 < users.size()) {  
                UserVo user;  
                for (int i = 0; i < users.size(); i++) {  
                    user = (UserVo) users.get(i);  
                    System.out.println("User Id:" + user.getId() + " --- "  
                            + "User Name:" + user.getName());  
                }  
            }  
        } finally {  
            session.close();  
        }  
        return null;  
    }

2.更新数据
Java代码

<update id="updateUser" parameterType="com.zakisoft.ibt.UserVo">  
        update user set name = #{name}, password = #{password} where id = #{id}  
    </update>

Java代码

public int updateUser(UserVo user){  
        SqlSession session = sqlSessionFactory.openSession();  
        int count = 0;  
        try {  
            UserOp mapper = session.getMapper(UserOp.class);  
            count = mapper.updateUser(user);  
            System.out.println("count: " + count);  
            // 请注意一定需要提交。  
            session.commit();  
        } finally {  
            session.close();  
        }  
        return count;  
    }

3.添加数据
Java代码

<insert id="insertNewOneUser" keyProperty="id" parameterType="com.zakisoft.ibt.UserVo" useGeneratedKeys="true">  
        insert into user (name, password) values (#{name},#{password})  
    </insert>

Java代码

public int insertNewOneUser(UserVo user) {  
        user = new UserVo();  
        user.setName("username: " + new Random().nextInt());  
        user.setPassword("passowrd: " + new Random().nextInt());  

        SqlSession session = sqlSessionFactory.openSession();  
        int count = 0;  
        try {  
            UserOp mapper = session.getMapper(UserOp.class);  
            count = mapper.insertNewOneUser(user);  
            System.out.println("count: " + count);  
            // 请注意一定需要提交。  
            session.commit();  
        } finally {  
            session.close();  
        }  

        return count;  
    }

4.删除数据
Java代码

<delete id="deleteUserById" parameterType="int">  
        delete from user where id = #{id}  
    </delete>

Java代码

public int deleteUserById(int id){  
        SqlSession session = sqlSessionFactory.openSession();  
        int count = 0;  
        try {  
            UserOp mapper = session.getMapper(UserOp.class);  
            count = mapper.deleteUserById(id);  
            System.out.println("count: " + count);  
            // 请注意一定需要提交。  
            session.commit();  
        } finally {  
            session.close();  
        }  
        return count;  
    }