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

1.搭建标准web项目结构

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

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

2.在lib中添加jar包

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

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <beans xmlns="http://www.springframework.org/schema/beans"
 3        xmlns:context="http://www.springframework.org/schema/context"
 4        xmlns:mvc="http://www.springframework.org/schema/mvc"
 5        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 6        xsi:schemaLocation="
 7        http://www.springframework.org/schema/beans
 8         http://www.springframework.org/schema/beans/spring-beans.xsd
 9          http://www.springframework.org/schema/context
10         http://www.springframework.org/schema/context/spring-context.xsd
11          http://www.springframework.org/schema/mvc
12         http://www.springframework.org/schema/mvc/spring-mvc.xsd
13         ">
14     <!-- 开启注解-->
15     <mvc:annotation-driven/>
16     <!--  扫描包-->
17     <context:component-scan base-package="com.day02.sation.controller,com.day02.sation.service"/>
18     <!--读取配置文件-->
19     <context:property-placeholder location="classpath:db.properties"/>
20     <!--  配置连接池-->
21     <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
22         <property name="driverClassName" value="${mysql.driver}"/>
23         <property name="url" value="${mysql.url}"/>
24         <property name="username" value="${mysql.userName}"/>
25         <property name="password" value="${mysql.password}"/>
26     </bean>
27     <!-- 配置sqlSessionFactory-->
28     <bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
29         <!-- 配置连接池-->
30         <property name="dataSource" ref="dataSource"/>
31         <!--别名-->
32         <!-- 读取映射文件-->
33         <property name="mapperLocations" value="classpath:mapper/*.xml"/>
34     </bean>
35     <!--   扫描接口包-->
36     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
37        <!-- sessionFactory-->
38         <property name="sqlSessionFactoryBeanName" value="sessionFactory"/>
39        <!-- 扫描接口包-->
40         <property name="basePackage" value="com.day02.sation.dao"/>
41     </bean>
42     <!--前缀后缀-->
43 </beans>

使用到的db.properties如下:

1 #驱动
2 mysql.driver=com.mysql.jdbc.Driver
3 #数据库ip地址
4 mysql.url=jdbc:mysql://localhost:3306/station
5 #用户名
6 mysql.userName=root
7 #密码
8 mysql.password=admin

4.配置web.xml代码

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
 3          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 4          xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
 5          version="3.1">
 6    <!-- 配置dispatcherServlet-->
 7     <servlet>
 8         <servlet-name>dispatcherServlet</servlet-name>
 9         <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
10       <!--  读取spring-config.xml文件-->
11         <init-param>
12             <param-name>contextConfigLocation</param-name>
13             <param-value>classpath:spring-config.xml</param-value>
14         </init-param>
15        <!-- 项目启动的时候初始化-->
16         <load-on-startup>1</load-on-startup>
17     </servlet>
18    <!-- 映射地址-->
19     <servlet-mapping>
20         <servlet-name>dispatcherServlet</servlet-name>
21         <url-pattern>/</url-pattern>
22     </servlet-mapping>
23 </web-app>

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

 1 package com.day02.sation.model;
 2 
 3 /**
 4  * Created by Administrator on 12/27.
 5  */
 6 public class Ticket {
 7     private  Integer id;
 8     private String startStation;
 9     private String stopStation;
10 
11     public Integer getId() {
12         return id;
13     }
14 
15     public void setId(Integer id) {
16         this.id = id;
17     }
18 
19     public String getStartStation() {
20         return startStation;
21     }
22 
23     public void setStartStation(String startStation) {
24         this.startStation = startStation;
25     }
26 
27     public String getStopStation() {
28         return stopStation;
29     }
30 
31     public void setStopStation(String stopStation) {
32         this.stopStation = stopStation;
33     }
34 }

Ticket.java

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

 1 package com.day02.sation.dao;
 2 
 3 import com.day02.sation.model.Ticket;
 4 
 5 import java.util.List;
 6 
 7 /**
 8  * Created by Administrator on 12/27.
 9  */
10 public interface ITicketDao {
11     /**
12      * 查询所有
13      * @return
14      */
15     List<Ticket> getList();
16 }

ITicketDao.java

7.在resources中添加mapper文件夹,然后在mapper中添加ticketMapper.xml映射文件

 1 <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
 2         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 3        <!-- 
 4       对应的接口地址: namespace="com.day02.sation.dao.ITicketDao"
 5        -->
 6 <mapper namespace="com.day02.sation.dao.ITicketDao">
 7    <!-- 查询所有
 8   对应的接口方法名称 id="getList" 
 9   定义返回的类型  resultType="com.day02.sation.model.Ticket"
