面试题总结
其它面试题(springboot、mybatis、并发、java中高级面试总结等)
/**
* 后端详情
*/
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") String id){
TiwenzhuangtaiEntity tiwenzhuangtai = tiwenzhuangtaiService.selectById(id);
return R.ok().put("data", tiwenzhuangtai);
}
/**
* 前端详情
*/
@RequestMapping("/detail/{id}")
public R detail(@PathVariable("id") String id){
TiwenzhuangtaiEntity tiwenzhuangtai = tiwenzhuangtaiService.selectById(id);
return R.ok().put("data", tiwenzhuangtai);
}
/**
* 后端保存
*/
@RequestMapping("/save")
public R save(@RequestBody TiwenzhuangtaiEntity tiwenzhuangtai, HttpServletRequest request){
tiwenzhuangtai.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
//ValidatorUtils.validateEntity(tiwenzhuangtai);
tiwenzhuangtaiService.insert(tiwenzhuangtai);
return R.ok();
}
/**
* 前端保存
*/
@RequestMapping("/add")
public R add(@RequestBody TiwenzhuangtaiEntity tiwenzhuangtai, HttpServletRequest request){
tiwenzhuangtai.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
//ValidatorUtils.validateEntity(tiwenzhuangtai);
tiwenzhuangtaiService.insert(tiwenzhuangtai);
return R.ok();
}
/**
* 修改
*/
@RequestMapping("/update")
public R update(@RequestBody TiwenzhuangtaiEntity tiwenzhuangtai, HttpServletRequest request){
//ValidatorUtils.validateEntity(tiwenzhuangtai);
tiwenzhuangtaiService.updateById(tiwenzhuangtai);//全部更新
return R.ok();
}
/**
* 删除
*/
@RequestMapping("/delete")
public R delete(@RequestBody Long[] ids){
tiwenzhuangtaiService.deleteBatchIds(Arrays.asList(ids));
return R.ok();
}
/**
* 提醒接口
*/
@RequestMapping("/remind/{columnName}/{type}")
public R remindCount(@PathVariable("columnName") String columnName, HttpServletRequest request,
@PathVariable("type") String type,@RequestParam Map<String, Object> map) {
map.put("column", columnName);
map.put("type", type);
if(type.equals("2")) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Calendar c = Calendar.getInstance();
Date remindStartDate = null;
Date remindEndDate = null;
if(map.get("remindstart")!=null) {
Integer remindStart = Integer.parseInt(map.get("remindstart").toString());
c.setTime(new Date());
c.add(Calendar.DAY_OF_MONTH,remindStart);
remindStartDate = c.getTime();
map.put("remindstart", sdf.format(remindStartDate));
}
if(map.get("remindend")!=null) {
Integer remindEnd = Integer.parseInt(map.get("remindend").toString());
c.setTime(new Date());
c.add(Calendar.DAY_OF_MONTH,remindEnd);
remindEndDate = c.getTime();
map.put("remindend", sdf.format(remindEndDate));
}
}
Wrapper<TiwenzhuangtaiEntity> wrapper = new EntityWrapper<TiwenzhuangtaiEntity>();
if(map.get("remindstart")!=null) {
wrapper.ge(columnName, map.get("remindstart"));
}
if(map.get("remindend")!=null) {
wrapper.le(columnName, map.get("remindend"));
}
int count = tiwenzhuangtaiService.selectCount(wrapper);
return R.ok().put("count", count);
}
}
@Configuration
public class InterceptorConfig extends WebMvcConfigurationSupport{
@Bean
public AuthorizationInterceptor getAuthorizationInterceptor() {
return new AuthorizationInterceptor();
}
@Override
public void addInterceptors(InterceptorRegistry registry) {
registry.addInterceptor(getAuthorizationInterceptor()).addPathPatterns("/**").excludePathPatterns("/static/**");
super.addInterceptors(registry);
}
/**
* springboot 2.0配置WebMvcConfigurationSupport之后,会导致默认配置被覆盖,要访问静态资源需要重写addResourceHandlers方法
*/
@Override
public void addResourceHandlers(ResourceHandlerRegistry registry) {
registry.addResourceHandler("/**")
.addResourceLocations("classpath:/resources/")
.addResourceLocations("classpath:/static/")
.addResourceLocations("classpath:/admin/")
.addResourceLocations("classpath:/front/")
.addResourceLocations("classpath:/public/");
super.addResourceHandlers(registry);
}
}
>
> ### 数据设计:
>
>
>
数据库表是数据库重要的组成部分,其实数据库只是一个框架,数据库表才是数据库的本质,本系统数据库表如下:allusers表:
| | | | |
| --- | --- | --- | --- |
| 序号 | 字段名称 | 字段类型 | 大小 |
| 1 | id | Int | 4 |
| 2 | username | | 150 |
| 3 | pwd | | 150 |
| 4 | cx | | 150 |
| 5 | addtime | DateTime | 8 |
churudengji表:
| | | | |
| --- | --- | --- | --- |
| 序号 | 字段名称 | 字段类型 | 大小 |
| 1 | id | Int | 4 |
| 2 | addtime | | 150 |
| 3 | dengjibiaoti | | 150 |
| 4 | dengjileixing | DateTime | 8 |
| 5 | dengjineirong | | 150 |
| 6 | dengjishijian | DateTime | 8 |
| 7 | beizhu | | 150 |
| 8 | xuehao | DateTime | 8 |
| 9 | xueshengxingming | | 150 |
| 10 | xingbie | DateTime | 8 |
| 11 | touxiang | | 150 |
| 12 | shishitiwen | DateTime | 8 |
| 13 | shouji | | |
| 14 | banji | DateTime | 8 |
| 15 | zhuanye | | |
| 16 | sfsh | DateTime | 150 |
| 17 | shhf | | |
xiujiashenqing表:
| | | | |
| --- | --- | --- | --- |
| 序号 | 字段名称 | 字段类型 | 大小 |
| 1 | id | Int | 4 |
| 2 | addtime | | 150 |
| 3 | shenqingbianhao | | 150 |
| 4 | shenqingbiaoti | DateTime | 8 |
| 5 | shenqingneirong | | 150 |
| 6 | xiujiatianshu | DateTime | 8 |
| 7 | xingchengchengshi | | 150 |
| 8 | tujingchengshi | DateTime | 8 |
| 9 | shenqingriqi | | 150 |
| 10 | beizhu | DateTime | 8 |
| 11 | xuehao | | 150 |
| 12 | xueshengxingming | DateTime | 8 |
| 13 | touxiang | DateTime | 8 |
| 14 | zhuanye | | 150 |
| 15 | banji | DateTime | 8 |
| 16 | shouji | | 150 |
| 17 | sfsh | DateTime | 8 |
| 18 | shhf | | 150 |
xuesheng表:
| | | | |
| --- | --- | --- | --- |
| 序号 | 字段名称 | 字段类型 | 大小 |
| 1 | id | Int | 4 |
| 2 | addtime | | 150 |
| 4 | xuehao | | 150 |
| 5 | mima | | 150 |
| 6 | xueshengxingming | DateTime | 8 |
| 7 | xingbie | | |
| 8 | touxiang | DateTime | 8 |
| 9 | zhuanye | | |
| 10 | banji | DateTime | 8 |
| 11 | zhuzhishengfen | | |
| 12 | shiji | DateTime | 8 |
| 13 | xianqu | DateTime | 8 |
| 14 | shouji | DateTime | 8 |
| 15 | youxiang | DateTime | 8 |
>
> ### 论文参考:
>
>
>
**[摘 要](#_Toc36622786)**
**[ABSTRACT](#_Toc36622787)**
**[目 录](#_Toc36622788)**
**[第1章 绪论](#_Toc36622789)**
[1.1背景及意义](#_Toc36622790)
[1.2 国内外研究概况](#_Toc36622791)
[1.3 研究的内容](#_Toc36622792)
**[第2章 相关技术](#_Toc36622793)**
[2.1 JAVA简介](#_Toc36622794)
[2.2 MyEclipse开发环境](#_Toc36622795)
[2.3 Tomcat服务器](#_Toc36622796)
[2.4 MySQL数据库](#_Toc36622797)
[2.5 Spring Boot框架](#_Toc36622798)
**[第3章 系统分析](#_Toc36622799)**
[3.1 需求分析](#_Toc36622800)
[3.2 系统可行性分析](#_Toc36622801)
[3.2.1技术可行性:技术背景](#_Toc36622802)
[3.2.2经济可行性](#_Toc36622803)
[3.2.3操作可行性:](#_Toc36622804)
[3.3 项目设计目标与原则](#_Toc36622805)
[3.4系统流程分析](#_Toc36622806)
[3.4.1操作流程](#_Toc36622807)
[3.4.2添加信息流程](#_Toc36622808)
[3.4.3删除信息流程](#_Toc36622809)
**[第4章 系统设计](#_Toc36622810)**
[4.1 系统体系结构](#_Toc36622811)
[4.2开发流程设计](#_Toc36622812)
[4.3 数据库设计原则](#_Toc36622813)
[4.4 数据表](#_Toc36622814)
**[第5章 系统详细设计](#_Toc36622815)**
[5.1管理员功能模块](#_Toc36622817)
[5.2学生前后台功能模块](#_Toc36622818)
**[第6章 系统测试](#_Toc36622820)**
[6.1系统测试的目的](#_Toc36622821)
[6.2系统测试方法](#_Toc36622822)
[6.3功能测试](#_Toc36622823)
**[结 论](#_Toc36622824)**
**[致 谢](#_Toc36622825)**
[参考文献](#_Toc36622826)
>
> ### 完整源码:
>
>
> 大家**点赞、收藏、关注、评论**啦 、**查看**👇🏻**微信获取联系方式**👇🏻
>
>
> 打卡 文章 更新**243/ 365天**
>
>
> **精彩专栏推荐订阅:**在**下方专栏**👇🏻👇🏻
>
>
> [Java项目精品实战案例《100套》]( )
>
>
> [web前端期末大作业网页实战《100套》]( )
>
>
>
# **最后**
![image.png](https://img-blog.csdnimg.cn/img_convert/f12279b1148797d84c654f584f8cd6ba.webp?x-oss-process=image/format,png)
> **本文已被[CODING开源项目:【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码】](https://bbs.csdn.net/forums/4f45ff00ff254613a03fab5e56a57acb)收录**
**[需要这份系统化的资料的朋友,可以点击这里获取](https://bbs.csdn.net/forums/4f45ff00ff254613a03fab5e56a57acb)**
65天**
>
>
> **精彩专栏推荐订阅:**在**下方专栏**👇🏻👇🏻
>
>
> [Java项目精品实战案例《100套》]( )
>
>
> [web前端期末大作业网页实战《100套》]( )
>
>
>
# **最后**
[外链图片转存中...(img-MRVIPTRz-1715515996814)]
> **本文已被[CODING开源项目:【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码】](https://bbs.csdn.net/forums/4f45ff00ff254613a03fab5e56a57acb)收录**
**[需要这份系统化的资料的朋友,可以点击这里获取](https://bbs.csdn.net/forums/4f45ff00ff254613a03fab5e56a57acb)**