mybaties的简单使用

红太狼 2022-01-22 06:17 228阅读 0赞

需要下载的jar包：  
链接：[https://pan.baidu.com/s/1FUtXK\_v-oTiV6paTaVcr0A][https_pan.baidu.com_s_1FUtXK_v-oTiV6paTaVcr0A]  
提取码：r2e9

--------------------

mybaties-config.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="123456" />
                </dataSource>
            </environment>
        </environments>
    
        
        <mappers>
            <mapper class="dao.UserMapper"/>
        </mappers>
    
    </configuration>

--------------------

UserMapper.java（dao层接口定义）：

public interface UserMapper {
          User getUserByID(String id);
          int addUser(User user);
    }

UserMapper.xml（dao层接口实现）：

<?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="dao.UserMapper">
    <resultMap id="Usermap" type="model.User">
        <id property="id" column="ID" />
        <result property="name" column="NAME"></result>
        <result property="age" column="AGE"></result>
    </resultMap>
        <select id="getUserByID" resultMap="Usermap">
            select * from user where id = #{id}
        </select>
        <insert id="addUser" parameterType="model.User">
            insert into user values (#{id},#{name},#{age})
        </insert>
    
    </mapper>

--------------------

User.java（实体类）：

public class User{
        private int id;
        private String name;
        private  int  age;
    
        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 int getAge() {
            return age;
        }
    
        public void setAge(int age) {
            this.age = age;
        }
        public  void  Output(){
            System.out.println("姓名："+getName()+", 年龄："+getAge());
        }
    }

--------------------

Main方法测试：

public static void test() throws IOException{
            String resource = "mybatis-config.xml";
            Reader reader = Resources.getResourceAsReader(resource);
            SqlSessionFactory factory=new SqlSessionFactoryBuilder().build(reader);
            //加载配置文件
            SqlSession session=factory.openSession();
            String statement="dao.UserMapper.getUserByID";
            //找到对应的接口
            User user=session.selectOne(statement, 123);
            //执行查询
            user.Output();
            User user2 = new User();
            user2.setId(1);
            user2.setName("zhang");
            user2.setAge(22);
            statement = "dao.UserMapper.addUser";
            user2.Output();
            System.out.println(session.insert(statement,user2));
            session.commit();
            //执行完事物操作后要提交才能保存到数据库
    
        }

[https_pan.baidu.com_s_1FUtXK_v-oTiV6paTaVcr0A]: https://pan.baidu.com/s/1FUtXK_v-oTiV6paTaVcr0A