话不多说,直接上代码
目录结构:
applicationContext.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd
">
<context:component-scan base-package="com.dlj.layui"></context:component-scan>
<context:property-placeholder location="classpath:jdbc.properties" />
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="user" value="${user}"></property>
<property name="driverClass" value="${driverClass}"></property>
<property name="jdbcUrl" value="${jdbcUrl}"></property>
<property name="password" value="${password}"></property>
</bean>
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
<!-- 事务 注解驱动 -->
<tx:annotation-driven />
<bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<property name="typeAliasesPackage" value="com.dlj.layui"></property>
<property name="mapperLocations" value="classpath:com/dlj/layui/*.xml"></property>
<property name="plugins">
<array>
<bean class="com.github.pagehelper.PageInterceptor">
<property name="properties">
<value>
</value>
</property>
</bean>
</array>
</property>
</bean>
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="sqlSessionFactoryBeanName" value="sessionFactory"></property>
<property name="basePackage" value="com.dlj.layui"></property>
</bean>
<mvc:annotation-driven />
</beans>
jdbc.properties
driverClass=com.mysql.jdbc.Driver
jdbcUrl=jdbc\:mysql\:///SSM?characterEncoding\=utf8&allowMultiQueries\=true
user=root
password=root
UserEntity.java
package com.dlj.layui.user.entity;
public class UserEntity {
private int id;
private int userage;
private String userName;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public int getUserage() {
return userage;
}
public void setUserage(int userage) {
this.userage = userage;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
@Override
public String toString() {
return "UserEntity [id=" + id + ", userage=" + userage + ", userName="
+ userName + "]";
}
}
UserDao .java
package com.dlj.layui.user.dao;
import java.util.List;
import org.apache.ibatis.annotations.Param;
import com.dlj.layui.user.entity.UserEntity;
public interface UserDao {
public List<UserEntity> getUsers(@Param("user")UserEntity user);
}
UserDao.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "mybatis-3-mapper.dtd" >
<mapper namespace="com.dlj.layui.user.dao.UserDao">
<select id="getUsers" parameterType="com.dlj.layui.user.entity.UserEntity"
resultType="com.dlj.layui.user.entity.UserEntity">
SELECT ID,
USERNAME,
USERAGE
FROM
USERS
</select>
</mapper>
UserService.java
package com.dlj.layui.user.service;
import com.dlj.layui.user.entity.UserEntity;
import com.github.pagehelper.PageInfo;
public interface UserService {
public PageInfo<UserEntity> getUsers(UserEntity user);
}
UserServiceImpl.java
package com.dlj.layui.user.service.impl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import com.dlj.layui.user.dao.UserDao;
import com.dlj.layui.user.entity.UserEntity;
import com.dlj.layui.user.service.UserService;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
@Transactional
@Service
public class UserServiceImpl implements UserService{
@Autowired
private UserDao userDao;
@Override
public PageInfo<UserEntity> getUsers(UserEntity user) {
PageHelper.startPage(10, 20,true);
return new PageInfo<UserEntity>(userDao.getUsers(user));
}
}
UserController.java
package com.dlj.layui.user.controller;
import java.util.List;
import javax.annotation.Resource;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import com.dlj.layui.user.entity.UserEntity;
import com.dlj.layui.user.service.UserService;
import com.github.pagehelper.PageInfo;
@RequestMapping("user")
@Controller
public class UserController {
@Autowired
@Resource(name="userServiceImpl")
private UserService userService;
@ResponseBody
@RequestMapping("user.do")
public Object getUsers(UserEntity user){
PageInfo<UserEntity> users = userService.getUsers(user);
System.out.println(users.getPageNum());
System.out.println(users.getPageSize());
System.out.println(users);
System.out.println(users.getPages());
System.out.println(users.getTotal());
List<UserEntity> list = users.getList();
return list;
}
}
JAR包地址:https://download.csdn.net/download/qq_27243967/10455766
访问地址:http://127.0.0.1:8080/Test1/user/user.do
访问后返回的数据