随着信息技术在管理上越来越深入而广泛的应用,管理信息系统的实施在技术上已逐步成熟。管理信息系统是一个不断发展的新型学科,任何一个单位要生存要发展,要高效率地把内部活动有机地组织起来,就必须建立与自身特点相适应的管理信息系统。
本管理信息系统是采用C#作开发平台实现学生档案管理系统,以SQL Server 2000数据库作为后台数据库支撑,完全遵循C/S模式进行设计,实现管理系统基本功能,主要包括:管理员登录、用户维护、成绩维护、课程维护等相关信息维护。
论文主要介绍了本课题的开发背景,所要完成的功能和开发的过程。重点的说明了系统设计的重点、设计思想、难点技术和解决方案。
关键词:学生档案管理系统;C#;SQL Server 2000数据库; C/S模式
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001016s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.110976s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.020582s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.020674s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001063s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003293s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000866s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.005918s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.022572s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.004072s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 71206 [ RunTime:0.021640s ]