国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 編程 > Java > 正文

SpringMVC+MyBatis分頁(最新)

2019-11-26 13:28:19
字體:
供稿:網(wǎng)友

目前主流的Web MVC框架,除了Struts這個(gè)主力 外,還有Spring MVC,主要是由于Spring MVC配置比較簡(jiǎn)單,使用起來也十分明了,非常靈活,與Spring 集成較好,對(duì)RESTful API的支持也比struts要好。

MyBatis是ibatis的升級(jí)版,作為hibernate的老對(duì)手,它 是一個(gè)可以自定義SQL、存儲(chǔ)過程和高級(jí)映射的持久層框架。

與hibernate的主要區(qū)別就是mybatis是半自動(dòng)化的,而hibernate是全自動(dòng)的,所以當(dāng)應(yīng)用需求越來越復(fù)雜的時(shí)候,自動(dòng)化的sql顯得比較笨拙。

由于前段時(shí)間接了個(gè)項(xiàng)目要用springmvc做,所以我抱著練手的態(tài)度,又玩起了整合框架的游戲。經(jīng)常搭框架的人應(yīng)該都清楚,框架搭建的核心就是配置文件。所以我主要貼下幾個(gè)配置文件的代碼。還是那句話,我都是寫好配置文件之后,運(yùn)行報(bào)錯(cuò)再加jar。這里列一下我用的jar包(應(yīng)該是最少的):

備注:上圖有一些額外的jar,比如我用的數(shù)據(jù)庫(kù)連接池是阿里巴巴的druid、日志框架式logback,所以引入了相關(guān)jar。關(guān)于這兩個(gè)框架的使用和配置都是非常簡(jiǎn)單的,所以這里就不細(xì)說。

1.整合SpringMVC

springMybatis-servlet.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:context="http://www.springframework.org/schema/context"     xmlns:mvc="http://www.springframework.org/schema/mvc"     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">        <!-- 啟用spring mvc 注解-->   <mvc:annotation-driven>    </mvc:annotation-driven>      <!-- 自動(dòng)掃描的包名 ,使Spring支持自動(dòng)檢測(cè)組件,如注解的Controller-->   <context:component-scan base-package="com.alibaba.controller" />   <context:component-scan base-package="com.alibaba.service"/>         <!-- 視圖解析器:定義跳轉(zhuǎn)的文件的前后綴 -->    <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">      <property name="prefix" value="/WEB-INF/jsp/" />      <property name="suffix" value=".jsp" /> <!--可為空,方便實(shí)現(xiàn)自已的依據(jù)擴(kuò)展名來選擇視圖解釋類的邏輯 -->   </bean>     <!--配置攔截器, 多個(gè)攔截器,順序執(zhí)行 -->    <mvc:interceptors>      <mvc:interceptor>        <!-- 匹配的是url路徑 -->       <mvc:mapping path="/" />       <mvc:mapping path="/user/**" />       <mvc:mapping path="/test/**" />              <bean class="com.alibaba.interceptor.CommonInterceptor"></bean>      </mvc:interceptor>     <!-- 當(dāng)設(shè)置多個(gè)攔截器時(shí),先按順序調(diào)用preHandle方法,然后逆序調(diào)用每個(gè)攔截器的postHandle和afterCompletion方法 -->   </mvc:interceptors>     </beans>   

2.整合Mybatis

