本文整理汇总了Java中org.apache.ibatis.type.JdbcType.INTEGER属性的典型用法代码示例。如果您正苦于以下问题:Java JdbcType.INTEGER属性的具体用法?Java JdbcType.INTEGER怎么用?Java JdbcType.INTEGER使用的例子?那么, 这里精选的属性代码示例或许可以为您提供帮助。您也可以进一步了解该属性所在类org.apache.ibatis.type.JdbcType
的用法示例。
在下文中一共展示了JdbcType.INTEGER属性的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: selectByExample
@SelectProvider(type=UserSqlProvider.class, method="selectByExample")
@Results({
@Result(column="id", property="id", jdbcType=JdbcType.INTEGER, id=true),
@Result(column="username", property="username", jdbcType=JdbcType.VARCHAR),
@Result(column="psw", property="psw", jdbcType=JdbcType.VARCHAR)
})
List<User> selectByExample(UserCriteria example);
示例2: 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);
示例3: 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);
示例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);
示例5: 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);
示例6: 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);
示例7: JOIN
@Select({"SELECT m.id, m.name, m.url, m.icon, m.menu_type, m.display, m.parent_id, m.status,",
"r.roleid FROM menu m LEFT JOIN (SELECT roleid,menuid FROM role_menu WHERE roleid=#{roleid})",
" r ON m.id=r.menuid "})
@Results({
@Result(column="parent_id", property="parentId", jdbcType= JdbcType.INTEGER)
})
List<Menu> selectByRoleId(int roleId);
示例8: IN
/**
*查询用户有权限的菜单列表
* @param userid
* @return
*/
@Select({"SELECT id, name, url, icon, menu_type, display, parent_id FROM menu WHERE id IN(",
"SELECT menuid FROM role_menu WHERE roleid IN ",
"(SELECT roleid FROM user_role WHERE userid=#{userid}) OR roleid=-1) AND menu_type<>'2' AND `status`='1'"})
@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="status", property="status", jdbcType= JdbcType.CHAR)
})
List<Menu> selectByUser(int userid);
示例9: 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);
示例10: 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);
示例11: 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);
示例12: 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);
示例13: 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);
示例14: selectByExample
@SelectProvider(type=UserSqlProvider.class, method="selectByExample")
@Results({
@Result(column="id", property="id", jdbcType=JdbcType.INTEGER, id=true),
@Result(column="username", property="username", jdbcType=JdbcType.VARCHAR),
@Result(column="password", property="password", jdbcType=JdbcType.VARCHAR),
@Result(column="role", property="role", jdbcType=JdbcType.INTEGER)
})
List<User> selectByExample(UserExample example);
示例15: selectByPrimaryKey
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table SysCode
*
* @mbggenerated Wed Jul 12 20:57:03 CST 2017
*/
@Select({
"select",
"codeId, codeTypeId, codeName, parentCodeId",
"from SysCode",
"where codeId = #{codeId,jdbcType=INTEGER}"
})
@Results({
@Result(column="codeId", property="codeId", jdbcType=JdbcType.INTEGER, id=true),
@Result(column="codeTypeId", property="codeTypeId", jdbcType=JdbcType.INTEGER),
@Result(column="codeName", property="codeName", jdbcType=JdbcType.VARCHAR),
@Result(column="parentCodeId", property="parentCodeId", jdbcType=JdbcType.INTEGER)
})
SysCode selectByPrimaryKey(Integer codeId);