eclipse构建maven+spring+mybatis控制台应用。

使用maven+spring+mybatis构建控制台应用，方便调试spring或者mybatis代码，或者编写测试代码。

一，首先使用eclipse构建maven项目。详细教程。

二，在你的 pom.xml 文件<denpendencies></denpendencies>节点中加入如下引用信息。

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-context</artifactId>
    <version>5.3.4</version>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-core</artifactId>
    <version>5.3.4</version>
</dependency>

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

然后执行拉取命令：mvn install

二，在resource目录下新建mybatis-config.xml文件。用于配置mybatis和连接数据库。

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
  PUBLIC "-////DTD Config 3.0//EN"
  "http:///dtd/mybatis-3-config.dtd">
<configuration>

    
    
    <settings>
    
      
        
        <!--将以下画线方式命名的数据库列映射到 Java 对象的驼峰式命名属性中-->
        <setting name= "mapUnderscoreToCamelCase" value="true" />
    </settings>
    <!--简化类命名空间 -->
   <!--  <typeAliases>
        <package name="tk.mybatis.simple.model" />
    </typeAliases> -->

  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC"/>
      <dataSource type="POOLED">
        <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/wxapp"/>
        <property name="username" value="root"/>
        <property name="password" value="0412"/>
      </dataSource>
    </environment>
  </environments>
    <mappers>
        <!--常规做法-->
        <!--<mapper resource="tk/mybatis/simple/mapper/CountryMapper.xml" />-->
        <!--<mapper resource="tk/mybatis/simple/mapper/PrivilegeMapper.xml" />-->
        <!--<mapper resource="tk/mybatis/simple/mapper/RoleMapper.xml" />-->
        <!--<mapper resource="tk/mybatis/simple/mapper/RolePrivilegeMapper.xml" />-->
        <!--<mapper resource="tk/mybatis/simple/mapper/UserMapper.xml" />-->
        <!--<mapper resource="tk/mybatis/simple/mapper/UserRoleMapper.xml" />-->
        <!--第二种做法-->
        <!-- <package name="tk.mybatis.simple.mapper"/> -->
        
        <mapper resource="userMapper.xml" />
    </mappers>
</configuration>

View Code

另新建applicationContext.xml文件，用于配置spring beans。

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www./schema/beans"
   xmlns:xsi="http://www./2001/XMLSchema-instance"
   xmlns:context="http://www./schema/context"
   xmlns:mvc="http://www./schema/mvc"
   xsi:schemaLocation="http://www./schema/beans
   http://www./schema/beans/spring-beans.xsd
   http://www./schema/context
   http://www./schema/context/spring-context.xsd
   http://www./schema/mvc
   http://www./schema/mvc/spring-mvc.xsd">

<bean id="helloWorld" class="beans.helloWorld">

    <property name = "who">
    <value> hello world spring</value>
    </property>
</bean>

</beans>

View Code

新建资源文件夹mappers，并新建userMapper.xml文件。

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper   
PUBLIC "-//ibatis.//DTD Mapper 3.0//EN"  
"http://ibatis./dtd/ibatis-3-mapper.dtd">

<mapper namespace="entity.myuser">
    <select id="getName" resultType="String">
        select role_name from t_role
        where id= #{id}
    </select>
</mapper>

View Code

三，编写主函数测试：

package main;
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.springframework.context.ApplicationContext;
import org.springframework.context.support.FileSystemXmlApplicationContext;

import beans.helloWorld;

public class test {

    public static void main(String[] args) throws IOException {
    
            ApplicationContext context = new FileSystemXmlApplicationContext("src/main/resources/applicationContext.xml");
            
            helloWorld hel = (helloWorld) context.getBean("helloWorld");
            hel.print();
            
            
            /* mybatis ����*/
            //����sql����
            String  resources = "mybatis-config.xml"; //�����ļ���ַ
            
            InputStream is = Resources.getResourceAsStream(resources);
            
            SqlSessionFactory fac = new  SqlSessionFactoryBuilder().build(is);
            
            SqlSession sqls = fac.openSession();
            
            String name = sqls.selectOne("entity.myuser.getName", 1);
            
            System.out.println(name);
            
            sqls.close();
            
                    
    }

}

View Code

注意：获取spring的ApplicationContext 对象使用FileSystemXmlApplicationContext方法，是从应用根目录寻找配置文件，需要填写配置文件路径。

ApplicationContext context = new FileSystemXmlApplicationContext("src/main/resources/applicationContext.xml");

而mybatis是从资源文件中寻找配置文件，所以不需要写路径。

String resources = "mybatis-config.xml"; 
InputStream is = Resources.getResourceAsStream(resources);

四，完整代码地址：

gitee：https:///zhangdabao2019/mvn_spring_mybatis.git