svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.plugin / org.gvsig.sqlite / org.gvsig.sqlite.provider / src / main / java / org / gvsig / sqlite / dal / functions / Reverseinstr.java @ 47456
History | View | Annotate | Download (1.63 KB)
1 | 47456 | jjdelcerro | /*
|
---|---|---|---|
2 | * gvSIG. Desktop Geographic Information System.
|
||
3 | *
|
||
4 | * Copyright (C) 2007-2020 gvSIG Association.
|
||
5 | *
|
||
6 | * This program is free software; you can redistribute it and/or
|
||
7 | * modify it under the terms of the GNU General Public License
|
||
8 | * as published by the Free Software Foundation; either version 3
|
||
9 | * of the License, or (at your option) any later version.
|
||
10 | *
|
||
11 | * This program is distributed in the hope that it will be useful,
|
||
12 | * but WITHOUT ANY WARRANTY; without even the implied warranty of
|
||
13 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
||
14 | * GNU General Public License for more details.
|
||
15 | *
|
||
16 | * You should have received a copy of the GNU General Public License
|
||
17 | * along with this program. If not, see <https://www.gnu.org/licenses/>.
|
||
18 | *
|
||
19 | * For any additional information, do not hesitate to contact us
|
||
20 | * at info AT gvsig.com, or visit our website www.gvsig.com.
|
||
21 | */
|
||
22 | package org.gvsig.sqlite.dal.functions; |
||
23 | |||
24 | import java.sql.SQLException; |
||
25 | import org.sqlite.SQLiteConnection; |
||
26 | |||
27 | /**
|
||
28 | *
|
||
29 | * @author gvSIG Team
|
||
30 | */
|
||
31 | public class Reverseinstr extends Functions.AbstractFunction { |
||
32 | |||
33 | public Reverseinstr(SQLiteConnection conn) {
|
||
34 | super("REVERSEINSTR", conn); |
||
35 | } |
||
36 | |||
37 | @Override
|
||
38 | protected void xFunc() throws SQLException { |
||
39 | String string = value_text(0); |
||
40 | if( string==null ) { |
||
41 | this.result();
|
||
42 | return;
|
||
43 | } |
||
44 | String substring = value_text(1); |
||
45 | if( substring==null ) { |
||
46 | this.result();
|
||
47 | return;
|
||
48 | } |
||
49 | int n = string.lastIndexOf(substring);
|
||
50 | if (n < 0) { |
||
51 | this.result();
|
||
52 | } else {
|
||
53 | this.result(n+1); |
||
54 | } |
||
55 | } |
||
56 | |||
57 | } |