2024/2/26日 日志 第一次测试案例分析(3)--基础准备

合集 - Javaweb(54)

1.2024/10/16 日 日志 --》关于MySQL的中 基础操作的整理以及 DQL的初步学习笔记与整理2024-10-162.2024/10/17日 日志 --》关于MySQL中的 约束、多表查询的初步学习笔记与整理2024-10-173.2024/10/18日 日志 --》关于MySQL中的 事务 以及JDBC的初步学习笔记与整理2024-10-184.2024/10/19日 日志--》关于MySQL中 JDBC的API 详解的整理简述2024-10-195.2024/10/21 日 日志 --》关于Mysql中的数据库连接池 简述笔记整理2024-10-216.2024/10/22日 日志 --》关于Maven的基础学习 笔记整理2024-10-227.2024/10/23日 日志--》关于Maven的基础学习--2 坐标与依赖范围2024-10-238.2024/10/24日 日志 --》关于Mybatis的学习笔记整理 - 环境与性质 以及ResultMap2024-10-249.2024/10/25日 日志 --》关于使用Mybatis进行增删改查 ---1 查询2024-10-2510.2024/10/26 日 使用Mybatic --》关于Mybatis 进行增删改查 ---2 添加、修改与删除2024-10-2611.2024/10/28日 使用Mybatic --》关于Mybatis 的参数传递与注解开发2024-10-2812.2024/10/29 HTML --》关于HTML的快速入门与标签2024-10-2913.2024/10/30 日 日志 --》关于CSS的学习2024-10-3114.2024/11/1日 日志 关于JavaScript简介&引入方式 以及基础语法的学习2024-11-0215.2024/11/4日 日志 关于JavaScript 变量、数据类型、类型转换和流程控制语句以及对象的学习2024-11-0416.2024/11/5日 日志 关于BOM浏览器对象模型和DOM文档对象模型的学习与笔记整理2024-11-0517.2024/11/6日 日志 正则表达式,web与HTTP2024-11-0618.2024/11/7日 日志 Tomcat简介&基本使用2024-11-0719.2024/11/8日 日志 关于Servlet ----（上）2024-11-0820.2024/11/11日 日志 关于Servlet ----HttpServlet（下）2024-11-1121.2024/11/12日 日志 关于Servlet ---- Request(请求)& Response(响应) 的补充2024-11-1222.2024/11/13日 日志 代码优化 以及 JSP 的快速入门、原理、脚本、缺点 和 EL表达式 以及 JSTL标签2024-11-1423.2024/11/14日 日志 关于 MVC 分层开发模式2024-11-1424.2024/11/15日 日志 关于 会话跟踪技术--- Cookie & Session2024-11-1625.2024/11/20日 日志 关于 Filter & Listener2024-11-2126.2024/11/21日 日志 关于AJAX & Axious异步框架 & JSON2024-11-2227.2024/11/27日 日志 关于Vue && Element2024-11-2828.JavaWeb案例整体分析---》差旅费报销管理信息系统->>题目详情2024-12-2229.JavaWeb案例整体分析---》差旅费报销管理信息系统->>登录与注册2024-12-2230.JavaWeb案例整体分析---》差旅费报销管理信息系统->>数据库操作和Mybatis配置以及pom.xml2024-12-2231.JavaWeb案例整体分析---》差旅费报销管理信息系统->>出差申请与报销部分2024-12-2232.2024/1/13日 日志 关于Vue && Element 的后续---》综合案例（1）02-1733.2024/1/14日 日志 关于Vue && Element 的后续---》综合案例（2）02-1734.2024/1/16日 日志 关于Vue && Element 的后续---》综合案例（4）02-1735.2024/1/17日 日志 关于Vue && Element 的后续---》综合案例（5）02-1736.2024/1/18日 日志 关于Vue && Element 的后续---》综合案例（6）02-1737.2024/1/19日 日志 关于Vue && Element 的后续---》综合案例（7）02-1738.2024/1/20日 日志 关于Vue && Element 的后续---》综合案例（8.1）02-1739.2024/1/21日 日志 关于Vue && Element 的后续---》综合案例（8.2）02-1740.2024/1/22日 日志 期末考试案例回顾与分析---》综合案例（1）02-1741.2024/1/23日 日志 期末考试案例回顾与分析---》综合案例（2）02-1842.2024/1/24日 日志 期末考试案例回顾与分析---》综合案例（3）02-1843.2024/1/25日 日志 期末考试案例回顾与分析---》综合案例（4）02-1844.2024/1/26日 日志 期末考试案例回顾与分析---》综合案例（5）02-1845.2024/1/27日 日志 期末考试案例回顾与分析---》综合案例（6）02-1846.2024/2/3日 日志 期末考试案例回顾与分析---》综合案例（7）02-1847.2024/2/4日 日志 期末考试案例回顾与分析---》综合案例（8）02-1848.2024/2/5日 日志 期末考试案例回顾与分析---》综合案例（9）02-1849.2024/2/6日 日志 期末考试案例回顾与分析---》综合案例（10）02-1850.2024/2/7日 日志 期末考试案例回顾与分析---》综合案例（汇总）02-1851.2024/2/24日 日志 第一次测试案例分析(1)--题目02-2752.2024/2/25日 日志 第一次测试案例分析(2)--数据库层面02-27

