aboutsummaryrefslogtreecommitdiff
path: root/src/org/traccar/helper
diff options
context:
space:
mode:
Diffstat (limited to 'src/org/traccar/helper')
-rw-r--r--src/org/traccar/helper/NamedParameterStatement.java61
1 files changed, 30 insertions, 31 deletions
diff --git a/src/org/traccar/helper/NamedParameterStatement.java b/src/org/traccar/helper/NamedParameterStatement.java
index e898af2d3..a4b1a12c6 100644
--- a/src/org/traccar/helper/NamedParameterStatement.java
+++ b/src/org/traccar/helper/NamedParameterStatement.java
@@ -29,7 +29,7 @@ public class NamedParameterStatement {
/**
* Index mapping
*/
- private final Map indexMap;
+ private final Map<String, List<Integer>> indexMap;
/**
* Query string
@@ -46,7 +46,7 @@ public class NamedParameterStatement {
*/
public NamedParameterStatement(AdvancedConnection connection, String query) {
- indexMap = new HashMap();
+ indexMap = new HashMap<String, List<Integer>>();
parsedQuery = parse(query, indexMap);
this.connection = connection;
}
@@ -54,7 +54,7 @@ public class NamedParameterStatement {
/**
* Parse query
*/
- static String parse(String query, Map paramMap) {
+ static String parse(String query, Map<String, List<Integer>> paramMap) {
int length = query.length();
StringBuilder parsedQuery = new StringBuilder(length);
@@ -90,12 +90,12 @@ public class NamedParameterStatement {
i += name.length();
// Add to list
- List indexList = (List) paramMap.get(name);
+ List<Integer> indexList = paramMap.get(name);
if (indexList == null) {
- indexList = new LinkedList();
+ indexList = new LinkedList<Integer>();
paramMap.put(name, indexList);
}
- indexList.add(new Integer(index));
+ indexList.add(index);
index++;
}
@@ -149,73 +149,72 @@ public class NamedParameterStatement {
public void setInt(String name, Integer value) throws SQLException {
- List indexList = (List) indexMap.get(name);
- if (indexList != null) for (Object index: indexList) {
+ List<Integer> indexList = indexMap.get(name);
+ if (indexList != null) for (Integer index: indexList) {
if (value != null) {
- statement.setInt((Integer) index, value);
+ statement.setInt(index, value);
} else {
- statement.setNull((Integer) index, Types.INTEGER);
+ statement.setNull(index, Types.INTEGER);
}
}
}
public void setLong(String name, Long value) throws SQLException {
- List indexList = (List) indexMap.get(name);
- if (indexList != null) for (Object index: indexList) {
+ List<Integer> indexList = indexMap.get(name);
+ if (indexList != null) for (Integer index: indexList) {
if (value != null) {
- statement.setLong((Integer) index, value);
+ statement.setLong(index, value);
} else {
- statement.setNull((Integer) index, Types.INTEGER);
+ statement.setNull(index, Types.INTEGER);
}
}
}
public void setBoolean(String name, Boolean value) throws SQLException {
- List indexList = (List) indexMap.get(name);
- if (indexList != null) for (Object index: indexList) {
+ List<Integer> indexList = indexMap.get(name);
+ if (indexList != null) for (Integer index: indexList) {
if (value != null) {
- statement.setBoolean((Integer) index, value);
+ statement.setBoolean(index, value);
} else {
- statement.setNull((Integer) index, Types.BOOLEAN);
+ statement.setNull(index, Types.BOOLEAN);
}
}
}
public void setDouble(String name, Double value) throws SQLException {
- List indexList = (List) indexMap.get(name);
- if (indexList != null) for (Object index: indexList) {
+ List<Integer> indexList = indexMap.get(name);
+ if (indexList != null) for (Integer index: indexList) {
if (value != null) {
- statement.setDouble((Integer) index, value);
+ statement.setDouble(index, value);
} else {
- statement.setNull((Integer) index, Types.DOUBLE);
+ statement.setNull(index, Types.DOUBLE);
}
}
}
public void setTimestamp(String name, Date value) throws SQLException {
- List indexList = (List) indexMap.get(name);
- if (indexList != null) for (Object index: indexList) {
+ List<Integer> indexList = indexMap.get(name);
+ if (indexList != null) for (Integer index: indexList) {
if (value != null) {
- statement.setTimestamp(
- (Integer) index, new Timestamp(value.getTime()));
+ statement.setTimestamp(index, new Timestamp(value.getTime()));
} else {
- statement.setNull((Integer) index, Types.TIMESTAMP);
+ statement.setNull(index, Types.TIMESTAMP);
}
}
}
public void setString(String name, String value) throws SQLException {
- List indexList = (List) indexMap.get(name);
- if (indexList != null) for (Object index: indexList) {
+ List<Integer> indexList = indexMap.get(name);
+ if (indexList != null) for (Integer index: indexList) {
if (value != null) {
- statement.setString((Integer) index, value);
+ statement.setString(index, value);
} else {
- statement.setNull((Integer) index, Types.VARCHAR);
+ statement.setNull(index, Types.VARCHAR);
}
}
}