【JAVAEE学习笔记1】Mybatis Tomcat 2022.3.14

准备工作：

 在Navicat中创建一张student表

在Eclipse中File->new->other->Dynamic Web Project

Next

 在eclipse项目的lib文件夹中导入mybatis-3.3.6中的以下文件(可以先复制粘贴，再build path)

选择这些文件->右键->Bulid Path.

练习中所涉及的代码：

 StudentMapper.xml

 	
 	select * from Student where sid = #{sid}
 	
 	

Student.java

package com.qfedu.pojo;

public class Student {
	private int sid;
	private String sname;
	private String age;
	private String course;
	public Student(){
		super();
	}
	public Student(int sid,String sname,String age,String course){
		super();
		this.sid=sid;
		this.sname=sname;
		this.age=age;
		this.course=course;
	}
	public int getSid() {
		return sid;
	}
	public void setSid(int sid) {
		this.sid = sid;
	}
	public String getSname() {
		return sname;
	}
	public void setSname(String sname) {
		this.sname = sname;
	}
	public String getAge() {
		return age;
	}
	public void setAge(String age) {
		this.age = age;
	}
	public String getCourse() {
		return course;
	}
	public void setCourse(String course) {
		this.course = course;
	}
	@Override
	public String toString() {
		return "Student [sid=" + sid + ", sname=" + sname + ", age=" + age + ", course=" + course + "]";
	}
	

}

TestFindBySid.java

package com.qfedu.test;
import java.io.*;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.*;
import com.qfedu.pojo.Student;
public class TestFindBySid {
	public static void main(String[] args){
		String resource = "mybatis-config.xml";
		try{
			InputStream in =Resources.getResourceAsStream(resource);
			SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
			SqlSession sqlSession = factory.openSession();
			Student student = sqlSession.selectOne("student.findStudentBySid",1);
			System.out.print(student.toString());
			sqlSession.close();
		}catch(IOException e){
			e.printStackTrace();
		}
	}

}

mybatis-config.xml

package com.qfedu.test;
import java.io.*;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.*;
import com.qfedu.pojo.Student;
public class TestFindBySid {
	public static void main(String[] args){
		String resource = "mybatis-config.xml";
		try{
			InputStream in =Resources.getResourceAsStream(resource);
			SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
			SqlSession sqlSession = factory.openSession();
			Student student = sqlSession.selectOne("student.findStudentBySid",1);
			System.out.print(student.toString());
			sqlSession.close();
		}catch(IOException e){
			e.printStackTrace();
		}
	}

}

运行结果：