JAVA - 如何从 sqlite 数据库存储和读取 RSA 公钥

Question

我必须将公钥和私钥存储到 sqlite 数据库中。实际上我将 pubKey.getEncoded() 写入数据库，并使用以下代码重新创建公钥:

    ResultSet result = stat.executeQuery("select publickey from cert where id='1'");
    KeyFactory rsaKeyFac =  KeyFactory.getInstance("RSA");
    X509EncodedKeySpec keySpec = new X509EncodedKeySpec(result.getBytes(1));
    RSAPublicKey pubKey;
    pubKey = (RSAPublicKey) rsaKeyFac.generatePublic(keySpec);

但它给了我以下错误

Exception in thread "main" java.security.spec.InvalidKeySpecException: java.security.InvalidKeyException: IOException: Detect premature EOF

此时:

pubKey = (RSAPublicKey) rsaKeyFac.generatePublic(keySpec);

谁能帮帮我？

提前致谢

Answer 1

如果你看这里:http://java.sun.com/docs/books/tutorial/jdbc/basics/retrieving.html您将看到如何正确地从数据库中检索。这是假设您的数据库列有一种 char(n) 类型。

ResultSet result = stat.executeQuery("select publickey from cert where id='1'");
while(result.next())
{
   KeyFactory rsaKeyFac =  KeyFactory.getInstance("RSA");
   X509EncodedKeySpec keySpec = new X509EncodedKeySpec(result.getString(1));
   RSAPublicKey pubKey;
   pubKey = (RSAPublicKey) rsaKeyFac.generatePublic(keySpec);
}

如果类型是 BLOB 或 CLOB，那么您需要使用不同的机制。 http://java.sun.com/j2se/1.5.0/docs/guide/jdbc/blob.html