1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
|
/*
Copyright (c) 2010 James Ahlborn
This library is free software; you can redistribute it and/or
modify it under the terms of the GNU Lesser General Public
License as published by the Free Software Foundation; either
version 2.1 of the License, or (at your option) any later version.
This library is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
Lesser General Public License for more details.
You should have received a copy of the GNU Lesser General Public
License along with this library; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307
USA
*/
package com.healthmarketscience.jackcess.util;
import java.io.IOException;
import com.healthmarketscience.jackcess.DataType;
import com.healthmarketscience.jackcess.RuntimeIOException;
import com.healthmarketscience.jackcess.Table;
import com.healthmarketscience.jackcess.impl.ColumnImpl;
/**
* Concrete implementation of ColumnMatcher which tests textual columns
* case-insensitively ({@link DataType#TEXT} and {@link DataType#MEMO}), and
* all other columns using simple equality.
*
* @author James Ahlborn
* @usage _general_class_
*/
public class CaseInsensitiveColumnMatcher implements ColumnMatcher {
public static final CaseInsensitiveColumnMatcher INSTANCE =
new CaseInsensitiveColumnMatcher();
public CaseInsensitiveColumnMatcher() {
}
public boolean matches(Table table, String columnName, Object value1,
Object value2)
{
if(!table.getColumn(columnName).getType().isTextual()) {
// use simple equality
return SimpleColumnMatcher.INSTANCE.matches(table, columnName,
value1, value2);
}
// convert both values to Strings and compare case-insensitively
try {
CharSequence cs1 = ColumnImpl.toCharSequence(value1);
CharSequence cs2 = ColumnImpl.toCharSequence(value2);
return((cs1 == cs2) ||
((cs1 != null) && (cs2 != null) &&
cs1.toString().equalsIgnoreCase(cs2.toString())));
} catch(IOException e) {
throw new RuntimeIOException("Could not read column " + columnName
+ " value", e);
}
}
}
|
