java-CRUD

已于 2022-11-09 21:08:29 修改
阅读量258 收藏
点赞数
文章标签： java spring 开发语言
于 2022-11-09 20:17:50 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_62324316/article/details/127776973
版权

DepartmentController:

package com.teach.ssm.mvc.controller;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import com.teach.ssm.mvc.domain.Department;
import com.teach.ssm.mvc.domain.News;
import com.teach.ssm.mvc.dto.DepartmentDto;
import com.teach.ssm.mvc.service.DepartmentService;


@Controller
public class DepartmentController {
	
	@Autowired
	private DepartmentService departmentService ;
	
	@RequestMapping("/pubDepartment")
	@ResponseBody
	public Map<String, Object> pubNews(@RequestBody DepartmentDto departmentDto) {
		//1.
		Department department = departmentDto.getDepartment();
		
		//2.    service
		int count = departmentService.pubDepartment(department);
		
		Map<String, Object> ret = new HashMap(){{
			put("code", 200);
			put("message","添加数据成功");
		}};
		
		//4
		return ret;
	}
	
	@RequestMapping("/queryDepartmentByName")
	@ResponseBody
	public Map<String, Object> queryDepartmentByName(@RequestBody Map<String, Object> params){
		String name=(String)params.get("name");
		List<Department> departmentsList=departmentService.queryDepartmentByName(name);
		//3
		Map<String, Object> retData=new HashMap(){{
			put("departmentsList",departmentsList);
		}};
		Map<String, Object> ret = new HashMap(){{
			put("code", 200);
			put("message","根据name模糊查询成功");
			put("data", retData);
			
		}};
		return ret;
	}
	
	@RequestMapping("/modifyDepartmentNameById")
	@ResponseBody
	public Map<String, Object> modifyDepartmentNameById(@RequestBody Map<String, Object> params){
		Integer id=(Integer)params.get("id");
		String name = (String)params.get("name");
		Department department=new Department();
		department.setId(id);
		department.setName(name);
		
		departmentService.modifyDepartmentNameById(department);
		
		Map<String, Object> ret=new HashMap(){{
			put("code",200);
			put("message","修改id="+department.getId()+"数据成功");
		}};
		return ret;
	}
	
	@RequestMapping("/deleteDepartmentId")
	@ResponseBody
	private Map<String, Object>deleteDepartmentId(@RequestBody Map<String, Object> params){
		Integer id=(Integer)params.get("id");
		
		departmentService.deleteDepartmentId(id);
		
		Map<String, Object> ret=new HashMap(){{
			put("code",200);
			put("message","成功删除id="+params.get("id")+"的数据");
		}};
		return ret;
	}

}

NewsController:

package com.teach.ssm.mvc.controller;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import com.teach.ssm.mvc.domain.News;
import com.teach.ssm.mvc.dto.NewsDto;
import com.teach.ssm.mvc.service.NewsService;

@Controller
public class NewsController {
	
	
	@Autowired
	private NewsService newsService;
	
	@RequestMapping("/pubNews")
	@ResponseBody
	public Map<String, Object> pubNews(@RequestBody NewsDto newsDto){
		//1
		News news = newsDto.getNews();
		//2
		int pubCount = newsService.pubNews(news);
		//3
		
		Map<String, Object> ret = new HashMap(){{
			put("code", 200);
			put("message", "成功发布新闻"+pubCount+"条,id="+news.getId());
			
		}};
		//4
		return ret;
	}
	
	
	@RequestMapping("/queryNewsByTitle")
	@ResponseBody
	public Map<String, Object> queryNewsByTitle(@RequestBody Map<String, Object> params){
		String title=(String)params.get("title");
		List<News> newsList=newsService.queryNewsByTitle(title);
		//3
		Map<String, Object> retData=new HashMap(){{
			put("newsList",newsList);
		}};
		Map<String, Object> ret = new HashMap(){{
			put("code", 200);
			put("message","根据title模糊查询成功");
			put("data", retData);
			
		}};
		return ret;
	}
	
	
	
