今日学习笔记

1.Spring与Spring MVC整合

<!-- 配置加载类路径的配置文件 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath*:applicationContext.xml,classpath*:spring-security.xml</param-value>
</context-param>
<!-- 配置监听器 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
 
2.Spring与MyBatis整合
　　2.1.整合思路
把 mybatis 配置文件（mybatis.xml）中内容配置到 spring 配置文件中 同时，把 mybatis 配置文件的内容清掉
<?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>
</configuration>
 
注意：由于使用的是代理Dao的模式，Dao具体实现类由MyBatis使用代理方式创建，所以此时
mybatis配置文件不能删。当整合 spring 和 mybatis 时，mybatis创建的Mapper.xml文件名必须和Dao接口文件名一致
 
　　2.2.Spring接管mybatis的Session工厂
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssm?useUnicode=true&characterEncoding=utf8
jdbc.username=root
jdbc.password=123456
 
<context:property-placeholder location="classpath:db.properties"/>
<!-- 配置连接池 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${jdbc.driver}" />
<property name="jdbcUrl" value="${jdbc.url}" />
<property name="user" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</bean>
<!-- 把交给IOC管理 SqlSessionFactory -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
</bean>
 
　　2.3.扫描所有Mapper接口和文件
<bean id="mapperScanner" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.itheima.ssm.dao"/>
</bean>
 
　　2.4.配置Spring
<!-- 配置事务管理器 -->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<tx:annotation-driven transaction-manager="transactionManager"/>
 
3.jsp页面
　　3.1.请求发起页面 index.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>主页</title>
</head>
<body>
<a href="${pageContext.request.contextPath}/product/findAll.do">查询产品信息</a>
</body>
</html>
 
　　3.2.显示日程页面 product-list.jsp
<!--工具栏-->
        <div class="pull-left">
            <div class="form-group form-inline">
                <div class="btn-group">
                    <button type="button" class="btn btn-default" title="新建" onclick="location.href='${pageContext.request.contextPath}/pages/product-add.jsp'"><i
                            class="fa fa-file-o"></i> 新建
                    </button>
                    <button type="button" class="btn btn-default" title="开启"><i class="fa fa-check"></i>
                        开启
                    </button>
                    <button type="button" class="btn btn-default" title="关闭">
                        <i class="fa fa-ban"></i>关闭
                    </button>
                    <button type="button" class="btn btn-default" title="刷新" onclick="location.href='${pageContext.request.contextPath}/product/findAll.do'">
                        <i class="fa fa-refresh"></i> 刷新
                    </button>
                </div>
            </div>
        </div>
        <div class="box-tools pull-right">
            <div class="has-feedback">
                <input type="text" class="form-control input-sm" placeholder="搜索">
                <span class="glyphicon glyphicon-search form-control-feedback"></span>
            </div>
        </div>
        <!--工具栏/-->

        <!--数据列表-->
        <table id="dataList" class="table table-bordered table-striped table-hover dataTable">
            <thead>
            <tr>
                <th class="" style="padding-right:0px;">
                    <input id="selall" type="checkbox" class="icheckbox_square-blue">
                </th>
                <th class="sorting_asc">ID</th>
                <th class="sorting_desc">编号</th>
                <th class="sorting_asc sorting_asc_disabled">日程</th>
                <th class="sorting">时间</th>
                <th class="text-center sorting">日程内容</th>
                <th class="text-center sorting">状态</th>
                <th class="text-center">操作</th>
            </tr>
            </thead>
            <tbody>
            <c:forEach var="product" items="${pageInfo.list}">
            <tr>
                <td><input name="ids" type="checkbox"></td>
                <td>${product.id}</td>
                <td>${product.productNum}</td>
                <td>${product.productName}</td>
                <td>${product.departureTimeStr}</td>
                <td class="text-center">${product.productDesc}</td>
                <td class="text-center">${product.productStatusStr}</td>
                <td class="text-center">
                    <button type="button" class="btn bg-olive btn-xs">编辑</button>
                    <button type="button" class="btn bg-olive btn-xs">删除</button>
                </td>
            </tr>
            </c:forEach>

            </tbody>

        </table>
        <!--数据列表/-->

    </div>
    <!-- 数据表格 /-->


</div>
<!-- /.box-body -->

