使用注解

CREATE TABLE `ktx_user_info` (
  `USER_INFO_ID_` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `LOGIN_NAME_` varchar(32) DEFAULT 'NULL' COMMENT '登录名',
  `PASSWORD_` varchar(32) DEFAULT 'NULL' COMMENT '密码',
  `USER_AGE_` int(3) DEFAULT NULL COMMENT '姓名',
  `GMT_CREATE_` datetime DEFAULT NULL COMMENT '创建时间',
  `GMT_MODIFY_` datetime DEFAULT NULL COMMENT '编辑时间',
  PRIMARY KEY (`USER_INFO_ID_`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='用户';

@Entity("ktx_user_info")
public class KUserInfo extends Model {

    @Id
    @Column("USER_INFO_ID_")
    private Long rowId;

    @Column("LOGIN_NAME_")
    private String loginName;

    @Column("PASSWORD_")
    private String password;

    @Column("USER_AGE_")
    private Integer userAge;

    @Column("GMT_CREATE_")
    private Date gmtCreate;

    @Column("GMT_MODIFY_")
    private Date gmtModify;

    @Transient
    private String testName;

    //getter and setter
}

//insert
KUserInfo ku = new KUserInfo();
ku.setLoginName("insertName");
ku.setPassword("123456");
ku.setUserAge(18);
ku.setGmtCreate(new Date());
Long id = (Long) jdbcDao.executeInsert(ku);

//update
KUserInfo ku = new KUserInfo();
ku.setRowId(36L);
ku.setPassword("787878");
ku.setGmtModify(new Date());
int count = jdbcDao.executeUpdate(ku);

//get
KUserInfo annotationUserInfo = jdbcDao.get(KUserInfo.class, id);

//delete
int count = jdbcDao.executeDelete(KUserInfo.class, id);