spring-dao.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:mybatis="http://mybatis.org/schema/mybatis-spring"     xmlns:context="http://www.springframework.org/schema/context"     xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd     http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd     http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">      <!-- 該包下的類支持注解,表示會(huì)被當(dāng)作{@code mybatis mapper}處理 配置了之后表示可以自動(dòng)引入mapper類-->   <mybatis:scan base-package="com.alibaba.dao"/>   <!--引入屬性文件 -->   <context:property-placeholder location="classpath:configuration.properties"/>      <!--數(shù)據(jù)庫(kù)連接-->   <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">      <property name="url" value="${jdbc.url}" />     <property name="username" value="${jdbc.username}"/>     <property name="password" value="${jdbc.password}"/>     <!-- 配置初始化大小、最小、最大 -->     <property name="initialSize"><value>1</value></property>     <property name="maxActive"><value>5</value></property>     <property name="minIdle"><value>1</value></property>     <!-- 配置獲取連接等待超時(shí)的時(shí)間 -->     <property name="maxWait"><value>60000</value></property>     <!-- 配置監(jiān)控統(tǒng)計(jì)攔截的filters -->     <property name="filters"><value>stat</value></property>     <!-- 配置間隔多久才進(jìn)行一次檢測(cè),檢測(cè)需要關(guān)閉的空閑連接,單位是毫秒 -->     <property name="timeBetweenEvictionRunsMillis"><value>60000</value></property>     <!-- 配置一個(gè)連接在池中最小生存的時(shí)間,單位是毫秒 -->     <property name="minEvictableIdleTimeMillis"><value>300000</value></property>     <!--     <property name="validationQuery"><value>SELECT 'x'</value></property>     <property name="testWhileIdle"><value>true</value></property>     <property name="testOnBorrow"><value>false</value></property>     <property name="testOnReturn"><value>false</value></property>     <property name="poolPreparedStatements"><value>true</value></property>     <property name="maxOpenPreparedStatements"><value>20</value></property>      -->   </bean>      <!-- mybatis配置 -->   <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">     <property name="dataSource" ref="dataSource" />   </bean>  </beans>   

3.web.xml整合SpringMVC和Mybatis

<?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_3_0.xsd" version="3.0">   <!-- 該servlet為tomcat,jetty等容器提供,將靜態(tài)資源映射從/改為/static/目錄,如原來訪問 http://localhost/foo.css ,現(xiàn)在http://localhost/static/foo.css -->   <!-- 不攔截靜態(tài)文件 -->   <servlet-mapping>     <servlet-name>default</servlet-name>     <url-pattern>/js/*</url-pattern>     <url-pattern>/css/*</url-pattern>     <url-pattern>/images/*</url-pattern>     <url-pattern>/fonts/*</url-pattern>   </servlet-mapping>      <!-- 配置字符集 -->   <filter>     <filter-name>encodingFilter</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>     <init-param>       <param-name>forceEncoding</param-name>       <param-value>true</param-value>     </init-param>   </filter>   <filter-mapping>     <filter-name>encodingFilter</filter-name>     <url-pattern>/*</url-pattern>   </filter-mapping>      <!-- 初始化 DispatcherServlet時(shí),該框架在 web應(yīng)用程序WEB-INF目錄中尋找一個(gè)名為[servlet-名稱]-servlet.xml的文件,       并在那里定義相關(guān)的Beans,重寫在全局中定義的任何Beans -->   <servlet>     <servlet-name>springMybatis</servlet-name>     <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>     <load-on-startup>1</load-on-startup>   </servlet>   <servlet-mapping>     <servlet-name>springMybatis</servlet-name>     <!-- 所有的的請(qǐng)求,都會(huì)被DispatcherServlet處理 -->     <url-pattern>/</url-pattern>   </servlet-mapping>       <context-param>     <param-name>contextConfigLocation</param-name>     <param-value>/WEB-INF/config/spring-*.xml</param-value>   </context-param>   <listener>     <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>   </listener>   <!-- druid web 監(jiān)控 -->   <servlet>     <servlet-name>DruidStatView</servlet-name>     <servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>   </servlet>   <servlet-mapping>     <servlet-name>DruidStatView</servlet-name>     <url-pattern>/druid/*</url-pattern>   </servlet-mapping>      <error-page>     <error-code>404</error-code>     <location>/error/404.jsp</location>   </error-page>   <error-page>     <error-code>500</error-code>     <location>/error/500.jsp</location>   </error-page> </web-app> 

4.logback.xml日志配置

<?xml version="1.0" encoding="UTF-8"?> <configuration>   <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">   <encoder>      <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>   </encoder>  </appender>    <logger name="test.LogbackTest" level="TRACE"/>    <logger name="com.alibaba.controller.TestController" level="TRACE"/>    <logger name="org.springframework.web.servlet.DispatcherServlet" level="DEBUG" />  <logger name="druid.sql" level="INFO" /><!-- 如果spring-config里面沒有配置slf4j,就不會(huì)顯示sql日志,logback只是slf4j的一個(gè)實(shí)現(xiàn) -->  <root level="debug">   <appender-ref ref="STDOUT" />  </root> </configuration> 

