用户管理系统环境搭建和查询

用户管理系统环境搭建和查询

用IDEA+Maven+SSM框架实现的登陆功能

使用的软件：

IntelliJ IDEA 2018.2.2 x64
jdk1.8
apache-tomcat-7.0.94
apache-maven-3.6.0
Webyog-SQLyog-Ultimate12.0.8.0
mysql-5.5.58-winx64

文件结构

配置pom.xml文件

接下来将ssm_parent目录下的pom.xml文件中的properties和libraries改为老师给的，前者用以配置数据库版本，后者用以引用jar包。
修改内容如下：

<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>1.8</maven.compiler.source>
<maven.compiler.target>1.8</maven.compiler.target>

<spring.version>5.0.2.RELEASE</spring.version>

<mybatis.version>3.2.6</mybatis.version>

<slf4j.version>1.7.7</slf4j.version>
<log4j.version>1.2.17</log4j.version>
<c3p0.version>0.9.5.2</c3p0.version>
<taglibs.version>1.1.2</taglibs.version>

org.springframework spring-core ${spring.version}

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-web</artifactId>
    <version>${spring.version}</version>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-oxm</artifactId>
    <version>${spring.version}</version>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-tx</artifactId>
    <version>${spring.version}</version>
</dependency>

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>${spring.version}</version>
</dependency>

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-webmvc</artifactId>
    <version>${spring.version}</version>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-aop</artifactId>
    <version>${spring.version}</version>
</dependency>

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-context-support</artifactId>
    <version>${spring.version}</version>
</dependency>

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-test</artifactId>
    <version>${spring.version}</version>
</dependency>
<!-- mybatis核心包 -->
<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>${mybatis.version}</version>
</dependency>
<!-- mybatis/spring包 -->
<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis-spring</artifactId>
    <version>1.2.2</version>
</dependency>
<!-- 导入java ee jar 包 -->
<dependency>
    <groupId>javax</groupId>
    <artifactId>javaee-api</artifactId>
    <version>7.0</version>
</dependency>

<!-- 导入Mysql数据库链接jar包 -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.30</version>
</dependency>
<!-- 导入dbcp的jar包，用来在applicationContext.xml中配置数据库 -->
<dependency>
    <groupId>commons-dbcp</groupId>
    <artifactId>commons-dbcp</artifactId>
    <version>1.2.2</version>
</dependency>
<!-- JSTL标签类 -->
<dependency>
    <groupId>jstl</groupId>
    <artifactId>jstl</artifactId>
    <version>1.2</version>
</dependency>
<!-- 日志文件管理包 -->
<!-- log start -->
<dependency>
    <groupId>log4j</groupId>
    <artifactId>log4j</artifactId>
    <version>${log4j.version}</version>
</dependency>


<!-- 数据连接池 -->
<dependency>
    <groupId>com.mchange</groupId>
    <artifactId>c3p0</artifactId>
    <version>${c3p0.version}</version>
</dependency>

<dependency>
    <groupId>taglibs</groupId>
    <artifactId>standard</artifactId>
    <version>${taglibs.version}</version>
</dependency>

<dependency>
    <groupId>org.slf4j</groupId>
    <artifactId>slf4j-api</artifactId>
    <version>${slf4j.version}</version>
</dependency>
<dependency>
    <groupId>org.slf4j</groupId>
    <artifactId>slf4j-log4j12</artifactId>
    <version>${slf4j.version}</version>
</dependency>

<!-- 导入servlet-api/jsp -->
<dependency>
    <groupId>javax.servlet</groupId>
    <artifactId>javax.servlet-api</artifactId>
    <version>3.1.0</version>
    <scope>provided</scope>
</dependency>
<!-- https://mvnrepository.com/artifact/javax.servlet.jsp/javax.servlet.jsp-api -->
<dependency>
    <groupId>javax.servlet.jsp</groupId>
    <artifactId>javax.servlet.jsp-api</artifactId>
    <version>2.3.1</version>
    <scope>provided</scope>
</dependency>

IUserDao中的内容为

<?xml version="1.0" encoding="UTF-8" ?> select * from userinfo select * from userinfo where username=#{username} and password=#{password}

UserMapper中的内容为

<?xml version="1.0" encoding="UTF-8" ?> select * from userinfo select * from userinfo where username=#{username} and password=#{password}

IUserService内容如下

package abc.service;

import abc.bean.UserInfo;

import java.util.List;

public interface IUserService {
public List findAll();

public boolean doLogin(UserInfo userInfo);

}

UserService内容如下

package abc.service.Impl;

import abc.bean.UserInfo;
import abc.dao.IUserDao;
import abc.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class UserService implements IUserService {
@Autowired
private IUserDao userDao;

@Override
public List<UserInfo> findAll() {
    return userDao.findAll();
}

@Override
public boolean doLogin(UserInfo userInfo) {
    UserInfo userInfo1 = userDao.doLogin(userInfo);
    if(userInfo1!=null)
    {
        return true;
    }
    else
        return false;
}

}

UserController内容如下：

package abc.controller;

import abc.bean.UserInfo;
import abc.service.IUserService;
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 java.util.List;
@Controller
@RequestMapping(“user”)
public class UserController {
@Autowired
private IUserService userService;

@RequestMapping("findAll.do")
public ModelAndView findAll()
{
    List<UserInfo> infos=userService.findAll();

    ModelAndView mv = new ModelAndView();
    mv.addObject("infos",infos);
    mv.setViewName("user-list");
    return mv;

}

@RequestMapping("login.do")
public ModelAndView dologin(UserInfo userInfo)
{
    boolean flag=userService.doLogin(userInfo);
    ModelAndView modelAndView=new ModelAndView();

    if(flag)
    {
        modelAndView.setViewName("main");

    }
    else{
        modelAndView.setViewName("../failer");
    }
    return  modelAndView;
}

}

配置网页文件：

接着在ssm_web目录下的webapp文件夹中粘贴css、img、pages文件夹（这个三个文件夹下的内容老师已经帮我们写好了），并且粘贴failer.jsp、index.jsp、login.jsp文件（老师已经帮我们写好）

配置其他文件

接下来在ssm_web目录下的resources文件夹中粘贴applicationContext.xml、db.properties、log4j.properties、spring-mvc.xml四个文件（老师已帮我们写好），并且修改一下db.properties中的一些数据库连接信息，还有applicationContext.xml和spring-mvc.xml中的一些适配自己项目的地方。

运行结果