使用idea+maven+mysql+tomcat搭建简单的增删查改ssm框架系统的企业版写法

最新推荐文章于 2022-09-05 11:18:25 发布

LISHUAICSDN

最新推荐文章于 2022-09-05 11:18:25 发布

阅读量394

点赞数 1

文章标签： ssm

本文链接：https://blog.csdn.net/LISHUAICSDN/article/details/94402775

版权

1 阅读前提

请阅读此文章前，阅读基础版。
基础版：https://blog.csdn.net/LISHUAICSDN/article/details/93902373
补充版：https://blog.csdn.net/LISHUAICSDN/article/details/94211271
素材包：
链接：https://pan.baidu.com/s/1gzVvVKRQ_n1I3N5e7rtpiw
提取码：0t7o
项目下载地址：
链接：https://pan.baidu.com/s/14QE2KfTULez7qKgRQMzQ3A
提取码：wdoe

2 项目搭建

2.1新建项目：

在这里插入图片描述

2.2 建立项目下各包

右击目名：
在这里插入图片描述

如果右下角出现此问题，左键点击即可。

方法如上建立ssm_dao，ssm_service 俩个model。
建立ssm_web的model。与上面的不一样。

此处如果有问题，请看基础版的详细解释。

目录结构如下图所示：
在这里插入图片描述

2.3 包、接口、类等建立。

在这里插入图片描述

下图的文件是由素材包直接导入的。如有问题请看基础版的详细导入过程。

pom.xml的配置，基础版有详细讲解。pom.xml的配置信息在素材包里有。

<?xml version="1.0" encoding="UTF-8"?>

4.0.0

<groupId>firstone</groupId>
<artifactId>first</artifactId>
<packaging>pom</packaging>
<version>1.0-SNAPSHOT</version>
<modules>
    <module>ssm_bean</module>
    <module>ssm_dao</module>
    <module>ssm_service</module>
    <module>ssm_web</module>
</modules>

<properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.7</maven.compiler.source>
    <maven.compiler.target>1.7</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>
    <!-- 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>

3 编程

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

@Override
public String toString() {
    return "UserInfo{" +
            "id=" + id +
            ", username='" + username + '\'' +
            ", password='" + password + '\'' +
            '}';
}

}

3.2 IUserDao

 package com.zhongruan.dao;

import com.zhongruan.bean.UserInfo;

import java.util.List;

public interface IUserDao {
public UserInfo doLogin(UserInfo userInfo);

public List<UserInfo> findAll();

public void   adduserinfo(UserInfo userInfo);

public void  deleteuserinfo(int  id);

public void updateuserinfo(UserInfo userInfo);

}

3.3 UserService

    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 org.springframework.web.bind.annotation.RequestMapping;

 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 login(UserInfo userInfo) {
    UserInfo userInfo1 = userDao.doLogin(userInfo);
    if (userInfo1 != null) {
        return true;
    } else {
        return false;
    }

}

@Override
public void adduserinfo(UserInfo userInfo) {
    userDao.adduserinfo(userInfo);
}

@Override
public void  deleteuserinfo(int id) {
    userDao.deleteuserinfo(id);
    //return userDao.deleteuserinfo(id);
}

@Override
public void updateuserinfo(UserInfo userInfo) {
    userDao.updateuserinfo(userInfo);
}

}

3.4 IUserService

package com.zhongruan.service;
import com.zhongruan.bean.UserInfo;
import java.util.List;
 public interface IUserService {
public boolean login(UserInfo userInfo);

//List<UserInfo> queryAllUserInfo();
public List<UserInfo> findAll();

public void  adduserinfo(UserInfo userInfo);

public void  deleteuserinfo(int  id);

public void  updateuserinfo(UserInfo userInfo);

}

3.5 UserController

 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("/Login.do")
public ModelAndView login(UserInfo userInfo)
{
    ModelAndView mv =new ModelAndView();
    boolean falg= userService.login(userInfo);
    if (falg)
    {
        mv.setViewName("main");
    }else {
        mv.setViewName("../failer");
    }
    return mv;
}

@RequestMapping("/findAll.do")
public ModelAndView findAll() {
    List<UserInfo> all = userService.findAll();
    ModelAndView mv = new ModelAndView();
    mv.addObject("userinfos", all);
    mv.setViewName("user-list");
    return mv;
}

@RequestMapping("/deleteuserinfo.do")
public String deleteuserinfo (int id)
{
    userService.deleteuserinfo(id);
    return "redirect:findAll.do";
}
@RequestMapping("/toAddUser.do")
public String adduserinfo(UserInfo userInfo) {
    userService.adduserinfo(userInfo);
    return "redirect:findAll.do";
}
@RequestMapping("/update.do")
public String updateuserinfo(UserInfo userInfo) {
    userService.updateuserinfo(userInfo);
    return "redirect:findAll.do";
}
}

3.6 userMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>

 <select id="doLogin" resultType="com.zhongruan.bean.UserInfo" parameterType="UserInfo">
select* from userinfo where username = #{username} and password=#{password}

<select id="findAll" resultType="com.zhongruan.bean.UserInfo">
select * from userinfo

<insert id="adduserinfo" parameterType="UserInfo">
    insert into  userinfo(id,username,password) VALUE (#{id},#{username},#{password})
</insert>

<delete id="deleteuserinfo" parameterType="int">
    delete from userinfo where id=#{id}
</delete>

<update id="updateuserinfo" parameterType="UserInfo">
    update  userinfo
    set     username = #{username},password = #{password}
    where   id = #{id}
</update>

## 3.7 jsp页面的简单修改 login.jsp: ![在这里插入图片描述](https://img-blog.csdnimg.cn/2019070119573059.png) user-list ![在这里插入图片描述](https://img-blog.csdnimg.cn/20190701195816199.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xJU0hVQUlDU0RO,size_16,color_FFFFFF,t_70) ![在这里插入图片描述](https://img-blog.csdnimg.cn/20190701195918521.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xJU0hVQUlDU0RO,size_16,color_FFFFFF,t_70) user-add.jsp ![在这里插入图片描述](https://img-blog.csdnimg.cn/20190701195957120.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xJU0hVQUlDU0RO,size_16,color_FFFFFF,t_70)

user-update.jsp
在这里插入图片描述

LISHUAICSDN

关注

1
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
使用idea+maven+mysql+tomcat搭建简单的增删查改ssm框架系统的企业版写法

1 阅读前提请阅读此文章前，阅读基础版。基础版：https://blog.csdn.net/LISHUAICSDN/article/details/93902373补充版：https://blog.csdn.net/LISHUAICSDN/article/details/94211271素材包：链接：https://pan.baidu.com/s/1gzVvVKRQ_n1I3N5e7rt...
复制链接

扫一扫