Maven +spring+springmvc+mybatis简单实例

2 篇文章 0 订阅
1 篇文章 0 订阅

spring+springmvc+mybatis简单实例

1、项目结构如下

在这里插入图片描述
2、pom.xml文件中的以来配置

<dependencies>

	<dependency>
		<groupId>commons-logging</groupId>
		<artifactId>commons-logging</artifactId>
		<version>1.2</version>
	</dependency>

	<!-- spring -->

	<dependency>
		<groupId>org.springframework</groupId>
		<artifactId>spring-aop</artifactId>
		<version>4.1.4.RELEASE</version>
	</dependency>
	<dependency>
		<groupId>org.springframework</groupId>
		<artifactId>spring-beans</artifactId>
		<version>4.1.4.RELEASE</version>
	</dependency>

	<dependency>
		<groupId>org.springframework</groupId>
		<artifactId>spring-context</artifactId>
		<version>4.1.4.RELEASE</version>
	</dependency>


	<dependency>
		<groupId>org.springframework</groupId>
		<artifactId>spring-core</artifactId>
		<version>4.1.4.RELEASE</version>
	</dependency>

	<dependency>
		<groupId>org.springframework</groupId>
		<artifactId>spring-expression</artifactId>
		<version>4.3.14.RELEASE</version>
	</dependency>


	<dependency>
		<groupId>org.springframework</groupId>
		<artifactId>spring-web</artifactId>
		<version>4.1.4.RELEASE</version>
	</dependency>

	<dependency>
		<groupId>org.springframework</groupId>
		<artifactId>spring-webmvc</artifactId>
		<version>4.1.4.RELEASE</version>
	</dependency>

	<dependency>
		<groupId>org.springframework</groupId>
		<artifactId>spring-jdbc</artifactId>
		<version>4.1.4.RELEASE</version>
	</dependency>

	<!-- mybatis -->

	<dependency>
		<groupId>org.mybatis</groupId>
		<artifactId>mybatis</artifactId>
		<version>3.4.5</version>
	</dependency>

	<dependency>
		<groupId>org.mybatis</groupId>
		<artifactId>mybatis-spring</artifactId>
		<version>1.3.2</version>
	</dependency>


	<dependency>
		<groupId>javax.servlet</groupId>
		<artifactId>servlet-api</artifactId>
		<version>2.5</version>
		<scope>provided</scope>
	</dependency>

	<dependency>
		<groupId>com.alibaba</groupId>
		<artifactId>druid</artifactId>
		<version>1.1.10</version>
	</dependency>

	<dependency>
		<groupId>mysql</groupId>
		<artifactId>mysql-connector-java</artifactId>
		<version>5.1.39</version>
	</dependency>


</dependencies>


<build>
	<sourceDirectory>src/main/java</sourceDirectory>
	<plugins>
		<!-- 指定编译jar包 -->
		<plugin>
			<groupId>org.apache.maven.plugins</groupId>
			<artifactId>maven-compiler-plugin</artifactId>
			<version>3.1</version>
			<configuration>
				<source>1.8</source>
				<target>1.8</target>
			</configuration>
		</plugin>

		<!-- Embedded Apache Tomcat required for testing war -->

		<plugin>
			<groupId>org.apache.tomcat.maven</groupId>
			<artifactId>tomcat7-maven-plugin</artifactId>
			<version>2.2</version>
			<configuration>
				<!-- path指定url中的目录 -->
				<path>/${project.artifactId}</path>
				<port>8888</port>
				<uriEncoding>UTF-8</uriEncoding> <!-- 需要和eclipse中指定的编码一致,否则会报错 -->
				<url>http://localhost:8888/</url>
				<server>tomcat7</server>
			</configuration>
		</plugin>

	</plugins>
</build>

3、mysql.properties 配置如下

mybatis.driverClassName=com.mysql.jdbc.Driver
mybatis.url=jdbc:mysql://localhost:3306/spring
mybatis.username=root
mybatis.password=Gepoint