10    -->
11     <select id="getList" resultType="com.day02.sation.model.Ticket">
12         SELECT id,start_station startStation,stop_station stopStation FROM ticket
13     </select>
14 </mapper>

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

 1 package com.day02.sation.test;
 2 
 3 import com.day02.sation.dao.ITicketDao;
 4 import com.day02.sation.model.Ticket;
 5 import org.junit.Test;
 6 import org.junit.runner.RunWith;
 7 import org.springframework.beans.factory.annotation.Autowired;
 8 import org.springframework.test.context.ContextConfiguration;
 9 import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
10 
11 import java.util.List;
12 
13 /**
14  * Created by Administrator on 12/27.
15  */
16 @RunWith(SpringJUnit4ClassRunner.class)
17 @ContextConfiguration("classpath:spring-config.xml")
18 public class TestDao {
19     @Autowired
20     private ITicketDao ticketDao;
21     @Test
22     public void testGetList(){
23 
24         List<Ticket> list = ticketDao.getList();
25 
26         System.out.println("list="+list);
27     }
28 }

9.编写ITicketservice.java接口

 1 package com.day02.sation.service;
 2 
 3 import com.day02.sation.model.Ticket;
 4 
 5 import java.util.List;
 6 
 7 /**
 8  * Created by Administrator on 12/27.
 9  */
10 public interface ITicketService {
11    /* 查询所有*/
12     List<Ticket> getList();
13 }

10.编写TicketService实现类

 1 package com.day02.sation.service.impl;
 2 
 3 import com.day02.sation.dao.ITicketDao;
 4 import com.day02.sation.model.Ticket;
 5 import com.day02.sation.service.ITicketService;
 6 import org.springframework.beans.factory.annotation.Autowired;
 7 import org.springframework.stereotype.Service;
 8 
 9 import java.util.List;
10 
11 /**
12  * Created by Administrator on 12/27.
13  */
14 @Service
15 public class TicketService implements ITicketService {
16     @Autowired
17     private ITicketDao ticketDao;
18     @Override
19     public List<Ticket> getList() {
20         return ticketDao.getList();
21     }
22 }

11.编写控制层 TicketController

 1 package com.day02.sation.controller;
 2 
 3 import com.day02.sation.model.Ticket;
 4 import com.day02.sation.service.ITicketService;
 5 import org.springframework.beans.factory.annotation.Autowired;
 6 import org.springframework.stereotype.Controller;
 7 import org.springframework.web.bind.annotation.RequestMapping;
 8 import org.springframework.web.bind.annotation.ResponseBody;
 9 
10 import javax.servlet.http.HttpServletRequest;
11 import java.util.List;
12 
13 /**
14  * Created by Administrator on 12/27.
15  */
16 @Controller
17 @RequestMapping("/ticket")
18 public class TicketController {
19     @Autowired
20     private ITicketService ticketService;
21 
22     /**
23      * 数据和页面一起请求
24      * @param req
25      * @return
26      */
27     @RequestMapping("/list")
28     public String listPage(HttpServletRequest req){
29         System.out.println("----listPage--------");
30         //接收参数
31         //调用业务方法
32         List<Ticket> list = ticketService.getList();
33         req.setAttribute("list",list);
34         return "/WEB-INF/views/list.jsp";
35     }
36 
37    
38 }

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

 1 <%@ page contentType="text/html;charset=UTF-8" language="java" pageEncoding="UTF-8" %>
 2 <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
 3 <html>
 4 <head>
 5     <title>车票列表</title>
 6 </head>
 7 <body>
 8 <div align="center">
 9     <table id="ticketList" border="1" cellspacing="1">
10         <tr>
11             <td>编号</td>
12             <td>开始车站</td>
13             <td>到达车站</td>
14         </tr>
15         <%--模拟假数据--%>
16         <tr>
17             <td>1</td>
18             <td>北京</td>
19             <td>成都</td>
20         </tr>
21       <%--  数据库中获取的数据--%>
22         <c:forEach items="${list}" var="ticket">
23             <tr>
24                 <td>${ticket.id}</td>
25                 <td>${ticket.startStation}</td>
26                 <td>${ticket.stopStation}</td>
27             </tr>
28         </c:forEach>
29     </table>
30 </div>
31 </body>
32 </html>

list.jsp

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

相关阅读:
关闭webstorm自动保存，并显示文件未保存标识
 ionic1.3.3 下拉刷新上拉加载更多
 纯css导航下划线跟随效果【转载】
wpf获取模板化控件中的动画。
wpf中dropdownButton控件下拉居中。。。
C#综合揭秘——深入分析委托与事件
 反射
 多线程，异步
 wcf,socket,数据传输方式
 面向对象五大原则三个基本特征
原文地址：https://www.cnblogs.com/newAndHui/p/8124974.html