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

我不是女神ヾ 2022-08-09 00:40 82阅读 0赞

1.新建web工程

![Center][]

2.添加spring支持

![Center 1][]

![Center 2][]

![Center 3][]

勾上spring persistence

![Center 4][]

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

![Center 5][]

![Center 6][]

applicationContext.xml移动到config下

添加依赖的mybaits和oracle数据包

![Center 7][]

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.新建包结构

![Center 8][]

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\}" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;   
</c:forEach>  
</div>  
</c:forEach>  
</body>  
</html>

15.启动服务

访问http://localhost:8080/frank/findDataExample.action

![Center 9][]

访问http://localhost:8080/frank/findGisExample.action

![Center 10][]

[Center]: /images/20220731/e1f8de546f274fc4a66b414a9eb15554.png
[Center 1]: /images/20220731/4398cb0cc2534ff4bbca41f9650955ea.png
[Center 2]: /images/20220731/2fcbecf3d9ca4672ae96b1aebf8ee02a.png
[Center 3]: /images/20220731/0c55dcadd2494bc7b4450ba2c43c4e3e.png
[Center 4]: /images/20220731/0089a6425f9940b692a13dd898f640d6.png
[Center 5]: /images/20220731/2a743357aa3a46619744b26a8d4896de.png
[Center 6]: /images/20220731/dbde346f22ee4eac89a7d2913a561492.png
[Center 7]: /images/20220731/55981faf3d6349eeac901ad0d45f866d.png
[Center 8]: /images/20220731/6e9d6dfc9b1c4e03a182821aeae5f375.png
[Center 9]: /images/20220731/fa1a81b0a9d44be89b902ab70cd266aa.png
[Center 10]: /images/20220731/35320355cb934fec86ed3c779833abd2.png