Spring+Mybatis

最新推荐文章于 2024-09-29 20:00:00 发布

Am0913

最新推荐文章于 2024-09-29 20:00:00 发布

阅读量154

点赞数

分类专栏： java 文章标签： spring mybatis

本文链接：https://blog.csdn.net/qq_28765061/article/details/52208941

版权

java 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

一、环境搭建

1.导入spring的orm包；

2.导入mybatis的jar包；

3.导入MySQL数据连接包。

二、配置文件

1.spring-mybatis.xml

	<!-- 配置数据源 -->
	<bean id="jdbcDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
		<property name="url" value="jdbc:mysql://localhost:3306/am?useUnicode=true&characterEncoding=utf-8"></property>
		<property name="username" value="root"></property>
		<property name="password" value="123456"></property>
	</bean>
	<!-- 配置会话工厂 -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="jdbcDataSource"></property>
		<property name="mapperLocations" value="classpath:com/am/dao/*.xml"></property>  
	</bean>
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">  
       <property name="basePackage" value="com.am.dao"></property>  
       <property name="sqlSessionFactory" ref="sqlSessionFactory"></property>  
    </bean>

2.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.am.dao.UserDao">  
	<resultMap type="com.am.model.User" id="userMap">
		<id column="c_id" property="id" />
		<result column="c_account" property="account"/>
		<result column="c_password" property="password"/>
	</resultMap>
	<select id="getUser" parameterType="com.am.model.User" resultMap="userMap">  
	    SELECT * FROM t_user WHERE c_account=#{account} AND c_password=#{password}  
	</select> 
</mapper>