当前位置:编程学习 > JAVA >>

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();
   }
  
  }
 
}

补充:软件开发 , Java ,
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,