Sunday, July 17, 2011

JAVA CODE TO STORE IMAGE IN DATABASE

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