java gjp sql

/*
           
     gjp
*/
CREATE DATABASE gjp;

USE gjp;

/*
       ,    
    , 
    
            
      double
           (  ,    )
       date
           
*/

CREATE TABLE gjp_zhangwu(
   --   
   zwid INT PRIMARY KEY AUTO_INCREMENT,
   --        
   flname VARCHAR(200),
   --   
   money DOUBLE,
   --   
   zhanghu VARCHAR(100),
   --     
   createtime DATE,
   --     
   description  VARCHAR(1000)
);
SELECT * FROM gjp_zhangwu

--        
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','      ');
INSERT  INTO gjp_zhangwu(zwid,flname,money,zhangHu,createtime,description) VALUES (11,'    ',1000,'    ','2016-10-29','   ');
INSERT  INTO gjp_zhangwu(zwid,flname,money,zhangHu,createtime,description) VALUES (12,'    ',1000,'  ','2016-10-30','  ');
INSERT  INTO gjp_zhangwu(zwid,flname,money,zhangHu,createtime,description) VALUES (13,'    ',2000,'  ','2016-10-30','    ');
INSERT  INTO gjp_zhangwu(zwid,flname,money,zhangHu,createtime,description) VALUES (14,'    ',5000,'  ','2016-10-30','   ');