排序错乱的sql及其结果图: SELECT NAME FROM ST_SCHDULE_NUM ORDER BY NAME ASC 可以看到上图中的1-10排在了1-2的前面,这是因为没有使用to_number(),针对此问题做出修改. 修改思路:先根据字符-前面的数字排序,再根据字符-后面的数字排序 排序正确的sql及其结果图: SELECT NAME FROM ST_SCHDULE_NUM ORDER BY TO_NUMBER(substr( NAME, 1, instr( NAME, '-',- 1 ) - 1 )) ASC, TO_NUMBER(substr( NAME, instr( NAME, '-',- 1 ) + 1 )) ASC
{ "port": "3000", "adminAccount": "598941324@qq.com", "db": { "servername": "127.0.0.1", "DATABASE": "yapi", "port": "27017" }, "mail": { "enable": false, "host": "smtp.163.com", "port": 465, "from": "@163.com", "auth": { "user": "@163.com", "pass": "*****" } }, "ldapLogin": { "enable": true, "server": "ldap://172.16.16.14", "baseDn": "CN=root,DC=wenyang,DC=com", "bindPassword": "wenyang", "searchDn": "OU=manager,DC=wenyang,DC=com", "searchStandard": "uid", "usernameKe....
题目 下面的字符串数组当中存有多条信息,请按照格式"姓名:xx,性别:xx"将信息打印出来,要求将打印姓名的动作作为第一个Consumer接口的Lambda实例,将打印性别的动作作为第二个Consumer接口的Lambda实例,将两个Consumer接口按照顺序拼接在一起。 String [] str = {"迪丽热巴,女", "古力娜扎,女", "马尔扎哈,男"}; 代码实现 import java.util.function.Consumer; /** * @author xuyuntong * @date 2021/1/14 10:20 */ public class testmain { public static void main(String[] args) throws Exception { String [] str = {"迪丽热巴,女", "古力娜扎,女", "马尔扎哈,男"}; Consumer<String> nameConsumer = testmain::printName; Consumer<String> sexCon....