125. 验证回文串
给定一个字符串,验证它是否是回文串,只考虑字母和数字字符,可以忽略字母的大小写。
说明:本题中,我们将空字符串定义为有效的回文串。
示例 1:
输入: "A man, a plan, a canal: Panama"
输出: true
示例 2:
输入: "race a car"
输出: false
我的答案
class Solution {
public boolean isPalindrome(String s) {
StringBuffer stringBuffer = new StringBuffer();
for(int i=0;i<s.length();i++){
if(s.charAt(i)>='a' && s.charAt(i)<='z'){
stringBuffer.append(s.charAt(i));
continue;
}
if(s.charAt(i)>='0' && s.charAt(i)<='9'){
stringBuffer.append(s.charAt(i));
continue;
}
if(s.charAt(i)>='A' && s.charAt(i)<='Z'){
stringBuffer.append((char)(s.charAt(i)+32));
continue;
}
}
//System.out.println(stringBuffer.toString());
for (int i = 0; i < stringBuffer.length()/2; i++) {
if(stringBuffer.charAt(i)!=stringBuffer.charAt(stringBuffer.length()-i-1)){
return false;
}
}
return true;
}
}
183. 从不订购的客户
某网站包含两个表,Customers 表和 Orders 表。编写一个 SQL 查询,找出所有从不订购任何东西的客户。
Customers 表:
+----+-------+
| Id | Name |
+----+-------+
| 1 | Joe |
| 2 | Henry |
| 3 | Sam |
| 4 | Max |
+----+-------+
Orders 表:
+----+------------+
| Id | CustomerId |
+----+------------+
| 1 | 3 |
| 2 | 1 |
+----+------------+
例如给定上述表格,你的查询应返回:
+-----------+
| Customers |
+-----------+
| Henry |
| Max |
+-----------+
我的答案
select Name as Customers from Customers where Customers.id not in (select CustomerId from Orders)
不使用in的话
select Name as Customers from Customers left join Orders on Customers.id = Orders.CustomerId where Orders.id is null