配置web.xml

<?xml version="1.0" encoding="UTF-8"?> <web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"><!-- <display-name></display-name> <welcome-file-list><welcome-file>index.jsp</welcome-file></welcome-file-list>--><!-- spring配置 --><context-param><param-name>contextConfigLocation</param-name><param-value>classpath:applicationContext.xml</param-value></context-param><listener><listener-class>org.springframework.web.context.ContextLoaderListener</listener-class></listener><!-- spring mvc配置 --><servlet><servlet-name>spring</servlet-name><servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class><load-on-startup>1</load-on-startup></servlet><servlet-mapping><servlet-name>spring</servlet-name><url-pattern>/</url-pattern></servlet-mapping> </web-app>

配置spring-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:mvc="http://www.springframework.org/schema/mvc"xmlns:p="http://www.springframework.org/schema/p"xmlns:context="http://www.springframework.org/schema/context"xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans.xsdhttp://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context.xsdhttp://www.springframework.org/schema/mvchttp://www.springframework.org/schema/mvc/spring-mvc.xsd"><!-- springmvc只是控制網(wǎng)站跳轉邏輯 --><!-- 只掃描控制器 --><context:component-scan base-package="com.atChina" use-default-filters="false"><context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/></context:component-scan><!-- 視圖解析器 --><bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"><property name="prefix" value="/WEB-INF/pages/"/><property name="suffix" value=".jsp"/></bean><mvc:annotation-driven></mvc:annotation-driven><mvc:default-servlet-handler/> </beans>

?配置applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?> <!-- 引用Spring的多個Schema空間的格式定義文件 --> <beans xmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"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.xsdhttp://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context.xsdhttp://www.springframework.org/schema/aophttp://www.springframework.org/schema/aop/spring-aop.xsdhttp://www.springframework.org/schema/txhttp://www.springframework.org/schema/tx/spring-tx.xsd "><!-- xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsd --><context:component-scan base-package="com.atChina"><context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/></context:component-scan><!-- spring用來控制業(yè)務邏輯,數(shù)據(jù)源,事物控制,aop --><bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"><property name="jdbcUrl" value="jdbc:oracle:thin:@localhost:1521:orcl"></property><property name="driverClass" value="oracle.jdbc.OracleDriver"></property><property name="user" value="scott"></property><property name="password" value="123456"></property></bean><!-- spring事務管理 --><bean id="dataSourceTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource"></property></bean><!-- 開啟基于注解的事務 --><tx:annotation-driven transaction-manager="dataSourceTransactionManager"/><!-- 整合mybatis目的: 1. spring管理所有組件,包括mapper的實現(xiàn)類.2. spring用來管理事務--><!-- 創(chuàng)建sqlSessionFactory對象 --><bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource"></property><!-- configLocation指定全局配置文件的位置 --><property name="configLocation" value="classpath:mybatis-config.xml"></property><!-- 指定mapper文件的位置 --><property name="mapperLocations" value="classpath:mybatis/mapper/*.xml"></property></bean><!-- 配置mapper掃描器 --><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><!-- 掃描包路徑，如果需要掃描多個包中間用半角逗號隔開 --><property name="basePackage" value="com.atChina.dao"></property><property name="sqlSessionFactoryBeanName" value="sqlSessionFactoryBean"/></bean><!-- 掃描所有的mapper接口實現(xiàn),讓這些mapper能夠自動注入 <mybatis-spring:scan base-package="com.atChina.dao"/>--> </beans>

配置mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration><settings><setting name="cacheEnabled" value="true"/><setting name="jdbcTypeForNull" value="NULL"/><!--開啟延遲加載--><setting name="lazyLoadingEnabled" value="true"/><!--關閉積極加載--><setting name="aggressiveLazyLoading" value="false"/></settings></configuration>

配置文件結構如下?

?

EmployeeService類?

package com.atChina.service;import java.util.List;import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service;import com.atChina.bean.Employee; import com.atChina.dao.EmployeePlusMapper;@Service public class EmployeeService {@Autowiredprivate EmployeePlusMapper employeePlusMapper;public List<Employee> getEmps(){return employeePlusMapper.getEmps();} }

EmployeeController類?

package com.atChina.controller;import java.util.List; import java.util.Map;import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping;import com.atChina.bean.Employee; import com.atChina.service.EmployeeService;@Controller public class EmployeeController {@AutowiredEmployeeService employeeService;@RequestMapping("/getemps")public String emps(Map<String, Object> map){List<Employee> emps = employeeService.getEmps();map.put("allEmps", emps);return "list";} }

?bean類

