一、搭建SSM框架环境
1、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:aop="http://www.springframework.org/schema/aop"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:tx="http://www.springframework.org/schema/tx"
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/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<!-- 1.开启自动扫描 -->
<context:component-scan base-package="cn.software.bms" />
<!-- 2.引用db.properties -->
<context:property-placeholder location="classpath:db.properties"/>
<!-- 3.数据源 -->
<bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource">
<property name="driverClassName" value="${jdbc.driver}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
<!-- 最大连接数 -->
<property name="maxTotal" value="${jdbc.maxTotal}" />
<!-- 最大空闲连接数 -->
<property name="maxIdle" value="${jdbc.maxIdle}" />
<!-- 初始化连接数 -->
<property name="initialSize" value="${jdbc.initialSize}" />
</bean>
<!-- 4.JDBC事务管理器 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
<!-- 5.开启事务注解 -->
<tx:annotation-driven transaction-manager="transactionManager"/>
<!-- 6.Spring整合Mybatis配置文件 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<property name="configLocation" value="classpath:mybatis-config.xml"></property>
</bean>
<!-- 7.MapperScannerConfigurer自动扫描Mapper包下的所有接口 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="cn.software.bms.mapper" />
</bean>
</beans>
注:package包名需与项目名一致
2、MyBatis配置文件 mybatis-config.xml
<?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>
<!-- 给类型添加别名,默认是类的名称首字母小写,大小写都可以 -->
<typeAliases >
<package name="cn.software.bms.bean"/>
</typeAliases>
<!-- 添加分页插件 -->
<plugins>
<plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
</plugins>
</configuration>
3、SpringMVC配置文件 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:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd
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/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<!-- 1.开启自动扫描 -->
<context:component-scan
base-package="cn.software.bms">
<!-- 只扫描包下含有@Controller的注解 -->
<context:include-filter type="annotation"
expression="org.springframework.stereotype.Controller" />
</context:component-scan>
<!-- 2.视图解析器 -->
<bean
class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/" />
<property name="suffix" value=".jsp"></property>
</bean>
<!-- 两个标准配置 -->
<!-- 静态资源的请求,就将该请求转由Web应用服务器默认的Servlet处理,
如果不是静态资源的请求,才由DispatcherServlet继续处理 -->
<mvc:default-servlet-handler />
<!-- 启用注解驱动,并解决json返回值等中文乱码问题 -->
<mvc:annotation-driven>
<mvc:message-converters register-defaults="true">
<bean class="org.springframework.http.converter.StringHttpMessageConverter">
<property name="supportedMediaTypes">
<list>
<value>text/plain;charset=UTF-8</value>
<value>text/html;charset=UTF-8</value>
<value>application/json;charset=UTF-8</value>
</list>
</property>
</bean>
</mvc:message-converters>
</mvc:annotation-driven>
<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
<property name="defaultEncoding" value="UTF-8"></property>
<property name="maxUploadSize" value="409600000"></property>
<property name="maxInMemorySize" value="40960"></property>
</bean>
</beans>
4、连接数据库文件 db.properties
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/book_lend?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true
jdbc.username=root
jdbc.password=123456
jdbc.maxTotal=30
jdbc.maxIdle=10
jdbc.initialSize=5
5、修改web.xml文件
<!-- Spring中文乱码过滤器 -->
<filter>
<display-name>CharacterEncodingFilter</display-name>
<filter-name>CharacterEncodingFilter</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>
</filter>
<filter-mapping>
<filter-name>CharacterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- Spring监听器,加载配置文件 ContextLoaderListener -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
<!-- Bootstraps the root web application context before servlet initialization -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- SpringMVC前端控制器,加载的默认文件名${servlet-name}-servlet.xml -->
<servlet>
<servlet-name>springmvc</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:springmvc-config.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<!-- Map all requests to the DispatcherServlet for handling -->
<servlet-mapping>
<servlet-name>springmvc</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
6、日志文件 log4j.properties
log4j.rootLogger=info,console
log4j.appender.console=org.apache.log4j.ConsoleAppender
log4j.appender.console.layout=org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=%p [%c] - %m%n
log4j.logger.cn.software.bms=DEBUG
二、创建数据表-user(用户表)
三、代码实现用户登录功能
1、编写bean层—UserInfo
@AllArgsConstructor
@NoArgsConstructor
@Data
public class UserInfo implements Serializable{
/**
*
*/
private static final long serialVersionUID = 4333784302110839152L;
private Integer id;
private String userId;
private String userName;
private String password;
@JsonFormat(timezone = "GMT+8", pattern="yyyy-MM-dd HH:mm:ss")
private Date registerTime;
private Boolean state;
}
注意:这里使用的是lombok插件进行有参,无参,getter和setter方法的构造
JsonFormat注解将日期格式化输出
2、编写mapper层----UserInfoMapper
接口文件:UserInfoMapper.java
public interface UserInfoMapper{
public UserInfo findUserInfoByName(String userName);
}
xml文件:UserInfoMapper.xml
<resultMap type="UserInfo" id="userMap">
<id column="id" property="id"/>
<result column="user_id" property="userId"/>
<result column="user_name" property="userName"/>
<result column="password" property="password"/>
<result column="register_time" property="registerTime"/>
<result column="state" property="state"/>
</resultMap>
<select id="findUserInfoByName" parameterType="String"
resultMap="userMap">
select * from user where user_name=#{userName}
</select>
3、编写service层—UserInfoService
接口文件:UserInfoService.java
public interface UserInfoService {
public String loginByName(String userName,String password,Boolean state);
}
UserInfoServiceImpl.java
@Transactional
@Service
public class UserInfoServiceImpl implements UserInfoService{
@Autowired
private UserInfoMapper userInfoMapper;
@Override
public String loginByName(String userName, String password,Boolean state) {
UserInfo userInfo = userInfoMapper.findUserInfoByName(userName);
if (userInfo != null
&&userInfo.getPassword().equals(EncryptUtil.md5Crypt(password))
&&userInfo.getState()==state) {
return "login success";
}else {
return "login error";
}
}
}
4、编写controller层—UserInfoController
@Controller
public class UserInfoController {
@Autowired
private UserInfoService userInfoService;
@RequestMapping("/login")
public String login(String userName, String password,Boolean state, HttpSession session) {
String msg = userInfoService.loginByName(userName, password,state);
if (msg.contains("success")) {
session.setAttribute("userName", userName);
return "redirect:index.jsp";
} else {
return "redirect:login.jsp";
}
}
}
5、login.jsp界面编写
<div>
<form action="login" method="post">
<dl class="admin_login">
<dt>
<strong>图书借阅管理系统</strong> <em>Management System</em>
</dt>
<dd class="user_icon">
<input type="text" name="userName" value="admin" placeholder="用户名"
class="login_txtbx" />
</dd>
<dd class="pwd_icon">
<input type="password" name="password" value="admin"
placeholder="密码" class="login_txtbx" />
</dd>
<dd class="dd">
<div class="state" style="color: #45bda6;">
<input class="s1" type="radio" name="state" value="true" title="管理员" checked=""> 管 理 员
<input class="s2" type="radio" name="state" value="false" title="用户"> 用 户
</div>
</dd>
<dd>
<button type="submit" class="submit_btn">
<p>立  即  登  录</p>
</button>
</dd>
<dd>
<a href="register.jsp" class="reg"><p>立即注测</p></a>
</dd>
<dd>
<p>© 2015-2016 DeathGhost 版权所有</p>
<p>陕B2-20080224-1</p>
</dd>
</dl>
</form>
</div>