NodeJS background processed for an Android app with nutritional diet
课程设计已通过，不再更新。
#广东某工业大学Andriod课程设计 饮食建议系统：
本题要求学生实现基于**食物营养数据库的饮食建议系统，可以对各种不同类型的食物包含的各种元素进行排序和展示；输入某人一天吃的各种食物，系统能给出该人的饮食是否合理，并给出建议。本题要求实现一个Android APP，但不对具体的技术进行要求，可以使用原生Android编程，也可以用Android与HTML混合编程实现。要求界面清爽，一目了然，让用户使用之后心情愉快。
#基本功能需求分析：
- 本题要求学生实现基于**食物营养数据库的饮食建议系统
- 可以对各种不同类型的食物包含的各种元素进行排序和展示
- 输入某人一天吃的各种食物，系统能给出该人的饮食是否合理
- 并给出建议。
基本思路：Andriod端负责请求数据、处理node服务器返回的Json、显示数据。
#数据库设计
数据库类型：MySQL
数据库SQL数据以及设计在根目录database.sql中
#API协议区域
-
andriod json获取测试
- 方式：GET
- 地址：/json
- 返回数据样式：{"no":"001","data":{"name":"cry","chinese":"陈荣源"}}
-
食物“类别”获取
- 方式：GET
- 地址：/getcategory
- 返回数据样式：
-
- [{"id":1,"name":"谷类","isDel":0},{"id":2,"name":"薯类淀粉","isDel":0},{"id":3,"name":"干豆类","isDel":0},{"id":4,"name":"蔬菜类","isDel":0},{"id":5,"name":"菌藻类","isDel":0},{"id":6,"name":"水果类","isDel":0},{"id":7,"name":"坚果种子","isDel":0},{"id":8,"name":"畜肉类","isDel":0},{"id":9,"name":"禽肉类","isDel":0},{"id":10,"name":"乳类","isDel":0},{"id":11,"name":"蛋类","isDel":0},{"id":12,"name":"鱼虾蟹贝","isDel":0},{"id":13,"name":"婴幼儿食品","isDel":0}]
-
食物列表获取
-
方式：GET
-
赋值：categoryID（食物类别ID），elementID（食物元素），rankID（up/down），pageNum（页数）
-
地址：/getfood?category=categoryID&&element=elementID&&rank=rankID&&page=pageNum
-
返回数据样式：
-
- [{"id":69,"name":"桂花藕粉","heat":344,"protein":0.4,"fat":0.1,"vitaminC":0,"vitaminE":0,"vitaminB1":0,"vitaminB2":0.01,"Fe":20.8,"Zn":0.23,"Se":0.39,"category":2,"isDel":0},{"id":68,"name":"藕粉","heat":372,"protein":0.2,"fat":0,"vitaminC":0,"vitaminE":0,"vitaminB1":0,"vitaminB2":0.01,"Fe":17.9,"Zn":0.15,"Se":2.1,"category":2,"isDel":0},{"id":76,"name":"马铃薯粉","heat":337,"protein":7.2,"fat":0.5,"vitaminC":0,"vitaminE":0.28,"vitaminB1":0.08,"vitaminB2":0.06,"Fe":10.7,"Zn":1.22,"Se":1.58,"category":2,"isDel":0},{"id":80,"name":"甘薯粉[地瓜粉]","heat":336,"protein":2.7,"fat":0.2,"vitaminC":0,"vitaminE":0,"vitaminB1":0.03,"vitaminB2":0.05,"Fe":10,"Zn":0.29,"Se":2.62,"category":2,"isDel":0},{"id":71,"name":"粉丝","heat":335,"protein":0.8,"fat":0.2,"vitaminC":0,"vitaminE":0,"vitaminB1":0.03,"vitaminB2":0.02,"Fe":6.4,"Zn":0.27,"Se":3.39,"category":2,"isDel":0},{"id":73,"name":"粉条","heat":337,"protein":0.5,"fat":0.1,"vitaminC":0,"vitaminE":0,"vitaminB1":0.01,"vitaminB2":0,"Fe":5.2,"Zn":0.83,"Se":2.18,"category":2,"isDel":0},{"id":84,"name":"玉米淀粉","heat":345,"protein":1.2,"fat":0.1,"vitaminC":0,"vitaminE":0,"vitaminB1":0.03,"vitaminB2":0.04,"Fe":4,"Zn":0.09,"Se":0.7,"category":2,"isDel":0},{"id":79,"name":"甘薯片[白薯干]","heat":340,"protein":4.7,"fat":0.8,"vitaminC":9,"vitaminE":0.38,"vitaminB1":0.15,"vitaminB2":0.11,"Fe":3.7,"Zn":0.35,"Se":2.64,"category":2,"isDel":0},{"id":67,"name":"团粉[芡粉","heat":346,"protein":1.5,"fat":0,"vitaminC":0,"vitaminE":0,"vitaminB1":0.01,"vitaminB2":0,"Fe":3.6,"Zn":0.18,"Se":0.37,"category":2,"isDel":0},{"id":72,"name":"豌豆粉丝","heat":367,"protein":0.4,"fat":0,"vitaminC":0,"vitaminE":0,"vitaminB1":0.02,"vitaminB2":0,"Fe":3.5,"Zn":0.32,"Se":0,"category":2,"isDel":0}]
-
数据条目：10（默认）
-
-
消耗食物数据提交
- 方式：post
- 地址：/foodconsum
- 返回数据样式：（待定）
-
用户注册
- 方式：Post
- 地址：/resign
- 密码加密方式：（待定）
- 返回数据样式：（待定，情况：用户名存在，密码重复错误，注册成功）
-
用户名是否存在查询
- 方式：Get
- 赋值：username（尝试注册的用户名）
- 地址：/existusername?resign=username
- 返回数据样式：
-
- {'result':ture}表示用户名已存在（不能注册）
- {'result':falue}表示用户名不存在（可以注册）
-
用户登录（这个可以有）
- 方式：Post
- 地址：/login
- 密码加密方式：（待定）
- 返回数据样式：（待定，情况：用户名或者密码错误，登录成功）