Javaweb学生信息管理系统.zip

/* Navicat MySQL Data Transfer Source Server : 本地数据库 Source Server Version : 50611 Source Host : localhost:3306 Source Database : db_student_manager_web Target Server Type : MYSQL Target Server Version : 50611 File Encoding : 65001 Date: 2018-06-10 20:32:20 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `s_admin` -- ---------------------------- DROP TABLE IF EXISTS `s_admin`; CREATE TABLE `s_admin` ( `id` int(5) NOT NULL AUTO_INCREMENT, `name` varchar(32) NOT NULL, `password` varchar(32) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id`,`name`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of s_admin -- ---------------------------- INSERT INTO `s_admin` VALUES ('1', 'admin', 'admin', '1'); -- ---------------------------- -- Table structure for `s_clazz` -- ---------------------------- DROP TABLE IF EXISTS `s_clazz`; CREATE TABLE `s_clazz` ( `id` int(5) NOT NULL AUTO_INCREMENT, `name` varchar(32) NOT NULL, `info` varchar(128) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of s_clazz -- ---------------------------- INSERT INTO `s_clazz` VALUES ('1', '软件一班', '这是软件工程专业。'); INSERT INTO `s_clazz` VALUES ('4', '数学一班', '大学数学专业'); INSERT INTO `s_clazz` VALUES ('5', '计算机科学与技术一班', '计算机专业'); -- ---------------------------- -- Table structure for `s_student` -- ---------------------------- DROP TABLE IF EXISTS `s_student`; CREATE TABLE `s_student` ( `id` int(5) NOT NULL AUTO_INCREMENT, `sn` varchar(32) NOT NULL, `name` varchar(32) NOT NULL, `password` varchar(32) NOT NULL, `clazz_id` int(5) NOT NULL, `sex` varchar(5) NOT NULL DEFAULT '男', `mobile` varchar(12) DEFAULT NULL, `qq` varchar(18) DEFAULT NULL, `photo` mediumblob, PRIMARY KEY (`id`,`sn`), KEY `student_clazz_id_foreign` (`clazz_id`), CONSTRAINT `student_clazz_id_foreign` FOREIGN KEY (`clazz_id`) REFERENCES `s_clazz` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of s_student -- ---------------------------- INSERT INTO `s_student` VALUES ('1', 'S11528202944239', '张三', '123456', '5', '男', '13918654525', '1193284480', 0x89504E470D0A1A0A0000000D494844520000006400000064080600000070E29554000000017352474200AECE1CE90000000467414D410000B18F0BFC6105000000097048597300000EC400000EC401952B0E1B00004A1549444154785E5D9D679065C775DF7BE64DCE6967D36C98CD19610922110041521425913665AB4A25BB444B2527C91F54E58FF697ADF22757C92EDB2AB9249764B94AD952592225821483B000B1C002D80536E7BCB361728E6F669EFFBFFFB9BDB3E49DBD7B43779F3E7DF2E9DBF7BEAA0B3FF83F95B49A52457F6CD5D5D53E562A95545515474AE25A378A6D756525BDF5D65BE9CB5FFE726A68684C53D3536971612175F7AC4BABAB2B6B75D5787575D530AAB9A77FB41538F705DCEA928EAB95B4B4B4E406D5D52537ADA929B95EA5B29A161616755D93CAE5B2EBD79428ABA4FAFA06D5AF4ACB2B95343D35ADF2A5B4BCBC9CEAEAEA0CA3A9A9313537371B768C27C692C749DB7C8FBEAB745D950ABC74BEB222E2682BD19FFEC01D405C7B1CC0D01FE3020460695332EE0076855455513FFA8306AB1A2B5BA6390770A35DD5B9BFFFDF1590A8AEAA4EAB1A78958E25152E5328E8CB1A2080EBEAEA756FC548B281F4DCDC6C7AE79DE3E9AB5FFD9ADB8E8E8CA6CECE0E435F55FB2783144C885AAD41AC2C6B40C53DFA5D2E2F8B8022B2FAA20CC62E88B1E3E3E3469CB2DADA5A31A026CD2FCC1BE9C6C60611A426B5B5B6A686C646E3333B3B935A5BDBD2A64D9BD3E3C70FD3E0D0509A100C98D8AA7A5BB76E4B1D1D1DA9BC3C2F5C960DBB2AD5090F31C044127E1604E1B122E6552FEBBAC1828200805B303170CF0C809016385D00C7F58BB171CF44E71E0CA24FF785C0AA0E8D690F20ED6E77FE7B7FE06679E326C4E34E49E72BEAEC83F74FA49DBBF6A4BEBECD696959C88ADBC082C0539353E9FCB973E9B5D75F4F8B4B8BE02B64025923C09F38CCB919A47648F7E4D4542A2F95DDE792DA21D52B62F8F8F8445ABFBE5752DD127D8848535393AA53761D346261614E0C98B5E40373626222CDCDCEA5AEEEEE343D33959616CBA9A7A75B75EBC59CC766627D437D6A6C68487BF7EE4FAD6D6D69615EB8A61533B9B9A959E7EA4CC85755D5EA745970855BA5C6F04D5CE10F42FE637CA20B4405360C2BA94E96FC6046D4E1089F2D942AB7E0892105299EC0AEAE1133B877FE7BFFA7924D4970545BAE0D3001C0247DF39B7F935E7AE9456940575A92D9F0A67A0C7A70F071BA7BEF5E3AFAFC514B8B39AEC6E2AB89CA79461E8987011018B59F9999A182EBDCB97357D2DC627393CBA6A7676C6E76ECD8614DE1FEE2E2824DD7CCCC6C9A9F9F97566CB206D4A99CB25BB76F1BA72999B0F5EBD7A7EDDBB70BCEB4EE0D5AF3366FEE4BFDDBFBC5A43AC198B639DCB2758B878DC64A664528CC5395356C59DA6112C5603C6E6EAC497B308363D481F0B206B62832680513566556619EEB1765D64C8DC9CD60361A42015BA81EFDA1BEE2A85816DA20E51691BEFBDDBF4F870E1DD4803699A0669FFE95D4F98C4CC6FDFBF7557ED876DC8C1192963075065C88C8095201912963C0300AF30771868747CC64883BF0E081EE2FD884D5D542BC199B9DEE9E4E4B1FE6AA51FBE4E4B86054525757971940FBA1A1418DA146DA33966EDDBA9D7A7B378A695BD5BE3D9D3B7746F597D373CF1D356EE7CF9F97E6EC4B1BA499C22EF0D4B184EDD67165255F436434037E48B23D7E53D2D730877A10DD03F6C0E3C089508E325AEA7ED022EA726D9771E17B7F080EDE5C87FFA9E80E8B4D27F88EFABA0631E5AD74E4C83369DDBA75F229A8769461EA66E7E664B7C7D2868D1BCD8C8013CC8600C09B571D10447A1717D194253305664CCAFCE103286F909F8029E3E353AA3B2550212498A9DADA924D16DA0A9160D8F56BD7525B7BBB0507A6F4F6F6A6478F1E5AFA19CBB5EB37D4F77C3A78707FDAB3678FB4F176BA7BF7AE4CF1EED42538972E5D34ACBE2D7D69F3A63EE31B440E5F1AD4090217FF15630F130FD290B1A8E5B22A0974450CCBB85302D1C322518B83EEA181A2215BE9D7BFF1F563348611762A8033226BD7668EEAACC886EFDAB52B5DB87021B5C8C637363519039060433271F6B3B2E74D2AA30BD4168D999C9C4CA3A3A31E20F8B33D7CF8D01247797B7B874D4FAD98435D9C36120533DADBDB527FFF0E336D7171C97B77578FF1C4FC757474A6C3878FB8AFCB972E493B86CDAC8D1B37D9E481FF3699347CCD827C06DABD4165E5D9F974F7E62D33B2553B1A3B3E366ED3D8847F42A88202362B5C03CB911903B0F52888CF1FA4D31FD73A046D7451D29838724DFB80113E85F3F03DA18155E7BFFF07568A0C800D53655514101A502137041924FAF2A5CBA9BBBBCB925816A38C84EAC1442416E0847E008691D876EC2AC49E9F9F33A161609B1C2C5A846D277ACABE66786448CE79498C6D4D636363EAB35A0CEB4B376FDE1073FA65DA86DD5F7373A371437388B2E8FFCAB52BD2D489F4BA020DB4E5D6AD9BAEDF2EA20F0E8ED8EFB01D3C74209D3EF571DAB2658BFA6916C3C64D3888B565CB5659019930494F1E77989730EBF4998996C7CE3DDFE7064C33A1A3AE19526CC0649C86201396EBD14FD5B9EFFF6185221A20BD109B23B5B9E7F859E745D70522D1C9D8E89809DF2609761B36C176BB42951F3F7A649B1C8E516D64D23AA40D6C9817EC2E66ABB777BDCD90E37C6DF803A2B14FCE9C715B22ADB20282BDBBF7A5919111AB3E0484A1E0DCA0088A7EC1A7B6B6C65A7AE5CA95F4DCB3CFA53D7B77A7BB0A1866E5A7468533046F6D694D0B0A6F3B3A3BD3F0E3C1D4A3FED0A847C2173C7A7A7A1CEDA17D26A6C7AD71E92F9B31FC189BC7AB72D3A6A8EB36DA3045FC65076F42EA3FD3520C80B6D02C6FA55FFFE57F742C880C11D700F9487B1C3BB6D04797B89C2349575D5DAD88A8983D23041C1D60F2CAEAB29D3526A6BEBECEE7BDF23D6850A512A60C335253532B33F358523C94E6A43D238A86A644EC05F99B7ED9782776D2301871EEDC256B5A8D1C764747B7073A31A14849E5F4515694044161765FDF9674EAF4293173C6612F12481030A3F2870F1FA40699A6CDF2770BD29891E151D551D9CCA4F3164C616D6DBDB469D6668E901962E7A88A91667A54CBF99BC42AB72992B0F81E15744FAD14F8643FA49DF6A66FB463CBD157E9DF7DE3E7E5434223609739E79EA80850AA47716C85133250F9084909C0503B8316AC19D96D1235CC1079C3BA753DF6118D8D4DB6A7F809F0416D315B794342376ED8901AC480328312516FDDBC29222469424B7AF6D967956F2CA6E98985F4E8F1709A55D8DBDDDDA15095EC3D7C187E66C3868D3E92CC6E53648526C124A41D67DDD6D6EE8062747444BE867B2BD6A879E537080BB49B579E822F6991266162316968E28F514234800190355FB3710F2B94851BFA9028E772EE47DB35FF91CB9E64EAD1B6604601CC6AC93D57E59EFFD72E40856989302E907116AE2304A22E52392D5F41383C36366AD305139A5B9AC3AF28020238C4611059932018124FD9E68D9BA53D436630CCDDD2B7359DBF8A4F184B338ACA5A9AEA52CFBAF5A9BD1593857DAF28191C4C9FFFFC9BE9D333A79DBFD07FA7C265E07575755BCAF12398344CE3B66DDBD3F5EBD7AC51B76FDF92AF92D6083734B3A9B9C97E69830405470F2D6CB232017560AC41FC2072BE4F013959F617711EE56C34090B14F90865A5DFF8C6D78E59B62930F90DDD1565E468E6FB1C917EB5F5D11D176D00863D0D64C2014E4F4FA41B37AE9911485C4B4B8B24AE5A123E9B06EEDF33811B9B1AA4151BD30B2F1C75F4B671E306DB7FB461FFBE7D82B992AE5DBB9A3E