Java JdbcType.VARCHAR屬性代碼示例

本文整理匯總了Java中org.apache.ibatis.type.JdbcType.VARCHAR屬性的典型用法代碼示例。如果您正苦於以下問題：Java JdbcType.VARCHAR屬性的具體用法？Java JdbcType.VARCHAR怎麽用？Java JdbcType.VARCHAR使用的例子？那麽, 這裏精選的屬性代碼示例或許可以為您提供幫助。您也可以進一步了解該屬性所在類org.apache.ibatis.type.JdbcType的用法示例。

在下文中一共展示了JdbcType.VARCHAR屬性的14個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的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);

開發者ID:RayeWang，項目名稱:SpringbootMybatis，代碼行數:7，代碼來源:UserMapper.java

示例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);

開發者ID:RayeWang，項目名稱:easyadmin，代碼行數:16，代碼來源:AdminUserMapper.java

示例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);

開發者ID:RayeWang，項目名稱:easyadmin，代碼行數:16，代碼來源:MenuMapper.java

示例4: 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

示例5: 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

示例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);

開發者ID:RayeWang，項目名稱:easyadmin，代碼行數:13，代碼來源:AdminUserMapper.java

示例7: 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);

開發者ID:RayeWang，項目名稱:easyadmin，代碼行數:19，代碼來源:MenuMapper.java

示例8: 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

示例9: 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);

開發者ID:shenhuanet，項目名稱:ssm-server，代碼行數:8，代碼來源:UserMapper.java

示例10: 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);

開發者ID:chenyurong，項目名稱:china-district-syscode，代碼行數:19，代碼來源:SysCodeMapper.java

示例11: 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);

開發者ID:yuexiahandao，項目名稱:MybatisCode，代碼行數:8，代碼來源:Mapper.java

示例12: pg_encoding_to_char

@Select("SELECT datname, rolname, datctype, pg_encoding_to_char(encoding) AS encode "
		+ "FROM pg_database, pg_roles "
		+ "WHERE pg_database.encoding=#{encodingType} "
		+ "AND pg_database.datdba=pg_roles.oid;")
@Results(value = {
		@Result(property="databaseName", column="datname", jdbcType=JdbcType.VARCHAR),
		@Result(property="databaseDbaName", column="rolname", jdbcType=JdbcType.VARCHAR),
		@Result(property="databaseCtype", column="datctype", jdbcType=JdbcType.VARCHAR),
		@Result(property="databaseEncode", column="encode", jdbcType=JdbcType.VARCHAR)
})
List<PgDatabaseInfo> getUtf8Databases(@Param("encodingType") int encodeType);

開發者ID:xiaowing，項目名稱:various_demos，代碼行數:11，代碼來源:PgDatabaseMapper.java

示例13: selectMany

@SelectProvider(type=SqlProviderAdapter.class, method="select")
@Results(id="SimpleTableResult", value= {
        @Result(column="A_ID", property="id", jdbcType=JdbcType.INTEGER, id=true),
        @Result(column="first_name", property="firstName", jdbcType=JdbcType.VARCHAR),
        @Result(column="last_name", property="lastName", jdbcType=JdbcType.VARCHAR, typeHandler=LastNameTypeHandler.class),
        @Result(column="birth_date", property="birthDate", jdbcType=JdbcType.DATE),
        @Result(column="employed", property="employed", jdbcType=JdbcType.VARCHAR, typeHandler=YesNoTypeHandler.class),
        @Result(column="occupation", property="occupation", jdbcType=JdbcType.VARCHAR)
})
List<SimpleTableRecord> selectMany(SelectStatementProvider selectStatement);

開發者ID:mybatis，項目名稱:mybatis-dynamic-sql，代碼行數:10，代碼來源:SimpleTableAnnotatedMapper.java

示例14: 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.VARCHAR屬性示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台，相關代碼片段篩選自各路編程大神貢獻的開源項目，源碼版權歸原作者所有，傳播和使用請參考對應項目的License；未經允許，請勿轉載。