Maven+spring+mybatis 整合学习

没几把剑

已于 2023-05-06 10:09:44 修改

阅读量497

点赞数

文章标签： maven mybatis spring

于 2017-03-07 17:09:09 首次发布

本文链接：https://blog.csdn.net/jeasen/article/details/60769471

版权

Maven用的阿里的，地址为http://maven.aliyun.com/nexus/content/groups/public，配置在setting的mirror节的url属性中，pom.xml如下：

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<groupId>com.ehl</groupId>
	<artifactId>MyMaven</artifactId>
	<packaging>war</packaging>
	<version>0.0.1-SNAPSHOT</version>
	<name>MyMaven Maven Webapp</name>
	<url>http://maven.apache.org</url>
	<properties>
		<!-- spring版本号 -->
		<spring.version>4.0.2.RELEASE</spring.version>
		<!-- mybatis版本号 -->
		<mybatis.version>3.2.6</mybatis.version>
		<!-- log4j日志文件管理包版本 -->
		<slf4j.version>1.7.7</slf4j.version>
		<log4j.version>1.2.17</log4j.version>
	</properties>

	<dependencies>
		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<version>4.11</version>
			<!-- 表示开发的时候引入，发布的时候不会加载此包 -->
			<scope>test</scope>
		</dependency>
		<!-- spring核心包 -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-core</artifactId>
			<version>${spring.version}</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-web</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-oxm</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-tx</artifactId>
			<version>${spring.version}</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-jdbc</artifactId>
			<version>${spring.version}</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-webmvc</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-aop</artifactId>
			<version>${spring.version}</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context-support</artifactId>
			<version>${spring.version}</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-test</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<!-- mybatis核心包 -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>${mybatis.version}</version>
		</dependency>
		<!-- mybatis/spring包 -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
			<version>1.2.2</version>
		</dependency>
		<!-- 导入java ee jar 包 -->
		<dependency>
			<groupId>javax</groupId>
			<artifactId>javaee-api</artifactId>
			<version>7.0</version>
		</dependency>
		<!-- 导入Mysql数据库链接jar包 -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.30</version>
		</dependency>
		<!-- 导入dbcp的jar包，用来在applicationContext.xml中配置数据库 -->
		<dependency>
			<groupId>commons-dbcp</groupId>
			<artifactId>commons-dbcp</artifactId>
			<version>1.2.2</version>
		</dependency>
		<!-- JSTL标签类 -->
		<dependency>
			<groupId>jstl</groupId>
			<artifactId>jstl</artifactId>
			<version>1.2</version>
		</dependency>
		<!-- 日志文件管理包 -->
		<!-- log start -->
		<dependency>
			<groupId>log4j</groupId>
			<artifactId>log4j</artifactId>
			<version>${log4j.version}</version>
		</dependency>


		<!-- 格式化对象，方便输出日志 -->
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>fastjson</artifactId>
			<version>1.1.41</version>
		</dependency>


		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-api</artifactId>
			<version>${slf4j.version}</version>
		</dependency>

		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-log4j12</artifactId>
			<version>${slf4j.version}</version>
		</dependency>
		<!-- log end -->
		<!-- 映入JSON -->
		<dependency>
			<groupId>org.codehaus.jackson</groupId>
			<artifactId>jackson-mapper-asl</artifactId>
			<version>1.9.13</version>
		</dependency>
		<!-- 上传组件包 -->
		<dependency>
			<groupId>commons-fileupload</groupId>
			<artifactId>commons-fileupload</artifactId>
			<version>1.3.1</version>
		</dependency>
		<dependency>
			<groupId>commons-io</groupId>
			<artifactId>commons-io</artifactId>
			<version>2.4</version>
		</dependency>
		<dependency>
			<groupId>commons-codec</groupId>
			<artifactId>commons-codec</artifactId>
			<version>1.9</version>
		</dependency>

		<dependency>
			<groupId>com.cloudhopper.proxool</groupId>
			<artifactId>proxool</artifactId>
			<version>0.9.1</version>
		</dependency>
		<dependency>
			<groupId>com.cloudhopper.proxool</groupId>
			<artifactId>proxool-cglib</artifactId>
			<version>0.9.1</version>
		</dependency>
	</dependencies>
	<build>
		<plugins>
			<plugin>
				<groupId>org.apache.maven.plugins</groupId>
				<artifactId>maven-compiler-plugin</artifactId>
				<version>3.1</version>
				<configuration>
					<source>1.7</source>
					<target>1.7</target>
				</configuration>
			</plugin>
		</plugins>
	</build>
</project>

首先创建model

