Maven管理,Spring与Mybatis的环境整合
来源:互联网 发布:linux 修改路由表 编辑:程序博客网 时间:2024/06/05 21:18
ps.本文旨在提供Spring + Mybatis环境整合的资源文件配置供大家参考.
这里是spring与mybatis的环境整合,使用maven管理
希望对大家有帮助,如有错误或疏漏的地方,请大家指出,在这里先谢谢了.
SSM近来比较受大家喜爱,
但其实有些中小项目呢,用到spring+mybatis也就可以了
ps.这是我一个小课题中使用的jar包与配置文件,可能与大家实际开发项目情况有偏差,请自行判断修改.
1.先是jar包截图 :
2.pom.xml :
pom.xml中jar的版本要注意,这里贴出mvnrepository
http://mvnrepository.com/
若是有版本不兼容等问题,可去mvnrepository中查询指定jar包的其他版本.
<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>BookStore</groupId> <artifactId>BookStore</artifactId> <packaging>war</packaging> <version>0.0.1-SNAPSHOT</version> <name>BookStore Maven Webapp</name> <url>http://maven.apache.org</url> <dependencies> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>3.8.1</version> <scope>test</scope> </dependency> <!-- https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api --> <dependency> <groupId>javax.servlet</groupId> <artifactId>javax.servlet-api</artifactId> <version>3.0.1</version> <!-- 只在编译时和测试时运行 --> <scope>provided</scope> </dependency> <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.42</version> </dependency> <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.2.8</version> </dependency> <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>1.3.0</version> </dependency> <!-- https://mvnrepository.com/artifact/org.springframework/spring-aspects --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-aspects</artifactId> <version>4.3.9.RELEASE</version> </dependency> <!-- https://mvnrepository.com/artifact/org.springframework/spring-expression --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-expression</artifactId> <version>4.3.9.RELEASE</version> </dependency> <!-- https://mvnrepository.com/artifact/org.springframework/spring-context-support --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context-support</artifactId> <version>4.3.9.RELEASE</version> </dependency> <!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>4.3.9.RELEASE</version> </dependency> <!-- https://mvnrepository.com/artifact/org.springframework/spring-aop --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-aop</artifactId> <version>4.3.9.RELEASE</version> </dependency> <!-- https://mvnrepository.com/artifact/org.springframework/spring-core --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-core</artifactId> <version>4.3.9.RELEASE</version> </dependency> <!-- https://mvnrepository.com/artifact/org.springframework/spring-beans --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-beans</artifactId> <version>4.3.9.RELEASE</version> </dependency> <!-- https://mvnrepository.com/artifact/org.springframework/spring-context --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>4.3.9.RELEASE</version> </dependency> <!-- https://mvnrepository.com/artifact/aopalliance/aopalliance --> <dependency> <groupId>aopalliance</groupId> <artifactId>aopalliance</artifactId> <version>1.0</version> </dependency> <!-- https://mvnrepository.com/artifact/com.mchange/c3p0 --> <dependency> <groupId>com.mchange</groupId> <artifactId>c3p0</artifactId> <version>0.9.5.2</version> </dependency> <!-- https://mvnrepository.com/artifact/javax.servlet/jstl --> <dependency> <groupId>javax.servlet</groupId> <artifactId>jstl</artifactId> <version>1.2</version> </dependency> </dependencies> <build> <finalName>BookStore</finalName> <plugins> <plugin> <groupId>org.apache.tomcat.maven</groupId> <artifactId>tomcat7-maven-plugin</artifactId> <version>2.2</version> <executions> <execution> <!-- 打包的时候运行 --> <phase>package</phase> <goals> <goal>run</goal> </goals> </execution> </executions> </plugin> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-compiler-plugin</artifactId> <version>2.3.2</version> <configuration> <source>1.8</source> <target>1.8</target> <encoding>UTF-8</encoding> </configuration> </plugin> </plugins> </build></project>
3.applicationContext.xml :
ps.注意两个< context: />
<?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.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd"> <context:annotation-config/> <context:component-scan base-package="com.bookstore" /> <!-- 配置c3p0连接池 --> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="driverClass" value="com.mysql.jdbc.Driver"/> <property name="jdbcUrl" value="jdbc:mysql://127.0.0.1:3306/bookstore"/> <property name="user" value="root"/> <property name="password" value="root"/> <!-- 若数据库中连接数不足时,一次向数据库服务器申请多少个连接 --> <property name="acquireIncrement" value="5" /> <!-- 初始化数据库连接时连接的数量 --> <property name="initialPoolSize" value="10" /> <!-- 数据库连接池中最小的数据库连接数 --> <property name="minPoolSize" value="5" /> <!-- 数据库连接池中最大的数据库连接数 --> <property name="maxPoolSize" value="10" /> <!-- 数据库连接池可以维护的Statement的个数 --> <property name="maxStatements" value="10" /> <!-- 每个连接同时可以使用的Statement对象的个数 --> <property name="maxStatementsPerConnection" value="5" /> </bean> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="configLocation" value="com/bookstore/mybatisConfig.xml"></property> </bean> <bean id="dbConnection" class="org.mybatis.spring.mapper.MapperFactoryBean"> <property name="mapperInterface" value="com.bookstore.dao.IUserDao"></property> <property name="sqlSessionFactory" ref="sqlSessionFactory"></property> </bean> </beans>
4.mybatisConfig.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> <mappers> <mapper resource="com/bookstore/DAO.xml"/> </mappers> </configuration>
5.DAO.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.bookstore.dao.IUserDao"> <!-- 数据库操作 --> <!-- 例:用户注册 --> <select id="register" parameterType="com.bookstore.bean.User"> insert user value(#{id},#{password}) </select></mapper>
6.IUserDao.java
/** * Dao接口 */public interface IUserDao { /** * 注册操作 * @param user */ void register(User user);}
7.UserDao.java
/** * dao实现类 */public class UserDao { /** * 注册操作 * @param user */ public void register(User user) { //获取spring上下文 ApplicationContext ctx = new ClassPathXmlApplicationContext("com/bookstore/applicationContext.xml"); /* * 数据库操作都是通过IUserDao接口操作, * 所以这里是通过IUserDao接口来连接数据库. */ IUserDao iuserDao=(IUserDao) ctx.getBean("dbConnection"); //调用iuserDao中的方法,即可进行对应的数据库操作了 iuserDao.register(user); }}
附上一个小小的项目,供大家参考,GitHub地址.
加油,与大家共勉.
阅读全文
0 0
- Maven管理,Spring与Mybatis的环境整合
- Maven管理,SpringMVC+Spring+Mybatis环境整合
- Maven管理Spring+Mybatis的整合
- IDEA+Maven整合Spring与MyBatis框架
- maven+spring+mybatis整合
- Maven + Spring 整合 Mybatis
- MyBatis、Spring、maven整合
- spring+mybatis+maven整合
- Maven + Spring 整合 Mybatis
- Spring与Mybatis整合环境搭建
- MyBatis与Spring的整合
- mybatis与spring的整合
- mybatis与spring的整合
- Spring 与 MyBatis 的整合
- SPRING与MYbatis的整合
- Spring与MyBatis的整合
- spring与mybatis的整合
- mybatis与spring的整合
- Java Integer包的toBinaryString(int i)函数详解
- Android系统广播大全
- 4401: 块的计数
- JavaWeb:上传下载文件
- android 广播大全
- Maven管理,Spring与Mybatis的环境整合
- 解决vs2015无法启动IIS Express的问题
- USB——设备请求和描述符
- Redis高级特性及应用场景
- 见习报告
- wsdl文件转换成java代码
- 序
- RPC框架Thrift架构描述
- 暑期复习计划。