1.搭建标准web项目结构

搭建完成后的项目结构如图

1.创建普通web项目(略)

2.在lib中添加jar包

3.在resources中添加spring-config.xml主配置文件

 <?xml version="1.0" encoding="UTF-8"?>
 <beans xmlns="http://www.springframework.org/schema/beans"
        xmlns:context="http://www.springframework.org/schema/context"
        xmlns:mvc="http://www.springframework.org/schema/mvc"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        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
          http://www.springframework.org/schema/mvc
         http://www.springframework.org/schema/mvc/spring-mvc.xsd
         ">
     <!-- 开启注解-->
     <mvc:annotation-driven/>
     <!--  扫描包-->
     <context:component-scan base-package="com.day02.sation.controller,com.day02.sation.service"/>
     <!--读取配置文件-->
     <context:property-placeholder location="classpath:db.properties"/>
     <!--  配置连接池-->
     <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
         <property name="driverClassName" value="${mysql.driver}"/>
         <property name="url" value="${mysql.url}"/>
         <property name="username" value="${mysql.userName}"/>
         <property name="password" value="${mysql.password}"/>
     </bean>
     <!-- 配置sqlSessionFactory-->
     <bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
         <!-- 配置连接池-->
         <property name="dataSource" ref="dataSource"/>
         <!--别名-->
         <!-- 读取映射文件-->
         <property name="mapperLocations" value="classpath:mapper/*.xml"/>
     </bean>
     <!--   扫描接口包-->
     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!-- sessionFactory-->
         <property name="sqlSessionFactoryBeanName" value="sessionFactory"/>
        <!-- 扫描接口包-->
         <property name="basePackage" value="com.day02.sation.dao"/>
     </bean>
     <!--前缀后缀-->
 </beans>

使用到的db.properties如下:

 #驱动
 mysql.driver=com.mysql.jdbc.Driver
 #数据库ip地址
 mysql.url=jdbc:mysql://localhost:3306/station
 #用户名
 mysql.userName=root
 #密码
 mysql.password=admin

4.配置web.xml代码

 <?xml version="1.0" encoding="UTF-8"?>
 <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
          xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
          version="3.1">
    <!-- 配置dispatcherServlet-->
     <servlet>
         <servlet-name>dispatcherServlet</servlet-name>
         <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
       <!--  读取spring-config.xml文件-->
         <init-param>
             <param-name>contextConfigLocation</param-name>
             <param-value>classpath:spring-config.xml</param-value>
         </init-param>
        <!-- 项目启动的时候初始化-->
         <load-on-startup>1</load-on-startup>
     </servlet>
    <!-- 映射地址-->
     <servlet-mapping>
         <servlet-name>dispatcherServlet</servlet-name>
         <url-pattern>/</url-pattern>
     </servlet-mapping>
 </web-app>

5.在model中创建Ticket.java文件

 package com.day02.sation.model; /**
  * Created by Administrator on 12/27.
  */
 public class Ticket {
     private  Integer id;
     private String startStation;
     private String stopStation;     public Integer getId() {
         return id;
     }     public void setId(Integer id) {
         this.id = id;
     }     public String getStartStation() {
         return startStation;
     }     public void setStartStation(String startStation) {
         this.startStation = startStation;
     }     public String getStopStation() {
         return stopStation;
     }     public void setStopStation(String stopStation) {
         this.stopStation = stopStation;
     }
 }

Ticket.java

6.在dao中添加ITicket.java接口

 package com.day02.sation.dao; import com.day02.sation.model.Ticket; import java.util.List; /**
  * Created by Administrator on 12/27.
  */
 public interface ITicketDao {
     /**
      * 查询所有
      * @return
      */
     List<Ticket> getList();
 }

ITicketDao.java

