SpringBoot实现MySQL数据前端显示

向右看齐 2022-05-23 08:25 436阅读 0赞

##### 使用springboot框架进行数据库信息的读取并且展示在页面上。Springboot框架相对来说比较简单，直接在pom文件中加入依赖就可以直接使用服务器，不需要再搭建tomcat。 #####

*  定义映射实体类，类中的属性和类型要和数据库表中的字段相对应

@Entity
    public class ExceptionOutput { 
        @Id
        @GeneratedValue(strategy= GenerationType.AUTO)
    
        private int id;
        private String fan_no;
        private String call_time;
        private int call_count;
    
        public int getId() {
            return id;
        }
    
        public void setId(int id) {
            this.id = id;
        }
    
        public void setFan_no(String fan_no) {
            this.fan_no = fan_no;
        }
    
        @Override
        public String toString() {
            return "ExceptionOutput{" +
                    "id=" + id +
                    ", fan_no='" + fan_no + '\'' +
                    ", call_time='" + call_time + '\'' +
                    ", call_count=" + call_count +
                    '}';
        }
    
        public void setCall_time(String call_time) {
            this.call_time = call_time;
        }
    
        public void setCall_count(int call_count) {
            this.call_count = call_count;
        }
    
        public String getFan_no() {
            return fan_no;
        }
    
        public int getCall_count() {
            return call_count;
        }
    
    
    
        public String getCall_time() {
            return call_time;
        }
    }

*  定义数据访问层

public interface ExceptionInfoRepository extends JpaRepository<ExceptionOutput, Long> { 
    
    }

*  定义Controller类

@Controller
    public class InforController { 
        @Autowired
        private ExceptionInfoRepository info;
        @RequestMapping("/query")
        @ResponseBody
        public List queryAll(){
            return  info.findAll();
        }
        @RequestMapping("/hat")
        public String Show(Model model){
            model.addAttribute("info",info.findAll());
            return "blank";
        }

*  进行数据访问并输出到表格中

</div>
                 <div class="row">
                <div class="col-md-12">
                   <div class="alert alert-success">
                       <table border="2" align="center">
                           <tr>
                               <td>序号</td>
                               <td>风机编号</td>
                               <td>报警时间</td>
                               <td>30s内温度高于80度次数</td>
                           </tr>
                           <tr th:each ="i:${info}">
                               <td th:text = "${ i.id}"></td>
                               <td th:text = "${ i.fan_no}"></td>
                               <td th:text = "${ i.call_time}"></td>
                               <td th:text = "${ i.call_count}"></td>
                           </tr>
                       </table>
                   </div>
                </div>
    
            </div>

![这里写图片描述][70]  
[工程源码][Link 1]  
注解需要注意几个相应的类对应要明确

[70]: /images/20220523/699ef66ec9b549578b5c75e8dff5b339.png
[Link 1]: https://github.com/random0815/shuang_0815/tree/master/Monitor