基于Java的个人日记本系统设计与实现(源代码+数据库+演示录像).zip

/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50735 Source Host : localhost:3306 Source Database : db_diary Target Server Type : MYSQL Target Server Version : 50735 File Encoding : 65001 Date: 2022-02-17 17:16:29 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for t_diary -- ---------------------------- DROP TABLE IF EXISTS `t_diary`; CREATE TABLE `t_diary` ( `diaryId` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(60) COLLATE utf8_bin DEFAULT NULL, `content` text COLLATE utf8_bin, `typeId` int(11) DEFAULT NULL, `releaseDate` datetime DEFAULT NULL, PRIMARY KEY (`diaryId`), KEY `FK_t_diary` (`typeId`), CONSTRAINT `FK_t_diary` FOREIGN KEY (`typeId`) REFERENCES `t_diarytype` (`diaryTypeId`) ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of t_diary -- ---------------------------- INSERT INTO `t_diary` VALUES ('1', '加班', 0x3C703EE698AF3C2F703E0D0A, '1', '2014-01-01 00:00:00'); INSERT INTO `t_diary` VALUES ('7', '我是一个程序猿', 0x3C703EE68891E698AFE4B880E4B8AAE88BA6E980BCE79A84E7A88BE5BA8FE78CBFE38082E380823C2F703E0D0A, '4', '2013-01-01 00:00:00'); INSERT INTO `t_diary` VALUES ('8', '6', null, '1', '2013-01-01 00:00:00'); INSERT INTO `t_diary` VALUES ('9', '7', null, '1', '2013-01-01 00:00:00'); INSERT INTO `t_diary` VALUES ('10', '8', null, '1', '2013-01-01 00:00:00'); INSERT INTO `t_diary` VALUES ('11', '9', null, '1', '2013-01-01 00:00:00'); INSERT INTO `t_diary` VALUES ('12', '10', null, '1', '2013-01-01 00:00:00'); INSERT INTO `t_diary` VALUES ('13', '11', null, '1', '2013-01-01 00:00:00'); INSERT INTO `t_diary` VALUES ('14', '12', null, '1', '2013-01-01 00:00:00'); INSERT INTO `t_diary` VALUES ('15', '13', null, '2', '2013-01-01 00:00:00'); INSERT INTO `t_diary` VALUES ('16', '14', null, '2', '2013-01-01 00:00:00'); INSERT INTO `t_diary` VALUES ('17', '15', null, '2', '2013-01-01 00:00:00'); INSERT INTO `t_diary` VALUES ('19', '苦逼的一天', 0x3C703EE688913C2F703E0D0A, '2', '2014-01-09 16:42:32'); INSERT INTO `t_diary` VALUES ('29', '只要你肯用心，遍地都是财富', 0x3C703E266E6273703B20266E6273703B20E4B896E4B88AE4BB8EE69DA5E4B88DE7BCBAE5B091E8B4A2E5AF8CEFBC8CE58FAAE698AFE7BCBAE5B091E58F91E78EB0E8B4A2E5AF8CE79A84E79CBCE58589E38082E79CBCE58589E4BB8EE4BD95E8808CE69DA5EFBC9FE58FAAE8A681E4BDA0E882AFE794A8E5BF83EFBC8CE9818DE59CB0E983BDE698AFE8B4A2E5AF8CE380823C6272202F3E0D0AE38080E380803C6272202F3E0D0AE38080E38080E58187E5A682E4BDA0E698AF266C6471756F3BE79A84E593A526726471756F3BEFBC8CE59CA8E58CBBE999A2E997A8E58FA3E79C8BE8A781E4B8A4E4B8AAE4BABAE5908CE697B6E59091E4BDA0E68B9BE6898BEFBC8CE4B880E4B8AAE6898BE9878CE68BBFE79D80E88DAFEFBC8CE58FA6E4B880E4B8AAE6898BE4B88AE68BBFE79D80E884B8E79B86EFBC8CE4BDA0E4BC9AE68EA5E593AAE4B8AAE4B88AE8BDA6EFBC9FE58FAFE883BDE69C89E4BABAE4BC9AE8AFB4EFBC8CE5BD93E784B6E698AFE5B0B1E8BF91E58E9FE58899EFBC8CE8B081E7A6BBE5BE97E8BF91E5B0B1E8AEA9E8B081E4B88AE8BDA6E38082E4B88AE6B5B7E69C89E4B8AA266C6471756F3BE79A84E593A526726471756F3BE58FABE887A7E58BA4EFBC8CE4BB96E8AFB4E5BA94E8AFA5E68EA5E6898BE4B88AE68BBFE884B8E79B86E79A84E4BABAEFBC8CE79086E794B1E5BE88E7AE80E58D95EFBC9AE6898BE4B88AE68BBFE88DAFE79A84E4BABAE5A49AE58D8AE698AFE5B08FE79785E5B08FE7979BEFBC8CE4B88DE4BC9AE8B791E588B0E7A6BBE5AEB6E5A4AAE8BF9CE79A84E59CB0E696B9E58EBBE79C8BE79785EFBC8CE8808CE68BBFE884B8E79B86E79A84E4BABAE4B880E5AE9AE698AFE4BD8FE999A2E79A84EFBC8CE8B7AFE7A88BE9809AE5B8B8E4BC9AE69BB4E8BF9CEFBC8CE5908CE6A0B7E698AFE68B89E4B880E8B69FE5AEA2EFBC8CE694B6E585A5E58DB4E79BB8E5B7AEE682ACE6AE8AE380823C6272202F3E0D0AE38080E38080E887A7E58BA4E8A2ABE7A7B0E4B8BA266C6471756F3BE7A59EE5A587E79A84E593A526726471756F3BEFBC8CE4BB96E59CA8E4B88AE6B5B7E5BC80E4BA863137E5B9B4E587BAE7A79FE8BDA6EFBC8CE58E9FE69CACE9BB98E9BB98E697A0E997BBEFBC8CE79BB4E588B0E587A0E4B8AAE69C88E5898DEFBC8CE4BB96E98187E588B0E4BA86E4B880E4BD8DE789B9E6AE8AE4B998E5AEA2EFBC8CE6898DE5B9BFE4B8BAE4BABAE79FA5E380823C6272202F3E0D0AE38080E38080E4B880E5A4A9E4B8ADE58D88EFBC8CE887A7E58BA4E59CA8E4B88AE6B5B7E7BE8EE7BD97E5A4A7E58EA6E997A8E58FA3E68EA5E588B0E4B880E4BD8DE4B998E5AEA2EFBC8CE8BDA6E5AD90E5889AE8B5B7E6ADA5EFBC8CE4BB96E5B0B1E8B79FE4B998E5AEA2E783ADE68385E59CB0E8818AE4BA86E8B5B7E69DA5EFBC8C266C6471756F3BE7BB88E4BA8EE8A2ABE68891E5AE88E588B0E4BDA0E4BA86EFBC8CE4BB8EE58699E5AD97E6A5BCE9878CE587BAE69DA5E79A84EFBC8CE882AFE5AE9AE8B7AFE7A88BE4B88DE79FADE3808226726471756F3BE4B998E5AEA2E4B880E684A3EFBC8CE887AAE5B7B1E79A84E7A1AEE8A681E58EBBE69CBAE59CBAEFBC8C266C6471756F3BE4BDA0E6808EE4B988E79FA5E98193EFBC9F26726471756F3BE4BB96E8AFB4EFBC8C266C6471756F3BE68891E79C8BE4B880E4B8AAE4BABAE58FAAE8A68133E7A792E9929FEFBC8CE982A3E4BA9BE59CA8E8B685E5B882E997A8E58FA3E38081E59CB0E99381E58FA3E68993E8BDA6EFBC8CE7A9BFE79DA1E8A1A3E79A84E4BABAE58FAFE883BDE58EBBE69CBAE59CBAE59097EFBC9FE69CBAE59CBAE4B99FE4B88DE4BC9AE8AEA9E4BB96E4BBACE8BF9BE58EBBE5958A2668656C6C69703B2668656C6C69703B26726471756F3BE4B998E5AEA2E4B88DE794B1E5BE97E585B4E887B4E5A4A7E5A29EEFBC8CE8AFB7E4BB96E7BBA7E7BBADE5BE80E4B88BE8AFB4E380823C6272202F3E0D0AE38080E38080E887A7E58BA4E4B8BEE4BA86E4B880E4B8AAE4BE8BE5AD90EFBC9A266C6471756F3BE69C89E4B880E6ACA1EFBC8CE68891E59CA8E4BABAE6B091E5B9BFE59CBAE79C8BE588B0E4B889E4B8AAE4BABAE59CA8E5898DE99DA2E68B9BE6898BEFBC9AE7ACACE4B880E4B8AAE698AFE5B9B4E8BDBBE5A5B3E5AD90EFBC8CE68BBFE79D80E5B08FE58C85EFBC8CE5889AE4B9B0E5AE8CE4B89CE8A5BFEFBC9BE4B8ADE997B4E698AFE4B880E5AFB9E99D92E5B9B4E794B7E5A5B3EFBC8CE4B880E79C8BE5B0B1E698AFE9809BE8A197E79A84EFBC9BE7ACACE4B889E4B8AAE698AFE7A9BFE7BEBDE7BB92E69C8DE79A84E99D92E5B9B4E794B7E5AD90EFBC8CE6898BE4B88AE8BF98E68F90E79D80E7AC94E8AEB0E69CACE794B5E88491E38082E68891E6AFABE4B88DE78AB9E8B1ABE59CB0E68A8AE8BDA6E5BC80E588B0E4BA86E7BEBDE7BB92E69C8DE99DA2E5898DEFBC8CE982A3E4BABAE4B88AE4BA86E8BDA6E4B99FE8A789E5BE97E5A587E680AAEFBC8CE8AFB4E4BDA0E4B8BAE4BD95E694BEE5BC83E5898DE99DA2E4B8A4E4B8AAE4B88DE68EA5EFBC8CE5818FE5818FE5BC80E588B0E68891E99DA2E5898DEFBC9FE68891E8AFB4EFBC8CE7ACACE4B880E4B8AAE5A5B3E5ADA9E5AD90E698AFE4B8ADE58D88E6BA9CE587BAE69DA5E4B9B0E4B89CE8A5BFE79A84EFBC8CE4BCB0E8AEA1E585ACE58FB8E5BE88E8BF91EFBC9BE4B8ADE997B4E982A3E5AFB9E68385E4BEA3E698AFE6B8B8E5AEA2EFBC8CE6B2A1E68BBFE4BB80E4B988E4B89CE8A5BFEFBC8CE4B88DE4BC9AE58EBBE5BE88E8BF9CE38082E7BEBDE7BB92E69C8DE7AB96E8B5B7E5A4A7E68B87E68C87E8AFB4EFBC8CE4BDA0E8AFB4E5AFB9E4BA86EFBC8CE68891E58EBBE5AE9DE5B1B1E380823C6272202F3E0D0AE38080E38080266C6471756F3BE68891E5819AE8BF87E7B2BEE7A1AEE7BB9FE8AEA1EFBC8CE68891E6AF8FE5A4A9E5BC803137E4B8AAE5B08FE697B6E79A84E8BDA6EFBC8CE7AE97E4B88AE6B2B9E8B4B9E5928CE59084E7A78DE8B4B9E794A8EFBC8CE5B9B3E59D87E6AF8FE5B08FE697B6E79A84E68890E69CACE4B8BA33342E35E58583E38082E5A682E69E9CE4B88AE69DA5E4B880E4B8AA3130E58583E79A84E8B5B7E6ADA5E4BBB7EFBC8CE5A4A7E7BAA6E8A681E5BC803130E58886E9929FEFBC8CE58AA0E4B88AE6AF8FE6ACA1E8BDBDE5AEA2E4B98BE997B4E79A84E5B9B3E59D87E7A9BAE9A9B6E697B6E997B437E58886E9929FEFBC8CE7AD89E4BA8EE698AFE68891E88AB1E4BA863137E58886E9929FE58FAAE8B59AE4BA863130E58583E992B1EFBC8CE8808C3137E58886E9929FE79A84E68890E69CACE4BBB7E698AF392E38E58583EFBC8CE4B88DE58892E7AE97EFBC8C3230E58583E588B03530E58583E4B98BE997B4E79A84E7949FE6848FE680A7E4BBB7E6AF94E69C80E9AB98E3808226726471756F3BE4B998E5AEA2E590ACE5BE97E79EA0E79BAEE7BB93E8888CEFBC8CE4BA94E4BD93E68A95E59CB0EFBC8CE5BF83E683B3E4BB8AE5A4A9E98187E4B88AE4BA86E5A587E4BABAEFBC8CE8BF99E593AAE5838FE4B8AAE587BAE7A79FE8BDA6E58FB8E69CBAEFBC8CE68890E69CACE7AB9FE784B6E7B2BEE7A1AEE588B0E4BA86E6AF8FE58886E9929FEFBC8CE58886E6988EE5B0B1E698AFE4B8AAE68890E69CACE6A0B8E7AE97E5B888E380823C6272202F3E0D0AE38080E38080E8AFB4E8AF9DE997B4E8BDA6E5AD90E5B7B2E588B0E4BA86E69CBAE59CBAEFBC8CE4B998E5AEA2E4B88BE8BDA6E697B6EFBC8CE789B9E6848FE79599E4B88BE4BA86E4BB96E79A84E794B5E8AF9DE38082E982A3E4BD8DE4B998E5AEA2E5908DE58FABE58898E6B6A6EFBC8CE698AFE5BEAEE8BDAFE4B8ADE59BBDE585ACE58FB8E585A8E79083E68A80E69CAFE694AFE68C81E983A8E79A84E983A8E997A8E7BB8FE79086EFBC8CE4BA8BE5908EE4BB96E5