7.在resources中添加mapper文件夹,然后在mapper中添加ticketMapper.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="com.day02.sation.dao.ITicketDao"
        -->
 <mapper namespace="com.day02.sation.dao.ITicketDao">
    <!-- 查询所有
   对应的接口方法名称 id="getList"
   定义返回的类型  resultType="com.day02.sation.model.Ticket"
    -->
     <select id="getList" resultType="com.day02.sation.model.Ticket">
         SELECT id,start_station startStation,stop_station stopStation FROM ticket
     </select>
 </mapper>

8.编写测试类进行测试 记住所有dao必须做测试,非常重要

 package com.day02.sation.test; import com.day02.sation.dao.ITicketDao;
 import com.day02.sation.model.Ticket;
 import org.junit.Test;
 import org.junit.runner.RunWith;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.test.context.ContextConfiguration;
 import org.springframework.test.context.junit4.SpringJUnit4ClassRunner; import java.util.List; /**
  * Created by Administrator on 12/27.
  */
 @RunWith(SpringJUnit4ClassRunner.class)
 @ContextConfiguration("classpath:spring-config.xml")
 public class TestDao {
     @Autowired
     private ITicketDao ticketDao;
     @Test
     public void testGetList(){         List<Ticket> list = ticketDao.getList();         System.out.println("list="+list);
     }
 }

9.编写ITicketservice.java接口

 package com.day02.sation.service; import com.day02.sation.model.Ticket; import java.util.List; /**
  * Created by Administrator on 12/27.
  */
 public interface ITicketService {
    /* 查询所有*/
     List<Ticket> getList();
 }

10.编写TicketService实现类

 package com.day02.sation.service.impl; import com.day02.sation.dao.ITicketDao;
 import com.day02.sation.model.Ticket;
 import com.day02.sation.service.ITicketService;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service; import java.util.List; /**
  * Created by Administrator on 12/27.
  */
 @Service
 public class TicketService implements ITicketService {
     @Autowired
     private ITicketDao ticketDao;
     @Override
     public List<Ticket> getList() {
         return ticketDao.getList();
     }
 }

11.编写控制层 TicketController

 package com.day02.sation.controller; import com.day02.sation.model.Ticket;
 import com.day02.sation.service.ITicketService;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Controller;
 import org.springframework.web.bind.annotation.RequestMapping;
 import org.springframework.web.bind.annotation.ResponseBody; import javax.servlet.http.HttpServletRequest;
 import java.util.List; /**
  * Created by Administrator on 12/27.
  */
 @Controller
 @RequestMapping("/ticket")
 public class TicketController {
     @Autowired
     private ITicketService ticketService;     /**
      * 数据和页面一起请求
      * @param req
      * @return
      */
     @RequestMapping("/list")
     public String listPage(HttpServletRequest req){
         System.out.println("----listPage--------");
         //接收参数
         //调用业务方法
         List<Ticket> list = ticketService.getList();
         req.setAttribute("list",list);
         return "/WEB-INF/views/list.jsp";
     } }

12.在该路径下(WEB-INF/views/)下添加list.jsp

注意在使用c标签时必须

a.配置 <%@ taglib prefix=”c” uri=”http://java.sun.com/jsp/jstl/core”%>

b.添加jar包 standard.jar jstl.jar

 <%@ page contentType="text/html;charset=UTF-8" language="java" pageEncoding="UTF-8" %>
 <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
 <html>
 <head>
     <title>车票列表</title>
 </head>
 <body>
 <div align="center">
     <table id="ticketList" border="1" cellspacing="1">
         <tr>
             <td>编号</td>
             <td>开始车站</td>
             <td>到达车站</td>
         </tr>
         <%--模拟假数据--%>
         <tr>
             <td>1</td>
             <td>北京</td>
             <td>成都</td>
         </tr>
       <%--  数据库中获取的数据--%>
         <c:forEach items="${list}" var="ticket">
             <tr>
                 <td>${ticket.id}</td>
                 <td>${ticket.startStation}</td>
                 <td>${ticket.stopStation}</td>
             </tr>
         </c:forEach>
     </table>
 </div>
 </body>
 </html>