Spring整合Mybatis

最新推荐文章于 2024-11-23 20:46:58 发布

原创最新推荐文章于 2024-11-23 20:46:58 发布 · 285 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍了一个基于MyBatis的用户模块实现过程，包括User类定义、UserDao接口、UserMapper配置文件以及Spring整合等内容。通过具体代码展示了如何使用MyBatis进行数据库操作。

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

一、项目工程代码整体结构

二、User.java

package entity;

public class User {

	private long id;
	private String username;
	private String password;
	
	public long getId() {
		return id;
	}
	public void setId(long 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;
	}
	
	
}

三、UserDao

package dao;

import entity.User;

public interface UserDao {

	public User searchUser();
}

四、UserMapper

<?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="dao.UserDao">
	
	<resultMap type="entity.User" id="user">
		<id property="id" column="id"/>
		<result property="username" column="username"/>
		<result property="password" column="password"/>
	</resultMap>

	<!-- 根据条件查询逻辑节点信息 -->
	<select id="searchUser" resultMap="user">
		select * from t_user;
	</select>
	
</mapper>

五、mybatis配置文件

<?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="dao/daoImpl/UserMapper.xml" />
	</mappers>
</configuration>

六、spring配置文件

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"
	   xmlns:tx="http://www.springframework.org/schema/tx"
	   xmlns:jpa="http://www.springframework.org/schema/data/jpa"
	   xmlns:p="http://www.springframework.org/schema/p"
	   xmlns:redis="http://www.springframework.org/schema/redis"
	   xmlns:aop="http://www.springframework.org/schema/aop" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
	   xsi:schemaLocation="http://www.springframework.org/schema/tx 
						   http://www.springframework.org/schema/tx/spring-tx.xsd
						   http://www.springframework.org/schema/beans 
						   http://www.springframework.org/schema/beans/spring-beans.xsd
						   http://www.springframework.org/schema/data/jpa
						   http://www.springframework.org/schema/data/jpa/spring-jpa.xsd
						   http://www.springframework.org/schema/context
						   http://www.springframework.org/schema/context/spring-context.xsd
						   http://www.springframework.org/schema/redis  
        				   http://www.springframework.org/schema/redis/spring-redis.xsd 
        				   http://www.springframework.org/schema/aop 
        				   http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">

	<context:annotation-config />

	<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/test?useUnicode=true&characterEncoding=UTF-8" />
		<property name="username" value="hqq1007" />
		<property name="password" value="123456" />
	</bean>


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

	<bean id="userDao" class="org.mybatis.spring.mapper.MapperFactoryBean">  
	    <property name="mapperInterface" value="dao.UserDao"/>  
	    <property name="sqlSessionFactory" ref="sqlSessionFactory"/>  
	</bean>
    
    
</beans>

七、测试

ApplicationContext ctx = null;
ctx = new ClassPathXmlApplicationContext("myspring.xml");
UserDao userDao = (UserDao) ctx.getBean("userDao");
User user = userDao.searchUser();
System.out.println(user.getUsername());

八、所需jar包

点击打开链接