iBatis学习笔记

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.demo.mybatis.mapper.StudentMapper">

	<resultMap id="studentResultMap" type="Student">
		<id property="id" column="id" />

		<result property="name" column="name" />
		<result property="gender" column="gender" />
		<result property="major" column="major" />
		<result property="grade" column="grade" />
		
	</resultMap>

	<select id="getById" parameterType="int" resultMap="studentResultMap">
		SELECT *
		FROM
		student WHERE id = #{id}
	</select>


	<insert id="addStudent" parameterType="Student" 
		useGeneratedKeys="true"  keyProperty="id">
		insert into student (name,gender,major,grade)
		values
		(#{name},#{gender},#{major},#{grade})	
	</insert>
	
	<select id="getList"  resultMap="studentResultMap">
		SELECT *
		FROM
		student
	</select>
	
	
	<delete id="delStudent" parameterType="int">
	delete 
	from 
	student 
	where id=#{id}
	
	</delete>

</mapper>

package com.demo.mybatis.mapper;

import java.util.ArrayList;

import com.demo.mybatis.dto.Student;

public interface StudentMapper {
		
	//根据学生ID查询学生实体
	public Student getById(int id);
	
	//添加学生
	public void addStudent(Student student);

	
	
	public ArrayList<Student> getList();
	
	
	//删除学生
	public void delStudent(int id);
	
}

package com.demo.mybatis.dto;

public class Student {

	private int id;
	private String name;   //姓名
	private String gender; //性别
	private String major;  //专业
	private String grade;  //年级
	
	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 getGender() {
		return gender;
	}
	public void setGender(String gender) {
		this.gender = gender;
	}
	public String getMajor() {
		return major;
	}
	public void setMajor(String major) {
		this.major = major;
	}
	public String getGrade() {
		return grade;
	}
	public void setGrade(String grade) {
		this.grade = grade;
	}
	
}

package com.demo.mybatis.test;

import java.io.IOException;
import java.io.Reader;
import java.util.ArrayList;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import com.demo.mybatis.dto.Student;
import com.demo.mybatis.mapper.StudentMapper;

public class TestMyBatis {
	private static SqlSessionFactory sqlSessionFactory =null;
	public static void main(String[] args) {
		// 与configuration.xml中的mapper配置类似，告诉MyBatis
		// 应读取的核心配置文件
		String resource = "resources/configuration.xml";
		Reader reader = null;
		try {
			reader = Resources.getResourceAsReader(resource);
		} catch (IOException e) {
			e.printStackTrace();
		}

		// 创建SqlSessionFactory实例。没有指定要用到的
		// environment，则使用默认的environment
		sqlSessionFactory = new SqlSessionFactoryBuilder()
				.build(reader);

		
//		selectbyID();
			
//		addStudent("Mack1","male","math","2");	
			
//		getlist();	
			
		delbyID(4);
			
			
		
	}
	
	/**
	 * 查询
	 */
	private static void getlist(){
		
		SqlSession sqlSession = sqlSessionFactory.openSession();

		try {
		//select
		StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
		ArrayList<Student> students = mapper.getList();

		
		if (students.size()>0) {
			
			for(int i=0;i<students.size();i++){
				System.out.println("姓名： " + students.get(i).getName() + "   专业： "
						+ students.get(i).getMajor());
			}
			
		} else {
			System.out.println("没有找到。");
		}
		} finally {
			sqlSession.close();
		}
	}
	
	/**
	 * 查询
	 */
	private static void selectbyID(){
		
		SqlSession sqlSession = sqlSessionFactory.openSession();

		try {
		//select
		StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
		Student student = mapper.getById(2);

		if (student != null) {
			System.out.println("姓名： " + student.getName() + "\n专业： "
					+ student.getMajor());
		} else {
			System.out.println("没有找到。");
		}
		} finally {
			sqlSession.close();
		}
	}
	
	/**
	 * 增加
	 */
	private static void addStudent(String name, String gender,String major,String grade){
		
		SqlSession sqlSession = sqlSessionFactory.openSession();

		try {
		//select
		StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
		Student student = new Student();
		student.setName(name);
		student.setGender(gender);
		student.setMajor(major);
		student.setGrade(grade);
		mapper.addStudent(student);

		
		} finally {
			sqlSession.close();
		}
	}
	
	
	/**
	 * 删除
	 */
	private static void delbyID(int id){
		
		SqlSession sqlSession = sqlSessionFactory.openSession();

		try {
		//select
		StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
		mapper.delStudent(id);

//		if (student != null) {
//			System.out.println("姓名： " + student.getName() + "\n专业： "
//					+ student.getMajor());
//		} else {
//			System.out.println("没有找到。");
//		}
		} finally {
			sqlSession.close();
		}
	}

}