当前位置: 首页>>代码示例>>Java>>正文

Java JdbcType.TIMESTAMP属性代码示例

本文整理汇总了Java中org.apache.ibatis.type.JdbcType.TIMESTAMP属性的典型用法代码示例。如果您正苦于以下问题：Java JdbcType.TIMESTAMP属性的具体用法？Java JdbcType.TIMESTAMP怎么用？Java JdbcType.TIMESTAMP使用的例子？那么, 这里精选的属性代码示例或许可以为您提供帮助。您也可以进一步了解该属性所在类org.apache.ibatis.type.JdbcType的用法示例。


在下文中一共展示了JdbcType.TIMESTAMP属性的11个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Java代码示例。

示例1: select

@Select({
        "select",
        "u.id, u.name, u.email, u.creator, u.flag, u.last_login_time,c.name createUser",
        "from admin_user u LEFT JOIN admin_user c ON u.creator=c.id",
        "where u.name LIKE #{query} LIMIT #{begin},#{pagesize}"
})
@Results({
        @Result(column="id", property="id", jdbcType= JdbcType.INTEGER, id=true),
        @Result(column="name", property="name", jdbcType= JdbcType.VARCHAR),
        @Result(column="psw", property="psw", jdbcType= JdbcType.VARCHAR),
        @Result(column="email", property="email", jdbcType= JdbcType.VARCHAR),
        @Result(column="creator", property="creator", jdbcType= JdbcType.INTEGER),
        @Result(column="flag", property="flag", jdbcType= JdbcType.INTEGER),
        @Result(column="last_login_time", property="lastLoginTime", jdbcType= JdbcType.TIMESTAMP)
})
List<AdminUser> select(@Param("begin") int begin, @Param("pagesize") int pageSize, @Param("query") String query);
开发者ID:RayeWang，项目名称:easyadmin，代码行数:16，代码来源:AdminUserMapper.java

示例2: selectByExample

@SelectProvider(type=MenuSqlProvider.class, method="selectByExample")
@Results({
    @Result(column="id", property="id", jdbcType= JdbcType.INTEGER, id=true),
    @Result(column="name", property="name", jdbcType= JdbcType.VARCHAR),
    @Result(column="url", property="url", jdbcType= JdbcType.VARCHAR),
    @Result(column="icon", property="icon", jdbcType= JdbcType.VARCHAR),
    @Result(column="menu_type", property="menuType", jdbcType= JdbcType.CHAR),
    @Result(column="display", property="display", jdbcType= JdbcType.INTEGER),
    @Result(column="parent_id", property="parentId", jdbcType= JdbcType.INTEGER),
    @Result(column="creator", property="creator", jdbcType= JdbcType.INTEGER),
    @Result(column="create_time", property="createTime", jdbcType= JdbcType.TIMESTAMP),
    @Result(column="update_user", property="updateUser", jdbcType= JdbcType.INTEGER),
    @Result(column="update_time", property="updateTime", jdbcType= JdbcType.TIMESTAMP),
    @Result(column="status", property="status", jdbcType= JdbcType.CHAR)
})
List<Menu> selectByExample(MenuCriteria example);
开发者ID:RayeWang，项目名称:easyadmin，代码行数:16，代码来源:MenuMapper.java

示例3: selectByExample

@SelectProvider(type=RoleSqlProvider.class, method="selectByExample")
@Results({
    @Result(column="id", property="id", jdbcType= JdbcType.INTEGER, id=true),
    @Result(column="name", property="name", jdbcType= JdbcType.VARCHAR),
    @Result(column="create_time", property="createTime", jdbcType= JdbcType.TIMESTAMP),
    @Result(column="creator", property="creator", jdbcType= JdbcType.INTEGER),
    @Result(column="update_time", property="updateTime", jdbcType= JdbcType.TIMESTAMP),
    @Result(column="update_user", property="updateUser", jdbcType= JdbcType.INTEGER),
    @Result(column="description", property="description", jdbcType= JdbcType.VARCHAR)
})
List<Role> selectByExample(RoleCriteria example);
开发者ID:RayeWang，项目名称:easyadmin，代码行数:11，代码来源:RoleMapper.java

示例4: select

@Select({
        "select",
        "r.id, r.name, r.create_time, r.creator,u.name as creator, r.description",
        "from role r LEFT JOIN admin_user u ON r.creator=u.id",
        "where r.name like #{query} LIMIT #{begin},#{pagesize}"
})
@Results({
        @Result(column="id", property="id", jdbcType= JdbcType.INTEGER, id=true),
        @Result(column="name", property="name", jdbcType= JdbcType.VARCHAR),
        @Result(column="create_time", property="createTime", jdbcType= JdbcType.TIMESTAMP),
        @Result(column="creator", property="creator", jdbcType= JdbcType.INTEGER),
        @Result(column="description", property="description", jdbcType= JdbcType.VARCHAR)
})
List<Role> select(@Param("begin") int begin, @Param("pagesize") int pageSize, @Param("query") String query);
开发者ID:RayeWang，项目名称:easyadmin，代码行数:14，代码来源:RoleMapper.java

示例5: selectByExample

