目录
从后往前做(也可以选择从前往后,看个人习惯)
alt+回车=导包
一、实体类创建
TabUsers
属性对照数据库哦~
package com.demo.model;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
/**
* 用户表
*/
@Data//lombok插件给的,可以不用自己敲getset
@NoArgsConstructor//无参构造
@AllArgsConstructor//有参构造
public class TabUsers extends Pager{
private String id;
private String loginname;
private String password;
private String username;
private String age;
private String sex;
private String tel;
private String email;
private String flag;
private String em1;
private String em2;
private String em3;
private String em4;
private String em5;
}
二、mapping里数据库查询语句
resultType返回值类型
<?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.demo.dao.TaberUsersDao">
<!-- 查询所有 -->
<select id="findAll" resultType="Users">
select User_id,User_nickname,Test_categories_number,User_gender,
User_real_name,User_mailbox,User_phoneNumber,User_signature,
User_password,User_note,User_membership_status
from user_table;
</select>
</mapper>
三、DAO层数据层
@Mapper
来和mapping对接
package com.demo.dao;
import com.demo.model.Users;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;
@Mapper//对接回mapping
public interface TaberUserDao {
//public可省略
public List<Users> findAll();
}
四、service和serviceImpl业务层
注意选import javax.servlet.http.HttpServletRequest;
这里是业务,业务主要是来处理接下来所产生所有指令和动作
package com.demo.service;
import com.demo.model.Users;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
public interface TableUserService {
//public可省略
//查询所有
public void view(HttpServletRequest request);
}
package com.demo.service.serviceImpl;
import com.demo.dao.TableUserDao;
import com.demo.model.Users;
import com.demo.service.TableUserService;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import java.util.List;
@Service
public class TableUserServiceImpl implements TableUserService {
@Resource
private TableUserDao dao;//引入容器,方便使用
/**
* service 这里是业务,业务主要是来处理接下来所产生所有指令和动作
* view()主要作用是查询所有数据
* 业务应该写在service这里
*/
@Override
public void view(HttpServletRequest request) {
List<Users> list=dao.findAll();
request.setAttribute("list",list);
}
}
五、controller
package com.demo.controller;
import com.demo.service.TableUserService;
import lombok.extern.log4j.Log4j2;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
@Controller
@Log4j2//日志,用于打印错误数据
public class TableUserController {
/**
* Controller 前后台数据交互
*/
@Resource//容器
private TableUserService service;
@RequestMapping(value = "table_users_view")
public String table_users_view(HttpServletRequest request){
service.view(request);
return "table_users/view";//前端
}
}
六、视图层
<%--
Created by IntelliJ IDEA.
User: Inspiron G3
Date: 2022/4/20
Time: 1:20
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%--先引入--%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<table>
<tr>
<th>用户昵称</th>
<th>用户真实姓名</th>
<th>用户性别</th>
<th>考试类别编号</th>
<th>用户账号</th>
<th>用户邮箱</th>
<th>用户手机号</th>
<th>用户个性签名</th>
<th>用户会员状态</th>
</tr>
<c:forEach var="it" items="${list}" varStatus="vs">
<tr>
<td>${it.User_nickname}</td>
<td>${it.User_real_name}</td>
<td>${it.User_gender}</td>
<td>${it.Test_categories_number}</td>
<td>${it.User_id}</td>
<td>${it.User_mailbox}</td>
<td>${it.User_phoneNumber}</td>
<td>${it.User_signature}</td>
<td>${it.User_membership_status}</td>
</tr>
</c:forEach>
</table>
</body>
</html>