package com.Entity;

public class Personal {
    Integer id;
    String name;
    String height;
    Integer age;

    public Integer getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getHeight() {
        return height;
    }

    public void setHeight(String height) {
        this.height = height;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }
}

package com.utils;

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) {
            e.printStackTrace();
        }
    }

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

package com.Mapper;

import com.Entity.Personal;
import com.Service.PersonalService;
import org.apache.ibatis.annotations.*;

import java.util.List;

public interface PersonalMapper {

    /**
     * 查询所有个人信息
     * @return
     * tips：因为是查询所有人的信息，会存在多个列表信息，所以应该使用列表来存储信息
     */
    @Select("select * from personal")
    List<Personal> findAll();

    /**
     * 增加个人信息
     * @param personal
     * @return 返回更新条数
     */
    @Insert("insert into personal (id,name,height,age) value(#{id},#{name},#{height},#{age})")
    int addPersonal(Personal personal);

    /**
     * 根据ID删除个人信息
     * @param id
     * @return 返回更新条数
     */
    @Delete("delete from personal where id =#{id}")
    int delPersonalById(@Param("id") Integer id);

    /**
     * 根据ID更新姓名
     * @param id
     * @param name
     * @return
     */
    @Update("update personal set name = #{name} where id = #{id}")
    int updatePersonalById(@Param("name") String name, @Param("id") Integer id);

}

package com.service;

import com.entity.Personal;
import com.mapper.PersonalMapper;
import com.utils.SqlSessionFactoryUtils;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;

import java.util.List;


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

    /**
     * 查询全部个人信息
     * @return
     */
    public List<Personal> selectAll() {
        SqlSession sqlSession = factory.openSession();
        PersonalMapper mapper = sqlSession.getMapper(PersonalMapper.class);
        List<Personal> personals = mapper.findAll();
        sqlSession.close();
        return personals;
    }

    /**
     * 增加个人信息
     * @param personal
     * @return
     */
    public int addPersonal(Personal personal){
        SqlSession sqlSession = factory.openSession();
        PersonalMapper mapper = sqlSession.getMapper(PersonalMapper.class);
        //rows 受影响行数
        int rows = mapper.addPersonal(personal);
        sqlSession.commit();
        return rows;
    }

    public int delPersonal(Integer id){
        SqlSession sqlSession = factory.openSession();
        PersonalMapper mapper = sqlSession.getMapper(PersonalMapper.class);
        //rows 受影响行数
        int rows = mapper.delPersonalById(id);
        sqlSession.commit();
        return rows;
    }

    public int updatePersonal(Integer id , String name){
        SqlSession sqlSession = factory.openSession();
        PersonalMapper mapper = sqlSession.getMapper(PersonalMapper.class);
        //rows 受影响行数
        int rows = mapper.updatePersonalById(name,id);
        sqlSession.commit();
        return rows;
    }

}

package com.service;

import com.entity.Personal;
import org.junit.jupiter.api.Test;

import java.util.List;

class PersonalServiceTest {
    PersonalService personalService = new PersonalService();
    @Test
    void selectAll() {
        List<Personal> personals= personalService.selectAll();
        System.out.println("-----------------");
        for (Personal personal : personals) {
            System.out.println("个人信息："+personal.getName());
        }
        System.out.println("-----------------");
    }

    @Test
    void addPersonal() {
        Personal personal = new Personal();
        personal.setId(7);
        personal.setAge(19);
        personal.setHeight("178");
        personal.setName("小码博客");
        int rows = personalService.addPersonal(personal);
        System.out.println("受影响行数为："+rows);
    }

    @Test
    void delPersonal() {
       int rows =  personalService.delPersonal(5);
        System.out.println("受影响行数为："+rows);
    }

    @Test
    void updatePersonal() {
        int rows = personalService.updatePersonal(2,"blog.hikki.site");
        System.out.println("受影响行数为："+rows);
    }
}

package com.entity;

public class Tag {
    private String id;
    private String tag;
    @Override
    public String toString() {
        return "Tag{" +
                "id='" + id + '\'' +
                ", tag='" + tag + '\'' +
                '}';
    }
    public String getId() {
        return id;
    }

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

    public String getTag() {
        return tag;
    }

    public void setTag(String tag) {
        this.tag = tag;
    }
}

//使用MyBatis提供的Resources类加载mybatis的配置文件
Reader reader = Resources.getResourceAsReader("mybatis-config.xml");
//构建sqlSession的工厂
sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);

package com.utils;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.Reader;
public class MybatisUtils {	
    public static SqlSessionFactory sqlSessionFactory = null;
    // 初始化SqlSessionFactory对象
    static{
        try {
            //使用MyBatis提供的Resources类加载mybatis的配置文件
            Reader reader = Resources.getResourceAsReader("mybatis-config.xml");
            //构建sqlSession的工厂
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    // 获取SqlSession对象的静态方法
    public static SqlSession getSession(){
        return sqlSessionFactory.openSession();
    }
}

/**
 * 新建文章
 * @param articleDTO        文章内容
 */
@Override
public void addArticle(ArticleDTO articleDTO) {
    System.out.println("debug--addArticle--articleDTO:"+articleDTO);
    //TODO:获取标签，判断是否存在，不存在则新添加标签
    List<Integer> tagIdList = tagService.addTag(articleDTO.getTagList());

    //TODO：获取分类，判断是否存在，不存在则新添加分类
    Integer categoryId = categoryService.addCategory(articleDTO.getCategoryName());

    //TODO：给文章设置默认值（如缩略图、置顶、删除、推荐、状态）
    // 其中置顶、删除、推荐、状态在数据库均设有默认值，可不填写
    // 该部分内容需要读取 t_site_config 数据库内容再设置，这里可以做一层缓存加快速度，此时先暂时做个虚拟数据
    Article article = BeanCopyUtil.copyBean(articleDTO, Article.class);
    article.setCategoryId(categoryId);
    article.setArticleCover("https://lsky.hikki.site/thumbnails/9e54d99bfd6587c219627297e0d7749b.png");
    // TODO：文章的和标签是一对多的关系，因此文章表不需要写入标签ID，使用关联表来写入记录
    // 添加文章
    articleMapper.insert(article);
    System.out.println("debug--addArticle--article.getID:"+article.getId());
}