本文整理匯總了Java中org.apache.ibatis.type.JdbcType.CHAR屬性的典型用法代碼示例。如果您正苦於以下問題：Java JdbcType.CHAR屬性的具體用法？Java JdbcType.CHAR怎麽用？Java JdbcType.CHAR使用的例子？那麽, 這裏精選的屬性代碼示例或許可以為您提供幫助。您也可以進一步了解該屬性所在類org.apache.ibatis.type.JdbcType的用法示例。
在下文中一共展示了JdbcType.CHAR屬性的3個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的Java代碼示例。
示例1: 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);
示例2: 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);
示例3: getUser
@Select("select * from users where id = #{value}")
@Results({
@Result(column="id", property="id"),
@Result(column="name", property="name"),
@Result(column="city", property="city", jdbcType=JdbcType.CHAR),
@Result(column="state", property="state", jdbcType=JdbcType.VARCHAR)
})
User getUser(Integer id);