华南农业大学Linux课程综合实验——用Java语言，实现从MySQL读取内容并显示在浏览器上

前言

用Java语言实现从Linux的MySQL读取内容并显示在浏览器上

项目结构

项目代码

StudentController.java

package com.controller;

import com.pojo.Student;
import com.service.StudentService;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.List;

/**
 * @Description: 把查询到的结果发送到 jsp
 * @param null 
 * @return null
 * @Author Squirrel_Lee
 * @CreateTime 2022/5/30 19:45
 */

@WebServlet("/studentServlet")
public class StudentController extends HttpServlet {
   
    private StudentService service=new StudentService();
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
   
        List<Student> student=service.selectStudents();
        req.setAttribute("student",student);
        req.getRequestDispatcher("/student.jsp").forward(req,resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
   
        super.doPost(req, resp);
    }
}

StudentMapper.java

package com.mapper;

import com.pojo.Student;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.ResultMap;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @Description:
 * @param null 
 * @return null
 * @Author Squirrel_Lee
 * @CreateTime 2022/5/30 19:45
 */

@Mapper
@Repository
public interface StudentMapper {
   
    @Select("select * from student")
    @ResultMap("studentResultMap")
    List<Student> selectStudents();
}

Student.java

package com.pojo;

/**
 * @Description: ·student实体类
 * @param null 
 * @return null
 * @Author Squirrel_Lee
 * @CreateTime 2022/5/30 19:45
 */

public class Student {
   
    private Integer id;
    private String studentId;
    private String studentName;

    public Integer getId() {
   
        return id;
    }

    public void setId(Integer id) {
   
        this.id = id;