Package com.logicaldoc.util.sql
Class SqlUtil
java.lang.Object
com.logicaldoc.util.sql.SqlUtil
This class contains methods about SQL handling
- Version:
- 4.5
- Author:
- Marco Meschieri - LogicalDOC
-
Method Summary
Modifier and TypeMethodDescriptionstatic String
doubleBackslashes
(String input) Double the backslashes in a string.static String
doubleQuotes
(String input) Double the quotes in a string.static String
doubleQuotesAndBackslashes
(String input) static Date
getColumnDateValue
(ResultSet resultSet, int column) Retrieves the date stored in a given column
-
Method Details
-
doubleQuotes
Double the quotes in a string. This means that each character ' will be replaced with '' (two quote characters)- Parameters:
input
- The incoming string- Returns:
- A string with doubled quotes
-
doubleBackslashes
Double the backslashes in a string. This means that each character \ will be replaced with \\- Parameters:
input
- The incoming string- Returns:
- A string with doubled backslashes
-
doubleQuotesAndBackslashes
-
getColumnDateValue
Retrieves the date stored in a given column- Parameters:
resultSet
- The resultset to usecolumn
- The column index- Returns:
- The date value
- Throws:
SQLException
- Error in the database
-