How do I set a char in a PreparedStatement?

Question

How do I set a char in a PreparedStatement?

Navigation

#1 by (3 votes)

4

My FuelType variable is a char how to set this in the PreparedStatement?

PreparedStatement ps = conexao.prepareStatement(sql);
ps.setString(1, veiculo.getTipoCombustivel());

java swing jdbc

asked by anonymous 02.06.2015 / 19:18

1 answer

What is the maximum limit of PHP / MySQL / Nginx in a request before giving error 504 Gateway Time-out SQL query in PHP and date format

score 3 · Accepted Answer

Exactly this way, however, it is necessary that the passed type be a String.

Therefore:

ps.setString(1, String.valueOf(veiculo.getTipoCombustivel()));

Type mapping:

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