暑期实训《研究生管理系统》2021.7.18 第三周第4次更新
成果维护接口文档如下

一、专利
1.增加专利
url: localhost:8081/student/insertPatent
传入参数：
stu_id
pat_name
pat_type
cly_num
state
reg_date yyyy-MM-dd类型的字符串
self_position [1,9]的整数
patent_id 字符串
测试url: localhost:8081/student/insertPatent?pat_name=专利12345&pat_type=新型&cly_num=12345&state=未审&reg_date=2021-05-02&stu_id=201656777&self_position=1&patent_id=ZL12345
测试结果：成功
patent
patent_relationship
都增加了

2.查询专利
url: localhost:8081/student/findPatent
传入参数：
stu_id
测试url: localhost:8081/student/findPatent?stu_id=201656777
测试结果：成功
{
“status”: 200,
“msg”: “查询成功”,
“data”: [
{
“patentId”: “ZL12345”,
“patName”: “专利12345”,
“patType”: “新型”,
“clyNum”: “12345”,
“regDate”: “2021-05-01T16:00:00.000+00:00”,
“state”: “未审”,
“selfPosition”: 1
}
]
}
3.删除专利
url: localhost:8081/student/deletePatent
传入参数：
patent_id 字符串
测试url: l localhost:8081/student/deletePatent?patent_id=ZL202035697637.3
测试结果：成功
patent
patent_relationship
都删除了

二、论文
1.增加论文
url: localhost:8081/student/insertPaper
传入参数：
stu_id
paper_id
paper_title
jm_name 期刊名称
col_method
imp_factors float型 例如5.5
time_publish yyyy-mm-dd
art_type
cit_num int型
puj_num
paper_level
place_pub
press
volume_num int型
issue_num int型
sta_page int型
sto_page int型
remarks
aut_positiom int型
测试url: localhost:8081/student/insertPaper?paper_id=sfsf&paper_title=叽里咕噜&jm_name=叽里咕噜杂志&col_method=不知道&imp_factors=3.5&time_publish=2210-05-08&art_type=不知道&cit_num=20&puj_num=树倒猢狲散&paper_level=二级&place_pub=三级&press=不知道&volume_num=1&issue_num=1&sta_page=1&sto_page=1&remarks=叽里咕噜&stu_id=201656777&aut_positiom=2
测试结果：成功
paper
paper_relationship
都增加了

2.查询论文
url: localhost:8081/student/findPaper
传入参数：
stu_id
测试url: localhost:8081/student/findPaper?stu_id=201656777
测试结果：成功
{
“status”: 200,
“msg”: “查询成功”,
“data”: [
{
“paperId”: “sfsf”,
“paperTitle”: “叽里咕噜”,
“jmName”: “叽里咕噜杂志”,
“colMethod”: “不知道”,
“impFactors”: 3.5,
“timePublish”: “2210-05-07T16:00:00.000+00:00”,
“artType”: “不知道”,
“citNum”: 20,
“pujNum”: “树倒猢狲散”,
“paperLevel”: “二级”,
“placePub”: “三级”,
“press”: “不知道”,
“volumeNum”: 1,
“issueNum”: 1,
“staPage”: 1,
“stoPage”: 1,
“remarks”: “叽里咕噜”,
“autPositiom”: 2
}
]
}

3.删除论文
url: localhost:8081/student/deletePaper
传入参数：
paper_id 字符串
测试url: localhost:8081/student/deletePaper?paper_id=sfsf
测试结果：成功
paper
paper_relationship
都删除了

三、项目
1.增加项目
url: localhost:8081/student/insertFruitProject
传入参数：
stu_id
pro_id
pro_name
pro_grade
pro_source
finance_num
pro_app_time yyyy-mm-dd
con_time yyyy-mm-dd
pro_funds 小数类型 2.36
pro_surplus 小数类型 3.25
acc_time yyyy-mm-dd
acc_num 整数类型
varchar

测试url: localhost:8081/student/insertFruitProject?stu_id=201830217&pro_id=123456789&pro_name=sdfs&pro_grade=sdfs&pro_source=dsfsd&finance_num=sdfsd&pro_app_time=2021-05-08&con_time=2021-05-08&pro_funds=5.12&pro_surplus=3.25&acc_time=2021-05-08&acc_num=7&varchar=sdfjdsfsdjfjdsalfdsa;ljk
测试结果：成功
project
project_relationship
都增加了

