2.5 maven+spring4.X基础上搭建mybatis
来源:互联网 发布:怎么进入网站的数据库 编辑:程序博客网 时间:2024/06/11 00:22
1.前言
1.本博客面向初级开发者。
2.本博客为系列博客,《1.X》系列为服务器数据库相关技术,前几章为简单搭建linux+tomcat+MySQL+nginx+redis、《2.X》为java后台技术前几章为搭建mevan+springmvc4+mybatis、《3.X》为前端UI技术,《4.X》为相关测试技术。
3.本博客在学习别人博客技术基础上,并加以自己实现研究优化为全部原创,有什么问题可以留言,不定期回答,互相交流学习。
2.搭建mybatis
1.准备
1.搭建maven项目
http://blog.csdn.net/zcjfzcjf/article/details/51105522
2.搭建springmvc项目
http://blog.csdn.net/zcjfzcjf/article/details/51233469
http://blog.csdn.net/zcjfzcjf/article/details/51235647
3.使用使用mybatis-generator工具创建mybatis相关代码
http://blog.csdn.net/zcjfzcjf/article/details/51287408
项目结构
2.新建sqlmap包
在com.my1下新建sqlmap包将生成的UserInfoMapper.xml放入
3.新建是实体entity包
在com.my1下新建entity包将生成的和UserInfoExample放入
4.dao包
在com.my1下dao包将生成的UserInfoMapper.java放入
这时会报错说明没有添加jar
5.添加jar
修改pom文件 如下
<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>mavenSpringMybatisDemo</groupId> <artifactId>mavenSpringMybatisDemo</artifactId> <packaging>war</packaging> <version>0.0.1-SNAPSHOT</version> <name>mavenSpringMybatisDemo Maven Webapp</name> <url>http://maven.apache.org</url><!-- 声明版本 --> <properties> <spring.version>4.0.2.RELEASE</spring.version> <junit.version>4.11</junit.version> </properties> <dependencies> <!-- maven包 --> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>3.8.1</version> <scope>test</scope> </dependency> <dependency> <groupId>com.sun.faces</groupId> <artifactId>jsf-api</artifactId> <version>2.0.4-b09</version> </dependency> <dependency> <groupId>com.sun.faces</groupId> <artifactId>jsf-impl</artifactId> <version>2.0.4-b09</version> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>jstl</artifactId> <version>1.2</version> </dependency> <dependency> <groupId>taglibs</groupId> <artifactId>standard</artifactId> <version>1.1.2</version> </dependency><!-- springjar包 --> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>${junit.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>${spring.version}</version> </dependency> <!-- spring --> <!-- 事务 --> <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-web</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-aspects</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context-support</artifactId> <version>${spring.version}</version> </dependency> <!-- over --> <!-- 2016 mybatis学习 --> <!-- mybatis 包 --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.2.8</version> </dependency> <!--mybatis spring 插件 --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>1.2.2</version> </dependency> <!-- mysql连接 --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.34</version> </dependency> <!-- 数据源 --> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.0.12</version> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>fastjson</artifactId> <version>1.2.3</version> </dependency> <dependency> <groupId>org.aspectj</groupId> <artifactId>aspectjweaver</artifactId> <version>1.8.4</version> </dependency> </dependencies> <build> <finalName>mavenSpringMybatisDemo</finalName> </build></project>
6.增加关于mybatis的配置文件
在src/main/resources下新建mybatis包
下在新建spring-mybatis.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:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.1.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.1.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.1.xsd "> <!-- 配置数据源 使用的是Druid数据源 --> <bean name="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close"> <property name="url" value="${jdbc.url}" /> <property name="username" value="${jdbc.username}" /> <property name="password" value="${jdbc.password}" /> <!-- 初始化连接大小 --> <property name="initialSize" value="0" /> <!-- 连接池最大使用连接数量 --> <property name="maxActive" value="20" /> <!-- 连接池最小空闲 --> <property name="minIdle" value="0" /> <!-- 获取连接最大等待时间 --> <property name="maxWait" value="60000" /> <property name="poolPreparedStatements" value="true" /> <property name="maxPoolPreparedStatementPerConnectionSize" value="33" /> <!-- 用来检测有效sql --> <property name="validationQuery" value="${validationQuery}" /> <property name="testOnBorrow" value="false" /> <property name="testOnReturn" value="false" /> <property name="testWhileIdle" value="true" /> <!-- 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 --> <property name="timeBetweenEvictionRunsMillis" value="60000" /> <!-- 配置一个连接在池中最小生存的时间,单位是毫秒 --> <property name="minEvictableIdleTimeMillis" value="25200000" /> <!-- 打开removeAbandoned功能 --> <property name="removeAbandoned" value="true" /> <!-- 1800秒,也就是30分钟 --> <property name="removeAbandonedTimeout" value="1800" /> <!-- 关闭abanded连接时输出错误日志 --> <property name="logAbandoned" value="true" /> <!-- 监控数据库 --> <property name="filters" value="mergeStat" /> </bean> <!-- myBatis文件 --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> <!-- 自动扫描entity目录, 省掉Configuration.xml里的手工配置 --> <property name="mapperLocations" value="classpath:com/my1/sqlmap/*.xml" /> </bean> <!-- mybatise通过接口来加载配置文件 --> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="com.my1.dao" /> <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" /> </bean> <!-- 配置事务管理器 --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource" /> </bean> <!-- 注解方式配置事物 --> <tx:annotation-driven transaction-manager="transactionManager" /> <!-- 拦截器方式配置事物 --><!-- <tx:advice id="transactionAdvice" transaction-manager="transactionManager"> --><!-- <tx:attributes> --><!-- <tx:method name="insert*" propagation="REQUIRED" /> --><!-- <tx:method name="update*" propagation="REQUIRED" /> --><!-- <tx:method name="delete*" propagation="REQUIRED" /> --><!-- <tx:method name="get*" propagation="SUPPORTS" read-only="true" /> --><!-- <tx:method name="find*" propagation="SUPPORTS" read-only="true" /> --><!-- <tx:method name="select*" propagation="SUPPORTS" read-only="true" /> --><!-- </tx:attributes> --><!-- </tx:advice> --> <!-- Spring aop事务管理 --><!-- <aop:config> --><!-- <aop:pointcut id="transactionPointcut" --><!-- expression="execution(* org.andy.shop.service..*Impl.*(..))" /> --><!-- <aop:advisor pointcut-ref="transactionPointcut" --><!-- advice-ref="transactionAdvice" /> --><!-- </aop:config> --></beans>
7.增加项目配置文件
在src/main/resources下新建config.properties
内容:
validationQuery=SELECT 1jdbc.url=jdbc:mysql://localhost:3306/school?useUnicode=true&characterEncoding=utf-8jdbc.username=rootjdbc.password=root
8修改web.xml引入mybatis配置文件
修改web.xml 至如下
<?xml version="1.0" encoding="utf-8"?><!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd"><web-app xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="2.5" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"> <description>最简单的SpringMVC环境抢建</description> <!-- 加载Srping配置文件 --> <context-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:/spring/applicationContext.xml,classpath:/mybatis/spring-mybatis.xml</param-value> </context-param> <!-- Spring 监听 --> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <!-- SpringMVC配置 --> <servlet> <servlet-name>myspringmvc</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <!-- 自定义springmvc的配置文件名称和路径 --> <init-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:/springmvc/springmvc-servlet.xml</param-value> </init-param> </servlet> <!-- springmvc 请求后缀 --> <servlet-mapping> <servlet-name>myspringmvc</servlet-name> <url-pattern>*.htmls</url-pattern> </servlet-mapping> <welcome-file-list> <welcome-file>index.jsp</welcome-file> </welcome-file-list> </web-app>
9.修改spring配置文件 引入config.properties
修改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.my1"></context:component-scan> <!--引入配置属性文件 --> <context:property-placeholder location="classpath:config.properties" /></beans>
10.业务层加入相关业务类
service包下新建UserServiceImpl.java
内容如下:
package com.my1.service;import java.util.List;import javax.annotation.Resource;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import com.my1.dao.UserInfoMapper;import com.my1.entity.UserInfo;/** * 创建时间�?016-1-27 下午5:22:59 * * @author andy * @version 2.2 */@Service("userService")public class UserServiceImpl { @Resource private UserInfoMapper userInfoMapper; public UserInfo getUsers(Integer id) { return userInfoMapper.selectByPrimaryKey(id); }}
11.控制层加入控制类
controller包下增加UserController.java
package com.my1.controller;import java.util.List;import javax.annotation.Resource;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.ui.ModelMap;import org.springframework.web.bind.annotation.PathVariable;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.ResponseBody;import com.my1.entity.UserInfo;import com.my1.service.UserServiceImpl;/** * 创建时间�?016-1-28 下午1:17:27 * @author andy * @version 2.2 */@Controller@RequestMapping("/user")public class UserController { @Resource private UserServiceImpl userService; @RequestMapping("/showInfo/{userId}") public String showUserInfo(ModelMap modelMap, @PathVariable int userId){ UserInfo userInfo = userService.getUsers(userId); modelMap.addAttribute("userInfo", userInfo); return "/user/showInfo"; }}
12.增加显示页面
webapp下WEB-INF下jsp包下增加user包下增加showInfo.jsp
内容:
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>userInfo</title></head><body> 姓名: ${userInfo.uname}</body></html>
13.访问
这样访问http://localhost:8080/mavenSpringMybatisDemo/user/showInfo/1.htmls
就能看到效果了
整体项目结构如下:
14demo下载
http://download.csdn.net/detail/zcjfzcjf/9507838
ps
搭建这个也是需要对于spring框架有一些理解的,所以说各位能不能搭建出来还是看缘分了,如果搭建不出来也不要着急,技术是只有交流才能共同进步的。
- 2.5 maven+spring4.X基础上搭建mybatis
- spring4+springmvc+mybatis+maven框架搭建
- 基于Spring4.x 搭建 Spring MVC + MyBatis
- 搭建SpringMVC4.x+Spring4.x+Hibernate4.x(非Maven版)
- 在maven项目基础上搭建springmvc+mybatis项目
- 2.2 maven基础上搭建springmvc4.X,一步一步超简单。
- Spring4+SpringMVC+Mybatis+Maven
- MyBatis学习总结(八)——Mybatis3.x与Spring4.x整合 一、搭建开发环境 1.1、使用Maven创建Web项目 执行如下命令: mvn archetype:create
- (SSM框架)SpringMVC+Spring4+Mybatis+Maven环境快速搭建开发案例
- 搭建Spring4.x.x开发环境
- Spring4+Hibernate4+Mybatis Maven的pom配置
- Spring4.x MVC 整合笔记,使用maven
- maven引入spring4.x所有依赖
- maven搭建jersey+Spring4+JPA+Druid+quartz
- Eclipse搭建Maven工程集成Spring4+Hibernate5
- ssm(spring4+springmvc4+mybatis3)maven环境搭建
- 第三章 快速搭建Spring4.x项目
- 个人学习笔记----基于Spring4.3.1+mybatis+postgresql+maven搭建的个人用调度平台(一)
- POJ-2594-Treasure Exploration(可重点最小路径覆盖)
- C++ new内存分配
- "三步反转"处理字符串
- OS X El Capitan U盘安装
- uva 11419 最大匹配
- 2.5 maven+spring4.X基础上搭建mybatis
- hdoj 1074 Doing Homework 【状压dp】
- Android studio学习笔记
- 弱鸡的笔记整理
- 安装svn插件的多种方式
- 对linux内核学习的一点感受
- editplus注册码生成
- App Extensions
- iOS开发之蓝牙4.0技术完美实现