Spring之JDBC模板(手写)
一 模板父类: SpringBaseDAO.java

sql文件如下:
-- Create tablecreate table COMMUNICATIONGROUPINGS(  cgid      VARCHAR2(32),  cgname    VARCHAR2(60),  cgcomment VARCHAR2(4000),  userid    VARCHAR2(32),  username  VARCHAR2(60),  cgtime    VARCHAR2(40))-- Add comments to the table comment on table COMMUNICATIONGROUPINGS  is '通讯录分组';-- Add comments to the columns comment on column COMMUNICATIONGROUPINGS.cgid  is '主键ID';comment on column COMMUNICATIONGROUPINGS.cgname  is '通讯录组名';comment on column COMMUNICATIONGROUPINGS.cgcomment  is '备注';comment on column COMMUNICATIONGROUPINGS.userid  is '创建人ID';comment on column COMMUNICATIONGROUPINGS.username  is '创建人姓名';comment on column COMMUNICATIONGROUPINGS.cgtime  is '创建时间<YYYY-MM-DD hh:mm:ss>';