一.首先观察页面初始化数据是否加载正确
步骤：1.先确定页面内容2.再确定内容所对应的数据库表3.编写SQL语句4.编写测试用例，并执行（是否与页面加载数据一致）
二.功能点考虑：
输入：可见输入和不可见输入处理：正常+异常处理输出：可见输出--->前台、后台不可见输出--->数据库
案例：以iwebshop为例，具体如下
（一）初始化页面测试
1.确定页面内容及对应的数据库
2.编写对应的数据库
| 首页内容分析 | SQL |
| 商品分类 | select * from iwebshop_category where parent_id=0 and visibility=1 order by sort limit 5 |
| 服饰鞋帽 | select * from iwebshop_category where parent_id=57 and visibility=1 order by id desc |
| 家居、家装 | select * from iwebshop_category where parent_id=68 and visibility=1 order by id asc |
| 热门数据 | select * from iwebshop_keyword where hot=1 order by `order` limit 5 |
| shop资讯 | select * from iwebshop_article where visiblity=1 and top=1 order by create_time desc |
| 最新商品 | select g.name, g.img, g.sell_price, g.market_price from iwebshop_commend_goods as c inner join iwebshop_goods as g on g.id=c.goods_id where c.commend_id=1 order by g.up_time desc limit 8 |
| 热卖商品 | select g.name, g.img, g.sell_price, g.market_price from iwebshop_commend_goods as c inner join iwebshop_goods as g on g.id=c.goods_id where c.commend_id=3 order by g.up_time desc limit 8 |
| 化妆品 | select g.name, g.img, g.sell_price, g.market_price from iwebshop_category as c inner join iwebshop_category_extend as e on c.id=e.category_id inner join iwebshop_goods as g on e.goods_id=g.id where c.id in( select id from iwebshop_category where parent_id in (select id from iwebshop_category where parent_id=67 or id=67 ) or id=67 ) order by g.up_time desc limit 8 |
| 服饰鞋帽 | select g.name, g.img, g.sell_price, g.market_price from iwebshop_category as c inner join iwebshop_category_extend as e on c.id=e.category_id inner join iwebshop_goods as g on e.goods_id=g.id where c.id in(57,58,59,60,61,63,64,81,97) order by g.up_time desc limit 8 |
| 图书、音像 | select g.name, g.img, g.sell_price, g.market_price from iwebshop_category as c inner join iwebshop_category_extend as e on c.id=e.category_id inner join iwebshop_goods as g on e.goods_id=g.id where c.id in( select id from iwebshop_category where parent_id in (select id from iwebshop_category where parent_id=69 or id=69 ) or id=69 ) order by g.up_time desc limit 8 |
| 手机、电脑、数码 | select g.name, g.img, g.sell_price, g.market_price from iwebshop_category as c inner join iwebshop_category_extend as e on c.id=e.category_id inner join iwebshop_goods as g on e.goods_id=g.id where c.id in( select id from iwebshop_category where parent_id in (select id from iwebshop_category where parent_id=66 or id=66 ) or id=66 ) order by g.up_time desc limit 8 |
| 家居、家装 | select g.name, g.img, g.sell_price, g.market_price from iwebshop_category as c inner join iwebshop_category_extend as e on c.id=e.category_id inner join iwebshop_goods as g on e.goods_id=g.id where c.id in( select id from iwebshop_category where parent_id in (select id from iwebshop_category where parent_id=68 or id=68 ) or id=68 ) order by g.sort asc,g.up_time desc limit 8 |
| 品牌列表 | select * from iwebshop_brand order by sort asc limit 6 |
| 关键词 | select * from iwebshop_keyword where hot =1 order by `order` limit 8 |
| 公告 | select * from iwebshop_announcement order by time desc limit 5 |
| 最新评论 | select g.name,g.img,c.contents from iwebshop_comment as c inner join iwebshop_goods as g on c.goods_id=g.id order by time desc |
| 帮助分类 | select * from iwebshop_help_category order by sort |
| 帮助信息 | select * from iwebshop_help where cat_id=3 order by id desc select * from iwebshop_help where cat_id=4 order by id desc select * from iwebshop_help where cat_id=5 order by id desc select * from iwebshop_help where cat_id=6 order by id desc select * from iwebshop_help where cat_id=7 order by id desc |
3.测试用例编写
（二）功能点测试
1.输入（可见输入、不可见输入）
2、处理操作
3、输出