	@RequestMapping("/modifyNewsTitleById")
	@ResponseBody
	public Map<String, Object> modifyNewsTitleById(@RequestBody Map<String, Object> params){
		Integer id=(Integer)params.get("id");
		String title = (String)params.get("title");
		News news=new News();
		news.setId(id);
		news.setTitle(title);
		
		newsService.modifyNewsTitleById(news);
		
		Map<String, Object> ret=new HashMap(){{
			put("code",200);
			put("message","修改id="+news.getId()+"新闻成功！");
		}};
		return ret;
	}

	
	@RequestMapping("/deleteId")
	@ResponseBody
	private Map<String, Object>deleteId(@RequestBody Map<String, Object> params){
		Integer id=(Integer)params.get("id");
		
		newsService.deleteId(id);
		
		Map<String, Object> ret=new HashMap(){{
			put("code",200);
			put("message","成功删除id="+params.get("id")+"的新闻");
		}};
		return ret;
	}
	
	
	@RequestMapping("/removeNewsByIds")
	@ResponseBody
	public Map<String, Object> removeNewsByIds(@RequestBody Map<String, Object> params) {
		
		//获取参数
		List<Integer> idList = (List<Integer>)params.get("ids");
		Integer[] ids = idList.toArray(new Integer[0]);
		
		//调用service方法，并获取数据
		int deleteCount = newsService.removeNewsByIds(ids);
		
		//包装数据
		Map<String, Object> data = new HashMap() {{
			put("deleteCount", deleteCount);
		}};
		Map<String, Object> ret = new HashMap() {{
			put("code", 200);
			put("message", "根据id数组删除新闻成功");
			put("data", data);
		}};
		
		//返回数据
		return ret;
		
	}
   
	
}

TestController:

package com.teach.ssm.mvc.controller;

import java.util.HashMap;
import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import com.teach.ssm.mvc.service.NewsService;

@Controller
public class TestController {
	@Autowired

	private NewsService newsService;
	
	
	@RequestMapping("/test")
	@ResponseBody
	public Map<String, Object> test() {
		System.out.println("in TestController test.....");
		//1.获得请求
		
		//2.调用service方法，获取返回的数据
		//newsService.pubNews();
		
		//3.包装数据
		Map<String, Object> ret = new HashMap(){{
			put("code", 200);
			put("message", "ok");
		}};
		
		//4.返回数据
		return ret;
	}

}

DepartmentDao:

package com.teach.ssm.mvc.dao;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;

import com.teach.ssm.mvc.domain.Department;


@Repository
public interface DepartmentDao {
	@Insert("insert into department(name, description,status,goal) values(#{name}, #{description}, #{status}, #{goal})")
	@Options(useGeneratedKeys=true,keyProperty="id",keyColumn="id")
	public int createDepartment(Department department);
	
	//@Select("select id, name, description, status, goal form department where id =#{id}")
	//public Department readDepartmentById(int id);
	@Select("select id, name, description, status, goal from department where id=#{id}")
	public Department readDepartmentById(int id);

	@Select("select id, name, description, status, goal from department where name like #{name}")
	public List<Department> readDepartmentByName(String name);
	
	@Update("update department set name=#{name} where id=#{id}")
	public int updateDepartmentNameById(Department department); 
	
	@Delete("delete from department where id = #{id}")
	public int deleteDepartmentById(int id);
}

NewsDao:

package com.teach.ssm.mvc.dao;


import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;

import com.teach.ssm.mvc.domain.News;

@Repository
public interface NewsDao {
	
	
	@Insert("insert into news(title, author,content) values(#{title}, #{author}, #{content})")
	@Options(useGeneratedKeys=true,keyProperty="id",keyColumn="id")
	public int createNews(News news);
	
	@Select("select id, title, author, content form news where id =#{id}")
	public News readNewsById(int id);
	
	@Select("select id, title, author,content from news where title like #{title}")
	public List<News> readNewsByTitle(String title);
	
	@Update("update news set title=#{title} where id=#{id}")
	public int updateNewsTitleById(News news);
	
	
	@Delete("delete from news where id = #{id}")
	public int deleteNewsById(int id);
	
	@Delete("delete from news where id in (${ids})")
	public int deleteNewsByIds(@Param("ids") String ids);
}

Department:

package com.teach.ssm.mvc.domain;

