----------------------------------------------------------------------------------------------------------
在mybatis-config.xml中配置如下：
<configuration> <typeAliases> <package name="com.wode.pojo"/> </typeAliases></configuration>
----------------------------------------------------------------------------------------------------------
在db.properties中：
jdbc.driver=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql://127.0.0.1:3306/school?useUnicode=true&characterEncoding=UTF-8 jdbc.username=root jdbc.password=root
----------------------------------------------------------------------------------------------------------
在applicationContext.xml中配置如下：
<context:property-placeholder location="/WEB-INF/classes/db.properties" /> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="${jdbc.driver}" /> <property name="url" value="${jdbc.url}" /> <property name="username" value="${jdbc.username}" /> <property name="password" value="${jdbc.password}" /> </bean> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="configLocation" value="classpath:mybatis-config.xml" /> </bean> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="com.wode.mapper"></property> </bean>
----------------------------------------------------------------------------------------------------------
在UserMapper中：
public interface UserMapper { /** * 获取所有用户总记录数 * @param userName 用户名 * @return 查找到的用户总记录数量的值 */ @Select("select count(*) from t_user where user_name like'%${userName}%'") @ResultType(Integer.class) public int getUserTotalcount(@Param("userName")String userName); /** * 获取所有的用户信息 * @param userName 用户名 * @param page Page对象 * @return 返回查找到的所有用户的集合 */ @Select("select * from t_user where user_name like'%${userName}%' order by user_id desc limit #{startIndex},#{pageSize}") @ResultMap("userMap") public List<User> getAllUsers(@Param("userName")String userName,@Param("startIndex")int startIndex,@Param("pageSize")int pageSize); /** * 添加用户 * @param user User对象 */ @Insert("insert into t_user values(null,#{userName},#{userPwd},#{userPhone},#{userEmail})") public void addUser(User user); /** * 删除用户 * @param userId 用户ID */ @Delete("delete from t_user where user_id=#{userId}") public void deleteUser(@Param("userId")int userId); /** * 修改用户 * @param user User对象 */ @Update("update t_user set user_name=#{userName},user_pwd=#{userPwd},user_phone=#{userPhone},user_email=#{userEmail} where user_id=#{userId}") public void updateUser(User user); /** * 通过用户ID查询用户 * @param userId 用户ID * @return 返回查找到的用用对象 */ @Select("select * from t_user where user_id=#{userId}") @ResultMap("userMap") public User selectUserByUserId(@Param("userId")int userId); /** * 查询用户名是否存在 * @param userName 用户名 * @return int 返回查询该用户的数量，存在返回1，反之返回0; */ @Select("select count(*) from t_user where user_name=#{userName}") @ResultType(Integer.class) public int selectUserNameByUserName(@Param("userName")String userName); /** * 查询用户邮箱是否存在 * @param userEmail 用户邮箱 * @return int 返回查询该用户的数量，存在返回1，反之返回0; */ @Select("select count(*) from t_user where user_email=#{userEmail}") @ResultType(Integer.class) public int selectUserEmailByUserEmail(@Param("userEmail")String userEmail); /** * 通过用户名与用户密码查询用户是否存在(用于用户登录验证) * @param userName 用户名 * @param userPwd 用户密码 * @return 返回查找到的用户 */ @Select("select * from t_user where user_name=#{userName} and user_pwd=#{userPwd}") @ResultMap("userMap") public User login(@Param("userName")String userName,@Param("userPwd")String userPwd); /** * 通过ID删除多个用户 * @param list 传入装有用户ID的集合 */ public void deleteUsersByUsersId(List<Integer> list); }
----------------------------------------------------------------------------------------------------------
在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="com.wode.mapper.UserMapper"> <resultMap type="User" id="userMap"> <id property="userId" column="user_id"/> <result property="userName" column="user_name"/> <result property="userPwd" column="user_pwd"/> <result property="userPhone" column="user_phone"/> <result property="userEmail" column="user_email"/> </resultMap> <delete id="deleteUsersByUsersId" parameterType="int" > delete from t_user where user_id in <foreach item="id" collection="list" open="(" close=")" separator=","> #{id} </foreach> </delete> </mapper>
----------------------------------------------------------------------------------------------------------