5.configuration.properties配置

jdbc.url=jdbc/:mysql/://localhost/:3306/druid?useUnicode/=true&characterEncoding/=UTF-8&zeroDateTimeBehavior/=convertToNull jdbc.username=root jdbc.password=123456 

6.測(cè)試搭建是否成功,后臺(tái)代碼

首先是登錄,用了加密,可以去掉

package com.alibaba.controller;  import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest;  import org.apache.commons.codec.digest.DigestUtils; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.RequestParam;  import com.alibaba.model.User; import com.alibaba.service.UserService; import com.alibaba.util.RequestUtil;  /**  * @author tfj  * 2014-7-26  */ @Controller public class SystemController {   private final Logger log = LoggerFactory.getLogger(SystemController.class);   @Resource   private UserService userService;      @RequestMapping(value = "/",method = RequestMethod.GET)   public String home() {     log.info("返回首頁!");     return "index";   }      @RequestMapping(value = "/test/hello",method = RequestMethod.GET)   public String testHello() {     log.info("執(zhí)行了testHello方法!");     return "testHello";   }      @RequestMapping(value = "/login",method = RequestMethod.POST)   public String testLogin(HttpServletRequest request,@RequestParam String username, @RequestParam String password) {     log.info("執(zhí)行了testLogin方法!");     User user = userService.findUserByName(username);     if(user!=null){       if(user.getPassword().equals(DigestUtils.md5Hex(password))){         request.getSession().setAttribute("userId", user.getId());          request.getSession().setAttribute("user", username);          return "redirect:" + RequestUtil.retrieveSavedRequest();//跳轉(zhuǎn)至訪問頁面       }else{         log.info("密碼錯(cuò)誤");          request.getSession().setAttribute("message", "用戶名密碼錯(cuò)誤,請(qǐng)重新登錄");         return "login";        }     }else{       log.info("用戶名不存在");        request.getSession().setAttribute("message", "用戶名不存在,請(qǐng)重新登錄");       return "login";      }   } } 

關(guān)于service和model就不寫了,寫一下mybatis的mapper類映射

<?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="com.alibaba.dao.UserMapper">     <select id="findUserByName" resultType="com.alibaba.model.User">     select id, username , password from sysuser where username = #{username}    </select> </mapper> 

7.前臺(tái)jsp主要是登錄和登錄成功的頁面,就不寫了

貼一下截圖:

到此,springmvc+mybatis整合成功。后續(xù)復(fù)雜的功能待添加

注意事項(xiàng)

1.框架中關(guān)于druid和logback的配置都是從官網(wǎng)上copy下來的,所以都是最基本的,讀者可以忽略,也可以換成讀者熟悉的數(shù)據(jù)庫(kù)組件和日志框架,如c3p0和log4j。

2.代碼里加入了權(quán)限管理,即訪問前需登錄,登錄后跳轉(zhuǎn)至待訪問頁面,關(guān)于springmvc的權(quán)限管理請(qǐng)看://m.survivalescaperooms.com/article/99569.htm

3.本文是從我的測(cè)試代碼里剝離出來的最簡(jiǎn)單的也是最基本的代碼,有些沒剝離干凈的地方還請(qǐng)見諒。

以上就是本文的全部?jī)?nèi)容,希望對(duì)大家的學(xué)習(xí)有所幫助,也希望大家多多支持武林網(wǎng)。

發(fā)表評(píng)論 共有條評(píng)論
用戶名: 密碼:
驗(yàn)證碼: 匿名發(fā)表
主站蜘蛛池模板: 蚌埠市| 垦利县| 长汀县| 黎城县| 丹江口市| 克拉玛依市| 伊金霍洛旗| 五莲县| 苏州市| 鄂托克前旗| 青铜峡市| 蕉岭县| 延川县| 凉城县| 甘谷县| 墨竹工卡县| 华坪县| 雷州市| 册亨县| 中牟县| 静乐县| 临夏县| 集贤县| 青神县| 南乐县| 扶风县| 鱼台县| 清河县| 巢湖市| 浦县| 南部县| 清丰县| 蛟河市| 鹰潭市| 石狮市| 彭阳县| 兴山县| 通江县| 抚宁县| 中牟县| 曲沃县|