Spring整合mybatis 1 查询
【摘要】
框架如图：
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/X...
框架如图：
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">
-
<!-- 1.spring监听 -->
-
<context-param>
-
<param-name>contextConfigLocation</param-name>
-
<param-value>/WEB-INF/spring-mybatis.xml</param-value>
-
</context-param>
-
<!--spring-->
-
<listener>
-
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
-
</listener>
-
<!-- 2.springmvc -->
-
<servlet>
-
<servlet-name>springmvc</servlet-name>
-
<servlet-class> org.springframework.web.servlet.DispatcherServlet</servlet-class>
-
<init-param>
-
<param-name>contextConfigLocation</param-name>
-
<param-value>/WEB-INF/spring-mvc.xml</param-value>
-
</init-param>
-
</servlet>
-
<servlet-mapping>
-
<servlet-name>springmvc</servlet-name>
-
<url-pattern>/</url-pattern>
-
</servlet-mapping>
-
<!-- 3.字符编码处理 -->
-
<filter>
-
<filter-name>encodingFilter</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>
-
</filter>
-
<filter-mapping>
-
<filter-name>encodingFilter</filter-name>
-
<url-pattern>/*</url-pattern>
-
</filter-mapping>
-
</web-app>
-
<?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:p="http://www.springframework.org/schema/p"
-
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-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/mvc
-
http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd
-
">
-
<!-- 默认扫描包路径，扫描控制器 -->
-
<context:component-scan base-package="com.controller"></context:component-scan>
-
<!-- 注解驱动 -->
-
<mvc:annotation-driven/>
-
<!-- 视图解析器 -->
-
<bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
-
<property name="prefix" value="/" />
-
<property name="suffix" value=".jsp" />
-
</bean>
-
</beans>
-
<?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:p="http://www.springframework.org/schema/p"
-
xmlns:context="http://www.springframework.org/schema/context"
-
xsi:schemaLocation="http://www.springframework.org/schema/beans
-
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
-
http://www.springframework.org/schema/context
-
http://www.springframework.org/schema/context/spring-context-3.0.xsd">
-
<!-- 1.自动扫描 -->
-
<context:component-scan base-package="com"></context:component-scan>
-
<!-- 2.配置数据源，就是原来mybatis的代码,此处使用dbcp数据源连接池 -->
-
<bean id="datasource" class="org.apache.commons.dbcp.BasicDataSource">
-
<property name="driverClassName" value="oracle.jdbc.OracleDriver"/>
-
<property name="url" value="jdbc:oracle:thin:@192.168.62.250:1521:orcl"/>
-
<property name="username" value="scott"/>
-
<property name="password" value="tiger"/>
-
</bean>
-
<!-- 3.配置sqlSessionFactory -->
-
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
-
<property name="dataSource" ref="datasource"/><!-- 数据源连接池 -->
-
<property name="mapperLocations" value="classpath:com/mapper/*.xml"></property>
-
</bean>
-
<!-- 4.mapper扫描器 -->
-
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
-
<property name="basePackage" value="com.dao"/>
-
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
-
</bean>
-
</beans>
实体类，Emp类
-
package com.entity;
-
-
public class Emp {
-
-
private int empNo;
-
private String eName;
-
private String salary;
-
public int getEmpNo() {
-
return empNo;
-
}
-
public void setEmpNo(int empNo) {
-
this.empNo = empNo;
-
}
-
public String geteName() {
-
return eName;
-
}
-
public void seteName(String eName) {
-
this.eName = eName;
-
}
-
public String getSalary() {
-
return salary;
-
}
-
public void setSalary(String salary) {
-
this.salary = salary;
-
}
-
-
}
-
package com.dao;
-
-
import java.util.List;
-
import java.util.Map;
-
import com.entity.Emp;
-
-
-
public interface EmpDao {
-
public List<Emp> search();
-
}
-
<?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.dao.EmpDao">
-
<select id="search" resultType="com.entity.Emp">
-
select empno ,ename , sal from emp
-
</select>
-
</mapper>
-
package com.service;
-
-
import java.util.List;
-
-
import com.entity.Emp;
-
-
public interface IEmpService {
-
-
List<Emp> getList();
-
-
}
-
package com.service.impl;
-
-
import java.util.List;
-
-
import javax.annotation.Resource;
-
import org.springframework.stereotype.Component;
-
import com.dao.EmpDao;
-
import com.entity.Emp;
-
import com.service.IEmpService;
-
-
@Component
-
public class EmpServiceImpl implements IEmpService{
-
-
@Resource
-
private EmpDao empDao;
-
public List<Emp> getList() {
-
return empDao.search();
-
}
-
-
}
-
package com.controller;
-
-
import java.util.List;
-
import javax.annotation.Resource;
-
import org.springframework.beans.factory.annotation.Autowired;
-
import org.springframework.stereotype.Controller;
-
import org.springframework.ui.Model;
-
import org.springframework.web.bind.annotation.RequestMapping;
-
import com.entity.Emp;
-
import com.service.IEmpService;
-
@Controller
-
@RequestMapping("/emp")
-
public class EmpController {
-
-
@Resource
-
private IEmpService service;
-
-
@RequestMapping("/list")
-
public String toIndex(Model model){
-
List<Emp> emps=service.getList();
-
System.out.println(emps.size()+".......");
-
model.addAttribute("eno", emps.size());
-
model.addAttribute("empList", emps);
-
return "list";
-
}
-
-
}
-
<%@ 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 '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>ddd
-
${eno }
-
<c:forEach items="${empList}" var="emp">
-
${emp.eName} <br/>
-
</c:forEach>
-
</body>
-
</html>
文章来源: aaaedu.blog.csdn.net，作者：tea_year，版权归原作者所有，如需转载，请联系作者。
原文链接：aaaedu.blog.csdn.net/article/details/70176844
【版权声明】本文为华为云社区用户转载文章，如果您发现本社区中有涉嫌抄袭的内容，欢迎发送邮件进行举报，并提供相关证据，一经查实，本社区将立刻删除涉嫌侵权内容，举报邮箱：
cloudbbs@huaweicloud.com
- 点赞
- 收藏
- 关注作者
评论（0）