53.2024/2/26日 日志 第一次测试案例分析(3)--基础准备02-27

54.2024/2/27日 日志 第一次测试案例分析(4)--登录与注册和仓库方面02-27

收起

Pojo
Material

点击查看代码

package com.Moonbeams.pojo;

public class Material {
    private Integer id;
    private String materialName;
    private String description;
    private String materialType;

    public Integer getId() {
        return id;
    }

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

    public String getMaterialName() {
        return materialName;
    }

    public void setMaterialName(String materialName) {
        this.materialName = materialName;
    }

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }

    public String getMaterialType() {
        return materialType;
    }

    public void setMaterialType(String materialType) {
        this.materialType = materialType;
    }

    @Override
    public String toString() {
        return "Material{" +
                "id=" + id +
                ", materialName='" + materialName + '\'' +
                ", description='" + description + '\'' +
                ", materialType='" + materialType + '\'' +
                '}';
    }
}

MaterialDetails

点击查看代码

package com.Moonbeams.pojo;

import com.google.protobuf.Internal;

public class MaterialDetails {
    private long id;
    private String createType;
    private Integer quantity;
    private String unit;
    private Integer storehouseId;
    private Integer materialId;

    public long getId() {
        return id;
    }
    public void setId(long id) {
        this.id = id;
    }

    public String getCreateType() {
        return createType;
    }

    public void setCreateType(String createType) {
        this.createType = createType;
    }

    public Integer getQuantity() {
        return quantity;
    }

    public void setQuantity(Integer quantity) {
        this.quantity = quantity;
    }

    public String getUnit() {
        return unit;
    }

    public void setUnit(String unit) {
        this.unit = unit;
    }

    public Integer getStorehouseId() {
        return storehouseId;
    }

    public void setStorehouseId(Integer storehouseId) {
        this.storehouseId = storehouseId;
    }
    public Integer getMaterialId() {
        return materialId;
    }
    public void setMaterialId(Integer materialId) {
        this.materialId = materialId;
    }

    @Override
    public String toString() {
        return "MaterialDetails{" +
                "id=" + id +
                ", createType='" + createType + '\'' +
                ", quantity=" + quantity +
                ", unit='" + unit + '\'' +
                ", storehouseId=" + storehouseId +
                ", materialId=" + materialId +
                '}';
    }
}

Storehouse

点击查看代码

package com.Moonbeams.pojo;

public class Storehouse {
    private Integer id;
    private String storehouseName;
    private String description;

    public Integer getId() {
        return id;
    }

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

    public String getStorehouseName() {
        return storehouseName;
    }

