Spring整合MyBatis并手动启动

来源：互联网发布：mac如何重装编辑：程序博客网时间：2024/06/14 19:39

driver=com.mysql.jdbc.Driverurl=jdbc:mysql://localhost:3306/shopusername=rootpassword=#\u5B9A\u4E49\u521D\u59CB\u8FDE\u63A5\u6570  initialSize=0  #\u5B9A\u4E49\u6700\u5927\u8FDE\u63A5\u6570  maxActive=20  #\u5B9A\u4E49\u6700\u5927\u7A7A\u95F2  maxIdle=20  #\u5B9A\u4E49\u6700\u5C0F\u7A7A\u95F2  minIdle=1  #\u5B9A\u4E49\u6700\u957F\u7B49\u5F85\u65F6\u95F4  maxWait=60000

<?xml version="1.0" encoding="UTF-8"?>  <beans xmlns="http://www.springframework.org/schema/beans"      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"      xmlns:context="http://www.springframework.org/schema/context"      xmlns:mvc="http://www.springframework.org/schema/mvc"      xsi:schemaLocation="http://www.springframework.org/schema/beans                            http://www.springframework.org/schema/beans/spring-beans-3.1.xsd                            http://www.springframework.org/schema/context                            http://www.springframework.org/schema/context/spring-context-3.1.xsd                            http://www.springframework.org/schema/mvc                            http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">      <!-- 引入配置文件 -->      <bean id="propertyConfigurer"          class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">          <property name="location" value="classpath:config/jdbc.properties" />      </bean>      <!-- spring和MyBatis完美整合，不需要mybatis的配置映射文件 -->      <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">          <property name="dataSource" ref="dataSource" />           <property name="configLocation" value="classpath:spring_mybatis/mybatis-config.xml"></property>        <!-- 自动扫描mapping.xml文件 -->          <property name="mapperLocations" value="classpath:mybatis/Mapper/*.xml"></property>      </bean>     <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"          destroy-method="close">          <property name="driverClassName" value="${driver}" />          <property name="url" value="${url}" />          <property name="username" value="${username}" />          <property name="password" value="${password}" />          <!-- 初始化连接大小 -->          <property name="initialSize" value="${initialSize}"></property>          <!-- 连接池最大数量 -->          <property name="maxActive" value="${maxActive}"></property>          <!-- 连接池最大空闲 -->          <property name="maxIdle" value="${maxIdle}"></property>          <!-- 连接池最小空闲 -->          <property name="minIdle" value="${minIdle}"></property>          <!-- 获取连接最大等待时间 -->          <property name="maxWait" value="${maxWait}"></property>      </bean>      <!-- DAO接口所在包名，Spring会自动查找其下的类 -->      <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">          <property name="basePackage" value="mybatis.dao" />          <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>      </bean>  </beans>

<?xml version="1.0" encoding="UTF-8"?>  <beans xmlns="http://www.springframework.org/schema/beans"      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"      xmlns:context="http://www.springframework.org/schema/context"      xmlns:mvc="http://www.springframework.org/schema/mvc"      xsi:schemaLocation="http://www.springframework.org/schema/beans                            http://www.springframework.org/schema/beans/spring-beans-3.1.xsd                            http://www.springframework.org/schema/context                            http://www.springframework.org/schema/context/spring-context-3.1.xsd                            http://www.springframework.org/schema/mvc                            http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">    <bean id="test" class="spring_mybatis.Test"></bean></beans>

<?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>    <settings>        <!-- 打印查询语句 -->        <setting name="logImpl" value="STDOUT_LOGGING" />    </settings></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>

package spring_mybatis;import org.springframework.beans.factory.annotation.Autowired;import mybatis.dao.UserMapper;import mybatis.domain.User;public class Test {    @Autowired    UserMapper userMapper;    public void test() {        User user = userMapper.getUserById(1);        System.out.println(user.getName());    }}

package spring_mybatis;import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;public class Start {    public static void main(String[] args) {         //整合spring mybatis         ApplicationContext ctx = new ClassPathXmlApplicationContext(                 new String[] {                         "spring_mybatis/spring.xml"                        ,"spring_mybatis/spring-mybatis.xml"                  });         Test test = (Test) ctx.getBean("test");         test.test();    }}

这里写图片描述

阅读全文

1 0