首页 > 其他 > 详细

mybatis 简单配置

时间:2015-09-29 18:56:33      阅读:223      评论:0      收藏:0      [点我收藏+]

一.com/book/map包下有两个配置文件:

1.MyBatisConfig.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/wzz"/>
				<property name="username" value="root"/>
				<property name="password" value="777777"/>
			</dataSource>
	    </environment>
    </environments>
	
    <mappers>
	   <mapper resource="com/book/map/bookmap.xml"/>
	</mappers>
	
</configuration>

  2.bookmap.xml   用于写sql语句进行数据库具体操作

<?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="domain.blog.mappers.AutoorMapper">
   <!--  parameterType为参数类型,resultType为返回值类型 -->
    <select id="findById" parameterType="int" resultType="com.book.pojo.bookUser">
    select * from bookuser where id=#{id}
    </select>

	</mapper>
	

  

  二.一个简单java类bookUser

package com.book.pojo;

public class bookUser {

	private int id;
	private String userName;
	private String password;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getUserName() {
		return userName;
	}
	public void setUserName(String userName) {
		this.userName = userName;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	
}

  

三.测试类

package com.book.test;

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;

import com.book.pojo.bookUser;

public class testBook {

	public static void main(String[] args) {
		
		String resource = "com/book/map/MyBatisConfig.xml";
		Reader reader = null;
		SqlSession session;
		try {
			reader = Resources.getResourceAsReader(resource);
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		SqlSessionFactory sqlMapper = new SqlSessionFactoryBuilder().build(reader);
		session = sqlMapper.openSession();
		bookUser temp = session.selectOne("findById",1);
		System.out.print(temp.getUserName());
		session.close();
	}

}

  

 

mybatis 简单配置

原文:http://www.cnblogs.com/wzz1020/p/4846960.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!