<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[fIuent的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/fIuent</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; fIuent]]></copyright><item><title><![CDATA[【LeetCode】Z字形变换]]></title><link>https://blog.youkuaiyun.com/fIuent/article/details/82799430</link><guid>https://blog.youkuaiyun.com/fIuent/article/details/82799430</guid><author>fIuent</author><pubDate>Fri, 21 Sep 2018 11:50:57 +0800</pubDate><description><![CDATA[【题目描述】

将字符串 &quot;PAYPALISHIRING&quot; 以Z字形排列成给定的行数：


P   A   H   N
A P L S I I G
Y   I   R


之后从左往右，逐行读取字符：&quot;PAHNAPLSIIGYIR&quot;

实现一个将字符串进行指定行数变换的函数:


string convert(string s, int numRows);

示例 1:


输入: s = &quot;PA...]]></description><category></category></item><item><title><![CDATA[【LeetCode】数据库 - 部门工资前三高的员工]]></title><link>https://blog.youkuaiyun.com/fIuent/article/details/82713433</link><guid>https://blog.youkuaiyun.com/fIuent/article/details/82713433</guid><author>fIuent</author><pubDate>Sat, 15 Sep 2018 15:24:05 +0800</pubDate><description><![CDATA[【题目描述】

Employee 表包含所有员工信息，每个员工有其对应的 Id, salary 和 department Id 。


+----+-------+--------+--------------+
| Id | Name  | Salary | DepartmentId |
+----+-------+--------+--------------+
| 1  | Joe   | ...]]></description><category></category></item><item><title><![CDATA[【LeetCode】数据库 - 部门工资最高的员工]]></title><link>https://blog.youkuaiyun.com/fIuent/article/details/82711768</link><guid>https://blog.youkuaiyun.com/fIuent/article/details/82711768</guid><author>fIuent</author><pubDate>Sat, 15 Sep 2018 10:47:44 +0800</pubDate><description><![CDATA[【题目描述】

Employee 表包含所有员工信息，每个员工有其对应的 Id, salary 和 department Id。


+----+-------+--------+--------------+
| Id | Name  | Salary | DepartmentId |
+----+-------+--------+--------------+
| 1  | Joe   | 7...]]></description><category></category></item><item><title><![CDATA[【LeetCode】数据库 - 从不订购的客户]]></title><link>https://blog.youkuaiyun.com/fIuent/article/details/82703635</link><guid>https://blog.youkuaiyun.com/fIuent/article/details/82703635</guid><author>fIuent</author><pubDate>Fri, 14 Sep 2018 15:28:11 +0800</pubDate><description><![CDATA[【题目描述】

某网站包含两个表，Customers 表和 Orders 表。编写一个 SQL 查询，找出所有从不订购任何东西的客户。

Customers 表：


+----+-------+
| Id | Name  |
+----+-------+
| 1  | Joe   |
| 2  | Henry |
| 3  | Sam   |
| 4  | Max   |
+----+-----...]]></description><category></category></item><item><title><![CDATA[【LeetCode】数据库 - 查找重复的电子邮箱]]></title><link>https://blog.youkuaiyun.com/fIuent/article/details/82700452</link><guid>https://blog.youkuaiyun.com/fIuent/article/details/82700452</guid><author>fIuent</author><pubDate>Fri, 14 Sep 2018 11:48:37 +0800</pubDate><description><![CDATA[【题目描述】

编写一个 SQL 查询，查找 Person 表中所有重复的电子邮箱。

示例：


+----+---------+
| Id | Email   |
+----+---------+
| 1  | a@b.com |
| 2  | c@d.com |
| 3  | a@b.com |
+----+---------+


根据以上输入，你的查询应返回以下结果：


+------...]]></description><category></category></item><item><title><![CDATA[【LeetCode】数据库 - 超过经理收入的员工]]></title><link>https://blog.youkuaiyun.com/fIuent/article/details/82664384</link><guid>https://blog.youkuaiyun.com/fIuent/article/details/82664384</guid><author>fIuent</author><pubDate>Wed, 12 Sep 2018 16:57:39 +0800</pubDate><description><![CDATA[【题目描述】

Employee 表包含所有员工，他们的经理也属于员工。每个员工都有一个 Id，此外还有一列对应员工的经理的 Id。