package com.ehl.pojo;

import java.io.Serializable;

public class User implements Serializable {  
	  
    /** 
     *  
     */  
    private static final long serialVersionUID = 1L;  
  
    private int uid;  
    private String userName;  
    private String password;  
  
    public int getUid() {  
        return uid;  
    }  
  
    public void setUid(int uid) {  
        this.uid = uid;  
    }  
  
    public String getUserName() {  
        return userName;  
    }  
  
    public void setUserName(String userName) {  
        this.userName = userName;  
    }  
  
    public String getPassword() {  
        return password;  
    }  
  
    public void setPassword(String password) {  
        this.password = password;  
    }  
  
    public static long getSerialversionuid() {  
        return serialVersionUID;  
    }  
  
    @Override  
    public String toString() {  
        return "uId: "+this.uid + ", Name: " + this.userName + ",Pass: " + this.password;  
    }  
}

然后是dao的接口定义

package com.ehl.dao;

import java.util.List;
import com.ehl.pojo.User;

public interface IUserDao {  
	  
    public User queryById(int id);  
      
    public void save(User u);  
      
    public void update(User u);  
      
    public void delete(Integer id);  
      
    public List<User> queryAll();  
}

dao的实现

package com.ehl.dao.impl;

import java.util.List;  

import org.mybatis.spring.SqlSessionTemplate;  
import org.springframework.beans.factory.annotation.Autowired;  
import org.springframework.stereotype.Repository;  

import com.ehl.dao.IUserDao;
import com.ehl.pojo.User;
  
  
@Repository  
public class UserDaoImpl implements IUserDao {  
  
    @Autowired  
    private SqlSessionTemplate sqlSessionTemplate;  
      
    @Override  
    public User queryById(int id) {  
        return (User) sqlSessionTemplate.selectOne("queryById", id);  
    }  
  
    @Override  
    public void save(User u) {  
        sqlSessionTemplate.insert("insert-user", u);  
    }  
  
    @Override  
    public void update(User u) {  
        sqlSessionTemplate.update("update-user", u);  
    }  
  
    @Override  
    public void delete(Integer id) {  
        sqlSessionTemplate.delete("delete-user",id);  
    }  
  
    @Override  
    public List<User> queryAll() {  
        List<User> users = sqlSessionTemplate.selectList("queryAll");  
        return users;  
    }  
  
}

service接口定义

package com.ehl.service;

import java.util.List;

import com.ehl.pojo.User;

public interface IUserService {
	public User queryById(int id);  
    
    public void save(User u);  
      
    public void update(User u);  
      
    public void delete(Integer id);  
      
    public List<User> queryAll();
}

service接口实现

package com.ehl.service.impl;

import java.util.List;

import javax.annotation.Resource;
import org.springframework.stereotype.Service;

import com.ehl.dao.IUserDao;
import com.ehl.pojo.User;
import com.ehl.service.IUserService;

@Service("userService")  
public class UserServiceImpl implements IUserService {
	
	@Resource 
	private IUserDao dao;
	
	@Override
	public User queryById(int id) {
		// TODO Auto-generated method stub
		return dao.queryById(id);
	}

	@Override
	public void save(User u) {
		// TODO Auto-generated method stub
		dao.save(u);
	}

	@Override
	public void update(User u) {
		// TODO Auto-generated method stub
		dao.update(u);
	}

	@Override
	public void delete(Integer id) {
		// TODO Auto-generated method stub
		dao.delete(id);
	}

	@Override
	public List<User> queryAll() {
		// TODO Auto-generated method stub
		return dao.queryAll();
	}  
}

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-3.0.xsd  
           http://www.springframework.org/schema/aop   
           http://www.springframework.org/schema/aop/spring-aop-3.0.xsd  
           http://www.springframework.org/schema/tx  
           http://www.springframework.org/schema/tx/spring-tx-3.0.xsd  
           http://www.springframework.org/schema/context  
           http://www.springframework.org/schema/context/spring-context-3.0.xsd">  
              
    <!-- 采用注释的方式配置bean -->    
    <context:annotation-config />    
    <!-- 配置要扫描的包 -->    
    <context:component-scan base-package="com.ehl"></context:component-scan>  
  
    <!-- 加载 jdbc.properties 配置文件 -->  
    <bean  
        class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">  
        <property name="locations">  
            <list>  
                <value>classpath:jdbc.properties</value>  
            </list>  
        </property>  
    </bean>  
  
    <!-- 配置数据源(连接池，proxool) -->  
    <bean id="dataSource"  
        class="org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy">  
        <property name="targetDataSource">  
            <bean class="org.logicalcobwebs.proxool.ProxoolDataSource">  
                <property name="driver" value="${jdbc.driverClassName}" />  
                <property name="driverUrl" value="${jdbc.url}" />  
                <property name="user" value="${jdbc.username}" />  
                <property name="password" value="${jdbc.password}" />  
                <property name="maximumConnectionCount" value="${proxool.maxConnCount}" />  
                <property name="minimumConnectionCount" value="${proxool.minConnCount}" />  
                <property name="statistics" value="${proxool.statistics}" />  
                <property name="simultaneousBuildThrottle" value="${proxool.simultaneousBuildThrottle}" />  
                <property name="trace" value="${proxool.trace}" />  
            </bean>  
        </property>  
    </bean>  
  
    <!-- Session工厂 -->  
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
        <property name="dataSource" ref="dataSource" />  
        <!-- mybatis配置文件 -->  
        <property name="configLocation" value="classpath:mybatis.xml" />  
    </bean>  
      
    <!-- 配置SqlSessionTemplate -->    
    <bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">    
        <constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory" />    
    </bean>  
  
