1 建立servlet的类继承httpServlet类 实现dao查询数据库 将数据库查询的数据 采用表格显示到浏览器上面
文件准备阶段有很多其他的项目,下面只放了一个主界面
package com.example.controller;
import com.example.model.User;
import com.example.service.IUserService;
import com.example.service.impl.UserServiceImpl;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.*;
import java.io.IOException;
import java.lang.reflect.Field;
import java.util.List;
@WebServlet(name = "Servlet", value = "/Servlet")
public class Servlet extends HttpServlet {
IUserService userService = new UserServiceImpl();
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//定义响应头 设置为html格式 字符集为utf-8
response.setContentType("text/html;charset=utf-8");
//获取全部user对象放到集合中
List<User> list=userService.getAllUser();
System.out.println(list);
//前后端不分离 设置css样式 以及html代码 y
//用java 字符串拼接的形式
String css="<style>"+
"table,tr,td{"+
"border:solid 1px red;"+
"border-collapse:collapse;}"+
"</style>"+
"<table>";
String aa=
"<style>\n" +
" table,tr,td{\n" +
" border: solid black 1px;\n" +
" border-collapse: collapse;\n" +
" }"+ "</style>"+
"<table>";
String str=css;
for (int i=0;i<list.size();i++){
Field[] fields=list.get(i).getClass().getDeclaredFields();
System.out.println
("循环"+fields);
str+="<tr>";
//每个对象 占一行 即为一个tr
for (int j=0;j<fields.length;j++){
//对象的每一个属性占一个td
if (!fields[j].isAccessible()){
fields[j].setAccessible(true);
}
try {
Object obj=fields[j].get(list.get(i));
str+="<td>"+obj+"</td>";
System.out.println(obj);
} catch (IllegalAccessException e) {
e.printStackTrace();
}
}
str+="</tr>";
}
str+="</table>";
//将 代码渲染到html 后端渲染
response.getWriter().write(str);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
}
}