devbox
Cpp五条
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Springboot快速开发-书本信息管理系统（项目源码）_springboot图书管理系统源码

作者：Cpp五条 | 2024-06-02 16:55:42

赞

踩

springboot图书管理系统源码

【我后续会发一个资源包，里面是所有代码，数据库表设计也有，大学生可以直接用，导入数据库运行，再导入后端项目和前端项目，再去网页运行就好了，效果图下面有】

 

1、考核要求：

  1. 数据库：MYSQL5.7+
  2. 后台技术：SpringBoot
  3. 前端技术：vue+elementui
  4. 代码简洁、有合理的注解，前面页面排版工整

2、考核注意事项：

1.运行sql脚本，创建数据库及书本表（根据我的实体类建表就可以了，整个项目可直接运行，跨域问题已处理，前后端的端口也已处理）

2.后台代码注意事项

        a.Maven地址的修改（修改成你自己的）；

        b.依赖可能不在本地，需要联网重新下载；

        c.jdbc.properties设置，数据库相关配置：数据库名/账号/密码，请修改成自己电脑所对应的账号和密码。

        d.generatorConfig.xml设置:Ⅰ：修改classPathEntry配置，更换成本地maven仓库中mysql数据库jdbc驱动jar包的位置；Ⅱ：修改table配置表信息(tableName和domainObjectName)，更换成考试中对应数据库表；Ⅲ：点击Edit Configurations...配置，添加Maven，输入命名：mybatis-gerenator:gerenate -e；

        e.application.yml设置:数据库相关设置：数据库名/帐号/密码，请修改成自己电脑对应的帐号和密码

        f.由于电脑tomcat以及jdk的安装位置不一样，请重新配置jdk和tomcat

        g.以上步骤完成，先不要写任何代码，先将web项目发布至tomcat并启动，如果首页访问成功，表示web项目部署成功，可以开始编写后台代码了

3.前端代码注意事项：

1.vue项目框架已搭建完成，为减小源码大小，相关模块已删除，运行项目前，请先进入vue项目根目录，使用npm install命令下载相关模块(此步骤需要联网)

2.项目启动后无需添加路由或*.vue文件，运行后会直接跳转到BookList.vue，在此vue文件中添加相关功能即可

3.开动

generatorConfig.xml、jdbc.properties、application.yml这三个配置文件我就不展示了，有需要的下载我的资源包

数据库表建好之后→导入前端（可以把需要的依赖先下载，然后干自己的事）→导入后端（进行我上面所说的那些后端操作）→写完代码运行后端→在写前端代码（运行前端）

以下是后端的代码：

Model层：Book

  1. package com.zking.spboot.model;
  2.  
  3. public class Book {
  4.     private Integer id;
  5.  
  6.     private String bookname;
  7.  
  8.     private Float price;
  9.  
  10.     private String booktype;
  11.  
  12.     public Book(Integer id, String bookname, Float price, String booktype) {
  13.         this.id = id;
  14.         this.bookname = bookname;
  15.         this.price = price;
  16.         this.booktype = booktype;
  17.     }
  18.  
  19.     public Book() {
  20.         super();
  21.     }
  22.  
  23.     public Integer getId() {
  24.         return id;
  25.     }
  26.  
  27.     public void setId(Integer id) {
  28.         this.id = id;
  29.     }
  30.  
  31.     public String getBookname() {
  32.         return bookname;
  33.     }
  34.  
  35.     public void setBookname(String bookname) {
  36.         this.bookname = bookname;
  37.     }
  38.  
  39.     public Float getPrice() {
  40.         return price;
  41.     }
  42.  
  43.     public void setPrice(Float price) {
  44.         this.price = price;
  45.     }
  46.  
  47.     public String getBooktype() {
  48.         return booktype;
  49.     }
  50.  
  51.     public void setBooktype(String booktype) {
  52.         this.booktype = booktype;
  53.     }
  54. }

Mapper层：BookMapper

  1. package com.zking.spboot.mapper;
  2.  
  3. import com.zking.spboot.model.Book;
  4. import org.springframework.stereotype.Repository;
  5.  
  6. import java.util.List;
  7. @Repository
  8. public interface BookMapper {
  9.  
  10.     /**
  11.      * 根据书本名称模糊查询
  12.      * @param book
  13.      * @return
  14.      */
  15.     List<Book> queryAll(Book book);
  16.  
  17.     int deleteByPrimaryKey(Integer id);
  18.  
  19.     int insert(Book record);
  20.  
  21.     int insertSelective(Book record);
  22.  
  23.     Book selectByPrimaryKey(Integer id);
  24.  
  25.     int updateByPrimaryKeySelective(Book record);
  26.  
  27.     int updateByPrimaryKey(Book record);
  28. }

