本文共 2449 字，大约阅读时间需要 8 分钟。

1、完整配置

（1）beans.xml

（2）mybatis-config.xml

（3）StudentMapper.xml

   
       
            select * from students where id = #{id}        
            select * from students        
    
             update students set age = #{age} where id = #{id}    
        
            
             deletes from students where id = #{id}    
    
   

2、DAO

（1）接口

package com.pengshiyu.mybatis.dao;import com.pengshiyu.mybatis.entity.Student;public interface StudentDao {
       public void update(Student studentA, int id);    public Student getById(int id);}

（2）实现

package com.pengshiyu.mybatis.dao.impl;import com.pengshiyu.mybatis.dao.StudentDao;import com.pengshiyu.mybatis.entity.Student;import org.mybatis.spring.SqlSessionTemplate;public class StudentDaoImpl implements StudentDao {
       private SqlSessionTemplate sqlSession;    @Override    public Student getById(int id) {
           return sqlSession.selectOne("com.pengshiyu.mybatis.entity.StudentMapper.getById", id);    }    @Override    public void update(Student studentA, int id) {
           sqlSession.update("com.pengshiyu.mybatis.entity.StudentMapper.updateById", studentA);        sqlSession.delete("com.pengshiyu.mybatis.entity.StudentMapper.deleteById", id);    }    public void setSqlSession(SqlSessionTemplate sqlSession) {
           this.sqlSession = sqlSession;    }}

3、测试

package com.pengshiyu.mybatis.test;import com.pengshiyu.mybatis.dao.StudentDao;import com.pengshiyu.mybatis.entity.Student;import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;import java.io.IOException;public class Demo {
       public static void main(String[] args) throws IOException {
           ApplicationContext context = new ClassPathXmlApplicationContext("beans.xml");        StudentDao studentDao = (StudentDao) context.getBean("StudentDao");        Student studentA = studentDao.getById(1);        studentA.setAge(25);        studentDao.update(studentA, 3);    }}

转载地址：https://pengshiyu.blog.csdn.net/article/details/106895510 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！