JAVA中SSM框架的搭建实现CRUD的方法-eolink官网

JAVA中SSM框架的搭建实现CRUD的方法

最近在开发公司的一个系统，系统的框架是用ssm的框架搭建的，当然和这次写博客的不一样，它拥有很多的配置文件，企业级的开发所需要的配置文件是非常繁琐的，今天记录一下一个简单的SSM框架的搭建和实现一个CRUD的操作。

使用的是Maven插件来配置我们需要的jar包，由于操作不多，所以并没有配置很多，要注意自己使用的jdk的版本，选择不同版本号的jdk

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">

4.0.0

com.lr

ssm

war

0.0.1-SNAPSHOT

ssm Maven Webapp

http://maven.apache.org

4.0.2.RELEASE

3.2.8

1.7.12

1.2.17

junit

4.11

test

javax

javaee-api

7.0

com.fasterxml.jackson.core

jackson-databind

2.8.8

org.springframework

spring-test

${srping.version}

org.springframework

spring-core

${srping.version}

org.springframework

spring-oxm

${srping.version}

org.springframework

spring-tx

${srping.version}

org.springframework

spring-jdbc

${srping.version}

org.springframework

spring-aop

${srping.version}

org.springframework

spring-context

${srping.version}

org.springframework

spring-context-support

${srping.version}

org.springframework

spring-expression

${srping.version}

org.springframework

spring-orm

${srping.version}

org.springframework

spring-web

${srping.version}

org.springframework

spring-webmvc

${srping.version}

org.springframework

spring-aspects

${srping.version}

org.mybatis

mybatis

${mybatis.version}

org.mybatis

mybatis-spring

1.2.2

mysql

mysql-connector-java

5.1.35

commons-dbcp

1.4

jstl

1.2

taglibs

standard

1.1.2

log4j

${log4j.version}

org.slf4j

slf4j-api

${slf4j.version}

org.slf4j

slf4j-log4j12

${slf4j.version}

com.alibaba

fastjson

1.2.6

org.codehaus.jackson

jackson-mapper-asl

1.9.13

commons-fileupload

1.3.1

commons-io

2.4

commons-codec

1.10

net.sourceforge.jexcelapi

jxl

2.6

org.apache.poi

poi

3.8

org.apache.poi

poi-ooxml

3.9

Maven_Project

org.apache.maven.plugins

maven-compiler-plugin

2.3.2

1.7

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">

4.0.0

com.lr

ssm

war

0.0.1-SNAPSHOT

ssm Maven Webapp

http://maven.apache.org

4.0.2.RELEASE

3.2.8

1.7.12

1.2.17

junit

4.11

test

javax

javaee-api

7.0

com.fasterxml.jackson.core

jackson-databind

2.8.8

org.springframework

spring-test

${srping.version}

org.springframework

spring-core

${srping.version}

org.springframework

spring-oxm

${srping.version}

org.springframework

spring-tx

${srping.version}

org.springframework

spring-jdbc

${srping.version}

org.springframework

spring-aop

${srping.version}

org.springframework

spring-context

${srping.version}

org.springframework

spring-context-support

${srping.version}

org.springframework

spring-expression

${srping.version}

org.springframework

spring-orm

${srping.version}

org.springframework

spring-web

${srping.version}

org.springframework

spring-webmvc

${srping.version}

org.springframework

spring-aspects

${srping.version}

org.mybatis

mybatis

${mybatis.version}

org.mybatis

mybatis-spring

1.2.2

mysql

mysql-connector-java

5.1.35

commons-dbcp

1.4

jstl

1.2

taglibs

standard

1.1.2

log4j

${log4j.version}

org.slf4j

slf4j-api

${slf4j.version}

org.slf4j

slf4j-log4j12

${slf4j.version}

com.alibaba

fastjson

1.2.6

org.codehaus.jackson

jackson-mapper-asl

1.9.13

commons-fileupload

1.3.1

commons-io

2.4

commons-codec

1.10

net.sourceforge.jexcelapi

jxl

2.6

org.apache.poi

poi

3.8

org.apache.poi

poi-ooxml

3.9

Maven_Project

org.apache.maven.plugins

maven-compiler-plugin

2.3.2

1.7

然后配置数据库的连接，改成自己的数据库就行了

driver=com.mysql.jdbc.Driver

url=jdbc\:mysql\://locahost\:3306/db

