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 = <span style="font-family: simsun;">"insert into image( id , image) values(?,?)"</span><span style="font-family: simsun;">;</span>
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();
}
}