public class Department {
     private int id;
     private String  name;
     private String description;
     private String status;
         private String goal;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() { 
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getDescription() {
		return description;
	}
	public void setDescription(String description) {
		this.description = description;
	}
	public String getStatus() {
		return status;
	}
	public void setStatus(String status) {
		this.status = status;
	}
	public String getGoal() {
		return goal;
	}
	public void setGoal(String goal) {
		this.goal = goal;
	}
	@Override
	public String toString() {
		return "Department [id=" + id + ", name=" + name + ", description=" + description + ", status=" + status
				+ ", goal=" + goal + "]";
	}
	
     
     
}

NewsDao:

package com.teach.ssm.mvc.domain;

public class News {
	private int id;
	private String title;
	private String author;
	private String content;

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getTitle() {
		return title;
	}

	public void setTitle(String title) {
		this.title = title;
	}

	public String getAuthor() {
		return author;
	}

	public void setAuthor(String author) {
		this.author = author;
	}

	public String getContent() {
		return content;
	}

	public void setContent(String content) {
		this.content = content;
	}

	@Override
	public String toString() {
		return "News [id=" + id + ", title=" + title + ", author=" + author + ", content=" + content + "]";
	}

}

DepartmentDto:

package com.teach.ssm.mvc.dto;

import com.teach.ssm.mvc.domain.Department;

public class DepartmentDto {
	private Department department;
	
	public Department getDepartment(){
		return department;
	}
	public void setDepartment(Department department){
		this.department=department;
	}

}

NewsDto:

package com.teach.ssm.mvc.dto;

import com.teach.ssm.mvc.domain.News;

public class NewsDto {
    private News news;

	public News getNews() {
		return news;
	}

	public void setNews(News news) {
		this.news = news;
	}
    
    
}

DepartmentService:

package com.teach.ssm.mvc.service;

import java.util.List;

import com.teach.ssm.mvc.domain.Department;
import com.teach.ssm.mvc.domain.News;


public interface DepartmentService {
	
	public int pubDepartment(Department department);
	
	//public List<Department> queryDepartmentByName(String name);
	public List<Department> queryDepartmentByName(String name);
	
	public int modifyDepartmentNameById(Department department);
	
	public int deleteDepartmentId(int id);

}

NewsService:

package com.teach.ssm.mvc.service;

import java.util.List;

import com.teach.ssm.mvc.domain.News;

public interface NewsService {
   
    public int pubNews(News news);
    
	public List<News> queryNewsByTitle(String title);
	
	public int modifyNewsTitleById(News news);
	
	public int deleteId(int id);

	int removeNewsByIds(Integer[] ids);
	
	
}

DepartmentServiceImpl:

package com.teach.ssm.mvc.service.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.teach.ssm.mvc.dao.DepartmentDao;
import com.teach.ssm.mvc.domain.Department;
import com.teach.ssm.mvc.service.DepartmentService;

@Service
public class DepartmentServiceImpl implements DepartmentService {

	@Autowired
	private DepartmentDao departmentDao;

	@Override
	public int pubDepartment(Department department) {
		int result = departmentDao.createDepartment(department);
		return result;
	}

	@Override
	public List<Department> queryDepartmentByName(String name) {
		// TODO Auto-generated method stub
		return departmentDao.readDepartmentByName(name);
	}

	@Override
	public int modifyDepartmentNameById(Department department) {
		// TODO Auto-generated method stub
		return departmentDao.updateDepartmentNameById(department);
	}

	@Override
	public int deleteDepartmentId(int id) {
		// TODO Auto-generated method stub
		return departmentDao.deleteDepartmentById(id);
	}

}

NewsServiceImpl:

package com.teach.ssm.mvc.service.impl;

import java.util.List;

import org.apache.commons.lang.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;


import com.teach.ssm.mvc.dao.NewsDao;
import com.teach.ssm.mvc.domain.News;
import com.teach.ssm.mvc.service.NewsService;

@Service
public class NewsServiceImpl implements NewsService{
	
	@Autowired
	private NewsDao newsDao;
	
	
	@Override
	public int pubNews(News news) {
		// TODO Auto-generated method stub
		int result = newsDao.createNews(news);
		//System.out.println(news.getId());
		return result;
	}


	@Override
	public List<News> queryNewsByTitle(String title) {
		// TODO Auto-generated method stub
		return newsDao.readNewsByTitle("%"+title+"%");
	}


	@Override
	public int modifyNewsTitleById(News news) {
		// TODO Auto-generated method stub
		return newsDao.updateNewsTitleById(news);
	}


	@Override
	public int deleteId(int id) {
		// TODO Auto-generated method stub
		return newsDao.deleteNewsById(id);
	}