<!-- .box-footer-->
<div class="box-footer">
    <div class="pull-left">
        <div class="form-group form-inline">
            总共${pageInfo.pages} 页  共${pageInfo.total} 条数据    每页
            <select class="form-control" id="changePageSize" onchange="changePageSize()">
                <option selected>${pageInfo.pageSize}</option>
                <option>1</option>
                <option>2</option>
                <option>3</option>
                <option>4</option>
                <option>5</option>
            </select> 条
        </div>
    </div>

    <div class="box-tools pull-right">
        <ul class="pagination">
            <li>
                <a href="${pageContext.request.contextPath}/product/findAll.do?page=1&size=${pageInfo.pageSize}" aria-label="Previous">首页</a>
            </li>
            <li><a href="${pageContext.request.contextPath}/product/findAll.do?page=${pageInfo.pageNum-1}&size=${pageInfo.pageSize}">上一页</a></li>
            <c:forEach begin="1" end="${pageInfo.pages}" var="pageNum">
                <li><a href="${pageContext.request.contextPath}/product/findAll.do?page=${pageNum}&size=${pageInfo.pageSize}">${pageNum}</a></li>
            </c:forEach>
            <li><a href="${pageContext.request.contextPath}/product/findAll.do?page=${pageInfo.pageNum+1}&size=${pageInfo.pageSize}">下一页</a></li>
            <li>
                <a href="${pageContext.request.contextPath}/product/findAll.do?page=${pageInfo.pages}&size=${pageInfo.pageSize}" aria-label="Next">尾页</a>
            </li>
        </ul>
    </div>

</div>

　　3.3控制器
@Controller
@RequestMapping("/product")
public class ProductController {
@Autowired
private IProductService productService;
@RequestMapping("/findAll.do")
public ModelAndView findAll() throws Exception {
ModelAndView mv = new ModelAndView();
List<Product> products = productService.findAll();
mv.addObject("productList", products);
mv.setViewName("product-list");
return mv;
}
}
 
4.日程添加
　　4.1.日程添加product-add.jsp
<div class="panel panel-default">
         <div class="panel-heading">日程信息</div>
         <div class="row data-type">

            <div class="col-md-2 title">日程编号</div>
            <div class="col-md-4 data">
               <input type="text" class="form-control" name="productNum"
                  placeholder="日程编号" value="">
            </div>
            <div class="col-md-2 title">日程名称</div>
            <div class="col-md-4 data">
               <input type="text" class="form-control" name="productName"
                  placeholder="日程名称" value="">
            </div>
            <div class="col-md-2 title">时间</div>
            <div class="col-md-4 data">
               <div class="input-group date">
                  <div class="input-group-addon">
                     <i class="fa fa-calendar"></i>
                  </div>
                  <input type="text" class="form-control pull-right"
                     id="datepicker-a3" name="departureTime">
               </div>
            </div>
            <div class="col-md-2 title">日程状态</div>
            <div class="col-md-4 data">
               <select class="form-control select2" style="width: 100%"
                  name="productStatus">
                  <option value="0" selected="selected">关闭</option>
                  <option value="1">开启</option>
               </select>
            </div>

            <div class="col-md-2 title rowHeight2x">其他信息</div>
            <div class="col-md-10 data rowHeight2x">
               <textarea class="form-control" rows="3" placeholder="其他信息"
                  name="productDesc"></textarea>
            </div>

         </div>
      </div>
      <!--订单信息/--> <!--工具栏-->
      <div class="box-tools text-center">
         <button type="submit" class="btn bg-maroon">保存</button>
         <button type="button" class="btn bg-default"
            onclick="history.back(-1);">返回</button>
      </div>
      <!--工具栏/--> </section>
      <!-- 正文区域 /-->
   </form>
</div>

　　4.2.控制器
@Controller
@RequestMapping("/product")
public class ProductController {
@Autowired
private IProductService productService;
@InitBinder
public void initBinder(WebDataBinder binder) {
binder.registerCustomEditor(Date.class, new MyDateEdit("yyyy-MM-dd HH:mm"));
}
@RequestMapping("/save.do")
public String save(Product product) throws Exception {
productService.save(product);
return "redirect:findAll.do";
}
@RequestMapping("/findAll.do")
public ModelAndView findAll() throws Exception {
ModelAndView mv = new ModelAndView();
List<Product> products = productService.findAll();
mv.addObject("productList", products);
mv.setViewName("product-list");
return mv;
}
}
　　4.3.Dao
public interface IProductDao {
@Select("select * from product")
List<Product> findAll() throws Exception;
@Insert("insert into
product(productNum,productName,cityName,departureTime,productPrice,productDesc,productStatus)
values(#{productNum},#{productName},#{cityName},#{departureTime},#{productPrice},#
{productDesc},#{productStatus})")
void save(Product product);
}
posted @ 2021-01-04 16:02  计算机语言学习日志  阅读(51)  评论(0)    收藏  举报