引入Mybatis配置及纯学习mybatis使用

Myth丶恋晨 2022-05-28 07:12 232阅读 0赞

第一步：

引入Mybatis的jar包：两种方式，一种创建Maven项目，一种直接下载Myabtis jar包

第一种：pom.xml配置

<groupId>commons-dbcp</groupId>

<artifactId>commons-dbcp</artifactId>

</dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

</dependency>

<groupId>org.mybatis</groupId>

<artifactId>mybatis</artifactId>

</dependency>

<groupId>org.mybatis</groupId>

<artifactId>mybatis-spring</artifactId>

</dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-web</artifactId>

<version>4.2.0.RELEASE</version>

</dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-orm</artifactId>

<version>4.2.0.RELEASE</version>

</dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-expression</artifactId>

<version>4.2.0.RELEASE</version>

</dependency>

配置说明：这个配置是mybatis整合spring的。毫无疑问，mysql驱动包是必要，其次将myabtis核心包引入项目中，另外还要将myabtis-spring整合包引入，这是因为mybatis需要整合mybatis，然后引入spring的核心包。

第二种配置：纯学习mybatis的配置:

只需要配置mybatis的包就行。

步骤如下

新建一个纯java项目，在idea下。

第一步，将jar包引入项目。

ant-1.9.6.jar  
                    ant-launcher-1.9.6.jar  
                    asm-5.2.jar  
                    cglib-3.2.5.jar  
                    commons-logging-1.2.jar  
                    javassist-3.22.0-GA.jar  
                    log4j-1.2.17.jar  
                    log4j-api-2.3.jar  
                    log4j-core-2.3.jar  
                    ognl-3.1.16.jar  
                    slf4j-api-1.7.25.jar  
                    slf4j-log4j12-1.7.25.jar  
                    mybatis-3.4.6.jar

主要配置，mybatis-config.xml，usermapper.xml

mybatis-config.xml

<table> 
 <tbody> 
 <tr> 
 <td><pre style="background-color:#2b2b2b;color:#a9b7c6;font-family:Menlo;font-size:9pt;">&lt;?xml version="1.0" encoding="UTF-8" ?&gt;
&lt;!DOCTYPE configuration
 PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
 "http://mybatis.org/dtd/mybatis-3-config.dtd"&gt;
&lt;configuration&gt;
 &lt;properties resource="com/mybatis/res/jdbc.properties"&gt;
 &lt;/properties&gt;
 &lt;environments default="development"&gt;
 &lt;environment id="development"&gt;
 &lt;transactionManager type="JDBC"/&gt;
 &lt;dataSource type="POOLED"&gt;
 &lt;property name="driver" value="${jdbc.driver}"/&gt;
 &lt;property name="url" value="${jdbc.url}"/&gt;
 &lt;property name="username" value="${jdbc.username}"/&gt;
 &lt;property name="password" value="${jdbc.password}"/&gt;
 &lt;/dataSource&gt;
 &lt;/environment&gt;
 &lt;/environments&gt;
 &lt;mappers&gt;
 &lt;mapper resource="com/mybatis/mapper/usermapper.xml"&gt;&lt;/mapper&gt;
 &lt;/mappers&gt;
&lt;/configuration&gt;</pre></td> 
 </tr> 
 </tbody> 
</table>

main函数测试

<table> 
 <tbody> 
 <tr> 
 <td><pre style="background-color:#2b2b2b;color:#a9b7c6;font-family:Menlo;font-size:9pt;">import com.mybatis.dao.UserDao;
import com.mybatis.pojo.User;
import org.apache.ibatis.annotations.Mapper;
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.apache.log4j.Logger;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;


public class Main {

public static void main(String[] args) {
 Logger logger = Logger.getLogger(Main.class);
 SqlSessionFactory sqlSessionFactory = null;
 String res = "com/mybatis/res/mybatis-config.xml";
 InputStream inputStream;
 try {
 inputStream = Resources.getResourceAsStream(res);
 sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
 SqlSession sqlSession = sqlSessionFactory.openSession();
 UserDao userDao = sqlSession.getMapper(UserDao.class);
 /*List&lt;User&gt; list = userDao.selectAll();
 logger.debug(list);
 */
 User user = userDao.select("root");
 logger.debug(user);

 } catch (IOException e) {
 e.printStackTrace();
 }
 }
}
</pre></td> 
 </tr> 
 </tbody> 
</table>