SpringMVC ibatis 搭建web应用

最新推荐文章于 2019-03-28 08:56:02 发布

coppher

最新推荐文章于 2019-03-28 08:56:02 发布

阅读量1.2k

点赞数

分类专栏： java 文章标签： java SpringMVC MySQL ibatis spring

本文链接：https://blog.csdn.net/huanyingfengxing/article/details/20140953

版权

java 专栏收录该内容

24 篇文章 0 订阅

订阅专栏

代码及配置的结构：

1、添加Maven project 【uitss】

添加依赖【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/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<groupId>org.cetc.woker</groupId>
	<artifactId>stuibs</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>war</packaging>
	<name>stuibs</name>
	<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
		<eclipsePluginVersion>2.8</eclipsePluginVersion>
		<jdkName>JavaSE-1.6</jdkName>
		<jdk.version>1.6</jdk.version>
		<spring.version>3.2.1.RELEASE</spring.version>
	</properties>
	<build>
		<plugins>
			<plugin>
				<groupId>org.apache.maven.plugins</groupId>
				<artifactId>maven-compiler-plugin</artifactId>
				<configuration>
					<source>1.6</source>
					<target>1.6</target>
				</configuration>
			</plugin>
			<plugin>
				<groupId>org.mortbay.jetty</groupId>
				<artifactId>maven-jetty-plugin</artifactId>
				<version>6.1.26</version>
				<configuration>
					<!-- <scanIntervalSeconds>10</scanIntervalSeconds> -->
					<webAppConfig>
						<contextPath>/</contextPath>  <!-- http://host:port/test/ -->
					</webAppConfig>
				</configuration>
			</plugin>
		</plugins>
	</build>
	<dependencies>
		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<version>3.8.1</version>
			<scope>test</scope>
		</dependency>

		<!--velocity配置 -->

		<dependency>
			<groupId>org.apache.velocity</groupId>
			<artifactId>velocity</artifactId>
			<version>1.6.2</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-aop</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-orm</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.apache.ibatis</groupId>
			<artifactId>ibatis-sqlmap</artifactId>
			<version>2.3.4.726</version>
		</dependency>

		<dependency>
			<groupId>org.apache.ibatis</groupId>
			<artifactId>ibatis-core</artifactId>
			<version>3.0</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context</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-webmvc</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-expression</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.codehaus.jackson</groupId>
			<artifactId>jackson-core-asl</artifactId>
			<version>1.9.5</version>
		</dependency>
		<dependency>
			<groupId>org.codehaus.jackson</groupId>
			<artifactId>jackson-mapper-asl</artifactId>
			<version>1.9.5</version>
		</dependency>
		
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-oxm</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.6</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-jdbc</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>commons-dbcp</groupId>
			<artifactId>commons-dbcp</artifactId>
			<version>1.2.2</version>
		</dependency>
		<dependency>
			<groupId>commons-lang</groupId>
			<artifactId>commons-lang</artifactId>
			<version>2.4</version>
		</dependency>
		<!-- servlet -->
		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>servlet-api</artifactId>
			<version>2.5</version>
		</dependency>
		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>jsp-api </artifactId>
			<version>2.0</version>
		</dependency>
		
		<!-- ibatis sources  -->
		
		<dependency>
			<groupId>org.apache.ibatis</groupId>
			<artifactId>ibatis-sqlmap</artifactId>
			<version>2.3.4.726</version>
			<classifier>sources</classifier>
		</dependency>

		<dependency>
			<groupId>org.apache.ibatis</groupId>
			<artifactId>ibatis-core</artifactId>
			<version>3.0</version>
			<classifier>sources</classifier>
		</dependency>
</dependencies>
</project>

2、web.xml配置

<web-app xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee/web-app_2_5.xsd"
	version="2.5">
	
	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>
	
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>
		classpath:applicationContext.xml
		</param-value>
	</context-param>

	<context-param>
		<param-name>log4jConfigLoaction</param-name>
		<param-value>classpath:log4j.properties</param-value>
	</context-param>

	<context-param>
		<param-name>webAppRootKey</param-name>
		<param-value>webName.root</param-value>
	</context-param>

	<!-- spring mvc 配置  -->
	 
	<servlet>
		<servlet-name>DispatcherServlet</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet
		</servlet-class>
		<init-param>
			<param-name>contextConfigLocation</param-name>
			<param-value>classpath:applicationContext.xml</param-value>
		</init-param>
		<load-on-startup>1</load-on-startup>
	</servlet>

	<servlet-mapping>
		<servlet-name>DispatcherServlet</servlet-name>
		<url-pattern>/</url-pattern>
	</servlet-mapping>

	<!-- Spring 加载 Log4j 的监听器 -->
	<listener>
		<listener-class>org.springframework.web.util.Log4jConfigListener
		</listener-class>
	</listener>
	
	<listener>
		<listener-class>org.springframework.web.util.IntrospectorCleanupListener
		</listener-class>
	</listener>
	
	<!-- 由于使用了spring mvc脱离了HttpServletRequest参数 不能直接使用request对象 -->
	<listener>
		<listener-class>org.springframework.web.context.request.RequestContextListener</listener-class>
	</listener>
	 
	<welcome-file-list>
		<welcome-file>index.jsp</welcome-file>
	</welcome-file-list>
