你们要的Twitter OA (含Java代码）

duziyuanyang 发表于 2016-10-31 04:36
parent, child, tree那题，选Oracle, pass all test case

请问楼主这边一定要用oracle写吗？还是语言可以自己选啊？我用mysql比较多。。。

encrypt and decrypt message我也做了很久。。。感觉不能这么做。因为-Your friend, Alice不是开头。我们无法知道哪一个是key的开头

wenjun93 发表于 2017-10-26 02:47
encrypt and decrypt message我也做了很久。。。感觉不能这么做。因为-Your friend, Alice不是开头。我们无 ...

For some reason, I cannot type Chinese on my computer today.
You need to read the question carefully, it asks you to figure out the key before you start coding. Otherwise, there will be at most 2^n way to do this. I missed that at beginning too. lol

Thanks for sharing!

楼主好人啊！！

楼主太厉害了~感谢大佬

好全面 谢谢楼主

duziyuanyang 发表于 2016-10-31 04:38
employee, department题， 自己没遇到，不过同学试了通过了

THIS PASSED THE TEST

1. SELECT DEPARTMENT.NAME AS 'DNAME', IFNULL(COUNT(EMPLOYEE.DEPT_ID),0) AS 'NUM'
   
2. FROM DEPARTMENT
   
3. LEFT JOIN EMPLOYEE
   
4. ON EMPLOYEE.DEPT_ID=DEPARTMENT.DEPT_ID
   
5. GROUP BY DEPARTMENT.DEPT_ID,DEPARTMENT.NAME
   
6. ORDER BY NUM DESC, DNAME;

复制代码

EMPLOYEE TABLE SOLUTION

1. SELECT DEPARTMENT.NAME AS 'DNAME', IFNULL(COUNT(EMPLOYEE.DEPT_ID),0) AS 'NUM'
   
2. FROM DEPARTMENT
   
3. LEFT JOIN EMPLOYEE
   
4. ON EMPLOYEE.DEPT_ID=DEPARTMENT.DEPT_ID
   
5. GROUP BY DEPARTMENT.DEPT_ID,DEPARTMENT.NAME
   
6. ORDER BY NUM DESC, DNAME;

复制代码

duziyuanyang 发表于 2016-10-31 04:36
parent, child, tree那题，选Oracle, pass all test case

不对啊