文件夹设置
UserController代码
package com.zhongruan.controller;
import com.github.pagehelper.PageInfo;
import com.zhongruan.bean.User;
import com.zhongruan.service.IUserService;
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.RequestParam;
import org.springframework.web.servlet.ModelAndView;
import javax.servlet.http.HttpSession;
import java.util.List;
@Controller
public class UserController {
@Autowired
private IUserService userService;
@RequestMapping("/findAll.do")
public ModelAndView findAll(@RequestParam(defaultValue ="1") int pageNum, @RequestParam(defaultValue ="5")int size, String searchname, HttpSession session){
if(searchname!=null){
session.setAttribute("searchname",searchname);
}else {
searchname=(String)session.getAttribute("searchname");
}
List<User>users=userService.findAll(pageNum, size, searchname);
PageInfo<User> pageInfo = new PageInfo<>(users);
ModelAndView modelAndView=new ModelAndView();
modelAndView.setViewName("allUser.jsp");
modelAndView.addObject("pageInfo",pageInfo);
return modelAndView;
}
@RequestMapping("/login.do")
public String login(User user,HttpSession session){
Boolean flag=userService.login(user.getUsername(),user.getPassword());
if (flag){
session.setAttribute("username",user.getUsername());
return "redirect:/findAll.do";
}else {
return "failure.jsp";
}
}
@RequestMapping("/delete.do")
public String deleteById(int id,HttpSession session){
userService.deleteById(id);
return "redirect:findAll.do";
}
@RequestMapping("/toupdate.do")
public ModelAndView toupdate(int id){
ModelAndView modelAndView = new ModelAndView();
modelAndView.addObject("user",userService.selectById(id));
modelAndView.setViewName("updateUser.jsp");
return modelAndView;
}
@RequestMapping("/update.do")
public String update(User user){
userService.update(user);
return "redirect:findAll.do";
}
@RequestMapping("/add.do")
public String add(User user){
if (user != null){
userService.add(user);
}
return "redirect:findAll.do";
}
}
IUserDao代码
package com.zhongruan.dao;
import com.zhongruan.bean.User;
import org.apache.ibatis.annotations.Param;
import java.util.List;
public interface IUserDao {
List<User>findAll(@Param("searchname") String searchname);
User selectByUserName(String username);
User selectById(int id);
void deleteById(int id);
void add(User user);
void update(User user);
}
LoginFilter代码
package com.zhongruan.filter;
import javax.servlet.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
public class LoginFilter implements Filter {
@Override
public void init(FilterConfig filterConfig) throws ServletException {
}
@Override
public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {
HttpServletRequest request=(HttpServletRequest) servletRequest;
HttpServletResponse response=(HttpServletResponse) servletResponse;
HttpSession session=request.getSession();
if(session.getAttribute("username")==null&&request.getRequestURI().indexOf("/login.do")==-1){
response.sendRedirect("index.jsp");
}else {
filterChain.doFilter(request,response);
}
}
@Override
public void destroy() {
}
}
UserService代码
package com.zhongruan.service.impl;
import com.github.pagehelper.PageHelper;
import com.zhongruan.bean.User;
import com.zhongruan.dao.IUserDao;
import com.zhongruan.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class UserService implements IUserService {
@Autowired
private IUserDao userDao;
@Override
public Boolean login(String username,String password) {
User user=userDao.selectByUserName(username);
if(null!=user && password.equals(user.getPassword())){
return true;
}else {
return false;
}
}
@Override
public User selectById(int id) {
return userDao.selectById(id);
}
@Override
public List<User> findAll(int pageNum,int size,String searchname) {
PageHelper.startPage(pageNum,size);
return userDao.findAll(searchname);
}
@Override
public void deleteById(int id) {
userDao.deleteById(id);
}
@Override
public void add(User user) {
userDao.add(user);
}
@Override
public void update(User user) {
userDao.update(user);
}
}
IUserService代码
package com.zhongruan.service;
import com.zhongruan.bean.User;
import java.util.List;
public interface IUserService {
Boolean login(String username,String password);
User selectById(int id);
List<User> findAll(int pageNum,int size,String searchname);
void deleteById(int id);
void add(User user);
void update(User user);
}
UserMapper代码
<?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.zhongruan.dao.IUserDao">
<select id="selectByUserName" parameterType="String" resultType="com.zhongruan.bean.User">
select * from tb_user where username=#{username}
</select>
<select id="findAll" resultType="com.zhongruan.bean.User" parameterType="String">
select * from tb_user
<where>
<if test="searchname!=null">
username like "%"#{searchname}"%"
</if>
</where>
</select>
<delete id="deleteById" parameterType="int">
delete from tb_user where id=#{id}
</delete>
<select id="selectById" parameterType="int" resultType="com.zhongruan.bean.User">
select * from tb_user where id=#{id}
</select>
<update id="update" parameterType="user">
update tb_user set username=#{username},password=#{password} where id=#{id}
</update>
<update id="add" parameterType="com.zhongruan.bean.User">
insert into tb_user(username,password)values(#{username},#{password})
</update>
</mapper>
applicationContext代码
<?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:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.3.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">
<!-- 1.配置数据库相关参数properties的属性:${url} -->
<context:property-placeholder location="classpath:db.properties"/>
<!-- 2.配置数据源 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${jdbc.driver}"/>
<property name="jdbcUrl" value="${jdbc.url}"/>
<property name="user" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
<property name="maxPoolSize" value="30"/>
<property name="minPoolSize" value="2"/>
</bean>
<!-- 3.配置SqlSessionFactory对象 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 注入数据库连接池 -->
<property name="dataSource" ref="dataSource"/>
<!-- 扫描bean包 使用别名 -->
<property name="typeAliasesPackage" value="com.zhongruan.bean"></property>
<!--配置加载映射文件 UserMapper.xml-->
<property name="mapperLocations" value="classpath:mapper/*.xml"/>
<property name="plugins">
<array>
<bean class="com.github.pagehelper.PageInterceptor">
<property name="properties">
<props>
<prop key="helperDialect">mysql</prop>
<prop key="reasonable">true</prop>
</props>
</property>
</bean>
</array>
</property>
</bean>
<!-- 自动生成dao,mapper-->
<!-- 4.配置扫描Dao接口包,动态实现Dao接口,注入到spring容器中 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!-- 给出需要扫描Dao接口包 -->
<property name="basePackage" value="com.zhongruan.dao"/>
<!-- 注入sqlSessionFactory -->
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
</bean>
<!--自动扫描-->
<context:component-scan base-package="com.zhongruan"/>
<!-- 配置事务-->
<!-- 5.配置事务管理器 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<!-- 6.开启事务注解-->
<tx:annotation-driven></tx:annotation-driven>
</beans>
db代码
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/zjgm?characterEncoding=utf-8
jdbc.username=root
jdbc.password=123456
结果