第一节mybatis 配置入门示例

1.eclispse  创建java poject 
2.引入 mybatis-3.4.6.jar 包 ojdbc6.jar
3.创建表 sqlplus scott/tiger
create table person ( id number, name varchar(20), age number) ;
 insert into person values (1,'zs',23);

4 src.org.lanqiao.entity 下创建 java对象 
package org.lanqiao.entity;

import java.math.BigDecimal;

public class Person {

    private BigDecimal id ;
    private String name;
    private BigDecimal age ;
    
    public Person(BigDecimal id, String name, BigDecimal age) {
        super();
        this.id = id;
        this.name = name;
        this.age = age;
    }
    @Override
    public String toString() {
        return "Person [id=" + id + ", name=" + name + ", age=" + age + "]";
    }
    public BigDecimal getId() {
        return id;
    }
    public void setId(BigDecimal id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public BigDecimal getAge() {
        return age;
    }
    public void setAge(BigDecimal age) {
        this.age = age;
    }

    
}

5.src.org.lanqiao.entity  创建  personMapper.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="org.lanqiao.entity.personMapper">
<!--  parameterMap：输入参数  resultType：返回参数（对象） -->
 <select id="selectPersonById" resultType="Person"  parameterMap="int">
 select * from person where id = #{id}
 </select>
</map

6.src 创建数据库链接文件conf.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="oracle.jdbc.OracleDriver" />
                <property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl" />
                <property name="username" value="scott" />
                <property name="password" value="tiger" />
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="org/lanqiao/entity/personMapper.xml" />
    </mappers>
</configuration>

7..src.org.lanqiao.entity  创建测试类

package org.lanqiao.entity;

import java.io.Reader;

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 testMybaties {

    
    public static void main(String[] args) throws Exception {
        
        Reader  reader=  Resources.getResourceAsReader("conf.xml") ;
        SqlSessionFactory sqlsessionfactory =new SqlSessionFactoryBuilder().build(reader);
        SqlSession  sqlsession =sqlsessionfactory.openSession();
        Person person=    sqlsession.selectOne("org.lanqiao.entity.personMapper.selectPersonById",1);
        System.out.println(person);
        sqlsession.close();
        
    }
}