SpringBoot-CRUD+分页与网页灰化（附加一个好玩的小玩意）

SpringBoot总共有3种CRUD+分页:JPA,Mybatis,SQL lite,个人觉得mybatis用起来最方便。

学习教程：https://how2j.cn/k/springboot/springboot-mybatis-crud-pagination/1651.html#nowhere

 

1jar包

     <!-- 分页支持-->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>4.1.6</version>
        </dependency>            

2.PageHelper函数支持

package com.empirefree.springboot.config;

import java.util.Properties;

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import com.github.pagehelper.PageHelper;

/**
* @author Empirefree 胡宇乔:
* @version 创建时间：2020年4月6日 上午11:54:04
*/

@Configuration
public class PageHelperConfig {
    @Bean
    public PageHelper pageHelper(){
        PageHelper pageHelper = new PageHelper();
        Properties p = new Properties();
        p.setProperty("offsetAsPageNum", "true");
        p.setProperty("rowBoundsWithCount", "true");
        p.setProperty("reasonable", "true");
        pageHelper.setProperties(p);
        
        return pageHelper;
    }
}

 

3.Mapper中的CRUD方法：个人建议这里可以自己写个代码生成器，这样方便以后开发springboot项目

package com.empirefree.springboot.mapper;
/**
* @author Empirefree 胡宇乔:
* @version 创建时间：2020年3月18日 下午2:15:10
*/
import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.empirefree.springboot.pojo.Category;
 
@Mapper
public interface CategoryMapper {
    
    //找到所有对象
    @Select("select * from category_ ")
    List<Category> findAllCategory();
    
    //找到所有对象
    @Select("select * from category_ " + "where id like concat ('%',#{id},'%') or name like concat ('%',#{name},'%')")
    List<Category> findBySomeCategory(Category category);
    
    // 根据一个抽象对象找到所有符合要求的对象
    @Select("select * from "+ "category_" +" where id = #{id}")
    public Category findById(Integer id);
/************************可以使用代码生成器****************************************/
    @Insert(" insert into category_ ( name ) values (#{name}) ")
    public int save(Category category); 
     
    @Delete(" delete from category_ where id= #{id} ")
    public void delete(int id);
         
    @Update("update category_ set name=#{name} where id=#{id} ")
    public int update(Category category); 
}

 

4：Contrller层：注意，这里要使用mybatis的findAll()，不能使用JPA的findALL();

package com.empirefree.springboot.web;
/**
* @author Empirefree 胡宇乔:
* @version 创建时间：2020年3月17日 下午8:01:04
*/
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;

import com.empirefree.springboot.dao.CategoryDAO;
import com.empirefree.springboot.mapper.CategoryMapper;
import com.empirefree.springboot.pojo.Category;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
  
@Controller
public class CategoryController {
         @Autowired 
         CategoryDAO categoryDAO;
         
         @Autowired 
         CategoryMapper categoryMapper;
         
        @RequestMapping("/listCategory")
        public String listCategory(Model m, @RequestParam(value = "start", defaultValue = "0") int start,@RequestParam(value = "size", defaultValue = "5") int size) throws Exception {
//            List<Category> cs = categoryDAO.findAll();
            
//            PageHelper.startPage(start,size,"id desc");
            PageHelper.startPage(start,size,"id");
            List<Category> cs = categoryMapper.findAllCategory();
//            Category category = new Category();
//            category.setName("牛逼");
//            List<Category> cs = categoryMapper.findBySomeCategory(category);
            PageInfo<Category> page = new PageInfo<>(cs);
            m.addAttribute("page", page);         
//            m.addAttribute("cs", cs);
             
            return "listCategory";
        }
        
        @RequestMapping("/addCategory")
        public String listCategory(Category c) throws Exception {
            categoryMapper.save(c);
            return "redirect:listCategory";
        }
        @RequestMapping("/deleteCategory")
        public String deleteCategory(Category c) throws Exception {
            categoryMapper.delete(c.getId());
            return "redirect:listCategory";
        }
        @RequestMapping("/updateCategory")
        public String updateCategory(Category c) throws Exception {
            categoryMapper.update(c);
            return "redirect:listCategory";
        }
        @RequestMapping("/editCategory")
        public String listCategory(int id,Model m) throws Exception {
            Category c= categoryMapper.findById(id);
            m.addAttribute("c", c);
            return "editCategory";
        }
        
}

 

5:网页灰度化（祭奠逝去的抗击肺炎英雄们）：主要函数就是：filter

html {
    -webkit-filter: grayscale(100%);
    -moz-filter: grayscale(100%);
    -ms-filter: grayscale(100%);
    -o-filter: grayscale(100%);
    filter: grayscale(100%);
    filter: progid:DXImageTransform.Microsoft.BasicImage(grayscale=1);
}

listCategory.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<style>
html {
    -webkit-filter: grayscale(100%);
    -moz-filter: grayscale(100%);
    -ms-filter: grayscale(100%);
    -o-filter: grayscale(100%);
    filter: grayscale(100%);
    filter: progid:DXImageTransform.Microsoft.BasicImage(grayscale=1);
}
</style>

</head>
<body>
<div style="500px;margin:20px auto;text-align: center">
    <table align='center' border='1' cellspacing='0'>
        <tr>
            <td>id</td>
            <td>name</td>
            <td>编辑</td>
            <td>删除</td>
        </tr>
        <c:forEach items="${page.list}" var="c" varStatus="st">
            <tr>
                <td>${c.id}</td>
                <td>${c.name}</td>
                <td><a href="editCategory?id=${c.id}">编辑</a></td>
                <td><a href="deleteCategory?id=${c.id}">删除</a></td>
            </tr>
        </c:forEach>
          
    </table>
    <br>
    <div>
                <a href="?start=1">[首  页]</a>
            <a href="?start=${page.pageNum-1}">[上一页]</a>
            <a href="?start=${page.pageNum+1}">[下一页]</a>
            <a href="?start=${page.pages}">[末  页]</a>
    </div>
    <br>
    <form action="addCategory" method="post">
      
    name: <input name="name"> <br>
    <button type="submit">提交</button>
      
    </form>
</div>
</body>
</html>

 

---------------------------------------C语言爆破好友消息(图片，文字，文件都可以)------------------------------------------------------------

 

 

 

C语言函数如下：(VS studio环境) 

#include <stdio.h>
#include <Windows.h>
// Empirefree 胡宇乔
int main()
{
    int i;
    char name[100];               //使用之前要先复制要轰炸的内容
    printf("输入你要轰炸的对象名称：");
    scanf_s("%s", &name, 40);
    printf("输入你要轰炸的次数:");
    scanf_s("%d", &i);
    HWND H = FindWindow(0,name);         //找到对话窗口
    while (i-- > 0)    
    {
        SendMessage(H, WM_PASTE, 0, 0);           //黏贴内容
        SendMessage(H, WM_KEYDOWN, VK_RETURN, 0); //回车发送
    }
}