使用数据库和ssm框架（spring + springmvc + mybatis ）写一个简单的书籍管理网站

---

使用数据库和ssm框架（spring + springmvc + mybatis ）写一个简单的书籍管理网站

---

---

目录

---

1.如何创建web项目，新手可以参照下图：

打开安装好的idea（我的是2018，差别不是很大，可以仔细辨别）





到这里，我们已经建立了一个空的web项目。

2.开始按照使用ssm框架建立相应的包：最初情况如下：

右键main，new一个空的目录（Directory）,取名：Java，然后右键新生成的Java，点击Make
Directory，选择Sources Root(变成淡蓝色)，然后对Java建立com包，再com包下面建立bean,controller,dao,service四个包。

然后在main建立一个resourecs，右键点击Make Directory as 选择Resources Root

在resources下面建立一个mapper,导入下面素材：

素材下载百度云：链接：https://pan.baidu.com/s/1RWchAy8kH6er9CbzZ25RdA
提取码：iky3

3.修改配置pom.xml文件

*修改pom.xml文件：*可以选择先替换 <properties> </properties>

 <properties>
    <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版本号 -->
    <spring.version>5.0.2.RELEASE</spring.version>
    <!-- mybatis版本号 -->
    <mybatis.version>3.2.6</mybatis.version>
    <!-- log4j日志文件管理包版本 -->
    <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>
  </properties>

然后使用下面的替换 <dependencies> </dependencies>

   <dependencies>
        <!-- spring核心包 -->
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-core</artifactId>
          <version>${spring.version}</version>
        </dependency>
    
        <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>
    
      </dependencies>
 
 之后点击idea右下角会出现的 auto......（然后ide会自动导入各种jar包，直到输出界面出现 SUCCESS BUILD） 这样子就配置成功了。

4.开始准备编程了（以网页书籍查询遍历为例子）

建立如下位置的类和接口：

Userinfo类：

package com.zhongruan.bean;

public class Userinfo {
    private int id;
    private String username;
    private String password;

    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;
    }
}

UserController类：

package com.zhongruan.controller;

import com.zhongruan.bean.Userinfo;
import com.zhongruan.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> userinfos = userService.findAll ();
        ModelAndView modelAndView=new ModelAndView ();
        modelAndView.addObject ("ui",userinfos);
        modelAndView.setViewName ("allUser");
        return modelAndView;
    }
}

IUserDao接口：

package com.zhongruan.dao;

import com.zhongruan.bean.Userinfo;

import java.util.List;

public interface IUserDao {
    public List<Userinfo> findAll();
}

IUSerivices接口：

package com.zhongruan.service;

import com.zhongruan.bean.Userinfo;

import java.util.List;

public interface IUserService {
    public List<Userinfo> findAll();
}

impl里面新建一个UserServicesimpl类，去实现IUserSerivices接口：

package com.zhongruan.service.impl;

import com.zhongruan.bean.Userinfo;
import com.zhongruan.dao.IUserDao;
import com.zhongruan.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;
@Service//注解，IUserService放进spring
public class UserServiceimpl implements IUserService {
    @Autowired//注解，把spring中的iUserDao生成后取出
    IUserDao iUserDao;
    @Override
    public List<Userinfo> findAll() {
        return iUserDao.findAll ();
    }
}

5.开始建立数据库和表：

表的设计如下：

表的数据如下：

6.开始配置tomcat调试

点击Run,点击EditConfiguration

7.效果图

点击“点击查询全部用户信息”，进入alluser.jsp页面

欧克大功告成！下次更新更新用户信息操作！