spring 3.x 学习笔记_spring mvc、spring jdbc 实现网站的登录注册功能

Bertha 。 2022-09-24 13:15 13阅读 0赞

#####  #####

##### 使用spring mvc、spring jdbc 实现网站的登录注册功能 #####

1.        据业务模型 创建model 一般实现序列化

2.        用spring 注解（@Repository）定义DAO，在该DAO中用注解（@Autowired）方式注入JdbcTemplate bean，使用JdbcTemplate api实现DAO方法

package com.shopfruit.dao;
     
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.jdbc.core.JdbcTemplate;
    import org.springframework.stereotype.Repository;
     
    /**
     *  使用spring jdbc 实现这个dao类
     * @author Administrator
     */
    @Repository//spring注解定义一个dao
    public class UserDao {
    1.1       @Autowired//自动注入JdbcTemplate 的bean
        private JdbcTemplate jdbcTemplate;
        /**
         * 用户注册
         * @return 1 注册成功、0 注册失败
         */
        public intregisterUser(String name,String password){
           String sql = "INSERT INTOt_user values(null,?,?);";
           int result = jdbcTemplate.update(sql, newObject[]{name,password});
           return result;
        }
        /**
         * 用户名校验
         * @param name
         * @return 1 已存在  0不存在允许注册
         */
        public intregisterCheck(String name){
           String sql="selectcount(user_id) from t_user where user_name=?";
           int result = jdbcTemplate.queryForInt(sql,name);
           return result;
        }
        /**
         * 用户登录
         * @return 1 验证成功 0验证失败
         */
        public intgetMatchCount(String name,String password){
           String sql = "SELECTcount(user_id) from t_user where user_name = ? and `password`=?;";
           int result = jdbcTemplate.queryForInt(sql, new Object[]{name,password});
           return result;
        }
    }

3. **配置文件装配DAO，在src目录创建spring配置文件applicationContext.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:p="http://www.springframework.org/schema/p"
        xmlns:context="http://www.springframework.org/schema/context"
        xmlns:aop="http://www.springframework.org/schema/aop"xmlns:tx="http://www.springframework.org/schema/tx"
        xsi:schemaLocation="http://www.springframework.org/schema/beans
          http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
          http://www.springframework.org/schema/context
          http://www.springframework.org/schema/context/spring-context-3.0.xsd
          http://www.springframework.org/schema/tx
          http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
          http://www.springframework.org/schema/aop
          http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">
           
           
           <context:component-scan base-package="com.shopfruit.dao"></context:component-scan>
           <context:component-scan base-package="com.shopfruit.service"></context:component-scan>
          
           
           <bean id="dataSource"class="org.apache.commons.dbcp.BasicDataSource"
           destroy-method="close"
           p:driverClassName="com.mysql.jdbc.Driver"
           p:url="jdbc:mysql://localhost:3306/spring"
           p:username="root"
           p:password="root"></bean>
          
           
           <bean id="jdbcTemplate"class="org.springframework.jdbc.core.JdbcTemplate"
           p:dataSource-ref="dataSource"></bean>
          
           
           <bean id="dataSourceTanslationManager"
           class="org.springframework.jdbc.datasource.DataSourceTransactionManager"
           p:dataSource-ref="dataSource"></bean>
          
           
           <aop:config proxy-target-class="true">
               <aop:pointcut id="serviceMethod"
                  expression=" execution(* com.baobaotao.service..*(..))"/>
               <aop:advisor pointcut-ref="serviceMethod"advice-ref="txAdvice" />
           </aop:config>
           <tx:advice id="txAdvice"transaction-manager="dataSourceTanslationManager">
               <tx:attributes>
                  <tx:method name="*"/>
               </tx:attributes>
           </tx:advice>
    </beans>

4. 已完成持久层开发和配置，下面完成业务层的开发和配置，配置在上面

package com.shopfruit.service;
     
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
     
    import com.shopfruit.dao.UserDao;
     
    @Service//标注为服务层的bean
    public class UserService {
        @Autowired
        private UserDao userDao;
        /**
         * 注册检查
         * @param name
         * @return用户名是否存在，不存在 true，存在false
         */
        public booleanregisterCheck(String name){
           return userDao.registerCheck(name)==0;
        }
        /**
         * 用户注册
         * @param name
         * @param password
         * @return注册是否成功
         */
        public booleanregisterUser(String name,String password){
           if(registerCheck(name)){
               return userDao.registerUser(name,password)>0;
           }
           return false;
        }
        /**
         * 登录校验
         * @param name
         * @param password
         * @return用户名密码是否匹配
         */
        public booleangetMatchCount(String name,String password){
           return userDao.getMatchCount(name,password)>0;
        }
    }

