MybatisPlus + Spring 的实现对Mybatis 进行简化

深藏阁楼爱情的钟 2023-06-30 12:53 115阅读 0赞

代码结构：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTM5ODg5_size_16_color_FFFFFF_t_70][]

applicationContext.xml配置文件

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xmlns:lang="http://www.springframework.org/schema/lang" 
        xmlns:aop="http://www.springframework.org/schema/aop"
        xmlns:tx="http://www.springframework.org/schema/tx"
        xmlns:context="http://www.springframework.org/schema/context" 
        xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx.xsd
        http://www.springframework.org/schema/aop
        http://www.springframework.org/schema/aop/spring-aop.xsd">
         
    
       
      <context:property-placeholder location="db.properties"/>
      <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
       
    				<property name="driverClass" value="${mysql.driver}" />
    				<property name="jdbcUrl" value="${mysql.url}" />
    				<property name="user" value="${mysql.username}" />
    				<property name="password" value="" />
      </bean>
    
    
       
       <bean id="dataSourceTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
       <property name="dataSource" ref="dataSource"></property>
       </bean>	
       
       <tx:annotation-driven transaction-manager="dataSourceTransactionManager"/>
       
       
       
       <bean id="sqlSessionFactoryBean" class="com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean">
       <property name="dataSource" ref="dataSource"></property>
        <property name="configLocation" value="mybatis.xml"></property>
       <property name="typeAliasesPackage" value="com.cjr"></property>
       </bean>
       
       <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.mapper"></property>
       </bean>
       
       </beans>

mybatis.xml

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration
     PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
     "http://mybatis.org/dtd/mybatis-3-config.dtd">
    
    <configuration>
    
    
    <properties resource="db.properties"></properties>
    
    
    	<settings>
    		<setting name="logImpl" value="LOG4J" />
    		
    	</settings>
    
    </configuration>

StudentMapper.java

package com.mapper;
    
    import com.baomidou.mybatisplus.core.mapper.BaseMapper;
    import com.cjr.student;
    
    //继承BaseMapper 可直接进行接口的实现，省略Mapper的步骤
    public interface StudentMapper extends BaseMapper<student>{
    	
    
    }

student.java

package com.cjr;
    
    import com.baomidou.mybatisplus.annotation.IdType;
    import com.baomidou.mybatisplus.annotation.TableField;
    import com.baomidou.mybatisplus.annotation.TableId;
    import com.baomidou.mybatisplus.annotation.TableName;
    
    @TableName("student")
    public class student {
    	@TableId(value="stuNo", type=IdType.AUTO)
    	private int stuNo;
    	@TableField(value="stuName")
    	private String stuName;
    	@TableField(value="stuAge")
    	private int stuAge;
    	
    	public student(int stuNo, String stuName, int stuAge) {
    		super();
    		this.stuNo = stuNo;
    		this.stuName = stuName;
    		this.stuAge = stuAge;
    	}
    	
    	public student( String stuName, int stuAge) {
    
    		this.stuName = stuName;
    		this.stuAge = stuAge;
    	}
    	public student() {
    		
    	}
    	public int getStuNo() {
    		return stuNo;
    	}
    	public void setStuNo(int stuNo) {
    		this.stuNo = stuNo;
    	}
    	public String getStuName() {
    		return stuName;
    	}
    	public void setStuName(String stuName) {
    		this.stuName = stuName;
    	}
    	public int getStuAge() {
    		return stuAge;
    	}
    	public void setStuAge(int stuAge) {
    		this.stuAge = stuAge;
    	}
    
    }

测试类：

package com.test;
    
    import java.sql.Connection;
    import java.sql.SQLException;
    import java.util.List;
    
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    
    import com.cjr.student;
    import com.mapper.StudentMapper;
    import com.mchange.v2.c3p0.ComboPooledDataSource;
    
    public class test {
    
    
    
    	public static void testInsert() {
    		ApplicationContext context =	new ClassPathXmlApplicationContext("applicationContext.xml");
    	    //从ioc中获取mapper
    		StudentMapper studentmapper = (StudentMapper)context.getBean("studentMapper");
    	student	student =  new student("zs",20);
    	   int count = studentmapper.insert(student);
    	  // System.out.println(count);
    	   List<student> list = studentmapper.selectList(null);
    	   for(int i=0;i<list.size();i++)
    	   System.out.println(list.get(i).getStuNo());
    	}
    	
    	public static void main(String[] args) throws SQLException {
    		
    //		ApplicationContext context =	new ClassPathXmlApplicationContext("applicationContext.xml");
    //	    ComboPooledDataSource ds = (ComboPooledDataSource) context.getBean("dataSource");
    //    System.out.println("-------"+ds);
    //    Connection  connection = ds.getConnection();
    //    System.out.println("---------"+connection);
    		
    		testInsert();	
        
    	}
    
    }

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTM5ODg5_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200117162842587.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTM5ODg5,size_16,color_FFFFFF,t_70