username=root

password=root

maxActive=20

maxIdle=20

minIdle=1

maxWait=60000

配置文件spring-dao.xml，Spring会自动查找其下的类

xmlns:xsi="http://w3.org/2001/XMLSchema-instance" xmlns:p="http://springframework.org/schema/p"

xmlns:context="http://springframework.org/schema/context"

xmlns:mvc="http://springframework.org/schema/mvc"

xsi:schemaLocation="http://springframework.org/schema/beans

http://springframework.org/schema/beans/spring-beans-3.1.xsd

http://springframework.org/schema/context

http://springframework.org/schema/context/spring-context-3.1.xsd

http://springframework.org/schema/mvc

http://springframework.org/schema/mvc/spring-mvc-4.0.xsd">

xmlns:xsi="http://w3.org/2001/XMLSchema-instance" xmlns:p="http://springframework.org/schema/p"

xmlns:context="http://springframework.org/schema/context"

xmlns:mvc="http://springframework.org/schema/mvc"

xsi:schemaLocation="http://springframework.org/schema/beans

http://springframework.org/schema/beans/spring-beans-3.1.xsd

http://springframework.org/schema/context

http://springframework.org/schema/context/spring-context-3.1.xsd

http://springframework.org/schema/mvc

http://springframework.org/schema/mvc/spring-mvc-4.0.xsd">

配置文件Spring和Mybatis的整合文件

xmlns:xsi="http://w3.org/2001/XMLSchema-instance"

xmlns:p="http://springframework.org/schema/p"

xmlns:context="http://springframework.org/schema/context"

xmlns:mvc="http://springframework.org/schema/mvc"

xsi:schemaLocation="http://springframework.org/schema/beans

http://springframework.org/schema/beans/spring-beans-4.0.xsd

http://springframework.org/schema/context

http://springframework.org/schema/context/spring-context-4.0.xsd

http://springframework.org/schema/mvc

http://springframework.org/schema/mvc/spring-mvc-4.0.xsd">

xmlns:xsi="http://w3.org/2001/XMLSchema-instance"

xmlns:p="http://springframework.org/schema/p"

xmlns:context="http://springframework.org/schema/context"

xmlns:mvc="http://springframework.org/schema/mvc"

xsi:schemaLocation="http://springframework.org/schema/beans

http://springframework.org/schema/beans/spring-beans-4.0.xsd

http://springframework.org/schema/context

http://springframework.org/schema/context/spring-context-4.0.xsd

http://springframework.org/schema/mvc

http://springframework.org/schema/mvc/spring-mvc-4.0.xsd">

配置事物的文件

xmlns:xsi="http://w3.org/2001/XMLSchema-instance" xmlns:p="http://springframework.org/schema/p"

xmlns:context="http://springframework.org/schema/context"

xmlns:aop="http://springframework.org/schema/aop"

xmlns:tx="http://springframework.org/schema/tx"

xmlns:mvc="http://springframework.org/schema/mvc"

xsi:schemaLocation="http://springframework.org/schema/beans

http://springframework.org/schema/beans/spring-beans-3.1.xsd

http://springframework.org/schema/context

http://springframework.org/schema/context/spring-context-3.1.xsd

http://springframework.org/schema/aop

http://springframework.org/schema/aop/spring-aop-3.1.xsd

http://springframework.org/schema/tx

http://springframework.org/schema/tx/spring-tx-3.1.xsd">

class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

xmlns:xsi="http://w3.org/2001/XMLSchema-instance" xmlns:p="http://springframework.org/schema/p"

xmlns:context="http://springframework.org/schema/context"

xmlns:aop="http://springframework.org/schema/aop"

xmlns:tx="http://springframework.org/schema/tx"

xmlns:mvc="http://springframework.org/schema/mvc"

xsi:schemaLocation="http://springframework.org/schema/beans

http://springframework.org/schema/beans/spring-beans-3.1.xsd

http://springframework.org/schema/context

http://springframework.org/schema/context/spring-context-3.1.xsd

http://springframework.org/schema/aop

http://springframework.org/schema/aop/spring-aop-3.1.xsd

http://springframework.org/schema/tx

http://springframework.org/schema/tx/spring-tx-3.1.xsd">

class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

配置Springmvc.xml文件

xmlns:xsi="http://w3.org/2001/XMLSchema-instance" xmlns:p="http://springframework.org/schema/p"

