mybatis入门配置

来源:互联网 发布:tm商标域名 编辑:程序博客网 时间:2024/05/21 15:00

概述

什么是mybatis请自行搜索,这篇文章是入门级配置。如果是学过Hibernate框架的话,学起来会更加轻松。

项目基本结构

1.mybatisconfig.xml配置文件
2.mapper.xml配置文件(
3.po类(对应表)
4.代理接口

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/mytest"/><!-- 账号 -->        <property name="username" value="root"/><!-- 密码 -->        <property name="password" value=""/>      </dataSource>    </environment>  </environments><!-- 导入定义的mapper.xml,mapper具体作用,请看其他文章 -->  <mappers>    <mapper resource="com/test/user.xml"/>  </mappers></configuration>

2.mapper.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"> <!-- 面向接口的实现 namespace是一个接口   --><mapper namespace="com.test.GetUserInter"><!-- id对应了接口的方法,帮你实现这个接口, parameterType 传入参数的类型   resultType 返回结果的类型    -->  <select id="selectUser" parameterType="int" resultType="com.test.User" >    select * from user where id = #{id}  </select></mapper>

3.po类的实现

public class User {    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;    }    @Override    public String toString() {        return "User [id=" + id + ", username=" + username + ", password=" + password + "]";    }}

4.接口的实现

//请务必和mapper.xml对应public interface GetUserInter {    public User selectUser();}

测试类

        //读取mybatis的配置文件         String resource = "mybatisconfig.xml";        InputStream inputStream = Resources.getResourceAsStream(resource);        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);        //开启session        SqlSession  session =sqlSessionFactory.openSession();        //查询一个id为8的user用户         User user = session.selectOne("com.test.GetUserInter.selectUser",1);        System.out.println(user);

结束语

文章是最最入门的配置。每个xml的具体作用,及其与springmvc整合,请移步其他文章

原创粉丝点击