JDBC - How to set char in a prepared statement

I cannot find any method like

char c = 'c';

preparedStatement.setChar(1, c);

Ho开发者_如何转开发w to set character to a prepared statement?

The JDBC Specification 4.0 in Appendix B (Data Type Conversion Tables) states the following conversions:

This table also shows the conversions used by the SQLInput reader methods, except that they use only the recommended conversions.

JDBC Type              Java Type
-------------------------------------------
CHAR                   String
VARCHAR                String
LONGVARCHAR            String
NUMERIC                java.math.BigDecimal
DECIMAL                java.math.BigDecimal
BIT                    boolean
BOOLEAN                boolean
TINYINT                byte
SMALLINT               short

TABLE B- 1  JDBC Types Mapped to Java Types

Therefore PreparedStatement.setString(1, String.valueOf(myChar)) should do the trick.

Use setString() to set the variable.

To get it back use getString() and assuming it is not null do something like this to get the character:

getString("your_column").charAt(0);

PreparedStatement.setString(1,c+" ");

PreparedStatement.setString(1,String.valueOf(c));