    public void setStorehouseName(String storehouseName) {
        this.storehouseName = storehouseName;
    }

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }

    @Override
    public String toString() {
        return "Storehouse{" +
                "id=" + id +
                ", storehouseName='" + storehouseName + '\'' +
                ", description='" + description + '\'' +
                '}';
    }
}

User

点击查看代码

package com.Moonbeams.pojo;

public class User {
    private Integer id;
    private String username;
    private String password;
    private String identify;

    public Integer getId() {
        return id;
    }

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

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getIdentify() {
        return identify;
    }

    public void setIdentify(String identify) {
        this.identify = identify;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                ", identify='" + identify + '\'' +
                '}';
    }
}

AdministratorService

点击查看代码

  package com.Moonbeams.service;

import com.Moonbeams.mapper.MaterialDetailsMapper;
import com.Moonbeams.mapper.MaterialMapper;
import com.Moonbeams.mapper.StorehouseMapper;
import com.Moonbeams.pojo.Material;
import com.Moonbeams.pojo.MaterialDetails;
import com.Moonbeams.pojo.Storehouse;
import com.Moonbeams.util.SqlSessionFactoryUtils;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;

import java.util.ArrayList;
import java.util.List;

public class AdministratorService {
    SqlSessionFactory factory = SqlSessionFactoryUtils.getSqlSessionFactory();

    public void addStorehouse(Storehouse storehouse) {
        try(SqlSession sqlSession = factory.openSession()) {
            StorehouseMapper storehouseMapper = sqlSession.getMapper(StorehouseMapper.class);
            storehouseMapper.addStore(storehouse);
            sqlSession.commit();
        }

    }

    public void deleteStorehouseById(int id) {
        try(SqlSession sqlSession = factory.openSession()) {
            StorehouseMapper storehouseMapper = sqlSession.getMapper(StorehouseMapper.class);
            storehouseMapper.deleteStoreById(id);
            sqlSession.commit();
        }
    }

    public void updateStorehouse(Storehouse storehouse) {
        try(SqlSession sqlSession = factory.openSession()) {
            StorehouseMapper storehouseMapper = sqlSession.getMapper(StorehouseMapper.class);
            storehouseMapper.modifyStore(storehouse);
            sqlSession.commit();
        }
    }

    public void modifyStoreDescription(Storehouse storehouse){
        try(SqlSession sqlSession = factory.openSession()) {
            StorehouseMapper storehouseMapper = sqlSession.getMapper(StorehouseMapper.class);
            storehouseMapper.modifyStoreDescription(storehouse);
            sqlSession.commit();
        }
    }

    public List<MaterialDetails> getMaterialDetailsByMaterialId(int id) {
        try(SqlSession sqlSession = factory.openSession()) {
            MaterialDetailsMapper materialDetailsMapper = sqlSession.getMapper(MaterialDetailsMapper.class);
            return materialDetailsMapper.getMaterialDetailsByMaterialId(id);
        }
    }

    public MaterialDetails getMaterialDetailsByMaterialIdAndType(int id) {
        try(SqlSession sqlSession = factory.openSession()) {
            MaterialDetailsMapper materialDetailsMapper = sqlSession.getMapper(MaterialDetailsMapper.class);
            System.out.println("Searching for materialId: " + id);

            return materialDetailsMapper.getMaterialDetailsByMaterialIdAndType(id);
        }
    }


    public int getStorehouseIdByMaterialId(int materialId) {
        try(SqlSession sqlSession = factory.openSession()) {
            MaterialDetailsMapper materialDetailsMapper = sqlSession.getMapper(MaterialDetailsMapper.class);
            MaterialDetails materialDetails = materialDetailsMapper.getMaterialDetailsByMaterialIdAndType(materialId);
            return materialDetails.getStorehouseId();
        }
    }

    public void modifyMaterialDetailsQuantity(MaterialDetails materialDetails) {
        try(SqlSession sqlSession = factory.openSession()) {
            MaterialDetailsMapper materialDetailsMapper = sqlSession.getMapper(MaterialDetailsMapper.class);
            materialDetailsMapper.modifyMaterialDetailsQuantity(materialDetails);
            sqlSession.commit();
        }
    }