</web-app>

3、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:aop="http://www.springframework.org/schema/aop"
	xmlns:tx="http://www.springframework.org/schema/tx" xmlns:context="http://www.springframework.org/schema/context"
	xmlns:util="http://www.springframework.org/schema/util"
	xmlns:mvc="http://www.springframework.org/schema/mvc"
	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.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
	http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-3.0.xsd
	http://www.springframework.org/schema/mvc  
    http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">
	 
	<mvc:annotation-driven /> 
	<context:annotation-config />
	<context:component-scan base-package="org.cetc.worker.stuibs" />
	<aop:config proxy-target-class="true" />
	<!-- config file -->
	<util:properties id="config" location="classpath:config.properties" />
	<bean id="propertyConfigurer"
		class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name="locations">
			<list>
				<value>classpath:config.properties</value>
			</list>
		</property>
	</bean>
	
	<!-- 转换器配置:只有配置好了转换器才能进行类与JSON和XML的转换 -->
    <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">
        <property name="messageConverters">
            <list>
                <!-- String 转换器 -->
                <ref bean="stringHttpMessageConverter"/>
                <!-- JSON 转换器 -->
                <ref bean="jsonHttpMessageConverter"/>
                <!-- XML 转换器 -->
                <ref bean="marshallingHttpMessageConverter"/>
            </list>
        </property>
    </bean>
    
    <bean id="stringHttpMessageConverter" class="org.springframework.http.converter.StringHttpMessageConverter"/>

    <bean id="jsonHttpMessageConverter"
          class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter"/>

    <bean id="marshallingHttpMessageConverter"
          class="org.springframework.http.converter.xml.MarshallingHttpMessageConverter">
        <constructor-arg ref="jaxbMarshaller"/>
        <property name="supportedMediaTypes" value="application/xml" />
    </bean>


    <bean id="jaxbMarshaller" class="org.springframework.oxm.jaxb.Jaxb2Marshaller">
        <!-- XML转换器需要绑定需要转换的类 -->
        <property name="classesToBeBound">
            <list>
                <value>org.cetc.worker.stuibs.bean.User</value>
            </list>
        </property>
    </bean>
	

	<!--Default ViewResolver -->
	<bean id="viewResolver"
		class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="viewClass"
			value="org.springframework.web.servlet.view.JstlView"></property>
		<property name="prefix" value="/WEB-INF/view/"></property>
		<property name="suffix" value=".jsp"></property>

	</bean>
	

	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
		destroy-method="close">
		<property name="driverClassName" value="${jdbc.driver}"></property>
		<property name="url" value="${jdbc.url}"></property>
		<property name="username" value="${jdbc.username}"></property>
		<property name="password" value="${jdbc.password}"></property>
		<property name="initialSize" value="${jdbc.initialSize}"></property>
		<property name="maxActive" value="${jdbc.maxActive}"></property>
		<property name="maxIdle" value="${jdbc.maxIdle}"></property>
	</bean>

	<!--configuration sqlMapClient of Ibatis? -->
	<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
		<property name="configLocation">
			<value>classpath:sqlMapConfig.xml</value>
		</property>
		<property name="dataSource">
			<ref local="dataSource" />
		</property>

	</bean>
	<!-- Define the transaction manager -->
	<bean id="transactionManager"
		class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource" />
	</bean>
	<!-- Use the tx tag configured interceptor, (if not configured interceptor, 
		using annotations is also a good way) -->
	<tx:advice id="txAdvice" transaction-manager="transactionManager">
		<tx:attributes>
			<tx:method name="trans*" propagation="REQUIRED" />
		</tx:attributes>
	</tx:advice>

	<!-- Tangent point - defined transaction management -->
	<!-- <aop:config> <aop:pointcut id="servicesPointcut" expression="(execution(*?org.cetc.worker.stuibs.*.service.impl.*.*(..)))" 
		/> <aop:advisor advice-ref="txAdvice" pointcut-ref="servicesPointcut" /> 
		</aop:config> -->

</beans>

4、 config.properties

jdbc.driver=com.mysql.jdbc.ReplicationDriver
jdbc.url=jdbc:mysql:replication://127.0.0.1:3306,127.0.0.1:3306/ibs_test?characterEncoding=UTF-8
jdbc.username=root
jdbc.password=mysql
jdbc.initialSize=5 
jdbc.maxActive=100 
jdbc.maxIdle=10

5、 sqlMapConfig.xml

<?xml version="1.0" encoding="UTF-8" ?>  
<!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
	<sqlMap resource="user.xml" />
</sqlMapConfig>

