import java.sql.*;
import java.io.*;
class MySqlSaveImage
{
public static void main(String[] rk) throws SQLException
{
Connection connection = null;
String connectionURL = "jdbc:mysql://localhost:3306/mydb";
ResultSet rs = null;
PreparedStatement psmnt = null;
FileInputStream fis;
try {
Class.forName("com.mysql.jdbc.Driver");//.newInstance();
connection = DriverManager.getConnection(connectionURL, "username", "password");
File image = new File("c:/Me.jpg");
psmnt = connection.prepareStatement("insert into images(image) "+ "values(?)");
fis = new FileInputStream(image);
psmnt.setBinaryStream(1, (InputStream)fis, (int)(image.length()));
int flag= psmnt.executeUpdate();
if(flag>0)
{
System.out.println("Uploaded successfully !");
}
else
{
System.out.println("unsucessfull to upload image.");
}
}
catch (Exception ex)
{
System.out.println("Found some error : "+ex);
}
finally
{
connection.close();
psmnt.close();
}
}
}
Friend leave your comments. Your comments are heartly invited
No comments:
Post a Comment