Spring+Mybatis

来源：互联网发布：微信扫码取号排队源码编辑：程序博客网时间：2024/04/29 16:37

一、环境搭建

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>

0 0