Spring mvc

最新推荐文章于 2023-08-03 08:00:00 发布

番茄柿

最新推荐文章于 2023-08-03 08:00:00 发布

阅读量805

点赞数

分类专栏： Spring

本文链接：https://blog.csdn.net/heyanfeng22/article/details/45727599

版权

Spring 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

利用spring mvc写一个登陆论坛并增加积分的小项目

spring mvc的流程

当页面输入：http://localhost:8080/superManager/index.html

映射到控制层中的loginPage（），返回的是login，即指向login.jsp，在login.jsp登陆，表单提交，指向action="<c:url value="/loginCheck.html"/>"，映射loginCheck(..)，通过业务处理，返回new ModelAndView("main")指向main.jsp;或者new ModelAndView("login",“error”,“账号或者密码错误”);

注意几个注解

当配置了扫描的包之后，用@方式

@Repository 该类被注解成是一个DAO

@Service 住结成Service

@Controller 控制层

@Autowired成员属性，省去了再xml配置bean，且get set方法

@RequestMapping(value="/index.html") 映射前端页面

1、配置web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5"
xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">


<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring*.xml</param-value>
</context-param>
<listener>
<listener-class>
org.springframework.web.context.ContextLoaderListener
</listener-class>
</listener>



<servlet>
<servlet-name>baobaotao</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<load-on-startup>2</load-on-startup>
</servlet>

<servlet-mapping>
<servlet-name>baobaotao</servlet-name>
<url-pattern>*.html</url-pattern>
</servlet-mapping>


<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>

</web-app>

2、配置spring-config.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:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
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/tx
http://www.springframework.org/schema/tx/spring-tx-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/aop
http://www.springframework.org/schema/aop/spring-aop-3.0.xsd" >


<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="locations" value="classpath:jdbc.properties"/>
</bean>

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">

<property name="driverClass" value="${jdbc.driverClassName}"/>

<property name="jdbcUrl" value="${jdbc.url}"/>

<property name="user" value="${jdbc.username}"/>

<property name="password" value="${jdbc.password}"/>


<property name="acquireIncrement" value="10"/>

<property name="initialPoolSize" value="10"></property>

<property name="maxPoolSize" value="100"/>

<property name="minPoolSize" value="10"/>
<property name="maxIdleTime" value="300"></property>
<property name="idleConnectionTestPeriod" value="60"></property> 
<property name="maxStatements" value="20"></property>
</bean>

<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource" />
</bean>




</beans>

3、配置spring注解文件baobaotao-servlet.xml

<context:component-scan base-package="com.baobaotao.*"/>


<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="viewClass"
value="org.springframework.web.servlet.view.JstlView" />
<property name="prefix" value="/WEB-INF/jsp/" />
<property name="suffix" value=".jsp" />
</bean>

</beans>

---------------------------------------------------------------------------------------------------------分割线--------------------------------------------------------------------------------------------------

4、bean

/**
*
*/
package com.baobaotao.domain;

import java.io.Serializable;
import java.util.Date;

