SSH里面怎样对两个字段排序？

[k_c_u_f]

 hsql="from Xa as x where x.Did='" + did + "' and x.Pid='" + pid + "'order by Date desc";

这是根据Date字段排序的，现在想增加一个排序字段Time，先对Date排序，再对Time排序，应该怎样写呢？

[shixitong]

……order by Date desc,Time asc

[shixitong]

引用 5 楼 k_c_u_f 的回复:

[quote=引用 1 楼 shixitong 的回复:]

……order by Date desc,Time asc

试过，没用，还是只对Date排序[/quote] 把你最终执行的sql语句和执行结果给我们看看（在数据库中）

[_追逐梦想_]

引用 6 楼 k_c_u_f 的回复:

[quote=引用 4 楼 a510835147 的回复:] hsql="select * from (select * from Xa as x where x.Did='" + did + "' and x.Pid='" + pid + "'order by Date desc) order by Time desc"

*号那个地方报错[/quote] 噢噢 hsql=" from Xa where id in (select id from Xa as x where x.Did='" + did + "' and x.Pid='" + pid + "'order by Date desc) order by Time desc" 这样应该就可以了，再试试，这个id是主键列

[k_c_u_f]

引用 8 楼 a510835147 的回复:

[quote=引用 6 楼 k_c_u_f 的回复:] [quote=引用 4 楼 a510835147 的回复:] hsql="select * from (select * from Xa as x where x.Did='" + did + "' and x.Pid='" + pid + "'order by Date desc) order by Time desc"

*号那个地方报错[/quote] 噢噢 hsql=" from Xa where id in (select id from Xa as x where x.Did='" + did + "' and x.Pid='" + pid + "'order by Date desc) order by Time desc" 这样应该就可以了，再试试，这个id是主键列[/quote] 这样实际上没有对Date排，只是对Time排了

[k_c_u_f]

引用 3 楼 Xgx120413 的回复:

就直接在order by 后面拼接多个待排序的字段即可。 xDDDDDDDDD

怎样拼接啊？这两个字段都是String型的

[_追逐梦想_]

引用 9 楼 k_c_u_f 的回复:

[quote=引用 8 楼 a510835147 的回复:] [quote=引用 6 楼 k_c_u_f 的回复:] [quote=引用 4 楼 a510835147 的回复:] hsql="select * from (select * from Xa as x where x.Did='" + did + "' and x.Pid='" + pid + "'order by Date desc) order by Time desc"

*号那个地方报错[/quote] 噢噢 hsql=" from Xa where id in (select id from Xa as x where x.Did='" + did + "' and x.Pid='" + pid + "'order by Date desc) order by Time desc" 这样应该就可以了，再试试，这个id是主键列[/quote] 这样实际上没有对Date排，只是对Time排了[/quote] 排了呀，先对date排，再对time排 。对date排是里面是那个子查询 对time排是外面那个查询 ，先对Date排序，再对Time排序 不是这样的么？

[k_c_u_f]

引用 11 楼 a510835147 的回复:

[quote=引用 9 楼 k_c_u_f 的回复:] [quote=引用 8 楼 a510835147 的回复:] [quote=引用 6 楼 k_c_u_f 的回复:] [quote=引用 4 楼 a510835147 的回复:] hsql="select * from (select * from Xa as x where x.Did='" + did + "' and x.Pid='" + pid + "'order by Date desc) order by Time desc"

*号那个地方报错[/quote] 噢噢 hsql=" from Xa where id in (select id from Xa as x where x.Did='" + did + "' and x.Pid='" + pid + "'order by Date desc) order by Time desc" 这样应该就可以了，再试试，这个id是主键列[/quote] 这样实际上没有对Date排，只是对Time排了[/quote] 排了呀，先对date排，再对time排 。对date排是里面是那个子查询 对time排是外面那个查询 ，先对Date排序，再对Time排序 不是这样的么？[/quote] 我试过的，只是对Time排序，除非对Date字段用group by，才是先对Date排，再对Time排，但是我不知道hsql的这种语句应该怎样写

[很难搞定]

你们用字符串拼接SQL 不怕被注入吗

[Earl_yuan]

hql和sql基本一样，所以sql可以对多个字段排序，就像楼上说的，那么对于hql也可以这样排序

[Cansluck]

就直接在order by 后面拼接多个待排序的字段即可。 xDDDDDDDDD

[_追逐梦想_]

hsql="select * from (select * from Xa as x where x.Did='" + did + "' and x.Pid='" + pid + "'order by Date desc) order by Time desc"

[k_c_u_f]

引用 4 楼 a510835147 的回复:

hsql="select * from (select * from Xa as x where x.Did='" + did + "' and x.Pid='" + pid + "'order by Date desc) order by Time desc"

*号那个地方报错

[k_c_u_f]

引用 1 楼 shixitong 的回复:

……order by Date desc,Time asc

试过，没用，还是只对Date排序