xmlns:context="http://springframework.org/schema/context"

xmlns:mvc="http://springframework.org/schema/mvc"

xsi:schemaLocation="http://springframework.org/schema/beans

http://springframework.org/schema/beans/spring-beans-3.1.xsd

http://springframework.org/schema/context

http://springframework.org/schema/context/spring-context-3.1.xsd

http://springframework.org/schema/mvc

http://springframework.org/schema/mvc/spring-mvc-4.0.xsd">

好了！！！需要配置的文件已经配置完成了，足够我们进行一波操作了

接下来是后台的一些代码，这里主要是实体类，dao层，service层，controller层，我把后台的文件一起上传了，mapper.xml文件是实现方法最关键的地方

id, name, password, age

insert into user(name,password,age) values(#{name},#{password},#{age})

delete from user

where id = #{id}

update user set name=#{name},password=#{password},age=#{age} where id=#{id}

select * from user

package com.lr.dao;

import java.util.List;

import com.lr.dto.User;

public interface IUserDao {

//查询用户

public User queryByPrimaryKey(int id);

//删除用户

public int deleteByPrimaryKey(int id);

//更新用户

public int updateByPrimaryKey(User user);

//添加用户

public int addUser(User user);

//查询所有用户

public List findallUser();

}

package com.lr.service;

import java.util.List;

import com.lr.dto.User;

public interface IUserService {

//查询用户

public User getUserById(int userId);

//删除

public void deleteUser(int id);

//更新用户

public void updateUser(User user);

//添加用户

public void addUser(User user);

//查看所有用户

public List findallUser();

}

package com.lr.service.Impl;

import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;

import com.lr.dao.IUserDao;

import com.lr.dto.User;

import com.lr.service.IUserService;

@Service("userService")

public class UserServiceImpl implements IUserService{

@Resource

private IUserDao userdao;

public IUserDao getUserdao() {

return userdao;

}

public void setUserdao(IUserDao userdao) {

this.userdao = userdao;

}

//查询用户

@Override

public User getUserById(int userId) {

return userdao.queryByPrimaryKey(userId);

}

//更新用户

@Override

public void updateUser(User user) {

userdao.updateByPrimaryKey(user);

}

//删除用户

@Override

public void deleteUser(int id) {

userdao.deleteByPrimaryKey(id);

}

//添加用户

@Override

public void addUser(User user) {

userdao.addUser(user);

}

//查询所有用户

@Override

public List findallUser() {

return userdao.findallUser();

}

package com.lr.controller;

import java.util.List;

import javax.servlet.http.HttpServletRequest;

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.ResponseBody;

import com.lr.dto.User;

import com.lr.service.IUserService;

@Controller

public class UserController {

@Autowired

private IUserService userService;

public IUserService getUserService() {

return userService;

}

public void setUserService(IUserService userService) {

this.userService = userService;

}

//主页面

@RequestMapping("/")

public String userMgr() {

return "showUser";

}

//添加用户

@RequestMapping("/addUser")

@ResponseBody

public void userAdd(User user) {

userService.addUser(user);

}

//删除用户

@RequestMapping("/deleteUser")

@ResponseBody

public void deleteUser(int id){

userService.deleteUser(id);

}

//修改用户

@RequestMapping("/updateUser")

@ResponseBody

public void upadteUser(User user){

userService.updateUser(user);

}

//根据id查找用户

@RequestMapping("/showUser")

@ResponseBody

public User showUser(int id,Model model){

return userService.getUserById(id);

}

//查询所有用户

@RequestMapping("/findallUser")

@ResponseBody

public List findallUser(){

return userService.findallUser();

}

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

xmlns:xsi="http://w3.org/2001/XMLSchema-instance" xmlns:p="http://springframework.org/schema/p"

xmlns:context="http://springframework.org/schema/context"

xmlns:mvc="http://springframework.org/schema/mvc"

xsi:schemaLocation="http://springframework.org/schema/beans

http://springframework.org/schema/beans/spring-beans-3.1.xsd

http://springframework.org/schema/context

http://springframework.org/schema/context/spring-context-3.1.xsd

http://springframework.org/schema/mvc

http://springframework.org/schema/mvc/spring-mvc-4.0.xsd">

好了！！！需要配置的文件已经配置完成了，足够我们进行一波操作了

接下来是后台的一些代码，这里主要是实体类，dao层，service层，controller层，我把后台的文件一起上传了，mapper.xml文件是实现方法最关键的地方

id, name, password, age

insert into user(name,password,age) values(#{name},#{password},#{age})

parameterType="java.lang.Integer">

select

from user

where id = #{id}

delete from user

where id = #{id}

update user set name=#{name},password=#{password},age=#{age} where id=#{id}

select * from user

package com.lr.dao;

import java.util.List;

import com.lr.dto.User;

public interface IUserDao {

//查询用户

public User queryByPrimaryKey(int id);

//删除用户

public int deleteByPrimaryKey(int id);

//更新用户

public int updateByPrimaryKey(User user);

//添加用户

public int addUser(User user);

//查询所有用户

public List findallUser();

}

package com.lr.service;

import java.util.List;

import com.lr.dto.User;

public interface IUserService {

//查询用户

public User getUserById(int userId);

//删除

public void deleteUser(int id);

//更新用户

public void updateUser(User user);

//添加用户

public void addUser(User user);

//查看所有用户

public List findallUser();

}

package com.lr.service.Impl;

import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;

import com.lr.dao.IUserDao;

import com.lr.dto.User;

import com.lr.service.IUserService;

@Service("userService")

public class UserServiceImpl implements IUserService{

@Resource

private IUserDao userdao;

public IUserDao getUserdao() {

return userdao;

}

public void setUserdao(IUserDao userdao) {

this.userdao = userdao;

}

//查询用户

@Override

public User getUserById(int userId) {

return userdao.queryByPrimaryKey(userId);

}

//更新用户

@Override

public void updateUser(User user) {

userdao.updateByPrimaryKey(user);

}

//删除用户

@Override

public void deleteUser(int id) {

userdao.deleteByPrimaryKey(id);

}

//添加用户

@Override

public void addUser(User user) {

userdao.addUser(user);

}

//查询所有用户

@Override

public List findallUser() {

return userdao.findallUser();

}

package com.lr.controller;

import java.util.List;

import javax.servlet.http.HttpServletRequest;

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.ResponseBody;

import com.lr.dto.User;

import com.lr.service.IUserService;

@Controller

public class UserController {

@Autowired

private IUserService userService;

public IUserService getUserService() {

return userService;

}

public void setUserService(IUserService userService) {

this.userService = userService;

}

//主页面

@RequestMapping("/")

public String userMgr() {

return "showUser";

}

//添加用户

@RequestMapping("/addUser")

@ResponseBody

public void userAdd(User user) {

userService.addUser(user);

}

//删除用户

@RequestMapping("/deleteUser")

@ResponseBody

public void deleteUser(int id){

userService.deleteUser(id);

}

//修改用户

@RequestMapping("/updateUser")

@ResponseBody

public void upadteUser(User user){

userService.updateUser(user);

}

//根据id查找用户

@RequestMapping("/showUser")

@ResponseBody

public User showUser(int id,Model model){

return userService.getUserById(id);

}

//查询所有用户

@RequestMapping("/findallUser")

@ResponseBody

public List findallUser(){

return userService.findallUser();

}

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

姓名：

密码：

年龄：

输入用户id:

姓名

密码

年龄

输入用户id:

姓名

密码

年龄

输入用户id:

输入用户姓名:

输入密码：

输入用户年龄:

Iterator与LIstIterator接口在java中的区别有哪些

366 2023-03-11

JAVA中SSM框架的搭建实现CRUD的方法

vue项目接口域名动态的获取方法

zookeeper python接口实例详解

Iterator与LIstIterator接口在java中的区别有哪些

推荐文章

接口调用是什么意思？几种常用接口调用方式

接口设计原则

8款在线 API 接口文档管理工具

api管理系统是什么？

什么是接口调试？接口调试的步骤有哪些？

api 接口管理系统有哪些？

接口测试有几种测试方法

API文档生成工具有哪些？

微服务和api网关区别

交换机配置步骤

最近发表

热评文章

在线接口文档管理工具推荐，支持在线测试，HTTP接口

开源的在线接口文档wiki工具Mindoc的介绍与使

如何优雅的进行接口设计？接口设计的六大原则是什么？

什么是API测试,api检测公司

软件接口设计怎么做？前后端分离软件接口设计思路

接口管理平台推荐，几大接口管理平台总有一款适合你！