Mybatis基础环境配置 (1)

ゝ一世哀愁。 2022-10-02 01:56 181阅读 0赞

[2019独角兽企业重金招聘Python工程师标准>>> ][2019_Python_] ![hot3.png][]

1、下载Mybatis 下载地址：github [https://github.com/mybatis/mybatis-3/releases][https_github.com_mybatis_mybatis-3_releases]

zip包必选，Source code 可选（方便以后学习，全下载了）

![161143\_Pzfg\_1586492.png][161143_Pzfg_1586492.png]

2、解压后如下图：

![161427\_U4eF\_1586492.png][161427_U4eF_1586492.png]

lib中放的是 mybatis 依赖包， mybatis.jar 和 lib中的jar 都要导入项目中。

3、由于要操作数据库，所以还需要 JDBC driver for MySQL.

官方地址：[http://dev.mysql.com/downloads/connector/j/][http_dev.mysql.com_downloads_connector_j]

所有需要的文件我已经打包到腾讯云，方便大家下载，希望腾讯云不要像360云盘如此恶心。

下载地址：[http://url.cn/40qtmQm][http_url.cn_40qtmQm]

4、打开eclipse 新建 java 项目，导入所有jar包

![162904\_467C\_1586492.png][162904_467C_1586492.png]

5、成功后目录如下图：

![163126\_hn63\_1586492.png][163126_hn63_1586492.png]

6、新建mybatis配置文件，mapper文件，统一放在config文件夹下

![233029\_5IDZ\_1586492.png][233029_5IDZ_1586492.png]

mybatis-config.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/mybatis" />
    				<property name="username" value="root" />
    				<property name="password" value="123456" />
    			</dataSource>
    		</environment>
    	</environments>
    	<mappers>
    		<mapper resource="Mapper/UserMapper.xml" />
    	</mappers>
    </configuration>

UserMapper.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">
    
    <mapper namespace="user">
    
    	<select id="findUserById" parameterType="int" resultType="com.stones.mybatis.pojo.User">
    		SELECT * FROM user WHERE id = #{id}
    	</select>
    	
    </mapper>

pojo类

package com.stones.mybatis.pojo;
    
    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;
    	}
    	
    	
    }

测试类

package com.stones.mybatis.test;
    
    import java.io.IOException;
    import java.io.InputStream;
    
    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 org.junit.*;
    
    import com.stones.mybatis.pojo.User;
    
    public class Test2 {
    
    	@Test
    	public void test() throws IOException {
    		
    		String resource = "MybatisConfig.xml";
    		InputStream inputStream = Resources.getResourceAsStream(resource);
    		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    		
    		SqlSession sqlSession = sqlSessionFactory.openSession();
    		
    		User user = sqlSession.selectOne("user.findUserById", 1);
    		
    		System.out.println(user.getUsername());
    	}
    
    }

7、日志配置

![085039\_zFdM\_1586492.png][085039_zFdM_1586492.png]

log4j.properties

# Global logging configuration
    #测试环境debug模式， 生产环境 info
    log4j.rootLogger=DEBUG, stdout
    # MyBatis logging configuration...
    log4j.logger.org.mybatis.example.BlogMapper=TRACE
    # Console output...
    log4j.appender.stdout=org.apache.log4j.ConsoleAppender
    log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
    log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

转载于:https://my.oschina.net/famoustone/blog/776243

[2019_Python_]: https://my.oschina.net/u/2663968/blog/3061697
[hot3.png]: /images/20220113/8f3820cfa25c45049291320a627eab4c.png
[https_github.com_mybatis_mybatis-3_releases]: https://github.com/mybatis/mybatis-3/releases
[161143_Pzfg_1586492.png]: /images/20220113/494fbf9a92984965a73660c82c5d0dab.png
[161427_U4eF_1586492.png]: /images/20220113/a045e5f0c14f466eac831efd861a9290.png
[http_dev.mysql.com_downloads_connector_j]: http://dev.mysql.com/downloads/connector/j/
[http_url.cn_40qtmQm]: http://url.cn/40qtmQm
[162904_467C_1586492.png]: /images/20220113/34fb493a63164508b6977c53ed359bc0.png
[163126_hn63_1586492.png]: /images/20220113/ae91c43085c64b64b7e95fcc15fbca5d.png
[233029_5IDZ_1586492.png]: /images/20220113/e43492ddbdea439fb8b8111e690ed276.png
[085039_zFdM_1586492.png]: /images/20220113/f602718d558a4485aaf5ce1c7468bcaa.png