myeclipse2014搭建springMVC+Mybatis+多数据源环境

最新推荐文章于 2020-09-01 00:14:20 发布

꧁༺摩༒西༻꧂

最新推荐文章于 2020-09-01 00:14:20 发布

阅读量3.6k

点赞数

分类专栏：框架

博主原创，微信号：steve_frank。

本文链接：https://blog.csdn.net/steve_frank/article/details/48785537

版权

框架专栏收录该内容

27 篇文章 1 订阅

订阅专栏

1.新建web工程

2.添加spring支持

勾上spring persistence

3.配置文件新建源文件夹

applicationContext.xml移动到config下

添加依赖的mybaits和oracle数据包

4.新建jdbc.properties

rkdata.driverClassName=oracle.jdbc.driver.OracleDriver
rkdata.url=jdbc\:oracle\:thin\:@192.168.118.52\:1521\:orcl
rkdata.username=yhrkdata
rkdata.password=rkdata2015
rkgis.driverClassName=oracle.jdbc.driver.OracleDriver
rkgis.url=jdbc\:oracle\:thin\:@192.168.118.52\:1521\:orcl
rkgis.username=yhrkgis
rkgis.password=rkgis2015

jdbc.maxActive=255
jdbc.maxIdle=20
jdbc.maxWait=100

5.新建log4j.properties

log4j.rootLogger=INFO, stdout
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%p %c{1} - %m%n
log4j.logger.org.springframework.security=ERROR

6.新建包结构

7.新建dispatcher-servlet.xml

8.WEB-INF下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"
version="3.0">
<display-name>frank</display-name>
<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>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>

<servlet>
<servlet-name>dispatcher</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>
classpath:dispatcher-servlet.xml
</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>

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

<filter>
<filter-name>characterEncodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
<init-param>
<param-name>forceEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>characterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
</web-app>

9.配置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:p="http://www.springframework.org/schema/p"
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">


<bean id="propertiesConfig"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="locations">
<list>
<value>classpath:jdbc.properties</value>
</list>
</property>
</bean>


<bean id="rkdataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="${rkdata.driverClassName}" />
<property name="url" value="${rkdata.url}" />
<property name="username" value="${rkdata.username}" />
<property name="password" value="${rkdata.password}" />
<property name="maxActive" value="${jdbc.maxActive}" />
<property name="maxIdle" value="${jdbc.maxIdle}" />
<property name="maxWait" value="${jdbc.maxWait}" />
</bean>

<bean id="rkgisSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="${rkgis.driverClassName}" />
<property name="url" value="${rkgis.url}" />
<property name="username" value="${rkgis.username}" />
<property name="password" value="${rkgis.password}" />
<property name="maxActive" value="${jdbc.maxActive}" />
<property name="maxIdle" value="${jdbc.maxIdle}" />
<property name="maxWait" value="${jdbc.maxWait}" />
</bean>

<bean id="rkdataSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="rkdataSource" />
<property name="configLocation" value="classpath:mybatis-config.xml" />
</bean>

<bean id="rkgisSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="rkgisSource" />
<property name="configLocation" value="classpath:mybatis-config.xml" />
</bean>


<bean id="rkdataSession" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg index="0" ref="rkdataSessionFactory" />
</bean>

<bean id="rkgisSession" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg index="0" ref="rkgisSessionFactory" />
</bean>
</beans>

10.编辑文件内容

Example_Mapper.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.founder.example.model.Example_Mapper">


<select id="findDataExample" resultType="map">
select * from D_JLX t
</select>
<select id="findGisExample" resultType="map">
select * from BL_SQGL_PT
t
</select>
</mapper>

Example.java

package com.founder.example.model;

/**
*
*
* @author steve
*
*/
public class Example {
}

11.IExampleDao.java

package com.founder.example.dao;
import java.util.List;
import java.util.Map;

/**
*
*
* @author steve
*
*/
public interface IExampleDao {

List<Map> findDataExample();

List<Map> findGisExample();
}

ExampleDaoImpl.java

package com.founder.example.dao.impl;

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

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

import com.founder.example.dao.IExampleDao;
import com.founder.example.model.Example;

@Transactional
@Repository
public class ExampleDaoImpl implements IExampleDao {
private SqlSessionTemplate rkdataSession;
private SqlSessionTemplate rkgisSession;

public SqlSessionTemplate getRkdataSession() {
return rkdataSession;
}

@Autowired
public void setRkdataSession(SqlSessionTemplate rkdataSession) {
this.rkdataSession = rkdataSession;
}

public SqlSessionTemplate getRkgisSession() {
return rkgisSession;
}

@Autowired
public void setRkgisSession(SqlSessionTemplate rkgisSession) {
this.rkgisSession = rkgisSession;
}

@Override
public List<Map> findDataExample() {
List list = rkdataSession.selectList(Example.class.getName()
+ "_Mapper.findDataExample");
return list;
}

@Override
public List<Map> findGisExample() {
List list = rkgisSession.selectList(Example.class.getName()
+ "_Mapper.findGisExample");
return list;
}
}

12.IExampleService.java

package com.founder.example.service;

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

public interface IExampleService {

List<Map> findDataExample();

List<Map> findGisExample();
}

ExampleServiceImpl.java

package com.founder.example.service.impl;

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

import javax.annotation.Resource;

import org.springframework.stereotype.Service;

import com.founder.example.dao.IExampleDao;
import com.founder.example.service.IExampleService;

/**
* @author steve
*
*/
@Service
public class ExampleServiceImpl implements IExampleService {
@Resource
private IExampleDao exampleDao;

@Override
public List<Map> findDataExample() {
return exampleDao.findDataExample();
}

@Override
public List<Map> findGisExample() {
return exampleDao.findGisExample();
}

}

13.ExampleController.java

package com.founder.example.controller;

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

import javax.annotation.Resource;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;

import com.founder.example.service.IExampleService;

@Controller
public class ExampleController {
@Resource
private IExampleService exampleService;

@RequestMapping("/findDataExample")
public ModelAndView findDataExample() {
List<Map> list = exampleService.findDataExample();// 传单独的值调用service方法
return new ModelAndView("dataExample", "list", list);
}

@RequestMapping("/findGisExample")
public ModelAndView findGisExample() {
List<Map> list = exampleService.findGisExample();// 传单独的值调用service方法
System.out.println(list.size());
return new ModelAndView("gisExample", "list", list);
}
}

14.新建jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><%@ taglib
prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'dataExample.jsp' starting page</title>
</head>
<body>
<c:forEach var="item" items="${list}">
<div>
<c:forEach var="entry" items="${item}">
<c:out value="${entry.key}" />
:
<c:out value="${entry.value}" />      
</c:forEach>
</div>
</c:forEach>
</body>
</html>