1.表的设计
create table student( id int, name varchar(20) not null default ‘‘, chinese decimal(5,2) not null default 0.0, english decimal(5,2) not null default 0.0, math decimal(5,2) not null default 0.0 ); insert into student values(1,‘韩顺平‘,89,78,90); insert into student(id,name,chinese,english,math) values(2,‘张飞‘,67,98,56),; insert into student(id,name,chinese,english,math) values(3,‘宋江‘,87,78,77); insert into student(id,name,chinese,english,math) values(4,‘关羽‘,88,98,90); insert into student(id,name,chinese,english,math) values(5,‘赵云‘,82,84,67); insert into student(id,name,chinese,english,math) values(6,‘欧阳锋‘,55,85,45); insert into student(id,name,chinese,english,math) values(7,‘黄蓉‘,75,65,30);
2.界面
3.程序框架图(开发模式)
|
|
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>添加学生</title> <script type="text/javascript"> </script> </head> <body> <form action="insetStuAction.php" name="#" method="post"> 学生编号:<input type="text" name="id"><br> 学生名字:<input type="text" name="name"><br> 语文成绩:<input type="text" name="chinaese"><br> 数学成绩:<input type="text" name="math"><br> 英语成绩:<input type="text" name="english"><br> <input type="submit" name="添加学生"> </form> </body> </html>
原文：https://www.cnblogs.com/hzg8754/p/9641398.html