简易的记账软件设计与实现

1.创建数据库

/*
SQLyog Ultimate v12.4.0 (64 bit)
MySQL - 5.5.49 
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;

create table `gjp_zhangwu` (
    `zwid` int (11),
    `flname` varchar (600),
    `money` double ,
    `zhangHu` varchar (300),
    `createtime` date ,
    `description` varchar (3000)
); 
insert into `gjp_zhangwu` (`zwid`, `flname`, `money`, `zhangHu`, `createtime`, `description`) values('1','吃饭支出','247','交通银行','2016-03-02','家庭聚餐');
insert into `gjp_zhangwu` (`zwid`, `flname`, `money`, `zhangHu`, `createtime`, `description`) values('2','工资收入','12345','现金','2016-03-15','开工资了');
insert into `gjp_zhangwu` (`zwid`, `flname`, `money`, `zhangHu`, `createtime`, `description`) values('3','服装支出','1998','现金','2016-04-02','买衣服');
insert into `gjp_zhangwu` (`zwid`, `flname`, `money`, `zhangHu`, `createtime`, `description`) values('4','吃饭支出','325','现金','2016-06-18','朋友聚餐');
insert into `gjp_zhangwu` (`zwid`, `flname`, `money`, `zhangHu`, `createtime`, `description`) values('5','股票收入','8000','工商银行','2016-10-28','股票大涨');
insert into `gjp_zhangwu` (`zwid`, `flname`, `money`, `zhangHu`, `createtime`, `description`) values('6','股票收入','5000','工商银行','2016-10-28','股票又大涨');
insert into `gjp_zhangwu` (`zwid`, `flname`, `money`, `zhangHu`, `createtime`, `description`) values('7','工资收入','5000','交通银行','2016-10-28','又开工资了');
insert into `gjp_zhangwu` (`zwid`, `flname`, `money`, `zhangHu`, `createtime`, `description`) values('8','礼金支出','5000','现金','2016-10-28','朋友结婚');
insert into `gjp_zhangwu` (`zwid`, `flname`, `money`, `zhangHu`, `createtime`, `description`) values('9','其他支出','1560','现金','2016-10-29','丢钱了');
insert into `gjp_zhangwu` (`zwid`, `flname`, `money`, `zhangHu`, `createtime`, `description`) values('10','交通支出','2300','交通银行','2016-10-29'