MyBatis入门

今天开始学MyBatis 在网上看了一些简单的demo  官方还提供了中文指南。。可以去下。。
  然后自己写了个简单的。。
  首先在mysql建名为mybatis的数据库   在数据库中建一个user表 里面有2个字段 id  name
 
  下面是目录结构


  Configuration.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>

    <typeAliases>

        <typeAlias alias="User" type="User" />

    </typeAliases>

    <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="55" />

            </dataSource>

        </environment>

    </environments>

    <mappers>

        <mapper resource="User.xml" />

    </mappers>

</configuration>

User.xml

public class User {

   private int id;

   private String name;

   

   

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;

}

@Override

public String toString() {

return "User [id=" + id + ", name=" + name + "]";

}

}


Test.java

import java.io.IOException;

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

public static void main(String[] args) throws IOException {

String resource = "Configuration.xml";

Reader reader = Resources.getResourceAsReader(resource);

SqlSessionFactory  sqlMapper = new SqlSessionFactoryBuilder().build(reader);

SqlSession session = sqlMapper.openSession();

try {

User user = (User)session.selectOne("User.selectUser",2);

System.out.println("user name:"+user.getName());

} catch (Exception e) {

e.printStackTrace();

}finally{

session.close();

}

}

}