java无法插入mysql_无法使用java将byte []插入MySQL

问题是你的名为“key”的列是SQL中的保留字.用反引号围绕它,事情应该有效.更好的是,考虑将列重命名为不是SQL保留字的内容.我已经使用下面的代码证明了这一点：

MySQL表：

create table keytable (name varchar(255) not null, `key` blob not null);

Java代码：

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.SQLException;

public class MySQLBlobInsert {

public static void main(String[] args) {

try {

Class.forName("com.mysql.jdbc.Driver").newInstance();

} catch (Exception e) {

throw new RuntimeException(e);

}

Connection conn = null;

try {

conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "password");

byte[] bkey = "This is some binary stuff".getBytes();

String query = "INSERT INTO keytable (name, `key`) VALUES (?,?)";

PreparedStatement pstmt = conn.prepareStatement(query);

pstmt.setString(1, "test");

pstmt.setBytes(2, bkey);

pstmt.execute();

} catch (SQLException e) {

throw new RuntimeException(e);

} finally {

if (conn != null) {

try { conn.close(); } catch (SQLException e) {}

}

}

System.out.println("done :)");

}

}