Mybatis3 最简例子

2019独角兽企业重金招聘Python工程师标准>>>

以下是我学习Mybatis3时的第一个例子，本人非专业人员，基础薄弱。

一、导入数据库文件

1、创建 mybatis-config.xml文件，注意：此处测试时用的 Sql Server 2012 

2、创建 User 类

3、创建 Usermapper.xml文件

4、创建 TestUser类

代码如下： 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="standalone">
        <environment id="standalone">
            <transactionManager type="JDBC" />
            <dataSource type="UNPOOLED">
                <property name="driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
                <property name="url" value="jdbc:sqlserver://localhost:1433;DatabaseName=hib"/>
                <property name="username" value="sa"/>
                <property name="password" value="novell"/>
            </dataSource>
        </environment>
    </environments>
    
    <mappers>
    <mapper resource="mybatis/Model/UserMapper.xml"/>  
    </mappers>
</configuration>

User.java

package mybatis.Model;

public class User {
	
	private int id;
	private String name;
	private String password;
	
	
	
	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 String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
}

UserMapperUsermapper.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="UserMapper">

	<select id="id" parameterType="int" resultType="mybatis.Model.User"> <!-- resultType 类型为对应该实体类  id为传入的参数-->
		select * from t_user where id = #{id}
	</select>
</mapper>

TestUser.java

package Testmybatis.odel;

import java.io.IOException;
import java.io.Reader;

import mybatis.Model.User;

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 TestUser {
	
	public static void main(String[] args) throws IOException{
		
		String resource = "mybatis-config.xml";
		Reader reader = Resources.getResourceAsReader(resource);
		//InputStream inputStream = Resources.getResourceAsStream(resource);
		SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
		
		SqlSession session = sessionFactory.openSession();
		try {
			
			User user = (User)session.selectOne("id", "1");
			System.out.println("username:" + user.getName());
			
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			session.close();
		}
		
	}

}

此处下载 myeclipse 导出工程 包括数据库在内~~~~

转载于:https://my.oschina.net/u/866794/blog/88721