如何为字符数组传递PreparedStatement setArray [英] How to pass PreparedStatement setArray for character array

问题描述

我有一些JDBC代码，如下所示:

I have some JDBC code as follows:

String selectSQL = "SELECT * FROM DBUSER WHERE USER_ID = ? and PASSWORD = ?";

Integer userId = 1000;
char[] passwordString = new char[] { 't', 'e', 's', 't' };

PreparedStatement preparedStatement = dbConnection.prepareStatement(selectSQL);
preparedStatement.setInt(1, 1001);
preparedStatement.setArray(2,... ??? // how to do this part?

// execute select SQL statement
ResultSet rs = preparedStatement.executeQuery();

如何调用preparedStatement.setArray设置查询中的第二个参数?我不想在这里使用字符串参数来保护密码.

How do I call preparedStatement.setArray to set the second parameter in the query? I don't want to use a string parameter here to protect the password.

请注意，我正在使用Hypersonic DB，但如果有用的话，请计划移至MySql.

Note I am using Hypersonic DB but plan to move to MySql if this is useful.

推荐答案

java.sql.Array 首先，您应该使用JDBC Conncetion的

PreparedStatement#setArray received a java.sql.Array First you should use the JDBC Conncetion's createArrayOf method to create the array, only then you can pass it to setArray.

由于该方法仅接受Object[]，因此您应该创建Character的数组而不是char.

As the method only accept Object[] you should create an array of Character instead of char.

例如:

Character[] passwordString = new Character[] { 't', 'e', 's', 't' };
Array sqlArray = con.createArrayOf("CHAR", passwordString);
preparedStatement.setArray(2, sqlArray);

这篇关于如何为字符数组传递PreparedStatement setArray的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！