BookMapper.xml 

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
  3. <mapper namespace="com.zking.spboot.mapper.BookMapper" >
  4.   <resultMap id="BaseResultMap" type="com.zking.spboot.model.Book" >
  5.     <constructor >
  6.       <idArg column="id" jdbcType="INTEGER" javaType="java.lang.Integer" />
  7.       <arg column="bookname" jdbcType="VARCHAR" javaType="java.lang.String" />
  8.       <arg column="price" jdbcType="REAL" javaType="java.lang.Float" />
  9.       <arg column="booktype" jdbcType="VARCHAR" javaType="java.lang.String" />
  10.     </constructor>
  11.   </resultMap>
  12.   <sql id="Base_Column_List" >
  13.     id, bookname, price, booktype
  14.   </sql>
  15.   <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
  16.     select 
  17.     <include refid="Base_Column_List" />
  18.     from t_book
  19.     where id = #{id,jdbcType=INTEGER}
  20.   </select>
  21.     <select id="queryAll" resultType="com.zking.spboot.model.Book">
  22.       select <include refid="Base_Column_List"/> from t_book where 1=1
  23.       <if test="null!=bookname and ''!=bookname">
  24.         and bookname like concat('%',#{bookname},'%')
  25.       </if>
  26.     </select>
  27.     <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >
  28.     delete from t_book
  29.     where id = #{id,jdbcType=INTEGER}
  30.   </delete>
  31.   <insert id="insert" parameterType="com.zking.spboot.model.Book" >
  32.     insert into t_book (id, bookname, price, 
  33.       booktype)
  34.     values (#{id,jdbcType=INTEGER}, #{bookname,jdbcType=VARCHAR}, #{price,jdbcType=REAL}, 
  35.       #{booktype,jdbcType=VARCHAR})
  36.   </insert>
  37.   <insert id="insertSelective" parameterType="com.zking.spboot.model.Book" >
  38.     insert into t_book
  39.     <trim prefix="(" suffix=")" suffixOverrides="," >
  40.       <if test="id != null" >
  41.         id,
  42.       </if>
  43.       <if test="bookname != null" >
  44.         bookname,
  45.       </if>
  46.       <if test="price != null" >
  47.         price,
  48.       </if>
  49.       <if test="booktype != null" >
  50.         booktype,
  51.       </if>
  52.     </trim>
  53.     <trim prefix="values (" suffix=")" suffixOverrides="," >
  54.       <if test="id != null" >
  55.         #{id,jdbcType=INTEGER},
  56.       </if>
  57.       <if test="bookname != null" >
  58.         #{bookname,jdbcType=VARCHAR},
  59.       </if>
  60.       <if test="price != null" >
  61.         #{price,jdbcType=REAL},
  62.       </if>
  63.       <if test="booktype != null" >
  64.         #{booktype,jdbcType=VARCHAR},
  65.       </if>
  66.     </trim>
  67.   </insert>
  68.   <update id="updateByPrimaryKeySelective" parameterType="com.zking.spboot.model.Book" >
  69.     update t_book
  70.     <set >
  71.       <if test="bookname != null" >
  72.         bookname = #{bookname,jdbcType=VARCHAR},
  73.       </if>
  74.       <if test="price != null" >
  75.         price = #{price,jdbcType=REAL},
  76.       </if>
  77.       <if test="booktype != null" >
  78.         booktype = #{booktype,jdbcType=VARCHAR},
  79.       </if>
  80.     </set>
  81.     where id = #{id,jdbcType=INTEGER}
  82.   </update>
  83.   <update id="updateByPrimaryKey" parameterType="com.zking.spboot.model.Book" >
  84.     update t_book
  85.     set bookname = #{bookname,jdbcType=VARCHAR},
  86.       price = #{price,jdbcType=REAL},
  87.       booktype = #{booktype,jdbcType=VARCHAR}
  88.     where id = #{id,jdbcType=INTEGER}
  89.   </update>
  90. </mapper>

Service层：BookService

  1. package com.zking.spboot.service;
  2.  
  3. import com.zking.spboot.model.Book;
  4. import org.springframework.stereotype.Repository;
  5.  
  6. import java.util.List;
  7.  
  8. public interface BookService {
  9.  
  10.     /**
  11.      * 根据书本名称模糊查询
  12.      * @param book
  13.      * @return
  14.      */
  15.     List<Book> queryAll(Book book);
  16.  
  17.     /**
  18.      * 新增书本
  19.      * @param record
  20.      * @return
  21.      */
  22.     int insert(Book record);
  23.  
  24. }

impl层：BookServiceImpl

  1. package com.zking.spboot.service.impl;
  2.  
  3. import com.zking.spboot.mapper.BookMapper;
  4. import com.zking.spboot.model.Book;
  5. import com.zking.spboot.service.BookService;
  6. import org.springframework.beans.factory.annotation.Autowired;
  7. import org.springframework.stereotype.Service;
  8.  
  9. import java.util.List;
  10.  
  11. /**
  12.  * 实现类
  13.  */
  14. @Service
  15. public class BookServiceImpl implements BookService {
  16.  
  17.     @Autowired
  18.     private BookMapper bookMapper;
  19.  
  20.     @Override
  21.     public List<Book> queryAll(Book book) {
  22.         return bookMapper.queryAll(book);
  23.     }
  24.  
  25.     @Override
  26.     public int insert(Book record) {
  27.         return bookMapper.insert(record);
  28.     }
  29.  
  30.  
  31. }

Controller层：BookController

  1. package com.zking.spboot.controller;
  2.  
  3. import com.zking.spboot.model.Book;
  4. import com.zking.spboot.service.BookService;
  5. import lombok.AllArgsConstructor;
  6. import lombok.Data;
  7. import lombok.NoArgsConstructor;
  8. import org.springframework.beans.factory.annotation.Autowired;
  9. import org.springframework.web.bind.annotation.RequestMapping;
  10. import org.springframework.web.bind.annotation.RestController;
  11.  
  12. import java.util.List;
  13.  
  14. @RestController
  15. @RequestMapping("/book")
  16. public class BookController {
  17.  
  18.     @Autowired
  19.     private BookService bookService;
  20.  
  21.     @RequestMapping("/addBook")
  22.     public JsonResponsBody<?> addBook(Book book){
  23.         bookService.insert(book);
  24.         return new JsonResponsBody<>();
  25.     }
  26.  
  27.     @RequestMapping("/queryAll")
  28.     public JsonResponsBody<List<Book>> queryAll(Book book){
  29.         List<Book> books = bookService.queryAll(book);
  30.         return new JsonResponsBody<>(200,"OK",books);
  31.     }
  32.  
  33.     @Data
  34.     @AllArgsConstructor
  35.     @NoArgsConstructor
  36.     class JsonResponsBody<T>{
  37.         private int code=200;
  38.         private String mag="Ok";
  39.         private T data;
  40.     }
  41. }

跨域问题处理：

  1. package com.zking.spboot;
  2.  
  3. import org.apache.ibatis.annotations.Mapper;
  4. import org.mybatis.spring.annotation.MapperScan;
  5. import org.springframework.boot.SpringApplication;
  6. import org.springframework.boot.autoconfigure.SpringBootApplication;
  7. import org.springframework.context.annotation.EnableAspectJAutoProxy;
  8. import org.springframework.transaction.annotation.EnableTransactionManagement;
  9.  
  10. @MapperScan("com.zking.spboot.mapper")
  11. @EnableTransactionManagement
  12. @EnableAspectJAutoProxy
  13. @SpringBootApplication
  14. public class SpbootApplication {
  15.  
  16.     public static void main(String[] args) {
  17.         SpringApplication.run(SpbootApplication.class, args);
  18.     }
  19.  
  20. }

以下是前端的代码：

前端接收后端的请求路径,src下面api下面的action.js

  1. /**
  2.  * 对后台请求的地址的封装，URL格式如下：
  3.  * 模块名_实体名_操作
  4.  */
  5. export default {
  6. 	//服务器
  7. 	'SERVER': 'http://localhost:8080/spboot',
  8. 	'ADD':'book/addBook',
  9. 	'ALL':'book/queryAll',
  10. 	//获得请求的完整地址，用于mockjs测试时使用
  11. 	'getFullPath': k => {
  12. 		return this.SERVER + this[k];
  13. 	}
  14. }

 前端src下面的router下面的index.js

  1. import Vue from 'vue'
  2. import Router from 'vue-router'
  3. import BookList from '@/views/BookList'
  4.  
  5. Vue.use(Router)
  6.  
  7. export default new Router({
  8.   routes: [
  9.     {
  10.       path: '/',
  11.       name: 'BookList',
  12.       component: BookList
  13.     }
  14.   ]
  15. })

前端页面：

  1. <template>
  2. 	<div>
  3. 		<!-- <h1 align="center">SpringBoot阶段机试，ts={{ts}}</h1> -->
  4. 		<!-- 1.搜索栏 -->
  5. 		<el-form :inline="true">
  6. 			<el-form-item label="书本名称">
  7. 				<el-input v-model="bookname" placeholder="书本名称"></el-input>
  8. 			</el-form-item>
  9. 			<el-form-item>
  10. 				<el-button type="primary" @click="query">查询</el-button>
  11. 				<el-button type="primary" @click="open">新增</el-button>
  12. 			</el-form-item>
  13. 		</el-form>
  14. 		<!-- 2.数据表格 -->
  15. 		<el-table :data="tableData" style="width: 100%">
  16. 			<el-table-column prop="id" label="书本编号" width="180">
  17. 			</el-table-column>
  18. 			<el-table-column prop="bookname" label="书本名称" width="180">
  19. 			</el-table-column>
  20. 			<el-table-column prop="price" label="书本价格">
  21. 			</el-table-column>
  22. 			<el-table-column prop="booktype" label="书本类型">
  23. 			</el-table-column>
  24. 		</el-table>
  25. 		<!-- 3.弹出框 -->
  26. 		<el-dialog title="新增" :visible.sync="dialogFormVisible" @close="close">
  27. 			<el-form :model="book" :rules="rules" ref="book">
  28. 				<el-form-item prop="bookname" label="书本名称" label-width="90px">
  29. 					<el-input v-model="book.bookname" autocomplete="off"></el-input>
  30. 				</el-form-item>
  31. 				<el-form-item prop="price" label="书本价格" label-width="90px">
  32. 			  <el-input v-model="book.price" autocomplete="off"></el-input>
  33. 				</el-form-item>
  34. 				<el-form-item prop="booktype" label="书本类型" label-width="90px">
  35. 					<el-select style="width:100%;" v-model="book.booktype" placeholder="请选择书本类型">
  36. 						<el-option label="玄幻" value="玄幻"></el-option>
  37. 						<el-option label="文学" value="文学"></el-option>
  38. 					</el-select>
  39. 				</el-form-item>
  40. 			</el-form>
  41. 			<div slot="footer" class="dialog-footer">
  42. 				<el-button @click="dialogFormVisible = false">取 消</el-button>
  43. 				<el-button type="primary" @click="save">确 定</el-button>
  44. 			</div>
  45. 		</el-dialog>
  46. 	</div>
  47. </template>
  48.  
  49. <script>
  50. 	export default {
  51. 		data: function() {
  52. 			return {
  53. 				ts: new Date().getTime(),
  54. 				bookname: '',
  55. 				tableData: [],
  56. 				dialogFormVisible: false,
  57. 				book: {
  58. 					bookname: '',
  59. 					price: '',
  60. 					booktype: ''
  61. 				},
  62. 				rules: {
  63. 					bookname: [{
  64. 						required: true,
  65. 						message: '请输入书本名称',
  66. 						trigger: 'blur'
  67. 				 }, ],
  68. 					price: [{
  69. 						required: true,
  70. 						message: '请输入书本价格',
  71. 						trigger: 'blur'
  72. 					}, ],
  73. 					booktype: [{
  74. 						required: true,
  75. 						message: '请选择书本类型',
  76. 						trigger: 'change'
  77. 					}, ]
  78. 				}
  79. 			};
  80. 		},
  81. 		methods: {
  82. 			close:function(){
  83. 				//清空表单数据
  84. 				this.book={
  85. 					bookname: '',
  86. 					price: '',
  87. 					booktype: ''
  88. 				};
  89. 				//清空表单验证
  90. 				this.$refs['book'].resetFields();
  91. 			},
  92. 			save: function() {
  93. 				this.$refs['book'].validate((valid) => {
  94. 					if (valid) {
  95. 						let url=this.axios.urls.ADD;
  96. 						this.axios.post(url,this.book).then(resp => {
  97. 							let data = resp.data; //data  -->  date  XXXXXX
  98. 							// {code:200,msg:'OK',data:[....]}
  99. 							if(data.code==200){
  100. 								//关闭弹出框
  101. 								this.dialogFormVisible=false;
  102. 								//再次查询列表方法
  103. 								this.query();
  104. 							}else{
  105. 								this.$message.error('新增失败！');
  106. 							}
  107. 						}).catch(err => {
  108.  
  109. 						})
  110. 					} else {
  111. 						console.log('error submit!!');
  112. 						return false;
  113. 					}
  114. 				});
  115. 			},
  116. 			query: function() {
  117. 				//1.定义查询参数
  118. 				let params = {
  119. 					bookname: this.bookname
  120. 				};
  121. 				//2.获取请求路径
  122. 				let url = this.axios.urls.ALL;
  123. 				//3.发起ajax请求
  124. 				this.axios.post(url, params).then(resp => {
  125. 					let data = resp.data; //data  -->  date  XXXXXX
  126. 					// {code:200,msg:'OK',data:[....]}
  127. 					console.log(data);
  128. 					this.tableData = data.data;
  129. 				}).catch(err => {
  130.  
  131. 				})
  132. 			},
  133. 			open: function() {
  134. 				this.dialogFormVisible = true;
  135. 			}
  136. 		}
  137. 	}
  138. </script>
  139.  
  140. <style>
  141. </style>

 以上就是今天的分享！！！

刚好有大学生找我帮忙写这个项目，我想可以与大家分享一下代码，有其他同行需要代码的也可以找我。感谢支持！

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/Cpp五条/article/detail/663539
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号