/**
* @author Administrator
*
*/
public class User implements Serializable
{
/**
*
*/
private static final long serialVersionUID = 1L;

private int userId;
private String userName;
private String password;
private int credits;
private String lastIp;
private Date lastVisit;
public int getUserId() {
return userId;
}
public void setUserId(int userId) {
this.userId = userId;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public int getCredits() {
return credits;
}
public void setCredits(int credits) {
this.credits = credits;
}
public String getLastIp() {
return lastIp;
}
public void setLastIp(String lastIp) {
this.lastIp = lastIp;
}
public Date getLastVisit() {
return lastVisit;
}
public void setLastVisit(Date lastVisit) {
this.lastVisit = lastVisit;
}

}

/**
*
*/
package com.baobaotao.domain;

import java.io.Serializable;
import java.util.Date;

/**
* @author Administrator
*
*/
public class LoginLog implements Serializable
{
/**
*
*/
private static final long serialVersionUID = 1L;
private int loginLogId;
private int userId;
private String ip;
private Date loginDate;
public int getLoginLogId() {
return loginLogId;
}
public void setLoginLogId(int loginLogId) {
this.loginLogId = loginLogId;
}
public int getUserId() {
return userId;
}
public void setUserId(int userId) {
this.userId = userId;
}
public String getIp() {
return ip;
}
public void setIp(String ip) {
this.ip = ip;
}
public Date getLoginDate() {
return loginDate;
}
public void setLoginDate(Date loginDate) {
this.loginDate = loginDate;
}

}

5、配置DAO

/**
*
*/
package com.baobaotao.dao;

import java.sql.ResultSet;
import java.sql.SQLException;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowCallbackHandler;
import org.springframework.stereotype.Repository;

import com.baobaotao.domain.User;

/**
* @author Administrator
*
*/

@Repository
public class UserDao
{
@Autowired
private JdbcTemplate jdbcTemplate;

public int getMatchCount(String userName,String password)
{
String sqlStr= "select count(*) from t_user where user_name = ? and password = ?";
return jdbcTemplate.queryForInt(sqlStr,new Object[]{userName,password});
}

public User findUserByName(final String userName)
{
String sql = "select user_id,user_name,credits from t_user where user_name = ?";
final User user = new User();
jdbcTemplate.query(sql, new Object[]{userName},new RowCallbackHandler() {

public void processRow(ResultSet rs) throws SQLException
{
user.setUserId(rs.getInt("user_id"));
user.setUserName(rs.getString("user_name"));
user.setCredits(rs.getInt("credits"));
}
});

return user;
}

public void updateLoginInfo(User user)
{
String sql = "update t_user set last_visit = ?,last_ip=?,credits=? where user_id=?";

jdbcTemplate.update(sql,new Object[]{user.getLastVisit(),user.getLastIp(),user.getCredits(),user.getUserId()});
}

}

/**
*
*/
package com.baobaotao.dao;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

import com.baobaotao.domain.LoginLog;

/**
* @author Administrator
*
*/
@Repository // 通过spring注解定义一个Dao
public class LoginLogDao
{
@Autowired //�Զ�ע��jdbctemplate
private JdbcTemplate jdbcTemplate;

public void insertLoginLog(LoginLog loginLog)
{
String sql ="insert into t_login_log(user_id,ip,login_datetime) values(?,?,?)";

Object[] args = {loginLog.getUserId(),loginLog.getIp(),loginLog.getLoginDate()};

jdbcTemplate.update(sql,args);
}
}

6、service

/**
*
*/
package com.baobaotao.service;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.baobaotao.dao.LoginLogDao;
import com.baobaotao.dao.UserDao;
import com.baobaotao.domain.LoginLog;
import com.baobaotao.domain.User;

/**
* @author Administrator
*
*/
@Service
public class UserService
{
@Autowired
private UserDao userDao;

@Autowired
private LoginLogDao loginLogDao;

public boolean hasMatchUser(String userName,String password)
{
int matchCount = userDao.getMatchCount(userName, password);
return matchCount > 0;
}

public User findUserByUserName(String userName)
{
return userDao.findUserByName(userName);
}

public void loginSuccess(User user)
{
user.setCredits(5+user.getCredits());
LoginLog loginLog = new LoginLog();
loginLog.setUserId(user.getUserId());
loginLog.setIp(user.getLastIp());
loginLog.setLoginDate(user.getLastVisit());
userDao.updateLoginInfo(user);
loginLogDao.insertLoginLog(loginLog);

}
}

7、控制层

/**
*
*/
package com.baobaotao.web;

/**
* @author Administrator
*
*/
public class LoginCommand
{
private String userName;

private String password;

public String getUserName() {
return userName;
}

public void setUserName(String userName) {
this.userName = userName;
}

public String getPassword() {
return password;
}

public void setPassword(String password) {
this.password = password;
}

}

/**
*
*/
package com.baobaotao.web;

import java.util.Date;

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.servlet.ModelAndView;

import com.baobaotao.domain.User;
import com.baobaotao.service.UserService;

/**
* @author Administrator
*
*/

@Controller //1、标志成为一个Controller
public class LoginController
{
@Autowired
private UserService userService ;

//2/负责处理/index.html的请求
@RequestMapping(value="/index.html")
public String loginPage()
{
return "login";
}

//负责处理/loginCheck.html的请求
@RequestMapping(value="/loginCheck.html")
public ModelAndView loginCheck(HttpServletRequest request,LoginCommand loginCommand)
{
boolean isValidUser = userService.hasMatchUser(loginCommand.getUserName(), loginCommand.getPassword());

if(!isValidUser)
{
return new ModelAndView("login","error","用户名或者密码错误");
}
else
{
User user = userService.findUserByUserName(loginCommand.getUserName());
user.setLastVisit(new Date());
user.setLastIp(request.getRemoteAddr());
userService.loginSuccess(user);
request.getSession().setAttribute("user", user);
return new ModelAndView("main");

}
}

}

8、前端

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>宝宝淘论坛登录</title>
</head>

<body>
<c:if test="${!empty error}">
<font color="red"><c:out value="${error}"/></font>
</c:if>

<form action="<c:url value="/loginCheck.html"/>" method="post">
用户:<input type="text" name="userName"></br>
密码:<input type="password" name="password">
<input type="submit" value=“登录">
<input type="reset" value=“重置">
</form>
</body>
</html>

main.jsp

番茄柿

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Spring mvc

利用spring mvc写一个登陆论坛并增加积分的小项目spring mvc的流程当页面输入：http://localhost:8080/superManager/index.html映射到控制层中的loginPage（），返回的是login，即指向login.jsp，在login.jsp登陆，表单提交，指向action=""，映射loginCheck(..)，通过业务处理，返回n
复制链接

扫一扫

专栏目录