2.查询项目
url: localhost:8081/student/findFruitProject
传入参数：
stu_id
测试url: localhost:8081/student/findFruitProject?stu_id=201830217
测试结果：成功
{
“status”: 200,
“msg”: “查询成功”,
“data”: [
{
“proId”: “123456789”,
“proName”: “sdfs”,
“proGrade”: “sdfs”,
“proSource”: “dsfsd”,
“financeNum”: “sdfsd”,
“proAppTime”: “2021-05-07T16:00:00.000+00:00”,
“conTime”: “2021-05-07T16:00:00.000+00:00”,
“proFunds”: 5,
“proSurplusFunds”: 3,
“accTime”: “2021-05-07T16:00:00.000+00:00”,
“accNum”: 7,
“varchar”: “sdfjdsfsdjfjdsalfdsa;ljk”
}
]
}

3.删除项目
url: localhost:8081/student/deleteFruitProject
传入参数：
paper_id 字符串
测试url: localhost:8081/student/deleteFruitProject?pro_id=123456789
测试结果：成功
project
project_relationship
都删除了

四、专著
1.增加专著
url: localhost:8081/student/insertBook
传入参数：
stu_id
book_id
monograph_name
monograph_type
book_num
format
publish_date yyyy-mm-dd
page_num int
edition
price 小数类型 4.5
word_num int
press
aut_position int
tutor_position int
测试url:
localhost:8081/student/insertBook?book_id=sdssf&monograph_name=sfssfsf&monograph_type=ffffff&book_num=dfdsfsfds&format=dadad&publish_date=2021-04-05&page_num=2&edition=111&price=4.5&word_num=4&press=jsdfk&stu_id=201656777&aut_position=2&tutor_position=1
测试结果：成功
book
book_relationship
都增加了

2.查询专著
url: localhost:8081/student/findBook
传入参数：
stu_id
测试url: localhost:8081/student/findBook?stu_id=201656777
测试结果：成功
{
“status”: 200,
“msg”: “查询成功”,
“data”: [
{
“bookId”: “sdssf”,
“monographName”: “sfssfsf”,
“monographType”: “ffffff”,
“bookNum”: “dfdsfsfds”,
“format”: “dadad”,
“publishDate”: “2021-04-04T16:00:00.000+00:00”,
“pageNum”: 2,
“edition”: “111”,
“price”: 4.50,
“press”: “jsdfk”,
“wordNum”: 4,
“autPosition”: 3,
“tutorPosition”: 1
}
]
}

3.删除专著
url: localhost:8081/student/deleteBook
传入参数：
book_id 字符串
测试url: localhost:8081/student/deleteBook?book_id=sdssf
测试结果：成功
book
book_relationship
都删除了

五、奖项
1.增加奖项
url: localhost:8081/student/insertAward
传入参数：
award_id
award_name
award_set_dep
award_type
award_category
award_time yyyy-mm-dd
award_year int
aut_position int
remarks
stu_id

测试url:
localhost:8081/student/insertAward?award_id=sfsff&award_name=sfsdfsd&award_set_dep=sdfsdfs&award_type=dsfsdf&award_category=fdsfdsf&award_time=2014-04-02&award_year=3&aut_position=2&remarks=sdfsafsd&stu_id=201830217
测试结果：成功
award
award_relationship
都增加了

2.查询奖项
url: localhost:8081/student/findAward
传入参数：
stu_id
测试url: localhost:8081/student/findAward?stu_id=201830217
测试结果：成功
{
“status”: 200,
“msg”: “查询成功”,
“data”: [
{
“awardId”: “sfsff”,
“awardName”: “sfsdfsd”,
“awardSetDep”: “sdfsdfs”,
“awardType”: “dsfsdf”,
“awardCategory”: “fdsfdsf”,
“awardTime”: “2014-04-01T16:00:00.000+00:00”,
“awardYear”: 3,
“autPosition”: 2,
“remarks”: “sdfsafsd”
}
]
}

3.删除奖项
url: localhost:8081/student/deleteAward
传入参数：
award_id 字符串
测试url: localhost:8081/student/deleteAward?award_id=sfsff
测试结果：成功
award
award_relationship
都删除了