{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["版本信息","JAVA代码审查记录表"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"版本信息","index":0,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,5]]}
[null,"代码走查单"]
[null,"版本控制信息"]
[null,"日期","版本号","修订说明","修订人","审核人"]
[null,"2024-04-25","V1.0","创建","亦然","浩翔"]
[null,"2024-05-15","V1.1","修改","亦然","浩翔"]
[null,"2024-06-27","V1.2","修改","亦然","浩翔"]

{"sheet":"JAVA代码审查记录表","index":1,"n_rows":105,"n_cols":6,"rows_kept":105,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,1],[1,4,1,5],[2,0,2,1],[2,4,2,5],[3,0,3,1],[3,4,3,5],[4,1,4,2],[5,0,5,5],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,0,17,5],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,0,23,5],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,0,27,5],[28,1,28,2],[29,1,29,2],[30,0,30,5],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,0,35,5],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,0,42,5],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,0,54,5],[55,1,55,2],[56,1,56,2],[57,1,57,2],[58,0,58,5],[59,1,59,2],[60,1,60,2],[61,0,61,5],[62,1,62,2],[63,1,63,2],[64,1,64,2],[65,0,65,5],[66,1,66,2],[67,1,67,2],[68,1,68,2],[69,1,69,2],[70,1,70,2],[71,1,71,2],[72,1,72,2],[73,1,73,2],[74,0,74,5],[75,1,75,2],[76,1,76,2],[77,1,77,2],[78,0,78,5],[79,1,79,2],[80,1,80,2],[81,1,81,2],[82,1,82,2],[83,0,83,5],[84,1,84,2],[85,1,85,2],[86,0,86,5],[87,1,87,2],[88,1,88,2],[89,1,89,2],[90,1,90,2],[91,1,91,2],[92,1,92,2],[93,1,93,2],[94,1,94,2],[95,1,95,2],[96,1,96,2],[98,0,98,5],[99,1,99,5],[100,1,100,5],[101,1,101,5],[102,1,102,5],[103,1,103,5],[104,1,104,5]]}
["Java 代码审查检查表"]
["项目名称",null,"集拼业务管理系统","系统模块","管理后台"]
["责任人",null,"浩翔","填写人","亦然"]
["走查日期",null,"2024-06-19","走查用时","0.5天"]
["编号","问  题",null,"结果","问题数量","备注"]
["变量,Auribute,和常量声明缺陷(VC)"]
[1,"变量和常量的命名是否与约定保持一致?",null,"是"]
[2,"是否存在容易混淆的相似的变量和属性名?",null,"是",2,"对应的问题已经修改"]
[3,"变量和属性是否书写正确?",null,"是"]
[4,"变量和属性是否被正确的初始化?",null,"是"]
[5,"非局部变量是否能用局部变量替换?",null,"是"]
[6,"所有的for循环的控制变量是否都在循环顶部被声明?",null,"否"]
[7,"是否有应该命名为常量的文字常量?",null,"否"]
[8,"变量和属性是否可以用常量替换?",null,"否"]
[9,"属性是否可以用本地变量?",null,"否"]
[10,"所有的属性是否都有正确的访问限制符(private,protected,public)?",null,"是"]
[11,"是否有静态属性应该是非静态或vice-versa?",null,"否"]
["方法定义缺陷(FD)"]
[1,"方法名的描述方法是否与命名约定一致?",null,"是"]
[2,"每个方法的参数值在使用之前是否都作了检查?",null,"是"]
[3,"对于每一个方法,它是否都返回了正确的值?",null,"是"]
[4,"每种方法是否都有正确的访问限制符(private, protected, public)?",null,"是"]
[5,"静态方法是否应该为非静态或vice-versa?",null,"否"]
["类定义缺陷(CD)"]
[1,"每一个类是否都有正确的构造函数和析构函数?",null,"是"]
[2,"在子类中是否有应该放到父类中的通用成员?",null,"否"]
[3,"类的继承层次是否能被简化?",null,"否"]
["数据引用缺陷(DR)"]
[1,"对于每一个数组引用,下标值是否在定义的范围内?",null,"是"]
[2,"对于对象和数组引用,是否组确定其值应为非空?",null,"是"]
["计算/数值缺陷(CN)"]
[1,"是否存在不同类型数据之间的混合计算?",null,"否"]
[2,"在计算中是否存在上溢或下溢的可能?",null,"是",2,"对应的问题已经修改"]
[3,"关于数值计算的顺序和优先级的假设是否正确?",null,"是"]
[4,"是否用了括号来避免模糊不清?",null,"是"]
["比较/关系缺陷(CR)"]
[1,"对每一个布尔测试,正确条件是否被检查?",null,"是"]
[2,"比较操作符是否正确?",null,"是"]
[3,"布尔表达式是否通过内部否定操作进行了简化",null,"是"]
[4,"每个布尔表达式是否都正确?",null,"是"]
[5,"比较操作是否存在不引人注意的副作用?",null,"否"]
[6,"\"&&\"是否被不小心替换为''&\"? ''||''是否被不小心替换为''|\"?",null,"否"]
["流程控制缺陷(CF)"]
[1,"对于每一个循环:是否选用了最佳的循环结构?",null,"是"]
[2,"所有的循环是否都能结束?",null,"是"]
[3,"如果一个循环有多个出口,是否每个出口都有必要并且得到正确处理?",null,"是"]
[4,"switch声明是否都有default条件?",null,"是"]
[5,"是否所有的case-switch-break对应关系都已更正并加上批注？",null,"是"]
[6,"是否named break叙述都跳到正确的地方？",null,"是"]
[7,"循环和分支的嵌套是否过深?是否正确?",null,"否",2,"对应的问题已经修改"]
[8,"是否有if嵌套可以转换程switch嵌套?",null,"否"]
[9,"空控制叙述是否都正确，并加上括号及批注？",null,"是"]
[10,"所有的异常是否都得到了正确的处理",null,"是"]
[11,"每一个方法在是否都结束?",null,"是"]
["输入输出缺陷(IO)"]
[1,"文件在被使用之前是否都被打开?",null,"是"]
[2,"输入对象的属性是否与使用的文件一致?",null,"是"]
[3,"文件在被使用之后是否都被关闭?",null,"是"]
["计算/数值缺陷(CN)"]
[1,"文本中是否有拼写和语法上的错误?",null,"否"]
[2,"所有的I/O异常处理的是否合理?",null,"是"]
["模块间接口缺陷"]
[1,"方法调用的参数的数量,顺序,类型和值是否与该方法声明一致?",null,"是"]
[2,"度量单位是否一致（如：公分 vs. 公尺）？",null,"不适用"]
[3,"如果对象或数组被传递,它们是否改变?是否被调用方法正确改变?",null,"不适用"]
["注释缺陷(CM)"]
[1,"每一个方法,类和文件是否都有适当的头注释?",null,"不适用"]
[2,"每一个属性,变量和常量的声明是否都有注释?",null,"否",1,"对应的问题已经修改"]
[3,"每个类和方法的潜在行为是否都有用简易的语言进行解释?",null,"否",2,"对应的问题已经修改"]
[4,"方法和类的头注释是否和它们的功能保持一致?",null,"是"]
[5,"注释和代码是否保持一致?",null,"是"]
[6,"注释对于理解代码是否有帮助?",null,"是"]
[7,"代码中的注释是否充分?",null,"是"]
[8,"代码中的注释是否过多?",null,"否"]
["布局和封包缺陷(LP)"]
[1,"代码布局格式和缩排标准是否前后一致?",null,"是"]
[2,"对于每一个方法,它的代码量是否都不超过60行?",null,"否"]
[3,"对于每一个编译模块,它的代码量是否都不超过600行?",null,"是"]
["模块性缺陷 (MO)"]
[1,"模块(方法,类)之间是否具有低偶合性?",null,"是"]
[2,"每个模块(方法,类)自身是否具有高聚合性?",null,"是"]
[3,"是否存在重复的代码,它的功能可以通过调用其它方法实现?",null,"否"]
[4,"Java类库的使用是否适时适地?",null,"是"]
["存储器使用缺陷(SU)"]
[1,"数组是否足够大?",null,"是"]
[2,"数组和对象不再使用之后,它们的引用是否被赋为空值?",null,"是"]
["性能缺陷 (PE) [可选]"]
[1,"是否有更好的数据结构和算法可以采用?",null,"否"]
[2,"测试安排是否合理,使易于通过的且代价低廉的测试优先于代价较高且通过频率较低的测试?",null,"是"]
[3,"是否可以通过对数值进行一次计算并将结果保存来减少对它重新计算带来的消耗?",null,"否"]
[4,"每一个计算出并保存了的结果是否都被应用?",null,"是"]
[5,"计算是否能被移到循环之外?",null,"否"]
[6,"在循环内是否有不需要的测试?",null,"否"]
[7,"短循环是否可以取消?",null,"不适用"]
[8,"对同一个数据进行操作的两个循环是否可以合并成一个?",null,"否"]
[{"$nulls":4},{"$f":"SUM(E7:E17,E19:E23,E25:E27,E29:E30,E32:E35,E37:E42,E44:E54,E56:E58,E60:E61,E63:E65,E76:E78,E80:E83,E85:E86,E88:E95,E67:E74)","v":9}]
[]
[]
["其他意见"]
["序号","意见内容"]
[1,"不变的值，尽量写个常量类。"]
[2,"减少循环调用方法查询数据库。"]
[3]
[4]
[5]