SSM--Spring整合Mybatis开发操作数据库

太过爱你忘了你带给我的痛 2022-01-26 01:43 139阅读 0赞

## 一、现附上项目层级目录以及所需要的jar包： ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pfeGluZG9uZw_size_16_color_FFFFFF_t_70][] ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pfeGluZG9uZw_size_16_color_FFFFFF_t_70 1][]

## 二、Spring核心配置文件、Mybatis核心配置文件以及日志文件： ##

1.Spring核心配置文件 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:context="http://www.springframework.org/schema/context"
    	xmlns:aop="http://www.springframework.org/schema/aop"
    	xmlns:tx="http://www.springframework.org/schema/tx"
    	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
    		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd
    		http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
    		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">
    		
    		
    		<context:property-placeholder location="db.properties"/>
    		
    		
    		<bean name="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    		     <property name="driverClass" value="${jdbc.driver}"/>
    		     <property name="jdbcUrl" value="${jdbc.url}"/>
    		     <property name="user" value="${jdbc.username}"/>
    		     <property name="password" value="${jdbc.password}"/>
    		</bean>
    		
    		
    		
    		<bean id = "sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
    		     <property name="dataSource" ref="dataSource"/>
    		     
    		     <property name="configLocation" value="classpath:sqlMapConfig.xml"/>
    		</bean>
    		
    		
    		
    		<bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
    		   
    		   <property name="sqlSessionFactory" ref="sqlSessionFactoryBean"/>
    		   
    		   <property name="mapperInterface" value="cn.skh.mapper.UserMapper"/>
    		</bean>
    		
    		
    		
    		<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    		  <property name="basePackage" value="cn.skh.mapper"/>
    		</bean>
     </beans>

2.Mybatis核心配置文件：

<?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>	
    
    	<typeAliases>
    		
    		<package name="cn.skh.bean"/>
    	</typeAliases>
    	<mappers>
    	  <package name="cn.skh.mapper"/>
    	</mappers>
    </configuration>

3.日志文件：

# Global logging configuration
    log4j.rootLogger=DEBUG, stdout
    # Console output...
    log4j.appender.stdout=org.apache.log4j.ConsoleAppender
    log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
    log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

## 三、JavaBean以及Mapper文件： ##

1.javaBean：

package cn.skh.bean;
    /**
     * 需要注意的地方 bean中的属性名称要和数据库中的属性名称相对性
     * 属性和数据库中字段的名称要一样 不能这个是name 那个是username
     * @author SKH
     *
     */
    public class User {
         private int id;
         private String name;
         private String password;
         private String sex;
         private int uid;
         public int getUid() {
     		return uid;
     	}
     	public void setUid(int uid) {
     		this.uid = uid;
     	}
    	public int getId() {
    		return id;
    	}
    	public void setId(int id) {
    		this.id = id;
    	}
    	public String getName() {
    		return name;
    	}
    	public void setName(String name) {
    		this.name = name;
    	}
    	public String getPassword() {
    		return password;
    	}
    	public void setPassword(String password) {
    		this.password = password;
    	}
    	public String getSex() {
    		return sex;
    	}
    	public void setSex(String sex) {
    		this.sex = sex;
    	}
    	@Override
    	public String toString() {
    		return "User [id=" + id + ", name=" + name + ", password=" + password + ", sex=" + sex + ", uid=" + uid + "]";
    	}
    	public User(int id, String name, String password, String sex, int uid) {
    		super();
    		this.id = id;
    		this.name = name;
    		this.password = password;
    		this.sex = sex;
    		this.uid = uid;
    	}
    	public User() {
    		
    	}
         
    }

2.mapper.xml 这里只写了查和增：

<?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="cn.skh.mapper.UserMapper">
     
     <select id="selectById" parameterType="int" resultType="user">
       select * from qwe where id = #{id} 
     </select>
      <insert id="insertOne" parameterType="user">
      
      
         insert into qwe values(#{id},#{name},#{password},#{sex},#{uid})
      
      </insert>
    </mapper>

## 四、测试类： ##

package cn.skh.test;
    
    import org.junit.Test;
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    
    import cn.skh.bean.User;
    import cn.skh.mapper.UserMapper;
    
    public class MapperTest {
       @Test
    	public void test() {
    	   ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");
           UserMapper mapper = ac.getBean(UserMapper.class);
           User user = mapper.selectById(0);
           System.out.println(user);
       }
       @Test
      	public void test2() {
    	   User u = new User(20,"miku","mlfl","女",1);
      	   ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");
             UserMapper mapper = ac.getBean(UserMapper.class);
             mapper.insertOne(u);
         }
    }

test输出：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pfeGluZG9uZw_size_16_color_FFFFFF_t_70 2][]

test2()输出:

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pfeGluZG9uZw_size_16_color_FFFFFF_t_70 3][]

都可以成功的对数据库进行操作。

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pfeGluZG9uZw_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20190527204045989.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pfeGluZG9uZw==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pfeGluZG9uZw_size_16_color_FFFFFF_t_70 1]: /images/20220126/97d4f29dd2c647a2afd4786cddb7fd34.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pfeGluZG9uZw_size_16_color_FFFFFF_t_70 2]: /images/20220126/a9d94250abcf486b81549de6a034f9f6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pfeGluZG9uZw_size_16_color_FFFFFF_t_70 3]: /images/20220126/4fd8a86ca5d145dc9a41248f7e45ee8c.png