图片mm.jpg 放在src目录下
源代码如下:import java.io.*;
import java.sql.*;public class BlobTest { public static void main(String[] args) throws Exception {
String url = "jdbc:mysql://localhost:3306/books";
Connection conn = null;
PreparedStatement pstmt = null;
String sql = "insert into img(author,image) values(?,?)"; // 数据库表名img
BufferedReader br = null;
InputStream is = null; Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(url, "root", "123456");
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "lumingee");
is = Thread.currentThread().getContextClassLoader()
.getResourceAsStream("mm.jpg");
pstmt.setAsciiStream(2, is);
if (pstmt.executeUpdate() == 1) { //**************提示错误在这里,不理解为什么
System.out.println("Insert succeed!");
} pstmt.close();
conn.close(); }}
源代码如下:import java.io.*;
import java.sql.*;public class BlobTest { public static void main(String[] args) throws Exception {
String url = "jdbc:mysql://localhost:3306/books";
Connection conn = null;
PreparedStatement pstmt = null;
String sql = "insert into img(author,image) values(?,?)"; // 数据库表名img
BufferedReader br = null;
InputStream is = null; Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(url, "root", "123456");
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "lumingee");
is = Thread.currentThread().getContextClassLoader()
.getResourceAsStream("mm.jpg");
pstmt.setAsciiStream(2, is);
if (pstmt.executeUpdate() == 1) { //**************提示错误在这里,不理解为什么
System.out.println("Insert succeed!");
} pstmt.close();
conn.close(); }}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货