    public Storehouse getStorehouseById(int id) {
        try(SqlSession sqlSession = factory.openSession()) {
            StorehouseMapper storehouseMapper = sqlSession.getMapper(StorehouseMapper.class);
            Storehouse storehouse = storehouseMapper.getStoreById(id);
            return storehouse;
        }
    }

    public List<Storehouse> getAllStorehouse() {
        try(SqlSession sqlSession = factory.openSession()) {
            StorehouseMapper storehouseMapper = sqlSession.getMapper(StorehouseMapper.class);
            List<Storehouse> storehouses= storehouseMapper.getStorehouseList();
            return storehouses;
        }
    }

    public void addMaterial(Material material) {
        try(SqlSession sqlSession = factory.openSession()) {
            MaterialMapper materialMapper = sqlSession.getMapper(MaterialMapper.class);
            materialMapper.addMaterial(material);
            sqlSession.commit();
        }
    }
    public void deleteMaterialById(int id) {
        try(SqlSession sqlSession = factory.openSession()) {
            MaterialMapper materialMapper = sqlSession.getMapper(MaterialMapper.class);
            List<Integer>MaterialIds = getAllMaterialId();
            boolean flag = true;
            for(Integer MaterialId : MaterialIds) {
                if (MaterialId == id) {
                    flag = false;
                    break;
                }
            }
            if(flag) {
                materialMapper.deleteMaterialById(id);
                sqlSession.commit();
            }
        }
    }
    public void updateMaterial(Material material) {
        try(SqlSession sqlSession = factory.openSession()) {
            MaterialMapper materialMapper = sqlSession.getMapper(MaterialMapper.class);
            materialMapper.modifyMaterial(material);
            sqlSession.commit();
        }
    }
    public Material getMaterialById(int id) {
        try(SqlSession sqlSession = factory.openSession()) {
            MaterialMapper materialMapper = sqlSession.getMapper(MaterialMapper.class);
            Material material = materialMapper.getMaterialById(id);
            return material;
        }
    }

    public List<Material> getAllMaterial() {
        try(SqlSession sqlSession = factory.openSession()) {
            MaterialMapper materialMapper = sqlSession.getMapper(MaterialMapper.class);
            List<Material> materials = materialMapper.getAllMaterials();
            return materials;
        }
    }

    public void addMaterialDetail(MaterialDetails materialDetails) {
        try(SqlSession sqlSession = factory.openSession()) {
            MaterialDetailsMapper materialDetailsMapper = sqlSession.getMapper(MaterialDetailsMapper.class);
            materialDetailsMapper.addMaterialDetails(materialDetails);
            sqlSession.commit();
        }
    }

    public List<Integer>getAllMaterialId() {
        try(SqlSession sqlSession = factory.openSession()) {
            MaterialDetailsMapper materialDetailsMapper = sqlSession.getMapper(MaterialDetailsMapper.class);
            List<MaterialDetails> materialDetails = materialDetailsMapper.getAllMaterialDetails();
            List<Integer>materialIds = new ArrayList<>();
            for(MaterialDetails materialDetail : materialDetails) {
                materialIds.add(materialDetail.getMaterialId());
            }
            return materialIds;
        }
    }

    public void addMaterialDetails(MaterialDetails materialDetails) {
        try(SqlSession sqlSession = factory.openSession()) {
            MaterialDetailsMapper materialDetailsMapper = sqlSession.getMapper(MaterialDetailsMapper.class);
            materialDetailsMapper.addMaterialDetails(materialDetails);
            sqlSession.commit();
        }
    }

    public List<MaterialDetails> getAllMaterialDetails() {
        try(SqlSession sqlSession = factory.openSession()) {
            MaterialDetailsMapper materialDetailsMapper = sqlSession.getMapper(MaterialDetailsMapper.class);
            List<MaterialDetails> materialDetails = materialDetailsMapper.getAllMaterialDetails();
            return materialDetails;
        }
    }


}

UserService

点击查看代码