+----+-------+--------+-----------+
| Id | Name  | Salary | ManagerId |
+----+-------+--------+-----------+
| 1  | Joe   | 70000  |...]]></description><category></category></item><item><title><![CDATA[【LeetCode】数据库 - 连续出现的数字]]></title><link>https://blog.youkuaiyun.com/fIuent/article/details/82663635</link><guid>https://blog.youkuaiyun.com/fIuent/article/details/82663635</guid><author>fIuent</author><pubDate>Wed, 12 Sep 2018 16:45:05 +0800</pubDate><description><![CDATA[【题目描述】

编写一个 SQL 查询，查找所有至少连续出现三次的数字。


+----+-----+
| Id | Num |
+----+-----+
| 1  |  1  |
| 2  |  1  |
| 3  |  1  |
| 4  |  2  |
| 5  |  1  |
| 6  |  2  |
| 7  |  2  |
+----+-----+


例如，给定上面的 Logs 表，...]]></description><category></category></item><item><title><![CDATA[【LeetCode】数据库 - 分数排名]]></title><link>https://blog.youkuaiyun.com/fIuent/article/details/82662721</link><guid>https://blog.youkuaiyun.com/fIuent/article/details/82662721</guid><author>fIuent</author><pubDate>Wed, 12 Sep 2018 16:23:53 +0800</pubDate><description><![CDATA[【题目描述】

编写一个 SQL 查询来实现分数排名。如果两个分数相同，则两个分数排名（Rank）相同。请注意，平分后的下一个名次应该是下一个连续的整数值。换句话说，名次之间不应该有“间隔”。


+----+-------+
| Id | Score |
+----+-------+
| 1  | 3.50  |
| 2  | 3.65  |
| 3  | 4.00  |
| 4  | 3.85...]]></description><category></category></item><item><title><![CDATA[【LeetCode】数据库 - 第N高的薪水]]></title><link>https://blog.youkuaiyun.com/fIuent/article/details/82662626</link><guid>https://blog.youkuaiyun.com/fIuent/article/details/82662626</guid><author>fIuent</author><pubDate>Wed, 12 Sep 2018 15:42:59 +0800</pubDate><description><![CDATA[【题目描述】

编写一个 SQL 查询，获取 Employee 表中第 n 高的薪水（Salary）。


+----+--------+
| Id | Salary |
+----+--------+
| 1  | 100    |
| 2  | 200    |
| 3  | 300    |
+----+--------+


例如上述 Employee 表，n = 2 时，应返回第二高的薪...]]></description><category></category></item><item><title><![CDATA[【LeetCode】数据库 - 第二高的薪水]]></title><link>https://blog.youkuaiyun.com/fIuent/article/details/82498955</link><guid>https://blog.youkuaiyun.com/fIuent/article/details/82498955</guid><author>fIuent</author><pubDate>Fri, 07 Sep 2018 17:06:31 +0800</pubDate><description><![CDATA[【题目描述】

编写一个 SQL 查询，获取 Employee 表中第二高的薪水（Salary） 。


+----+--------+
| Id | Salary |
+----+--------+
| 1  | 100    |
| 2  | 200    |
| 3  | 300    |
+----+--------+


例如上述 Employee 表，SQL查询应该返回 200 作为第...]]></description><category></category></item><item><title><![CDATA[【LeetCode】数据库 - 组合两个表]]></title><link>https://blog.youkuaiyun.com/fIuent/article/details/82496706</link><guid>https://blog.youkuaiyun.com/fIuent/article/details/82496706</guid><author>fIuent</author><pubDate>Fri, 07 Sep 2018 15:59:49 +0800</pubDate><description><![CDATA[【题目描述】

表1: Person


+-------------+---------+
| 列名         | 类型     |
+-------------+---------+
| PersonId    | int     |
| FirstName   | varchar |
| LastName    | varchar |
+-------------+---------+...]]></description><category></category></item><item><title><![CDATA[Java跨平台开发神器之JNI]]></title><link>https://blog.youkuaiyun.com/fIuent/article/details/47733471</link><guid>https://blog.youkuaiyun.com/fIuent/article/details/47733471</guid><author>fIuent</author><pubDate>Mon, 17 Aug 2015 22:08:29 +0800</pubDate><description><![CDATA[之前应公司要求，利用java开发一个门禁系统，其要求是用封装好的DLL（C++写的）来做为接口，用java去调用该DLL库中暴露出来的接口，已完成门禁系统的逻辑开发。
        对于我这样的实习僧来说实为当头一棒，从来没有接触过java还能跨平台，我了个ca，于是乎在内心几近崩溃的条件下，开始查资料，垒代码，最终算是完成了要求，现在分享如下，望需要的小伙伴们拾到干货。


     ]]></description><category></category></item></channel></rss>