	@Override
	public int removeNewsByIds(Integer[] ids) {
		// TODO Auto-generated method stub
		//ids=[1,2,3,4]    =>1,2,3,4
		return newsDao.deleteNewsByIds(StringUtils.join(ids,","));
	}
	

}

spring:

<context:component-scan base-package="com.teach.ssm.mvc.service" />

	<context:annotation-config />


	<!-- 引入db配置 -->
	<context:property-placeholder location="classpath:config/jdbc.properties" />
	<bean id="dataSource"
		class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="${jdbc.driver}" />
		<property name="url" value="${jdbc.url}" />
		<property name="username" value="${jdbc.username}" />
		<property name="password" value="${jdbc.password}" />
	</bean>

	<!-- 让mybatis使用spring创建的数据源 -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource" />
	</bean>
	<!-- 配置mybatis扫描的dao包 -->
	<bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.teach.ssm.mvc.dao" />
	</bean>

springmvc:

<!-- spring mvc 框架采用注解 注入 Bean -->
	<context:component-scan base-package="com.teach.ssm.mvc.controller" />

	<mvc:annotation-driven />


	<!-- 拦截器配置 <mvc:interceptors> <mvc:interceptor> <mvc:mapping path="/*" /> 
		<bean class="com.teach.ssm.mvc.interceptor.LogInterceptor" /> </mvc:interceptor> 
		</mvc:interceptors> -->

web.xml:

<!-- springMVC -->
	<servlet>
		<servlet-name>springMvcServlet</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
		<init-param>
			<param-name>contextConfigLocation</param-name>
			<param-value>classpath:config/springmvc.xml</param-value>
		</init-param>
		<load-on-startup>1</load-on-startup>
	</servlet>
	<servlet-mapping>
		<servlet-name>springMvcServlet</servlet-name>
		<url-pattern>/</url-pattern>
	</servlet-mapping>
	
