mybatis01

<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>x.x.x</version>
</dependency>

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.6</version>
</dependency>
<dependency>
    <groupId>log4j</groupId>
    <artifactId>log4j</artifactId>
    <version>1.2.12</version>
</dependency>
<dependency>
    <groupId>junit</groupId>
    <artifactId>junit</artifactId>
    <version>4.10</version>
</dependency>

package com.itheima.domain;
import java.io.Serializable;
import java.util.Date;
public class User implements Serializable {
    private Integer id;
    private String name;
    private Date birthday;
    private String sex;
    private String address;
    
    public Integer getId() {
        return id;
    }
    public void setId(Integer id) {
        this.id=id;
    }
    public String getname() {
        return name;
    }
    public void setName(String name) {
        this.name=id;
    }
    ......
    @Override
    public void toString() {
        return "User{"+
                "id="+id+
        ......
    }
    
}

public Interface IUserDao {
    /**
    查询所有操作
    */
    List<User> findAll();
}

<?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">

<!--mybatis的主配置文件-->
<configuration>
    <!--配置环境-->
    <environments default="mysql">
        <!--配置mysql的环境-->
        <environment id="mysql">
            <!--配置事务的类型-->
            <transactionManager type="JDBC"></transactionManager>
            <!--配置数据源（连接池）-->
            <dataSource type="POOLED">
                <!--配置连接数据库的4个基本信息-->
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/eesy_mybatis"/>
                <property name="username" value="root"/>
                <property name="password" value="1234"/>
            </dataSource>
        </environment>
    </environments>
    
    <!--指定映射配置文件的位置，映射配置文件指的是每个dao独立的配置文件-->
    <mappers>
        <mapper resource="com/itheima/dao/IUserDao.xml">
    </mappers>
</configuration>

<?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="com.itheima.dao.IUserDao">

    <!--配置查询所有-->
    <!--id的名称需要些dao的方法名称-->
    <select id="findAll" resultType="com.itheima.domain.User">
        select * from user
    </select>
</mapper>

public static void main(String[] args) throws Exception{
    //1、读取配置文件
    InputStream in=Resources.getResourceAsStream("SqlMapConfig.xml");
    //2、创建SqlSessionFactory工厂
    SqlSessionFactoryBuilder builder=new SqlSessionFactoryBuilder();
    SqlSessionFactory factory=builder.build(in);
    //3、使用工厂生产SqlSession对象
    SqlSession session=factory.openSession();
    //4、使用SqlSession创建Dao接口的代理对象
    IUserDao userDao=session.getMapper(IUserDao.class);
    //5、使用代理对象执行方法
    List<User> users=userDao.findAll();
    for(User user:users) {
        System.out.println(user);
    }
    //6、释放资源
    session.close();
    in.close();
}

package com.itheima.dao;

import com.itheima.domain.User;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface IUserDao {

    @Select("SELECT * FROM user")
    List<User> findAll();
}

<!--如果用注解来配置的话，此处应该使用class属性指定被注解的dao全限定类名-->
    <mappers>
        <!--<mapper resource="com/itheima/dao/IUserDao.xml"/>-->
        <mapper class="com.itheima.dao.IUserDao"/>
    </mappers>

package com.itheima.dao.impl;

import com.itheima.dao.IUserDao;
import com.itheima.domain.User;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;

import java.util.List;

public class UserDaoImpl implements IUserDao {
    private SqlSessionFactory factory;
    public UserDaoImpl(SqlSessionFactory factory) {
        this.factory=factory;
    }


    public List<User> findAll() {
        SqlSession session=factory.openSession();
        List<User> users=session.selectList("com.itheima.dao.IUserDao.findAll");
        session.close();
        return users;
    }
}

List<User> users=session.selectList("com.itheima.dao.IUserDao.findAll");

<mapper namespace="com.itheima.dao.IUserDao">  <select id="findAll" resultType="com.itheima.domain.User">

public class MybatisTest {
    public static void main(String[] args) throws Exception{
        //1、读取配置文件
        InputStream in= Resources.getResourceAsStream("SqlMapConfig.xml");
        //2、创建SqlSessionFactory
        SqlSessionFactoryBuilder builder=new SqlSessionFactoryBuilder();
        SqlSessionFactory factory=builder.build(in);
        //3、创建SqlSession
//        SqlSession session=factory.openSession();
//        //4、创建Dao的代理对象
//        IUserDao dao=session.getMapper(IUserDao.class);
        UserDaoImpl dao=new UserDaoImpl(factory);
        //5、使用代理对象执行方法
        List<User> users=dao.findAll();
        for (User user:users) {
            System.out.println(user);
        }
        //6、释放资源
        in.close();
    }
}

package com.itheima.mybatis.io;

import java.io.InputStream;

public class Resources {

    /**
     * 根据传入的参数，获取一个字节输入流
     * @param filePath
     * @return
     */
    public static InputStream getResourceAsStream(String filePath) {
        return Resources.class.getClassLoader().getResourceAsStream("filePath");
    }
}