文章目录
一、实现步骤 1.后端:实体类[po层]-->实体的Mapper接口[dao层]-->实体接口的xml配置文件[dao层]-->实体的Service接口[service层]-->实体的service实现类[service层]-->实体的控制类[controller层] 2.前端:/user/user.jsp页面-->/user/-->
二、实现方法 1.user.java 2.UserMapper.java 3.UserMapper.xml 4.UserService.java 5.UserServiceImpl 6.UserController.java 7.user.jsp
一、实现步骤
1.后端:实体类[po层]–>实体的Mapper接口[dao层]–>实体接口的xml配置文件[dao层]–>实体的Service接口[service层]–>实体的service实现类[service层]–>实体的控制类[controller层]
2.前端:/user/user.jsp页面–>/user/–>
二、实现方法
1.user.java
package com.javapandeng.po;
import java.io.Serializable;
public class User implements Serializable {
private Integer id;
private String userName;
private String passWord;
private String phone;
private String realName;
private String sex;
private String address;
private String email;
public User(Integer id, String userName, String passWord, String phone, String realName, String sex, String address, String email) {
this.id = id;
this.userName = userName;
this.passWord = passWord;
this.phone = phone;
this.realName = realName;
this.sex = sex;
this.address = address;
this.email = email;
}
public User() {
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getPassWord() {
return passWord;
}
public void setPassWord(String passWord) {
this.passWord = passWord;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public String getRealName() {
return realName;
}
public void setRealName(String realName) {
this.realName = realName;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", userName='" + userName + ''' +
", passWord='" + passWord + ''' +
", phone='" + phone + ''' +
", realName='" + realName + ''' +
", sex='" + sex + ''' +
", address='" + address + ''' +
", email='" + email + ''' +
'}';
}
}
2.UserMapper.java
package com.javapandeng.mapper;
import com.javapandeng.base.BaseDao;
import com.javapandeng.po.User;
public interface UserMapper extends BaseDao {
}
3.UserMapper.xml
id,userName,passWord,phone,realName,sex,address,email
#{id},#{userName},#{passWord},#{phone},#{realName},#{sex},#{address},#{email}
userName = #{userName},
passWord = #{passWord},
phone = #{phone},
realName = #{realName},
sex = #{sex},
address = #{address},
email = #{email}
and id = #{id}
and userName = #{userName}
and passWord = #{passWord}
and phone = #{phone}
and realName = #{realName}
and sex = #{sex}
and address = #{address}
and email = #{email}
insert into manage( ) values( )
delete from manage where id=#{id}
delete from manage where 1=1
delete from manage where 1=1
update manage where 1=1
update manage where id=#{id}
select from manage where 1=1
select from manage
select from manage where 1=1
select from manage where id=#{id}
select from manage where id=#{id}
select from manage where 1=1
select from manage where 1=1
select from manage where 1=1
select from manage where 1=1
insert into user(
) values
(#{item.userName},#{item.passWord},#{item.phone},#{item.realName},#{item.sex},#{item.address},#{item.email})
update user
userName = #{item.userName},
passWord = #{item.passWord},
phone = #{item.phone}
realName = #{item.realName}
sex = #{item.sex}
address = #{item.address}
email = #{item.email}
where 1=1
and id = #{item.id}
${sql}
${sql}
${sql}
${sql}
${sql}
${sql}
${sql}
4.UserService.java
package com.javapandeng.service;
import com.javapandeng.base.BaseService;
import com.javapandeng.po.User;
public interface UserService extends BaseService {
}
5.UserServiceImpl
package com.javapandeng.service.impl;
import com.javapandeng.base.BaseDao;
import com.javapandeng.base.BaseServiceImpl;
import com.javapandeng.mapper.UserMapper;
import com.javapandeng.po.User;
import com.javapandeng.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@Service
public class UserServiceImpl extends BaseServiceImpl implements UserService {
@Autowired
private UserMapper userMapper;
@Override
public BaseDao getBaseDao() {
return userMapper;
}
}
6.UserController.java
package com.javapandeng.controller;
import com.javapandeng.base.BaseController;
import com.javapandeng.po.User;
import com.javapandeng.service.UserService;
import com.javapandeng.utils.Pager;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
@Controller
@RequestMapping("/user")
public class UserController extends BaseController {
@Autowired
private UserService userService;
@RequestMapping("/findBySql")
public String findBySql(Model model,User user){
String sql = "select * from user where 1=1 ";
if(!isEmpty(user.getUserName())){
sql += " and userName like '%"+user.getUserName()+"%' ";
}
sql+=" order by id";
Pager pagers = userService.findBySqlRerturnEntity(sql);
model.addAttribute("pagers",pagers);
model.addAttribute("obj",user);
return "user/user";
}
}
7.user.jsp
<%@page language="java" contentType="text/html; character=UTF-8" pageEncoding="UTF-8" %>
<%--引入公共标签页面--%>
<%@include file="/common/taglibs.jsp"%>
<%--【管理员后台-用户管理模块:第七步创建前端/user/user.jsp页面】--%>
管理员后台-湖北工程学院
<%--引入css、js文件,同时使用了公共标签页面里面配置了的上下文路径ctx--%>
用户名
手机号
真实姓名
性别
邮箱
地址
${data.userName}
${data.phone}
${data.realName}
${data.sex}
${data.email}
${data.address}
<%--分页显示用户信息--%>
共${pagers.total}记录,共${pageNumber}页,
当前第${curPage}页
首页
上一页
[${pageNumber}]
${pageNumber}
下一页
尾页
尾页