工具:mybatis+pgsql
详见: pgsql官方文档
含义: 字符串数字转int型排序
表结构:
create table user(
id varchar(32),
username varchar(32),
password varchar(32)
)
案例 – 通过id从小到大排序
dao层
List<User> list();
sql
<select id = "list" resultType = "com.test.dto.User">
select id,username,password
from user
order by cast(id as integer) asc
</select>