[Mybatis] 19. Mybatis DB추가, 수정, 삭제하기

package mybatisjava;

import java.io.IOException;
import java.io.InputStream;
import java.util.HashMap;
import java.util.Map;

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 mapper.StudentMapper;

//데이터 추가 수정 삭제하기
public class Main3 {
	private static SqlSessionFactory sqlMap;
	private static Map<String,Object> map = new HashMap<>();
	static {
		InputStream input = null;
		try {
			input = Resources.getResourceAsStream("mapper/mybatis-config.xml");
		} catch(IOException e) {
			e.printStackTrace();
		}
		sqlMap = new SqlSessionFactoryBuilder().build(input);
	}
	public static void main(String[] args) {
		SqlSession session = sqlMap.openSession();
		System.out.println("이몽룡 학생 추가하기");
		Student st = new Student();
		st.setStudno(1003);
		st.setName("이몽룡");
		st.setJumin("2345623456781");
		st.setId("leemy");
		int result = session.getMapper(StudentMapper.class).insert(st);
		System.out.println(result + "건 추가");
		System.out.println("이몽룡 학생 조회하기");
		System.out.println(session.getMapper(StudentMapper.class).select3("이몽룡"));
		System.out.println("이몽룡 학생의 학년:1, 몸무게:80, 키:175로 변경하기");
		st.setGrade(1);
		st.setWeight(80);
		st.setHeight(175);
		result = session.getMapper(StudentMapper.class).update(st);
		System.out.println("변경건수:" + result);
		System.out.println("이몽룡 학생 조회하기");
		System.out.println(session.getMapper(StudentMapper.class).select3("이몽룡"));
		
		System.out.println("이몽룡 학생정보 삭제하기");
		result = session.getMapper(StudentMapper.class).delete(st.getStudno());
		System.out.println("삭제건수:" + result);
		System.out.println("이몽룡 학생 조회하기");
		System.out.println(session.getMapper(StudentMapper.class).select3("이몽룡"));
	}
}