6、user.xml

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE sqlMap            PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"           "http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap>
	<typeAlias alias="user" type="org.cetc.worker.stuibs.bean.User" />
	<resultMap id="userMap" class="org.cetc.worker.stuibs.bean.User">
		<result property="id" column="id" columnIndex="1" />
		<result property="name" column="name" columnIndex="2" />
	</resultMap>
	<select id="getUserById" resultClass="user" parameterClass="java.lang.Integer">
		select * from t_user where id=#id#
	</select>
	
	<select id="getAll" resultClass="user">
		select * from t_user
	</select>

	<select id="selectUsertByName" parameterClass="String"
		resultClass="user">
		select * from t_user where name like
		'%$name$%'
	</select>

	<insert id="createUser" parameterClass="user">
		insert into
		t_user(id,name) values
		(#id#,#name#);
		<selectKey resultClass="int" keyProperty="id">
			select @@identity as inserted
		</selectKey>
	</insert>

	<delete id="deleteUserById" parameterClass="int">
		delete from t_user where id=#id#
	</delete>

	<update id="updateUser" parameterClass="user">
		update t_user set
		id=#id#,name=#name#
	</update>
	
</sqlMap>

7、Java代码：

User

package org.cetc.worker.stuibs.bean;

public class User {
	
	private int id;
	
	private String name;

	@Override
	public String toString() {
		return "User [id=" + id + ", name=" + name + "]";
	}

	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;
	}

}

UserDao

package org.cetc.worker.stuibs.dao;

import java.util.List;

import org.cetc.worker.stuibs.bean.User;
public interface UserDao {
	public User getUserById(int id);
	
	public List<User> getAll();
	
	public boolean creatUser(User user);
}

UserDaoImpl

package org.cetc.worker.stuibs.dao.impl;

import java.sql.SQLException;
import java.util.Collections;
import java.util.List;

import javax.annotation.Resource;

import org.cetc.worker.stuibs.bean.User;
import org.cetc.worker.stuibs.dao.UserDao;
import org.springframework.stereotype.Repository;

import com.ibatis.sqlmap.client.SqlMapClient;
@Repository
public class UserDaoImpl implements UserDao {
	
	private SqlMapClient sqlMapClient;
	
	@Resource
	public void setMSqlMapClient(SqlMapClient sqlMapClient){
		this.sqlMapClient=sqlMapClient;
	}
	
	public User getUserById(int id) {
		try {
			return (User) sqlMapClient.queryForObject("getUserById", id);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
	}

	@SuppressWarnings("unchecked")
	@Override
	public List<User> getAll() {
		try {
			return sqlMapClient.queryForList("getAll");
		} catch (Exception e) {
			e.printStackTrace();
			return Collections.emptyList();
		}
	}

	@Override
	public boolean creatUser(User user) {
		boolean isSueccess = false;
		try {
			sqlMapClient.insert("createUser", user);
			isSueccess = true;
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return isSueccess;
	}
}

UserService

package org.cetc.worker.stuibs.service;

import java.util.List;

import org.cetc.worker.stuibs.bean.User;

public interface UserService {
	
	public User getById(int id);
	
	public List<User> getAll();
	
	public boolean createUser(User user);

}

UserServiceImpl

package org.cetc.worker.stuibs.service.impl;

import java.util.List;

import org.cetc.worker.stuibs.bean.User;
import org.cetc.worker.stuibs.dao.UserDao;
import org.cetc.worker.stuibs.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@Service
public class UserServiceImpl implements UserService{
	
	@Autowired
	private UserDao userDao;

	@Override
	public User getById(int id) {
		return userDao.getUserById(id);
	}

	@Override
	public List<User> getAll() {
		return userDao.getAll();
	}

	@Override
	public boolean createUser(User user) {
		return userDao.creatUser(user);
	}

}

UserController（提供Rest接口）

package org.cetc.worker.stuibs.controller;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.cetc.worker.stuibs.bean.User;
import org.cetc.worker.stuibs.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;

@Controller
@RequestMapping("/user")
public class UserController {
	
	@Autowired
	private UserService userService;
	
	
	@RequestMapping(value ="/get/{id}",method = RequestMethod.GET,produces="application/json")
	@ResponseBody
	public User  getById(@PathVariable int id){
		User user = userService.getById(id);
		return user;
	}
	
	@RequestMapping(value ="/list",method = RequestMethod.GET,produces="application/json")
	@ResponseBody
	public List<User>  getList(){
		List<User> users = userService.getAll();
		return users;
	}
	
	@RequestMapping(value ="/create",method = RequestMethod.POST,produces="application/json")
	@ResponseBody
	public Map<String, Object>  createUser(@RequestBody User user){
		boolean isCreateSuccess = userService.createUser(user);
		Map<String, Object> rspMap = new HashMap<String, Object>();
		rspMap.put("isSuccess", isCreateSuccess);
		return rspMap;
	}
	
}

ibatis使用参考文章：http://www.cnblogs.com/ycxyyzw/archive/2012/10/13/2722567.html

coppher

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
SpringMVC ibatis 搭建web应用

1、添加Maven project 【uitss】添加依赖【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.
复制链接

扫一扫