package com.atChina.bean;import java.io.Serializable; import java.util.Date;public class Employee implements Serializable{/*** */private static final long serialVersionUID = 1L;public Employee(String empno, String ename, String job, Integer mgr,Date hiredate, Double sal) {super();this.empno = empno;this.ename = ename;this.job = job;this.mgr = mgr;this.hiredate = hiredate;this.sal = sal;}public Employee() {super();}private String empno;private String ename;private String job;private Integer mgr;private Date hiredate;private Double sal;private Department dt;public String getEmpno() {System.out.println("...getEmpno()....");return empno;}public void setEmpno(String empno) {this.empno = empno;}public String getEname() {return ename;}public void setEname(String ename) {this.ename = ename;}public String getJob() {return job;}public void setJob(String job) {this.job = job;}public Integer getMgr() {return mgr;}public void setMgr(Integer mgr) {this.mgr = mgr;}public Date getHiredate() {return hiredate;}public void setHiredate(Date hiredate) {this.hiredate = hiredate;}public Double getSal() {return sal;}public void setSal(Double sal) {this.sal = sal;}public Department getDt() {return dt;}public void setDt(Department dt) {this.dt = dt;}@Overridepublic String toString() {return "Employee [empno=" + empno + ", ename=" + ename + ", job=" + job+ ", mgr=" + mgr + ", hiredate=" + hiredate + ", sal=" + sal+ ", dt=" + dt + "]";}}package com.atChina.bean;import java.io.Serializable; import java.util.List;public class Department implements Serializable{/*** */private static final long serialVersionUID = 1L;private Integer id;private List<Employee> emps;public List<Employee> getEmps() {return emps;}public void setEmps(List<Employee> emps) {this.emps = emps;}public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}private Integer deptno;private String dname;private String loc;public int getDeptno() {return deptno;}public void setDeptno(int deptno) {this.deptno = deptno;}public String getDname() {return dname;}public void setDname(String dname) {this.dname = dname;}public String getLoc() {return loc;}public void setLoc(String loc) {this.loc = loc;}@Overridepublic String toString() {return "Department [id=" + id + ", emps=" + emps + ", deptno=" + deptno+ ", dname=" + dname + ", loc=" + loc + "]";}}

Mapper類?

package com.atChina.dao;import java.util.List;import com.atChina.bean.Employee;public interface EmployeePlusMapper {public Employee getEmpAndDeptByEmpno(Integer empno);public List<Employee> getEmps(); }

?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"> <!-- namespace不能隨便自定義了，應該是接口類的全限定名 --> <mapper namespace="com.atChina.dao.EmployeePlusMapper"><resultMap type="com.atChina.bean.Employee" id="defineDifEmp2"><id column="empno" property="empno" /><result column="ename" property="ename" /><result column="job" property="job" /><result column="mgr" property="mgr" /><result column="hiredate" property="hiredate" /><result column="sal" property="sal" /><!-- association可以指定聯(lián)合的javaBean對象property="dt":指定哪個屬性是聯(lián)合的對象javaType:指定這個屬性對象的類型[不能省略]--><association property="dt" javaType="com.atChina.bean.Department"><result column="deptno" property="deptno" /><result column="dname" property="dname" /><result column="loc" property="loc" /></association></resultMap><select id="getEmpAndDeptByEmpno" resultMap="defineDifEmp2">select a.empno, a.ename, a.job, a.mgr, a.hiredate, a.sal,b.deptno, b.dname, b.loc from emptest a join depttest bon a.deptno = b.deptnowhere a.empno = #{empno}</select><select id="getEmps" resultType="com.atChina.bean.Employee">select a.empno, a.ename, a.job, a.mgr, a.hiredate, a.salfrom emptest a </select> </mapper>

?index.jsp

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <% 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 'index.jsp' starting page</title><meta http-equiv="pragma" content="no-cache"><meta http-equiv="cache-control" content="no-cache"><meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"><meta http-equiv="description" content="This is my page"></head><body><a href="getemps">查詢員工</a></body> </html>

?list.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%> <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <!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=ISO-8859-1"> <title>員工列表</title> </head> <body><table><tr><td>empno</td><td>ename</td><td>job</td><td>mgr</td><td>hiredate</td><td>sal</td></tr><c:forEach items="${allEmps}" var="emp"><tr><td>${emp.empno}</td><td>${emp.ename}</td><td>${emp.job}</td><td>${emp.mgr}</td><td>${emp.hiredate}</td><td>${emp.sal}</td></tr></c:forEach></table> </body> </html>

測試如下:

?

總結

以上是生活随笔為你收集整理的mybaits二十七:spring, spring mvc,mybatis(ssm) 整合的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內容還不錯，歡迎將生活随笔推薦給好友。