SSM框架搭建(含分页)

话不多说,直接上代码

目录结构:


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

访问后返回的数据














  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值