</beans>

resources目录下建立sqlmap文件夹，放置User-sqlmap-mapping.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="com.ehl.pojo.User">  
  
    <cache />  
      
    <resultMap type="User" id="resultListUser">  
        <id column="uid" property="uid" />  
        <result column="userName" property="userName"/>  
        <result column="password" property="password" />  
    </resultMap>  
      
    <select id="queryById" resultType="User" parameterType="int">  
        SELECT  
        UID,  
        USERNAME,  
        PASSWORD  
        FROM user_t
        WHERE UID = #{id}  
    </select>  
      
    <insert id="insert-user" parameterType="User" useGeneratedKeys="true" keyProperty="uid">  
            insert into  
            user_t(userName,password) values(#{userName},#{password})   
    </insert>  
      
    <update id="update-user" parameterType="User">  
        UPDATE user_t SET USERNAME=#{userName},PASSWORD=#{password} WHERE UID=#{uid}  
    </update>  
      
    <delete id="delete-user" parameterType="int">  
        DELETE FROM user_t WHERE UID=#{id}  
    </delete>  
      
    <select id="queryAll" resultMap="resultListUser">  
        SELECT * FROM user_t  
    </select>  
</mapper>

jdbc属性文件，测试过程中发现，此文件第一行需要加上注释说明，不然jdbc.driverClassName的值总是读取不到

#配置文件
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/mytest
jdbc.username=SYS
jdbc.password=ehl1234
proxool.maxConnCount=10
proxool.minConnCount=5
proxool.statistics=1m,15m,1h,1d
proxool.simultaneousBuildThrottle=30
proxool.trace=false

最后是mybaits.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>  
    <typeAliases>  
        <typeAlias alias="user" type="com.ehl.pojo.User"/>  
    </typeAliases>  
      
    <!-- 指定映射文件 -->  
    <mappers>  
        <mapper resource="sqlmap/User-sqlmap-mapping.xml" />  
    </mappers>  
</configuration>

MyEclipse的目录结构如下

最后是集成JUnit的测试代码

package com.ehl.test;

import java.util.List;


import org.junit.Test;  
import org.junit.runner.RunWith;  
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;  
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;  

import com.ehl.service.IUserService;
import com.ehl.pojo.User;


@RunWith(SpringJUnit4ClassRunner.class)  
@ContextConfiguration(locations="/applicationContext.xml")  
public class test {  
  
    @Autowired  
    IUserService userService;   
      
    @Test  
    public void testQueryById(){  
        User u = userService.queryById(1);  
        if(u != null){  
            System.out.println(u);  
        }  
    }  
      
    @Test  
    public void testInsert() {  
        for(int i = 0; i < 100; i++){  
            User u = new User();  
            u.setUserName("whh");  
            u.setPassword("sb");  
            userService.save(u);  
        }  
        System.out.println("保存成功！");  
    }  
      
    @Test  
    public void testUpdate(){  
        User u = userService.queryById(3);  
        u.setUserName("scott");  
        u.setPassword("scott");  
        userService.update(u);  
        System.out.println("修改成功！");  
    }  
      
      
    @Test  
    public void testDelete(){  
        int id = 4;  
        userService.delete(id);  
        System.out.println("删除成功！");  
    }  
      
      
    @Test  
    public void testQueryAll(){  
        List<User> users = userService.queryAll();  
        if(users != null){  
            for(int i = 0; i < users.size(); i++){  
                System.out.println(users.get(i));  
            }  
        }  
    }  
}