	<!-- 配置spring -->
    <context-param>
	     <param-name>contextConfigLocation</param-name>
	     <param-value>classpath:config/spring.xml</param-value>
     </context-param>
     <listener>
	      <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
	
	
	<welcome-file-list>
		<welcome-file>index.jsp</welcome-file>
	</welcome-file-list>

今天要吃什么呢
关注
java web 简单的crud
12-13
简单的web crud 适合小白使用 ，里面提供的是源代码，供大家参考，
java后端CRUD功能实现
daniaoxp的博客
09-14 3484
1、springboot框架建立 框架建立可参考以下博客，需要把补充部分也完成 https://blog.csdn.net/daniaoxp/article/details/119811741 内容稍有不同，还要做以下改变。 改变1： 下面操作不需要 改变2： 在HelloApplication.java文件中新增**@MapperScan（“com.xp.dao”）** 改变3： application.yml文件内容换成以下内容 server: port: 8888 spring: dat
java中灵活配置简单易用功能强大的MybatisPlus基础CRUD增删改查代码一键生成器的工具类
LeungChunwai的博客
11-30 405
java中灵活配置简单易用功能强大的MybatisPlus基础CRUD增删改查代码一键生成器的工具类
Java CRUD操作实现与示例解析
最新发布
weixin_42299150的博客
07-04 11
在软件开发中，CRUD(创建Create、读取Read、更新Update、删除Delete)是常见的数据操作范式，涵盖了基本的数据管理功能。本文将深入探讨如何使用Java语言实现CRUD操作，包括数据库的连接、数据操作的实现方法以及示例代码的详细解析。无论是初学者还是有一定经验的开发者，都可以从本文中学习如何在Java中有...
Java学习- 数据库的CRUD操作
qq_44813352的博客
03-04 303
SQL分类 1) DDL(Data Definition Language)数据定义语言 用来定义数据库对象：数据库，表，列等。关键字：create, drop,alter 等 2) DML(Data Manipulation Language)数据操作语言 用来对数据库中表的数据进行增删改。关键字：insert, delete, update 等 3) DQL(Data Query Langu...
Java-CRUD-Repository
04-12
在Java-CRUD-Repository项目中，这些功能通常通过以下步骤实现： 1. 定义Employee实体类。 2. 创建Repository接口，扩展JpaRepository或自定义其方法。 3. 实现Service层，处理业务逻辑，如验证输入、处理异常等。 4...
java-crud-api:完整的php-crud-api项目的Java端口（单个文件REST API）
05-19
要开始使用 Java CRUD API，你需要首先解压 `java-crud-api-master`，然后根据项目文档配置数据库连接，构建项目并运行。在开发过程中，你可以利用提供的测试用例来验证功能的正确性，并根据实际需求进行定制和扩展...
java-crud：Java CRUD的回购指南
02-02
使用Liquibase迁移的Hibernate和JPA CRUD操作在此存储库中，您将找到使用Hibernate和JPA对H2数据库执行基本CRUD操作的代码。 该存储库还展示了如何使用Liquibase执行数据库迁移。 accopanying教程位于先决条件Maven...
restful-crud-实验.tar.gz
06-28
这个名为"restful-crud-实验.tar.gz"的压缩包文件显然是一个教学资源，旨在帮助学习者理解如何在SpringBoot应用中实现基于REST的创建（Create）、读取（Read）、更新（Update）和删除（Delete）功能。 首先，我们要...
java-crud-api-with-springboot-and-mysql:使用Springboot学习Java API CRUD
05-02
先决条件 Windows-版本10 -版本1.8.0 IDE-版本4.8.0 -版本2.0 -版本1.18.0 版本4.8.1 -版本1.5.14 -版本5.7.10 步 将生成的项目从Spring Boot复制到Eclipse工作区 从文件系统打开项目......
Java连接mysql实现crud
09-14
用Java编写链接mysql数据库，内附sql文件，有注释，适合新手学习
CRUD的完整实例
08-15
这个java项目功能是用户登录，并进行信息的增删改查操作。 开发使用的是ssh开发框架，把程序导入，然后附加数据库就可以了，保证能运行的
ssm-crud整合项目源码
08-15
SSM高级整合视频ssm-crud整合项目源码SSM高级整合视频ssm-crud整合项目源码SSM高级整合视频ssm-crud整合项目源码SSM高级整合视频ssm-crud整合项目源码
SSM项目CRUD实战项目
11-21
SSM项目CRUD实战项目代码，博客地址：https://blog.csdn.net/q283614346/article/details/83933586
java代码对数据库数据的CRUD操作
weixin_56887123的博客
04-16 1270
提示：文章写完后，目录可以自动生成，如何生成可参考右边的帮助文档 提示：文章写完后，目录可以自动生成，如何生成可参考右边的帮助文档 java代码对数据库数据的CRUD操作前言一、CRUD、JDBC是什么？二、操作步骤1.连接mqsql数据库2.对数据库中的表进行增、删、改、查总结前言一、pandas是什么？二、使用步骤1.引入库2.读入数据总结 前言 提示：这里可以添加本文要记录的大概内容： 例如：随着人工智能的不断发展，机器学习这门技术也越来越重要，很多人都开启了学习机器学习，本文就介绍了机器学习的
CRUD工具类
You辉编程的博客
08-15 167
CRUD生成工具
java怎么写crud_java后端怎么避免只会写CRUD？
weixin_35918994的博客
02-23 447
管理学大师彼得·德鲁克的著作《卓有成效的管理者》一书中提到了如下几个核心观点：1.管理者不专指高级经理，而是泛指知识工作者、经理、专业人员，不论其是否有下属，不论职位高低，只要是因为职位和专业在其工作中做影响绩效和成果的决策，即可成为管理者；2.管理者的工作必须卓有成效；3.卓有成效是可以学会的；4.有效的管理者注重自己对外界的价值，由价值目标驱动自己的工作，而非一味无脑等待工作安排。在日常接到新...
Javaweb学习笔记2（JDBC的CRUD、工具类的提取与测试、批处理）
Huamang的博客
04-10 108
JDBC执行增删改查 insert insert用的执行sql语句的方法是executeUpdate()，返回影响的记录数量 package com.jdbctest; import org.junit.Test; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; public class Insert { @Te
mongodb之java CRUD 简单操作
热门推荐
上善若水 厚德载物
12-16 1万+
驱动包下载：https://github.com/mongodb/mongo-java-driver/downloads 我下载的是 mongo-2.8.0.jar — Version 2.8.0 打开mongo shell -- 新建数据库test --( use test) 打开eclipse新建工程，把junit,mongo-2.8.0.jar导入。 新建测试类如下： pa
用java 写CRUD
02-07
Here's an example of how you might implement CRUD operations in Java using the JDBC API: ``` import java.sql.*; public class CRUDExample { public static void main(String[] args) throws ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值