手动启动MyBatists

喜欢ヅ旅行 2022-06-14 09:50 172阅读 0赞

![这里写图片描述][SouthEast]

package mybatis.boot;
    
    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 mybatis.dao.UserMapper;
    import mybatis.domain.User;
    
    public class Test {
    
        public static void main(String[] args) throws Exception {
            Reader reader = Resources.getResourceAsReader("mybatis/config/Configuration.xml"); 
            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
            SqlSession session = sqlSessionFactory.openSession();
    //      User user = (User)session.selectOne("mybatis.dao.UserMapper.getUserById", 1);
    
    
            //以接口方式交互数据
            UserMapper userMapper = session.getMapper(UserMapper.class);
            User user = userMapper.getUserById(1);
            System.out.println(user.getName());
    
    
        }
    
    }

<?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>  
        <typeAliases>  
            <typeAlias alias="User" type="mybatis.domain.User" />  
        </typeAliases>  
    
        <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/shop" />  
                <property name="username" value="root" />  
                <property name="password" value="" />  
            </dataSource>  
          </environment>  
        </environments>  
    
        <mappers>  
            <mapper resource="mybatis/Mapper/User.xml" />  
        </mappers>  
     </configuration>

package mybatis.dao;
    
    import mybatis.domain.User;
    
    public interface UserMapper { 
    
        public User getUserById(int id);
    }

<?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="mybatis.dao.UserMapper">  
        <select id="getUserById" parameterType="int" resultType="mybatis.domain.User">  
            select * from `user` where id = #{id}  
        </select>  
    </mapper>

[SouthEast]: /images/20220614/c0ed7e423b884ad39f34ba6303ea0583.png