实体java类：
package model;
public class Bloger {
private Integer id;
private String name;
//这里需要注意变量的命名规范，因为实体变量会和sql记录一一对应，
// 所以不规范的命名方式会导致mybatis执行异常
private String userName;
private int age;
private String email;
public Bloger(){}
public Bloger(Integer id, String name, String userName, int age, String email) {
this.id = id;
this.name = name;
this.userName = userName;
this.age = age;
this.email = email;
}
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 String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
@Override
public String toString() {
return “BlogId:”+ getId()+ " BlogName:"+getName()+ " username:" + getUserName();
}
}
接口方法：
package dao;
import model.Bloger;
import org.apache.ibatis.annotations.Select;
public interface BlogerMapper {
//通过接口方法 getBlogerId（Integer id）返回一个实体对象
public Bloger getBlogerId(Integer id);
public void addBloger(Bloger bloger);
public void updateBloger(Bloger bloger);
public Boolean deleteBloger(Integer id);
}
mapper 配置文件：
**《一线大厂Java面试题解析+后端开发学习笔记+最新架构讲解视频+实战项目源码讲义》**【docs.qq.com/doc/DSmxTbFJ1cmN1R2dB】 完整内容开源分享
tis-3-mapper.dtd">
select id,name,user_name,age,email from mybatis_test where id = #{id}
INSERT into mybatis_test(user_name,age,email,name)
VALUES (#{user_name},#{age},#{email},#{name});
UPDATe mybatis_test
SET user_name=#{user_name},age=#{age},email=#{email},name=#{name}
WHERe id = #{id}
DELETE FROM mybatis_test where id =#{id}
package test;
import dao.BlogerMapper;
import model.Bloger;
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 java.io.IOException;
import java.io.InputStream;
public class MybatisDriver {
public static void main(String[] args) throws Exception{
mybatits_select();
}
public static SqlSessionFactory getSqlSessionFactory() throws IOException {
String resource = “source/configuration.xml”;
InputStream inputStream= Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory= new SqlSessionFactoryBuilder().build(inputStream);
return sqlSessionFactory;
}
public static void mybatits_add() throws IOException{
// 获取SqlSessionFactory对象
SqlSessionFactory sqlSessionFactory=getSqlSessionFactory();
// 获取回话对象
SqlSession sqlSession=sqlSessionFactory.openSession();
// 这里MyBaitis帮我们创建了代理对象
BlogerMapper blogerMapper =sqlSession.getMapper(BlogerMapper.class);
Bloger bloger=new Bloger();
bloger.setName(“樊瑞8号”);
bloger.setEmail(“wujianqinjian8@163.com”);
bloger.setAge(33);
