<?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>
    <!--   MyBatis配置文件-->
    <settings>
        <setting name="logImpl" value="STDOUT_LOGGING"/>
        <setting name="mapUnderscoreToCamelCase" value="true"/>
    </settings>
    <!-- 為類配置別名-->
    <typeAliases>
        <!--<typeAlias type="com.kid.mybatispro.model.Admin" alias="Admin"></typeAlias>-->
        <package name="com.kid.mybatispro.model"/>
    </typeAliases>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <!--type="POOLED" 使用數(shù)據(jù)庫連接池功能-->
            <dataSource type="POOLED">
                <!-- 數(shù)據(jù)庫連接的配置-->
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://127.0.0.1:3306/ssmdb?serverTimezone=Asia/Shanghai"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>
    <!-- 注冊映射文件-->
    <mappers>
        <mapper resource="mappers/AdminMapper.xml"></mapper>
    </mappers>
</configuration>

 create table admin(
   id int  primary key auto_increment,
   account varchar(20),
   password varchar(20),
   gender CHAR(1)
 )

package com.kid.mybatispro.dao;
import com.kid.mybatispro.model.Admin;
import org.apache.ibatis.annotations.Param;
import java.util.List;
public interface AdminDao {
    //單個參數(shù)傳遞
    Admin findAdminById(int id);
    Admin findAdminByAccount(int id);
    //多個參數(shù)的傳遞
    Admin login(@Param("acc") String account, @Param("pass") String password);
    Admin login1(Admin admin);
    // 添加數(shù)據(jù)
    void insertAdmin(Admin admin);
    void deleteAdmin(int id);
    void updateAdmin(Admin admin);
    int findAdminCount();
    String findAdminId(String account);
    List<Admin> findAdmins();
}

<?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="接口的地址">
<select id="findAdminById" parameterType="int" resultType="com.ffyc.mybatis.model.Admin">
select * from admin where id = #{id} </select> </mapper>

    public static void main(String[] args) throws IOException {
        //MyBatis讀取配置文件
        Reader reader = Resources.getResourceAsReader("mybatis.xml");
        //創(chuàng)建 SqlSessionFactory   負(fù)責(zé)創(chuàng)建SqlSession對象(連接數(shù)據(jù)庫的會話對象,類似Connection)
        //SqlSessionFactory對象只需要創(chuàng)建一次，不需要銷毀
        SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
        //創(chuàng)建SqlSession對象
        SqlSession sqlSession = sessionFactory.openSession();
        //創(chuàng)建接口的代理對象
        AdminDao adminDao = sqlSession.getMapper(AdminDao.class);
        Admin admin = adminDao.findAdminById(1); //讓代理對象帶我們巧用映射文件中與此接口中相同名稱的方法
        System.out.println(admin);
    }