整理学习的框架(2)--mybatis+spring_学习喜欢整理框架-CSDN博客

整理学习的框架(2)–mybatis+spring

简单整合Spring与mybatis

核心
~Spring核心配置文件 applicationContext.xml
~mybatis配置文件Configyration.xml
~映射文件处理
java项目结构
代码示例–User.java

package gwx.entity;

public class User {
    private Integer id;
    private String name;
    private Integer age;
    public Integer getId() {
        return id;
    }
    public void setId(Integer id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public Integer getAge() {
        return age;
    }
    public void setAge(Integer age) {
        this.age = age;
    }
    @Override
    public String toString() {
        return "User [id=" + id + ", name=" + name + ", age=" + age + "]";
    }
    public User() {
        super();
        // TODO Auto-generated constructor stub
    }

}

代码示例–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="www.gwx.mapper.UserMapper">
    <select id="getById" parameterType="int" resultType="User">
        select * from user where id =#{id}
    </select>
</mapper>

代码示例–UserMapper.java

package gwx.mapper;

import gwx.entity.User;

public interface UserMapper {
//方法名与mapper文件中id一致
    public User getById(Integer id); 
}

代码示例–Configuration.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>
    <typeAliases>
        <typeAlias alias="User" type="gwx.entity.User"/>
    </typeAliases>
</configuration>

代码示例–applicationContext.xml

<?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:tx="http://www.springframework.org/schema/tx"
   xmlns:aop="http://www.springframework.org/schema/aop" 
   xsi:schemaLocation="
        http://www.springframework.org/schema/beans 
        http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
        http://www.springframework.org/schema/tx 
        http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
        http://www.springframework.org/schema/aop 
        http://www.springframework.org/schema/aop/spring-aop-4.0.xsd">

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/health_test"/>
        <property name="username" value="root"/>
        <property name="password" value="113036"/>
    </bean>

    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="configLocation" value="classpath:Configuration.xml"/>
    </bean>

    <bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
        <property name="sqlSessionFactory" ref="sqlSessionFactory"/>
        <property name="mapperInterface" value="gwx.mapper.UserMapper"/>
    </bean>


</beans>

代码示例–Test.java

package gwx.test;

import gwx.entity.User;
import gwx.mapper.UserMapper;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;


public class Test {
    public static ApplicationContext ctx;

    static{
            ctx=new ClassPathXmlApplicationContext("applicationContext.xml");
    }

    public static void main(String[] args) {
        UserMapper mapper = (UserMapper) ctx.getBean("userMapper");
        User user = mapper.getById(1);
        System.out.println(user.toString());
    }
}