5. 单元测试业务层

package com.shopfruit.service;
     
    import static org.junit.Assert.*;
     
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.test.context.ContextConfiguration;
    importorg.springframework.test.context.junit4.SpringJUnit4ClassRunner;
     
    import com.shopfruit.service.UserService;
    //基于JUnit4的spring测试框架
    @RunWith(SpringJUnit4ClassRunner.class)
    //启动spring容器
    @ContextConfiguration(locations = {"/applicationContext.xml"} )
    public class TestUserService {
        @Autowired
        private UserService userService;
        @Test
        public void testRegisterUser(){
           boolean b1 = userService.registerUser("admin", "123456");
           assertTrue(b1);
        }
        @Test
        public voidtestRegisterCheck() {
           Boolean b1 = userService.registerCheck("admindgzv");
           Boolean b2 = userService.registerCheck("adminzfczv");
           assertTrue(b1);
           assertTrue(b2);
        }
        @Test
        public voidtestGetMatchCount() {
           boolean b1 = userService.getMatchCount("admin", "123456");
           boolean b2 = userService.getMatchCount("admin1", "123456");
           assertTrue(b1);
           assertTrue(b2);
        }
     
    }

6.展现层的实现

1)       配置spring mvc，以便web容器启动能够自启动spring容器，处理请求。web.xml

<?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/javaeehttp://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">
      <display-name>ShopFruit</display-name>
      <welcome-file-list>
        <welcome-file>index.jsp</welcome-file>
      </welcome-file-list>
      
      <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>
            classpath:applicationContext.xml
        </param-value>
      </context-param>
      
      <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
      </listener>
      
      <servlet>
        <servlet-name>shopfruit</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
      </servlet>
      
      <servlet-mapping>
        <servlet-name>shopfruit</servlet-name>
        <url-pattern>*.html</url-pattern>
      </servlet-mapping>
    </web-app>

2)       处理登录注册请求的控制器类

package com.shopfruit.web;
     
    import javax.servlet.http.HttpServletRequest;
     
    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 org.springframework.web.servlet.ModelAndView;
     
    import com.shopfruit.domain.User;
    import com.shopfruit.service.UserService;
     
    @Controller//标注成为spring mvc 的Controller类
    public class LoginRegisterController {
        @Autowired
        private UserService userService;
        /**
         * 请求login.html跳登录页面
         * @return
         */
        @RequestMapping(value={"/login.html"})
        public String login(){
           return "login";
        }
        /**
         * 请求register.html跳注册页面
         * @return
         */
        @RequestMapping(value={"/register.html"})
        public String register(){
           return "register";
        }
        /**
         * 检查用户名
         * @param request
         * @return
         */
        @RequestMapping(value={"/registerCheck.html"})
        public @ResponseBody StringregisterCheck(HttpServletRequest request){
           String name =request.getParameter("name");
           boolean b = userService.registerCheck(name);
           if(!b){
    //         return"user error";
               return "用户名重复请重新取名";
           }
          
    //     return"user ok";
           return "用户名可用";
        }
        /**
         * 登录检查
         * @param request
         * @return
         */
        @RequestMapping(value={"/loginUser.html"})
        public ModelAndViewloginCheck(HttpServletRequest request){
           String name =request.getParameter("name");
           Stringpassword = request.getParameter("password");
           boolean b = userService.getMatchCount(name,password);
           if(!b){
               return new ModelAndView("login","status","用户名或者密码错误");
           }
           UserloginUser = new User();
           loginUser.setName(name);
           request.getSession().setAttribute("user",loginUser);
           return new ModelAndView("main","status","登录成功");
        }
        /**
         * 用户注册
         * @param request
         * @param user
         * @return
         */
        @RequestMapping(value={"/registerUser.html"})
        public ModelAndViewregisterUser(HttpServletRequest request,User user){
           boolean b = userService.registerUser(user.getName(),user.getPassword());
           if(!b){
               return new ModelAndView("register","status","注册失败，请重新注册。");
           }
           request.getSession().setAttribute("user",user);
           return new ModelAndView("main","status","注册成功");
        }
    }

写控制器类发现eclipse没有javax.servlet.http.HttpServletRequest 这个类，这个类在tomcat的lib 的servlet-aip.jar,需要我们自己在项目中引入

配置spring mvc 配置文件 shopfruit-servlet.xml

