java jdbc处理char,JDBC - 如何在预准备语句中设置char

I cannot find any method like

char c = 'c';

preparedStatement.setChar(1, c);

How 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.