1.先准备数据库创建数据库—db_gm(创建的数据库名称), 创建表—tb_user(创建的表名称)
2.新建项目 – maven
archetypeCatalog = internal, 作用: 加快构建maven骨架
架包存放路径:C:\当前用户.m2\repository
3.导包 pom.xml
4.创建项目的目录结构 – Java、resources、webapp
5.根据MVC(model View Controller)的项目开发思想创建包结构名
6.根据表去创建实体类和dao层
model/bean/pojo/entity — 存放实体类
dao/mapper — 存放接口,与数据库直接交互
service — 业务逻辑层,大致与dao层一致
controller — 控制层 / 表现层
package com.zjitc.bean;
/**
* UserInfo - 实体类,映射数据库字段,字段建议一致
*/
public class UserInfo {
// 在实体类中为什么要进行封装?
// Spring 容器,去访问对象成员属性的时候必须是封装类型的,不然就没办法访问
private int id; //用户ID
private String username; //用户名
private String password; //用户密码
// get/set 访问器
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
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 UserInfo() {
}
public UserInfo(int id, String username, String password) {
this.id = id;
this.username = username;
this.password = password;
}
// toString的方法重写
@Override
public String toString() {
return "UserInfo{" +
"id=" + id +
", username='" + username + '\'' +
", password='" + password + '\'' +
'}';
}
}
package com.zjitc.dao;
import com.zjitc.bean.UserInfo;
import java.util.List;
// IUserInfoDao - 接口,数据库访问层,直接可以访问数据库
public interface IUserInfoDao {
// 验证登陆
// 查询Select
UserInfo doLogin(String username);
}
package com.zjitc.service;
import com.zjitc.bean.UserInfo;
import java.util.List;
public interface IUserInfoService {
UserInfo doLogin(String username);
}
package com.zjitc.service.impl;
import com.github.pagehelper.PageHelper;
import com.zjitc.bean.UserInfo;
import com.zjitc.dao.IUserInfoDao;
import com.zjitc.service.IUserInfoService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
import java.util.List;
@Service
public class UserInfoServiceImpl implements IUserInfoService {
// @Resource(name = "u1")
@Autowired
private IUserInfoDao userInfoDao;
@Override
public UserInfo doLogin(String username) {
return userInfoDao.doLogin(username);
}
}
7.整合 Spring + Mybatis – 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: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-4.3.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.3.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">
<!-- 1、配置数据库相关参数-->
<context:property-placeholder location="classpath:db.properties"/>
<!-- 2、配置数据源-->
<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}"/>
<!-- <property name="maxPoolSize" value="20"/>-->
<!-- <property name="minPoolSize" value="3"/>-->
</bean>
<!-- 3、配置sqlSessionFactory对象-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!--引入数据库连接池-->
<property name="dataSource" ref="dataSource"/>
<!-- 扫描dao层 使用别名-->
<property name="typeAliasesPackage" value="com.zjitc.bean"/>
<!-- 配合加载映射文件 *mapper.xml-->
<property name="mapperLocations" value="classpath:mapper/*.xml"/>
</bean>
<!-- 自动生成dao,mapper-->
<!-- 4、配置扫描dao接口包,将dao层注入spring容器中-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!-- 配置给出需要扫描的dao层路径-->
<property name="basePackage" value="com.zjitc.dao"/>
<!-- 注入Spring容器中-->
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
</bean>
<!-- 自动扫描全部包,注解支持-->
<context:component-scan base-package="com.zjitc"/>
<!-- 配置事务注解-->
<bean id="transactionMapper" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<tx:annotation-driven></tx:annotation-driven>
</beans>
8.编写mapper.xml
<?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.zjitc.dao.IUserInfoDao">
<!-- 登陆-->
<select id="doLogin" parameterType="String" resultType="com.zjitc.bean.UserInfo">
select * from tb_user where username=#{username}
</select>
</mapper>
9.编写Service层
10.整合 Spring-MVC.xml 和 web.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:mvc="http://www.springframework.org/schema/mvc"
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-4.3.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.3.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">
<!-- 1、注解扫描位置/注解支持-->
<context:component-scan base-package="com.zjitc.controller"/>
<!-- <mvc:annotation-driven></mvc:annotation-driven>-->
<!-- 2、配置映射处理器和映射器-->
<bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping"/>
<bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter"/>
<!-- 3、视图解析器-->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/pages/"/>
<property name="suffix" value=".jsp"/>
</bean>
</beans>
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
version="3.1">
<!-- 配置加载类路径文件-->
<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>
<listener>
<listener-class>org.springframework.web.context.request.RequestContextListener</listener-class>
</listener>
<!-- 配置解决中文乱码-->
<filter>
<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-mvc.xml-->
<servlet>
<servlet-name>dispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring-mvc.xml</param-value>
</init-param>
<!-- 让服务器启动的时候,就进行创建servlet对象-->
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>dispatcherServlet</servlet-name>
<!--
/* 会把所有的请求都当做requestMappering给指定的路径,都会进controller
/ 页面不会去拦截
*.do
-->
<url-pattern>*.do</url-pattern>
</servlet-mapping>
</web-app>
11.导入页面/view
12.编写Controller
package com.zjitc.controller;
import com.github.pagehelper.PageInfo;
import com.zjitc.bean.UserInfo;
import com.zjitc.service.IUserInfoService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.ModelAndView;
import javax.servlet.http.HttpSession;
import java.io.IOException;
import java.util.List;
@Controller
@RequestMapping("/user")
public class UserInfoController {
@Autowired
private IUserInfoService userInfoService;
@RequestMapping("/doLogin.do")
public String doLogin(String username, String password, HttpSession session){
// 1、调用service,查询得到结果,自动补全返回值 ctrl+alt+v
UserInfo userInfo = userInfoService.doLogin(username);
// 判断
if(userInfo != null){
if (userInfo.getPassword().equals(password)){
System.out.println("密码正确,登陆成功");
session.setAttribute("userInfo",userInfo);
return "main";
}
else {
System.out.println("密码错误,登陆失败");
session.setAttribute("message","密码错误,登陆失败");
return "../login";
}
}
else {
System.out.println("用户不存在,请重新输入");
session.setAttribute("message","用户不存在,请重新输入");
return "../login";
}
}
}
13.进行测试