@SelectProvider(type=AdminUserSqlProvider.class, method="selectByExample")
@Results({
    @Result(column="id", property="id", jdbcType= JdbcType.INTEGER, id=true),
    @Result(column="name", property="name", jdbcType= JdbcType.VARCHAR),
    @Result(column="psw", property="psw", jdbcType= JdbcType.VARCHAR),
    @Result(column="email", property="email", jdbcType= JdbcType.VARCHAR),
    @Result(column="update_time", property="updateTime", jdbcType= JdbcType.TIMESTAMP),
    @Result(column="update_user", property="updateUser", jdbcType= JdbcType.INTEGER),
    @Result(column="creator", property="creator", jdbcType= JdbcType.INTEGER),
    @Result(column="flag", property="flag", jdbcType= JdbcType.INTEGER),
    @Result(column="last_login_time", property="lastLoginTime", jdbcType= JdbcType.TIMESTAMP)
})
List<AdminUser> selectByExample(AdminUserCriteria example);
开发者ID:RayeWang，项目名称:easyadmin，代码行数:13，代码来源:AdminUserMapper.java

示例6: selectByExample

@SelectProvider(type=UserRoleSqlProvider.class, method="selectByExample")
@Results({
    @Result(column="userid", property="userid", jdbcType= JdbcType.INTEGER, id=true),
    @Result(column="roleid", property="roleid", jdbcType= JdbcType.INTEGER, id=true),
    @Result(column="creator", property="creator", jdbcType= JdbcType.INTEGER),
    @Result(column="create_time", property="createTime", jdbcType= JdbcType.TIMESTAMP)
})
List<UserRole> selectByExample(UserRoleCriteria example);
开发者ID:RayeWang，项目名称:easyadmin，代码行数:8，代码来源:UserRoleMapper.java

示例7: JOIN

@Select({"SELECT r.id, r.name, r.create_time, r.creator, r.description,u.name creatorUser,u1.userid ",
    "FROM role r LEFT JOIN admin_user u ON r.creator=u.id",
    " LEFT JOIN (SELECT roleid,userid FROM user_role WHERE userid=#{userId}) u1 ON r.id=u1.roleid  "})
@Results({
        @Result(column="id", property="id", jdbcType= JdbcType.INTEGER, id=true),
        @Result(column="name", property="name", jdbcType= JdbcType.VARCHAR),
        @Result(column="create_time", property="createTime", jdbcType= JdbcType.TIMESTAMP),
        @Result(column="creator", property="creator", jdbcType= JdbcType.INTEGER),
        @Result(column="description", property="description", jdbcType= JdbcType.VARCHAR),
        @Result(column = "creatorUser",property = "creatorUser",jdbcType = JdbcType.INTEGER)
})
List<Role> selectByUserId(int userId);
开发者ID:RayeWang，项目名称:easyadmin，代码行数:12，代码来源:UserRoleMapper.java

示例8: selectByPrimaryKey

@Select({
    "select",
    "userid, roleid, creator, create_time",
    "from user_role",
    "where userid = #{userid,jdbcType=INTEGER}",
      "and roleid = #{roleid,jdbcType=INTEGER}"
})
@Results({
    @Result(column="userid", property="userid", jdbcType= JdbcType.INTEGER, id=true),
    @Result(column="roleid", property="roleid", jdbcType= JdbcType.INTEGER, id=true),
    @Result(column="creator", property="creator", jdbcType= JdbcType.INTEGER),
    @Result(column="create_time", property="createTime", jdbcType= JdbcType.TIMESTAMP)
})
UserRole selectByPrimaryKey(@Param("userid") Integer userid, @Param("roleid") Integer roleid);
开发者ID:RayeWang，项目名称:easyadmin，代码行数:14，代码来源:UserRoleMapper.java

示例9: selectByExample

@SelectProvider(type=RoleMenuSqlProvider.class, method="selectByExample")
@Results({
    @Result(column="menuid", property="menuid", jdbcType= JdbcType.INTEGER, id=true),
    @Result(column="roleid", property="roleid", jdbcType= JdbcType.INTEGER, id=true),
    @Result(column="flag", property="flag", jdbcType= JdbcType.INTEGER),
    @Result(column="creator", property="creator", jdbcType= JdbcType.INTEGER),
    @Result(column="create_time", property="createTime", jdbcType= JdbcType.TIMESTAMP)
})
List<RoleMenu> selectByExample(RoleMenuCriteria example);
开发者ID:RayeWang，项目名称:easyadmin，代码行数:9，代码来源:RoleMenuMapper.java

示例10: selectByPrimaryKey

@Select({
    "select",
    "menuid, roleid, flag, creator, create_time",
    "from role_menu",
    "where menuid = #{menuid,jdbcType=INTEGER}",
      "and roleid = #{roleid,jdbcType=INTEGER}"
})
@Results({
    @Result(column="menuid", property="menuid", jdbcType= JdbcType.INTEGER, id=true),
    @Result(column="roleid", property="roleid", jdbcType= JdbcType.INTEGER, id=true),
    @Result(column="flag", property="flag", jdbcType= JdbcType.INTEGER),
    @Result(column="creator", property="creator", jdbcType= JdbcType.INTEGER),
    @Result(column="create_time", property="createTime", jdbcType= JdbcType.TIMESTAMP)
})
RoleMenu selectByPrimaryKey(@Param("menuid") Integer menuid, @Param("roleid") Integer roleid);
开发者ID:RayeWang，项目名称:easyadmin，代码行数:15，代码来源:RoleMenuMapper.java

示例11: selectByPrimaryKey

@Select(value = "select id, username, password, nick_name, sex, register_date from user where id = #{id,jdbcType=INTEGER}")
@Results(value = { @Result(column = "nick_name", property = "nickName", jdbcType = JdbcType.VARCHAR), @Result(column = "register_date", property = "registerDate", jdbcType = JdbcType.TIMESTAMP) })
User selectByPrimaryKey(Integer id);
开发者ID:wooui，项目名称:springboot-training，代码行数:3，代码来源:UserMapper.java


注：本文中的org.apache.ibatis.type.JdbcType.TIMESTAMP属性示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。