package com.Moonbeams.service;

import com.Moonbeams.mapper.UserMapper;
import com.Moonbeams.pojo.User;
import com.Moonbeams.util.SqlSessionFactoryUtils;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;

public class UserService {

    SqlSessionFactory factory = SqlSessionFactoryUtils.getSqlSessionFactory();

    /**
     * 登录方法
     * @param username
     * @param password
     * @return
     */
    public User login (String username, String password) {
        //2.获取Sqlsession
        SqlSession sqlsession = factory.openSession();
        //3.获取UserMapper
        UserMapper mapper = sqlsession.getMapper(UserMapper.class);
        //4.调用方法
        User user = mapper.select(username, password);

        //释放资源（查询，无需提交事务）
        sqlsession.close();

        return user;
    }

    /**
     * 注册方法
     * @param user
     * @return
     */

    public boolean register(User user){
        //2.获取Sqlsession
        SqlSession sqlsession = factory.openSession();
        //3.获取Usermapper
        UserMapper mapper = sqlsession.getMapper(UserMapper.class);

        //4.判断用户名是否存在
        User u = mapper.selectByUsername(user.getUsername());

        if(u == null){
            //用户名不存在
            mapper.add(user);
            sqlsession.commit();
        }
        //释放资源
        sqlsession.close();

        return u == null;
    }

    public User selectByUsername(String username) {
        try (SqlSession session = factory.openSession()) {
            UserMapper mapper = session.getMapper(UserMapper.class);
            return mapper.selectByUsername(username);
        }
    }
    public void modifyPassword(User user) {
        try (SqlSession session = factory.openSession()) {
            UserMapper mapper = session.getMapper(UserMapper.class);
            mapper.modifyPassword(user);
            session.commit();
        }
    }

    public void resetPassword(User user) {
        try (SqlSession session = factory.openSession()) {
            UserMapper mapper = session.getMapper(UserMapper.class);
            mapper.resetPassword(user);
            session.commit();
        }
    }

    public void modifyIdentify(User user) {
        try (SqlSession session = factory.openSession()) {
            UserMapper mapper = session.getMapper(UserMapper.class);
            mapper.modifyIdentify(user);
            session.commit();
        }
    }

}

util
CheckCodeUtil

点击查看代码

    package com.Moonbeams.util;

