mybatis简单查询

来源：互联网发布：程序员推荐书单编辑：程序博客网时间：2024/06/04 18:29

准备开发环境

创建一个java项目
编码实现简单查询功能
2.1 Student类

package com;public class Student {    private Integer id;    private String name;    private Integer age;    private Integer tid;    public Student(){}    public Student(String name, Integer age, Integer tid) {        this.name = name;        this.age = age;        this.tid = tid;    }    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 Integer getAge() {        return age;    }    public void setAge(Integer age) {        this.age = age;    }    public Integer getTid() {        return tid;    }    public void setTid(Integer tid) {        this.tid = tid;    }    @Override    public String toString() {        return "Student [id=" + id + ", name=" + name + ", age=" + age+ ", tid=" + tid + "]";    }}

2.2 student类对应的mapper文件

<?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.StudentMapper">    <insert id="insertStudent" parameterType="com.Student">        <!-- insert into STUDENT values(se_Student.nextval,#{name},#{age},#{tid}) -->        insert into STUDENT(name,age,tid) values(#{name},#{age},#{tid})    </insert>    <select id="selectStudent" resultType="com.Student">        select * from STUDENT    </select></mapper>

2.3 测试类Test.java

package pojo;import java.io.IOException;import java.io.Reader;import java.util.List;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 com.Student;public class Test {    public static void main(String[] args) throws IOException {        String resource = "sqlConfig.xml";        Reader reader = Resources.getResourceAsReader(resource);        SqlSessionFactory sqlMapper = new SqlSessionFactoryBuilder().build(reader);        SqlSession session = sqlMapper.openSession();//      Student student = new Student();//      session.insert("com.StudentMapper.insertStudent", student);//      session.select("com.StudentMapper.selectStudent",student);        List<Student> students = session.selectList("com.StudentMapper.selectStudent");        System.out.println(students);    }}

1 0