大型运输行业实战_day03_1_基于intellij idea的非maven spring+springMVC+mybatis搭建

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;
    }
}

     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();
}

    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>

list.jsp

   13.部署启动,访问 http://localhost:8080/ticket/list 界面如下图: