该博客展示了如何使用Java代码将图片数据插入到MySQL数据库中。通过建立数据库连接，预编译SQL语句，设置参数为图片文件的二进制流，然后执行更新操作，实现了图片数据的存储。如果执行成功，会输出'success'，否则输出'failed'。
import java.sql.*;
import java.util.Scanner;
import java.io.*;
public class mysql插入图片 {
private static final File File = null;
private static String String;
public static Connection getConn() {
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/xinxi", "root", "123456");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static void add( String fromFileName, String toFileName) {
Connection conn = getConn();String sql = "insert into image( id , image) values(?,?)";
PreparedStatement ps;
try {
ps = conn.prepareStatement(sql);
ps.setString(1, "tupian");
File file1=new File("D:\\test.jpg");
InputStream in;
in = new BufferedInputStream(new FileInputStream(file1));
ps.setBinaryStream(2, in, (int) file1.length());
int count = 0;
count = ps.executeUpdate();
if(count==1)
{
System.out.println("success");
}else
{
System.out.println("failed");
}
in.close();
ps.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
原文：http://blog.csdn.net/yixian918/article/details/41748499
扫一扫
2万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
