Springmvc+mybatis案列 1

加jar包

项目目录

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" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" version="2.5">  <display-name></display-name> <!-- spring配置文件 -->  <!-- <context-param>    <param-name>ContectConfigLocation</param-name>    <param-value>classpath:applicationContext.xml</param-value>  </context-param> -->   <listener>  <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>  </listener>  <!-- 配置字符集 -->    <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>  </filter>  <filter-mapping>  <filter-name>CharacterEncodingFilter</filter-name>  <url-pattern>/*</url-pattern>  </filter-mapping>  <listener>    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>  </listener>    <!-- 配置springmvc -->  <servlet>    <servlet-name>springmvcMybatis</servlet-name>    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>    <init-param>      <param-name>contextConfigLocation</param-name>      <param-value>classpath:mvc.xml</param-value>    </init-param>    <load-on-startup>1</load-on-startup>  </servlet>  <servlet-mapping>    <servlet-name>springmvcMybatis</servlet-name>    <url-pattern>*.do</url-pattern>  </servlet-mapping>    <welcome-file-list>    <welcome-file>index.jsp</welcome-file>  </welcome-file-list></web-app>

User.java

package cn.sxt.vo;public class User {private int id;private String name;private String pwd;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;}public String getPwd() {return pwd;}public void setPwd(String pwd) {this.pwd = pwd;}@Overridepublic String toString() {return "User [id=" + id + ", name=" + name + ", pwd=" + pwd + "]";}}

user.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="cn.sxt.vo.user.mapper"><select id="list" resultType="User" >select * from user_info</select></mapper>

UserDao.java

package cn.sxt.dao;import java.util.List;import cn.sxt.vo.User;public interface UserDao { public List<User> list();}

UserDaoImpl.java

package cn.sxt.dao.impl;import java.util.List;import org.apache.ibatis.session.SqlSessionFactory;import org.mybatis.spring.support.SqlSessionDaoSupport;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Repository;import cn.sxt.dao.UserDao;import cn.sxt.vo.User;@Repository("UserDao")public class UserDaoImpl extends SqlSessionDaoSupport implements UserDao{@Autowired@Overridepublic void setSqlSessionFactory(SqlSessionFactory sqlSessionFactory) {super.setSqlSessionFactory(sqlSessionFactory);}public List<User> list() {return getSqlSession().selectList("cn.sxt.vo.user.mapper.list");}}

UserService.java

package cn.sxt.service;import java.util.List;import cn.sxt.vo.User;public interface UserService {public List<User> list();}

UserServiceImpl.java

package cn.sxt.service.impl;import java.util.List;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import cn.sxt.dao.UserDao;import cn.sxt.service.UserService;import cn.sxt.vo.User;@Service("UserService")public class UserServiceImpl implements UserService {@Autowiredprivate UserDao userDao;public void setUserDao(UserDao userDao) {this.userDao = userDao;}public List<User> list() {return userDao.list();}}

UserController.java

package cn.sxt.Controller;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.ui.ModelMap;import org.springframework.web.bind.annotation.RequestMapping;import cn.sxt.service.UserService;@Controllerpublic class UserController {@Autowiredprivate UserService userService;public void setUserService(UserService userService) {this.userService = userService;}@RequestMapping("/list")public String list(ModelMap map){map.addAttribute("list", userService.list());return "list";}}

db.properties

driver=oracle.jdbc.driver.OracleDriverurl=jdbc:oracle:thin:@localhost:1521:orclusername=scottpassword=tiger

mvc.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: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/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"><!--  扫描该包下的注解 --><context:component-scan base-package="cn.sxt.Controller"/><!-- 启用spring mvc注解 --><context:annotation-config></context:annotation-config><!-- 配置视图解析器 --><bean class=" org.springframework.web.servlet.view.InternalResourceViewResolver"> <!-- 前缀 -->        <property name="prefix" value="/WEB-INF/jsp/"/>        <!-- 后缀 -->        <property name="suffix" value=".jsp"/></bean></beans>

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8"?>  <!DOCTYPE configuration PUBLIC  "-//mybatis.org//DTD Config 3.0//EN"           "http://mybatis.org/dtd/mybatis-3-config.dtd">    <configuration>      <typeAliases>         <package name="cn.sxt.vo"/>     </typeAliases>     <mappers>     <!-- 所有mapper文件填写位置 -->       <mapper resource="cn/sxt/vo/user.mapper.xml"/>   </mappers>  </configuration> 

list.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%>"><meta http-equiv="Content-Type" content="text/html; charset=gbk"><title>Insert title here</title></head><body><table width="80%" align="center">   <tr>   <td>编号</td>   <td>姓名</td>   <td>密码</td>   </tr>   <c:forEach items="${list}" var="bean">   <tr>   <td>${bean.id}</td>   <td>${bean.name}</td>   <td>${bean.pwd}</td>   </tr>   </c:forEach>   </table></body></html>