<pre name="code" class="html"><?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:p="http://www.springframework.org/schema/p"
        xmlns:context="http://www.springframework.org/schema/context"
        xsi:schemaLocation="http://www.springframework.org/schema/beans
          http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
          http://www.springframework.org/schema/context
          http://www.springframework.org/schema/context/spring-context-3.0.xsd">
           
        <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter"> 
               <property name="messageConverters">  
                   <list>  
                        <bean class ="org.springframework.http.converter.StringHttpMessageConverter">  
                           <property name ="supportedMediaTypes">
                                 <list>
                                     <value>text/html;charset=UTF-8</value>  
                                </list>  
                           </property>  
                        </bean>  
                   </list>  
              </property> 
        </bean> 
        
        <context:component-scan base-package="com.shopfruit.web"/>
        
        <bean
           class="org.springframework.web.servlet.view.InternalResourceViewResolver"
           p:viewClass="org.springframework.web.servlet.view.JstlView"
           p:prefix="/jsp/"
           p:suffix=".jsp"/>
    </beans>
    <p><span style="font-size:12px;">

7. 前台页面展示1)index.jsp 网站首页

2)       login.jsp登录界面

3)       register.jsp 注册页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
    <!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>
    <script type="text/javascript" src="js/jquery-1.8.1.js"></script>
    <script type="text/javascript">
    	$(function(){
    		$("#userName").bind("blur",function(){
    			var name = $(this).val();
    			$.ajax({
    			   type: "POST",
    			   url: "registerCheck.html",
    			   data: {name:name},
    			   success: function(msg){
    				   $("#message").html(msg);
    			   }
    			});
    		});
    	});
    </script>
    </head>
    <body>
    	<c:if test="${!empty status }">
    		<font color="red"><c:out value="${status }"></c:out> </font>
    	</c:if>
    	<form action="registerUser.html">
    		用户名：<input id="userName" name="name" type="text"/><span style="color:red;" id="message"></span><br>
    		密码：<input name="password" type="text"/><br>
    		<input type="submit" value="注册"/> <input type="reset" value="重置"/>
    	</form>
    </body>
    </html>

4) main 登录成功、或者注册成功后转向的页面

8. 最后发现spring mvc 返回给ajax的内容如果返回的是中文就会是乱码，原因是spring3.x

默认是iso-8859-1编码。解决办法一：spring mvc 的配置文件(shopfruit-servlet.xml)中添加

<bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter" >  
    			<property name="messageConverters">   
    		         <list>   
    		             <bean class = "org.springframework.http.converter.StringHttpMessageConverter">   
    		                <property name = "supportedMediaTypes">
    		                      <list>
    		                          <value>text/html;charset=UTF-8</value>   
    		                     </list>   
    		                </property>   
    		             </bean>   
    		         </list>   
    		   </property>  
    	</bean>

解决办法二：重写StringHttpMessageConverter类

</pre><pre name="code" class="java">package com.shopfruit.util;
    
    import java.io.IOException;
    import java.io.OutputStreamWriter;
    import java.nio.charset.Charset;
    import java.util.Arrays;
    import java.util.List;
    
    import org.springframework.http.HttpOutputMessage;
    import org.springframework.http.MediaType;
    import org.springframework.http.converter.StringHttpMessageConverter;
    import org.springframework.util.FileCopyUtils;
    
    public class UTF8StringHttpMessageConverter extends StringHttpMessageConverter {
    	private static final MediaType utf8 = new MediaType("text", "plain",
    			Charset.forName("UTF-8"));
    	private boolean writeAcceptCharset = true;
    
    	@Override
    	protected MediaType getDefaultContentType(String dumy) {
    		return utf8;
    	}
    
    	protected List<Charset> getAcceptedCharsets() {
    		return Arrays.asList(utf8.getCharSet());
    	}
    
    	protected void writeInternal(String s, HttpOutputMessage outputMessage)
    			throws IOException {
    		if (this.writeAcceptCharset) {
    			outputMessage.getHeaders().setAcceptCharset(getAcceptedCharsets());
    		}
    		Charset charset = utf8.getCharSet();
    		FileCopyUtils.copy(s, new OutputStreamWriter(outputMessage.getBody(),
    				charset));
    	}
    
    	public boolean isWriteAcceptCharset() {
    		return writeAcceptCharset;
    	}
    
    	public void setWriteAcceptCharset(boolean writeAcceptCharset) {
    		this.writeAcceptCharset = writeAcceptCharset;
    	}
    }

在spring 配置文件中添加