import javax.imageio.ImageIO;
import java.awt.*;
import java.awt.geom.AffineTransform;
import java.awt.image.BufferedImage;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.util.Arrays;
import java.util.Random;

    /**
     * 生成验证码工具类
     */
    public class CheckCodeUtil {

        public static final String VERIFY_CODES = "123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ";
        private static Random random = new Random();


        /**
         * 输出随机验证码图片流,并返回验证码值（一般传入输出流，响应response页面端，Web项目用的较多）
         *
         * @param w
         * @param h
         * @param os
         * @param verifySize
         * @return
         * @throws IOException
         */
        public static String outputVerifyImage(int w, int h, OutputStream os, int verifySize) throws IOException {
            String verifyCode = generateVerifyCode(verifySize);
            outputImage(w, h, os, verifyCode);
            return verifyCode;
        }

        /**
         * 使用系统默认字符源生成验证码
         *
         * @param verifySize 验证码长度
         * @return
         */
        public static String generateVerifyCode(int verifySize) {
            return generateVerifyCode(verifySize, VERIFY_CODES);
        }

        /**
         * 使用指定源生成验证码
         *
         * @param verifySize 验证码长度
         * @param sources    验证码字符源
         * @return
         */
        public static String generateVerifyCode(int verifySize, String sources) {
            // 未设定展示源的字码，赋默认值大写字母+数字
            if (sources == null || sources.length() == 0) {
                sources = VERIFY_CODES;
            }
            int codesLen = sources.length();
            Random rand = new Random(System.currentTimeMillis());
            StringBuilder verifyCode = new StringBuilder(verifySize);
            for (int i = 0; i < verifySize; i++) {
                verifyCode.append(sources.charAt(rand.nextInt(codesLen - 1)));
            }
            return verifyCode.toString();
        }

        /**
         * 生成随机验证码文件,并返回验证码值 (生成图片形式，用的较少)
         *
         * @param width 图片宽度
         * @param height 图片高度
         * @param outputFile 输出流
         * @param verifySize 数据长度
         * @return 验证码数据
         * @throws IOException
         */
        public static String outputVerifyImage(int width, int height, File outputFile, int verifySize) throws IOException {
            String verifyCode = generateVerifyCode(verifySize);
            outputImage(width, height, outputFile, verifyCode);
            return verifyCode;
        }



        /**
         * 生成指定验证码图像文件
         *
         * @param w
         * @param h
         * @param outputFile
         * @param code
         * @throws IOException
         */
        public static void outputImage(int w, int h, File outputFile, String code) throws IOException {
            if (outputFile == null) {
                return;
            }
            File dir = outputFile.getParentFile();
            //文件不存在
            if (!dir.exists()) {
                //创建
                dir.mkdirs();
            }
            try {
                outputFile.createNewFile();
                FileOutputStream fos = new FileOutputStream(outputFile);
                outputImage(w, h, fos, code);
                fos.close();
            } catch (IOException e) {
                throw e;
            }
        }

        /**
         * 输出指定验证码图片流
         *
         * @param w
         * @param h
         * @param os
         * @param code
         * @throws IOException
         */
        public static void outputImage(int w, int h, OutputStream os, String code) throws IOException {
            int verifySize = code.length();
            BufferedImage image = new BufferedImage(w, h, BufferedImage.TYPE_INT_RGB);
            Random rand = new Random();
            Graphics2D g2 = image.createGraphics();
            g2.setRenderingHint(RenderingHints.KEY_ANTIALIASING, RenderingHints.VALUE_ANTIALIAS_ON);

            // 创建颜色集合，使用java.awt包下的类
            Color[] colors = new Color[5];
            Color[] colorSpaces = new Color[]{Color.WHITE, Color.CYAN,
                    Color.GRAY, Color.LIGHT_GRAY, Color.MAGENTA, Color.ORANGE,
                    Color.PINK, Color.YELLOW};
            float[] fractions = new float[colors.length];
            for (int i = 0; i < colors.length; i++) {
                colors[i] = colorSpaces[rand.nextInt(colorSpaces.length)];
                fractions[i] = rand.nextFloat();
            }
            Arrays.sort(fractions);
            // 设置边框色
            g2.setColor(Color.GRAY);
            g2.fillRect(0, 0, w, h);

            Color c = getRandColor(200, 250);
            // 设置背景色
            g2.setColor(c);
            g2.fillRect(0, 2, w, h - 4);

            // 绘制干扰线
            Random random = new Random();
            // 设置线条的颜色
            g2.setColor(getRandColor(160, 200));
            for (int i = 0; i < 20; i++) {
                int x = random.nextInt(w - 1);
                int y = random.nextInt(h - 1);
                int xl = random.nextInt(6) + 1;
                int yl = random.nextInt(12) + 1;
                g2.drawLine(x, y, x + xl + 40, y + yl + 20);
            }

            // 添加噪点
            // 噪声率
            float yawpRate = 0.05f;
            int area = (int) (yawpRate * w * h);
            for (int i = 0; i < area; i++) {
                int x = random.nextInt(w);
                int y = random.nextInt(h);
                // 获取随机颜色
                int rgb = getRandomIntColor();
                image.setRGB(x, y, rgb);
            }
            // 添加图片扭曲
            shear(g2, w, h, c);

            g2.setColor(getRandColor(100, 160));
            int fontSize = h - 4;
            Font font = new Font("Algerian", Font.ITALIC, fontSize);
            g2.setFont(font);
            char[] chars = code.toCharArray();
            for (int i = 0; i < verifySize; i++) {
                AffineTransform affine = new AffineTransform();
                affine.setToRotation(Math.PI / 4 * rand.nextDouble() * (rand.nextBoolean() ? 1 : -1), (w / verifySize) * i + fontSize / 2, h / 2);
                g2.setTransform(affine);
                g2.drawChars(chars, i, 1, ((w - 10) / verifySize) * i + 5, h / 2 + fontSize / 2 - 10);
            }

            g2.dispose();
            ImageIO.write(image, "jpg", os);
        }

        /**
         * 随机颜色
         *
         * @param fc
         * @param bc
         * @return
         */
        private static Color getRandColor(int fc, int bc) {
            if (fc > 255) {
                fc = 255;
            }
            if (bc > 255) {
                bc = 255;
            }
            int r = fc + random.nextInt(bc - fc);
            int g = fc + random.nextInt(bc - fc);
            int b = fc + random.nextInt(bc - fc);
            return new Color(r, g, b);
        }

        private static int getRandomIntColor() {
            int[] rgb = getRandomRgb();
            int color = 0;
            for (int c : rgb) {
                color = color << 8;
                color = color | c;
            }
            return color;
        }

        private static int[] getRandomRgb() {
            int[] rgb = new int[3];
            for (int i = 0; i < 3; i++) {
                rgb[i] = random.nextInt(255);
            }
            return rgb;
        }

        private static void shear(Graphics g, int w1, int h1, Color color) {
            shearX(g, w1, h1, color);
            shearY(g, w1, h1, color);
        }

        private static void shearX(Graphics g, int w1, int h1, Color color) {

            int period = random.nextInt(2);

            boolean borderGap = true;
            int frames = 1;
            int phase = random.nextInt(2);

            for (int i = 0; i < h1; i++) {
                double d = (double) (period >> 1)
                        * Math.sin((double) i / (double) period
                        + (6.2831853071795862D * (double) phase)
                        / (double) frames);
                g.copyArea(0, i, w1, 1, (int) d, 0);
                if (borderGap) {
                    g.setColor(color);
                    g.drawLine((int) d, i, 0, i);
                    g.drawLine((int) d + w1, i, w1, i);
                }
            }

        }

        private static void shearY(Graphics g, int w1, int h1, Color color) {

            int period = random.nextInt(40) + 10; // 50;

            boolean borderGap = true;
            int frames = 20;
            int phase = 7;
            for (int i = 0; i < w1; i++) {
                double d = (double) (period >> 1)
                        * Math.sin((double) i / (double) period
                        + (6.2831853071795862D * (double) phase)
                        / (double) frames);
                g.copyArea(i, 0, 1, h1, 0, (int) d);
                if (borderGap) {
                    g.setColor(color);
                    g.drawLine(i, (int) d, i, 0);
                    g.drawLine(i, (int) d + h1, i, h1);
                }

            }

        }
    }

