package com.dwx;

import javax.imageio.ImageIO;
import java.awt.*;
import java.awt.image.BufferedImage;
import java.io.*;

public class ChangeColor {
    public static void main(String[] args) throws FileNotFoundException {
        //读取照片
        File file = new File("src/main/java/com/dwx/pic.jpg");
        //新图片地址
        File file1 = new File("src/main/java/newpic.jpg");
        FileOutputStream fileOutputStream = new FileOutputStream(file1);
        //通过idea的图像功能获取到的图片的背景的RGB颜色
        Color colorOld = new Color(253,253,255);
        //希望改成的RGB颜色
        Color colorNew = new Color(250, 5, 5);
        BufferedImage read = null;
        try {
            read = ImageIO.read(file);
            int height = read.getHeight();
            int width = read.getWidth();
            for (int i=0;i<width;i++){
                for(int j=0;j<height;j++){
                    if (read.getRGB(i,j)==colorOld.getRGB()){
                        //如果相等就将次点的颜色设置成我们需要的颜色
                        read.setRGB(i,j,colorNew.getRGB());
                    }
                }
            }
            //最后 把修改过的RGB再写回去
            ImageIO.write(read,"jpg",fileOutputStream);
        } catch (IOException e) {
            e.printStackTrace();
        }


    }
}

//编写Student实体类
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Student {
    private int id;
    private String name;
    //这里是一个联表 在java代码中 直接把链表的参数放进去
    private int tid;
}

//编写Teacher的实体类
//这里直接使用注解来完成实体类的完善
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Teacher {
    private String name;
    private int id;
    private List<Student> studentList;
}

package com.dwx.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

//创建与数据库映射的类
@Data
@AllArgsConstructor
@NoArgsConstructor
public class student {
    private int id;
    private String name;
    private String password;

}

public interface StudentMapper {

    //测试使用注解来实现查询
    @Select("select * from mybatis.student")
    List<student> getStudentList();

}

public class test {
    @Test
    public void getStudentList(){
        MyBatisUtils myBatisUtils = new MyBatisUtils();
        SqlSession sqlSession = myBatisUtils.getSqlSession();
        StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
        List<student> studentList = mapper.getStudentList();
        for (student student : studentList) {
            System.out.println(student.toString());
        }
        sqlSession.close();
    }
}

sqlSessionFactory.openSession();

@Test
  public void InsertStudnet(){
      MyBatisUtils myBatisUtils = new MyBatisUtils();
      SqlSession sqlSession = myBatisUtils.getSqlSession();
      //获得了sqlSession就需要进行联结获得mapper
      UserDao mapper = sqlSession.getMapper(UserDao.class);
      //通过mapper对象来进行操作
      mapper.InsertStudent(new student(4,"王五","123456"));
      //对于需要对数据库进行改动的如：“增删改” 都系要提交事务
      sqlSession.commit();//此代码就是提交事务
      //关闭sqlsession
      sqlSession.close();
  }

sqlsessionFactory.openSession(true);

//测试使用注解实现有参查询
    @Select("select * from mybatis.student where id = #{id}")
    student getStudentByID(@Param("id") int id);

//测试使用注解实现增加
   @Insert("insert into mybatis.student (id,name,password) values(#{id},#{name},#{password})")
   int InsertStudent(student student);

//测试使用注解实现删除
    @Delete("delete from mybatis.student where id = #{id}")
    int DeleteStudentById(@Param("id") int id);

List<student> getStudentListByLimit(Map<String,Object> map);

@Test
   public void getStudentListByLimitTest(){
       MyBatisUtils myBatisUtils = new MyBatisUtils();
       SqlSession sqlSession = myBatisUtils.getSqlSession();
       StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
       Map<String, Object> map = new HashMap<>();
       map.put("startIndex",1);
       map.put("pageSize",2);
       List<student> studentListByLimit = mapper.getStudentListByLimit(map);
       for (student student : studentListByLimit) {
           System.out.println(student.toString());
       }
       sqlSession.close();
   }

