spring整合mybatis

最新推荐文章于 2025-08-09 19:50:58 发布

原创最新推荐文章于 2025-08-09 19:50:58 发布 · 259 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#spring #mybatis #java

本文详细介绍如何使用Spring框架整合MyBatis实现持久层操作，包括数据库连接配置、实体类定义、Mapper接口及XML文件编写，并通过测试类验证功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.建数据库springmybaitis(多了一个i) ,再建表名为user  属性id username password

package com.itcast.pojo;

public class User {
    private int id;
    private String username;
    private String password;
    public User(){}
    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;
    }
    public String toString(){
        return "User[id="+id+" , username="+username+" , password="+password+"]";
    }
    


}

package com.itcast.dao;

import com.itcast.pojo.User;

public interface UserDao {
    public void addUser(User user);
   /* public User getUser(User user);
    public void updateUser(User user);
    public void deleteUser(int UserId);*/
}

UserDao.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="com.itcast.dao.UserDao">  
   
    <insert id="addUser" parameterType="com.itcast.pojo.User" >  
         INSERT INTO user (id,username,password) VALUES (#{id},#{username},#{password})  
    </insert>  
</mapper>

applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"
    xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
    http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
    http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-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/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">
 

     <context:property-placeholder location="classpath:db.properties" />

    <!-- 数据库连接池 -->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
        destroy-method="close">
        <property name="driverClassName" value="${jdbc.driver}" />
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.username}" />
        <property name="password" value="${jdbc.password}" />
        <property name="maxActive" value="10" />
        <property name="maxIdle" value="5" />
    </bean>
    
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
    <property name="dataSource" ref="dataSource" />  
    <property name="configLocation" value="classpath:mybatis-config.xml"></property>  
</bean>
  
<bean id="userDao" class="org.mybatis.spring.mapper.MapperFactoryBean">  
    <property name="mapperInterface" value="com.itcast.dao.UserDao"></property>  
    <property name="sqlSessionFactory" ref="sqlSessionFactory"></property>  
</bean> 
 
</beans>

db.properties 这里数据库名是springmybaitis 多了一个i

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/springmybaitis?characterEncoding=utf-8
jdbc.username=root
jdbc.password=admin

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>  
    <mappers>  
        <mapper resource="com/itcast/dao/UserDao.xml"/>  
    </mappers>  
</configuration>

再来一个测试类

package com.itcast.test;

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

import com.itcast.dao.UserDao;
import com.itcast.pojo.User;

public class TestUser {   
    @Test   
    public void testadd() {
            ApplicationContext ac=new ClassPathXmlApplicationContext("applicationContext.xml");
            UserDao userDao=(UserDao) ac.getBean("userDao");
            User user=new User();
            //添加两条数据
            user.setId(1);
            user.setUsername("NBA");
            user.setPassword("AAA");
            userDao.addUser(user);
            user.setId(2);
            user.setUsername("CBA");
            user.setPassword("123");
            userDao.addUser(user);
            System.out.println("添加成功");