SqlSessionFactoryUtils

点击查看代码

package com.Moonbeams.util;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.IOException;
import java.io.InputStream;

public class SqlSessionFactoryUtils {
    private static SqlSessionFactory sqlSessionFactory;

    static{
        //静态代码块会随着类的加载而自动执行，且只执行一次
        try {
            String resource = "mybatis-config.xml";
            InputStream inputStream = Resources.getResourceAsStream(resource);
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        } catch (IOException e) {
            throw new RuntimeException(e);
        }
    }

    public static SqlSessionFactory getSqlSessionFactory(){return sqlSessionFactory;}
}

mybatis-config.xml

点击查看代码

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <!--起别名-->
    <typeAliases>
        <package name="com.Moonbeams.pojo"/>
    </typeAliases>

    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql:///test?useSSL=false&amp;allowPublicKeyRetrieval=true&amp;useServerPrepStmts=true&amp;useUnicode=true&amp;characterEncoding=UTF-8&amp;serverTimezone=Asia/Shanghai"/>
                <property name="username" value="root"/>
                <property name="password" value=""/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <!--扫描mapper-->
        <package name="com.Moonbeams.mapper"/>
        <!--如果不扫描则加载映射文件-->
        <!--<mapper resource="Moonbeams/mapper/XXX.xml"/>-->

    </mappers>
</configuration>