Logging initialized using 'class org.apache.ibatis.logging.stdout.StdOutImpl' adapter.
Class not found: org.jboss.vfs.VFS
JBoss 6 VFS API is not available in this environment.
Class not found: org.jboss.vfs.VirtualFile
VFS implementation org.apache.ibatis.io.JBoss6VFS is not valid in this environment.
Using VFS adapter org.apache.ibatis.io.DefaultVFS
Find JAR URL: file:/E:/java/MyBatisStudy/Mybatis03/target/classes/com/dwx/pojo
Not a JAR: file:/E:/java/MyBatisStudy/Mybatis03/target/classes/com/dwx/pojo
Reader entry: student.class
Listing file:/E:/java/MyBatisStudy/Mybatis03/target/classes/com/dwx/pojo
Find JAR URL: file:/E:/java/MyBatisStudy/Mybatis03/target/classes/com/dwx/pojo/student.class
Not a JAR: file:/E:/java/MyBatisStudy/Mybatis03/target/classes/com/dwx/pojo/student.class
Reader entry: ����   < :
Checking to see if class com.dwx.pojo.student matches criteria [is assignable to Object]
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
Find JAR URL: file:/E:/java/MyBatisStudy/Mybatis03/target/test-classes/com/dwx/mapper
Not a JAR: file:/E:/java/MyBatisStudy/Mybatis03/target/test-classes/com/dwx/mapper
Reader entry: test.class
Listing file:/E:/java/MyBatisStudy/Mybatis03/target/test-classes/com/dwx/mapper
Find JAR URL: file:/E:/java/MyBatisStudy/Mybatis03/target/test-classes/com/dwx/mapper/test.class
Not a JAR: file:/E:/java/MyBatisStudy/Mybatis03/target/test-classes/com/dwx/mapper/test.class
Reader entry: ����   < U
Find JAR URL: file:/E:/java/MyBatisStudy/Mybatis03/target/classes/com/dwx/mapper
Not a JAR: file:/E:/java/MyBatisStudy/Mybatis03/target/classes/com/dwx/mapper
Reader entry: StudentMapper.class
Reader entry: StudentMapper.xml
Listing file:/E:/java/MyBatisStudy/Mybatis03/target/classes/com/dwx/mapper
Find JAR URL: file:/E:/java/MyBatisStudy/Mybatis03/target/classes/com/dwx/mapper/StudentMapper.class
Not a JAR: file:/E:/java/MyBatisStudy/Mybatis03/target/classes/com/dwx/mapper/StudentMapper.class
Reader entry: ����   <  
 com/dwx/mapper/StudentMapper 
 java/lang/Object
 getStudentList
 ()Ljava/util/List;
 	Signature
 *()Ljava/util/List<Lcom/dwx/pojo/student;>;
 
Find JAR URL: file:/E:/java/MyBatisStudy/Mybatis03/target/classes/com/dwx/mapper/StudentMapper.xml
Not a JAR: file:/E:/java/MyBatisStudy/Mybatis03/target/classes/com/dwx/mapper/StudentMapper.xml
Reader entry: <?xml version="1.0" encoding="UTF-8" ?>
Checking to see if class com.dwx.mapper.test matches criteria [is assignable to Object]
Checking to see if class com.dwx.mapper.StudentMapper matches criteria [is assignable to Object]
Opening JDBC Connection
Created connection 473153915.
Setting autocommit to false on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@1c33c17b]
==>  Preparing: select * from mybatis.student
==> Parameters: 
<==    Columns: id, name, password
<==        Row: 1, 张三, welcome
<==        Row: 2, 李四, welcome
<==        Row: 4, 王五, 123456
<==        Row: 17, dwx, welcome
<==        Row: 100, 李一百, welcome
<==      Total: 5
student{id=1, name='张三', pwd='welcome'}
student{id=2, name='李四', pwd='welcome'}
student{id=4, name='王五', pwd='123456'}
student{id=17, name='dwx', pwd='welcome'}
student{id=100, name='李一百', pwd='welcome'}

Process finished with exit code 0

package com.dwx.mapper;

import com.dwx.pojo.student;
import com.dwx.untils.MyBatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.apache.log4j.Logger;
import org.junit.Test;

import java.util.List;

public class test {
    //注意 此处导包要导Apache的包
    Logger logger = Logger.getLogger(test.class);

    @Test
    public void getStudentListTest(){
        //首先需要获取到 mapper
        //以下的操作都是固定的 不需要进行任何改变
        MyBatisUtils myBatisUtils = new MyBatisUtils();
        SqlSession sqlSession = myBatisUtils.getSqlSession();
        StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
        List<student> studentList = mapper.getStudentList();
        for (student student : studentList) {
            System.out.println(student.toString());
        }

    }
}

package com.dwx.mapper;

import com.dwx.pojo.student;
import com.dwx.untils.MyBatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.apache.log4j.Logger;
import org.junit.Test;

import java.util.List;

public class test {
    //注意 此处导包要导Apache的包
    Logger logger = Logger.getLogger(test.class);
    @Test
    public void log4jTest(){
        logger.info("###################infor#################");
        logger.debug("##################debug#################");
        logger.error("##################error##################");
    }
}

@Alias("hello")
public class student {
    private int id;
    private String name;
    private String password;

    //无参构造
    public student() {
    }

    //有参构造
    public student(int id, String name, String password) {
        this.id = id;
        this.name = name;
        this.password = password;
    }

    //get和set方法
    public int getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

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

    public String getPassword() {
        return password;
    }

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