4、UserMapper.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.iweb.dao.UserMapper">

   <insert id="insert"  parameterType="map">
        INSERT INTO user(name) VALUES(#{username})
   </insert>

</mapper>

5、web.xml配置如下

    <?xml version="1.0" encoding="UTF-8"?>
 <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"                       
    xmlns="http://java.sun.com/xml/ns/javaee"     xsi:schemaLocation="http://java.sun.com/xml/ns/javaee    
    http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">

 
         <display-name>springmvcbd003</display-name>
         <welcome-file-list>
          		<welcome-file>default.jsp</welcome-file>
         </welcome-file-list>

  		<context-param>
     		   <param-name>contextConfigLocation</param-name>
			  <param-value>/WEB-INF/applicationContext.xml,/WEB-INF/springmvc-servlet.xml</param-value>
        </context-param>
		 <listener>
     		   <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	     </listener>

	  <servlet>
   			  <servlet-name>springmvc</servlet-name>
   			 <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
	  </servlet>
		 <servlet-mapping>
     			  <servlet-name>springmvc</servlet-name>
        	     <url-pattern>/</url-pattern>
    	</servlet-mapping>
</web-app>

6、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:jdbc="http://www.springframework.org/schema/jdbc"
		    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-4.0.xsd     
           http://www.springframework.org/schema/jdbc        
           http://www.springframework.org/schema/jdbc/spring-jdbc-4.0.xsd">
           
        <context:property-placeholder location="classpath:config/mysql.properties" />  
	
		<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"  init-method="init" destroy-method="close">
		    <property name="driverClassName" value="${mybatis.driverClassName}" />
			<property name="url" value="${mybatis.url}" /><!--必须 -->
			<property name="username" value="${mybatis.username}" /><!-- 必须 -->
			<property name="password" value="${mybatis.password}" /><!-- 必须 -->
		    <property name="maxActive" value="20"></property><!-- 必须 -->
		</bean>
	
		<!-- MyBatis配置 -->
		<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
			<property name="dataSource" ref="dataSource" />
			<!-- 自动扫描entity目录, 省掉Configuration.xml里的手工配置,这边可以配置mybatis执行查询返回的自定义实体 -->
			<property name="typeAliasesPackage" value="com.iweb.entity"/>
			<!-- 显式指定Mapper文件位置 -->
			<property name="mapperLocations" value="classpath*:mapper/*Mapper.xml" />
		</bean>
	
	
		<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
			<property name="basePackage" value="com.iweb.dao" /><!-- 不需要加.* -->
			
		<!-- 	<property name="annotationClass" value="org.springframework.stereotype.Repository" /> -->
			<!-- 上面和下面这个都可以 -->
			<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
		</bean>
	
		<!-- <bean id="transactionManager"   
		class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> 
			<property name="dataSource" ref="dataSource" /> </bean> -->
	</beans>

7、springmvc-servlet.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:aop="http://www.springframework.org/schema/aop"
	    xmlns:context="http://www.springframework.org/schema/context"
	    xmlns:mvc="http://www.springframework.org/schema/mvc"
	    xsi:schemaLocation="http://www.springframework.org/schema/beans      
	    http://www.springframework.org/schema/beans/spring-beans.xsd
	    http://www.springframework.org/schema/aop   
	    http://www.springframework.org/schema/aop/spring-aop-4.0.xsd
	    http://www.springframework.org/schema/context 
	    http://www.springframework.org/schema/context/spring-context-4.0.xsd
	    http://www.springframework.org/schema/mvc 
	    http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">         

	    <context:component-scan base-package="com.iweb" />
        <mvc:annotation-driven/> 
 	    <mvc:default-servlet-handler />
  	    <mvc:resources mapping="/js/**" location="/WebCotent/resource/js/" />
  
   
     <bean id="viewResolver"  class="org.springframework.web.servlet.view.InternalResourceViewResolver"> 
        <!-- <property name="viewClass"><value>org.springframework.web.servlet.view.JstlView</value></property> -->
        <property name="prefix" value="/WEB-INF/jsp/" />
        <property name="suffix" value=".jsp" />
    </bean>
</beans>

8、src目录结构
在这里插入图片描述
9、各个类文件的代码如下

  1. UserController

     package com.iweb.controller;
     import java.util.HashMap;
     import java.util.Map;
     
     import org.mybatis.spring.SqlSessionTemplate;
     import org.springframework.beans.factory.annotation.Autowired;
     import org.springframework.stereotype.Controller;
     import org.springframework.web.bind.annotation.RequestMapping;
     import org.springframework.web.bind.annotation.RequestMethod;
     import org.springframework.web.bind.annotation.RequestParam;
     
     import com.iweb.service.UserService;
     
     @Controller
     @RequestMapping("/user")
     public class UserController {
     		@Autowired
     		UserService us;
    
     @RequestMapping(value = "/insert", method = { RequestMethod.GET,
     		RequestMethod.POST })
     public String userInsert(@RequestParam("username") String username) {
     	Map<String, Object> map = new HashMap<String, Object>();
     	map.put("username", username);
     	us.insert(map);
     	return "/usermanage/success";
     }
    
         SqlSessionTemplate sssSessionTemplate;
     }
    

2)UserMapper代码如下

package com.iweb.dao;

import java.util.Map;

import org.springframework.stereotype.Repository;

@Repository
public interface UserMapper {
	public int insert(Map<String, Object> map);
	/*
	 * public int update(Map<String, Object> map); public int delete(Map<String,
	 * Object> map); public int search();
	 */
}

3)UserService代码如下

    package com.iweb.service;
   import java.util.Map;
	public interface UserService {
		public int insert(Map<String, Object> map);	
	}

4)UserServiceImple代码如下

 package com.iweb.service.imp;

import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.iweb.dao.UserMapper;
import com.iweb.service.UserService;

@Service
public class UserServiceImp implements UserService{
	
	@Autowired
	UserMapper userMapper;
	public int insert(Map<String, Object> map){
		return userMapper.insert(map);
	}

}

10、default.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>Insert title here</title>
</head>
<body>
	<a href="user/insert?username=xiaoMing">新增</a>
</body>
</html>
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值