MyBatis(1)--MyBatis入门示例

待我称王封你为后i 2022-06-09 00:17 144阅读 0赞

# 1.MyBatis下载 #

*  [MyBatis下载入口][MyBatis]
 *  [MySqljar下载入口][MySqljar]

#### mysql驱动jar包必须与mysql数据库版本相对应 ####

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

# 2.第一个示例： #

## 1>.数据库sql创建： ##

create database mybatis;
    use mybatis;
    CREATE TABLE t_role(id INT, role_name VARCHAR(20), note VARCHAR(20));
    INSERT INTO t_role VALUES(1,'Tom', 'teacher');
    INSERT INTO t_role VALUES(2,'Kobe', 'player');

## 2>.创建数据库表对应的JavaBean： ##

package com.anlw;
    
    public class Role { 
        private Integer id;
        private String roleName;
        private String note;
        public Role() {
            super();
        }
        public Role(Integer id, String roleName, String note) {
            super();
            this.id = id;
            this.roleName = roleName;
            this.note = note;
        }
        public Integer getId() {
            return id;
        }
        public void setId(Integer id) {
            this.id = id;
        }
        public String getRoleName() {
            return roleName;
        }
        public void setRoleName(String roleName) {
            this.roleName = roleName;
        }
        public String getNote() {
            return note;
        }
        public void setNote(String note) {
            this.note = note;
        }
        @Override
        public String toString() {
            return "Role [id=" + id + ", roleName=" + roleName + ", note=" + note + "]";
        }
    }

## 3>.定义该表的查询接口： ##

package com.anlw;
    
    public interface RoleMapper {
    
        Role getRole(Integer id);
    
    }

## 4>.定义该表的查询接口的映射器(RoleMapper.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">
    <mapper namespace="com.anlw.RoleMapper">
        <select id="getRole" resultType="com.anlw.Role" parameterType="int">
            select id,role_name roleName,note from t_role where id = #{id}
        </select>
    </mapper>

## 5>.定义构建SqlSessionFactory的配置文件(mybatis-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/mybatis" />
                    <property name="username" value="root" />
                    <property name="password" value="123456" />
                </dataSource>
            </environment>
        </environments>
        <mappers>
            <mapper resource="RoleMapper.xml" />
        </mappers>
    </configuration>

## 6>.构建SqlSessionFactory，测试Main方法： ##

package com.anlw;
    
    import java.io.IOException;
    import java.io.InputStream;
    
    import org.apache.ibatis.io.Resources;
    import org.apache.ibatis.session.SqlSession;
    import org.apache.ibatis.session.SqlSessionFactory;
    import org.apache.ibatis.session.SqlSessionFactoryBuilder;
    
    public class Test {
        public static void main(String[] args) throws IOException {
            String resource = "mybatis-config.xml";
            InputStream inputStream = Resources.getResourceAsStream(resource);
            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
            SqlSession session = sqlSessionFactory.openSession();
            RoleMapper roleMapper = session.getMapper(RoleMapper.class);
            Role role = roleMapper.getRole(2);
            System.out.println(role.toString());
        }
    }

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

# 3.源码下载： #

*  [源码下载][Link 1]

[MyBatis]: https://github.com/mybatis/mybatis-3/releases
[MySqljar]: http://central.maven.org/maven2/mysql/mysql-connector-java/5.0.8/mysql-connector-java-5.0.8.jar
[Link 1]: http://download.csdn.net/download/an_2016/9922894