• 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 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. "1.0" encoding="UTF-8" ?>
    2. 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 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 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> queryAll(Book book){
    29.         List books = bookService.queryAll(book);
    30.         return new JsonResponsBody<>(200,"OK",books);
    31.     }
    32.  
    33.     @Data
    34.     @AllArgsConstructor
    35.     @NoArgsConstructor
    36.     class JsonResponsBody{
    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. 		
    4. 		
    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. 		
    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. 		
    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>

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

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

  • 相关阅读:
    【解锁未来】探索Web3的无限可能性-01
    同花顺_代码解析_技术指标_V，W
    opencv快速入门（三）——图像几何变换
    Cookie和localStorage存储的区别
    llama2+localGPT打造纯私有知识助手
    request对象，类视图，HttpResponse对象，JsonResponse对象
    React之组件实例的三大属性之rel
    Gradle 出现 Could not resolve gradle
    王怀民院士：开源创新必将成为中国迈向世界科技强国的战略机遇
    高等工程数学 —— 第五章 （1）线性规划与单纯形法
  • 原文地址：https://blog.csdn.net/m0_62246061/article/details/127786329