How to save image in sql server 2012 database using JAVA.

package Image_data;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;

public class Save_Image {

public static void main(String[] args) {



     
               DB db = new DB();
               Connection conn=db.dbConnect(
                 "jdbc:jtds:sqlserver://localhost:1433/test","sa","");
               db.insertImage(conn,"d://filepath//test.JPG");
               db.getImageData(conn);
     



class DB
{
       public DB() {}

       public Connection dbConnect(String db_connect_string,
          String db_userid, String db_password)
       {
               try
               {
                       Class.forName("net.sourceforge.jtds.jdbc.Driver");
                       Connection conn = DriverManager.getConnection(
                         db_connect_string, db_userid, db_password);

                       System.out.println("connected");
                       return conn;
                       
               }
               catch (Exception e)
               {
                       e.printStackTrace();
                       return null;
               }
       }

       public void insertImage(Connection conn,String img)
       {
               int len;
               String query;
               PreparedStatement pstmt;
               
               try
               {
                       File file = new File(img);
                       FileInputStream fis = new FileInputStream(file);
                       len = (int)file.length();

                       query = ("insert into TableImage VALUES(?,?,?)");
                       pstmt = conn.prepareStatement(query);
                       pstmt.setString(1,file.getName());
                       pstmt.setInt(2, len);
 
                       // Method used to insert a stream of bytes
                       pstmt.setBinaryStream(3, fis, len);
                       pstmt.executeUpdate();

               }
               catch (Exception e)
               {
                       e.printStackTrace();
               }
       }

       public void getImageData(Connection conn)
       {
               
                byte[] fileBytes;
                String query;
                try
                {
                        query = "select data from tableimage";
                        Statement state = conn.createStatement();
                        ResultSet rs = state.executeQuery(query);
                        if (rs.next())
                       {
                                 fileBytes = rs.getBytes(1);
                                 OutputStream targetFile=
                                 new FileOutputStream(
                                      "d://filepath//new.JPG");

                                 targetFile.write(fileBytes);
                                 targetFile.close();
                       }      
                       
                }
                catch (Exception e)
                {
                        e.printStackTrace();
                }
       }
};

}

}

Comments

Post a Comment

Popular posts from this blog

Book ticket online through IRCTC using Selenium Webdriver.

Hi Guys, Everyday I try something new, So Today I will share code to book ticket online From IRCTC with the help of Selenium Webdriver. But before please! NOTE some points before Executing the code: All the CAPTCHA Field's have to be filled Manually because I didn't found how to auto fill it. After Searching trains all fields and links are generated dynamically so you have to Inspect the field every time. I have wrote this code to book ticket between NDLS(New Delhi) to CNB(Kanpur) Journey date June,13 You cannot inspect element by right clicking on element, press F12 and do it manually. This code will only take you to payment gateway after that you have to handle it manually. Now The Code is Below: import java.util.List; import java.util.concurrent.TimeUnit; import org.openqa.selenium.By; import org.openqa.selenium.Keys; import org.openqa.selenium.WebDriver; import org.openqa.selenium.WebElement; import org.openqa.selenium.firefox.FirefoxDriver; im
Read more

How to create a New Gmail Account using Selenium Web Driver.

package Signup_gmail; import org.apache.bcel.generic.Select; import org.apache.james.mime4j.message.Message; import org.openqa.selenium.By; import org.openqa.selenium.WebDriver; import org.openqa.selenium.WebElement; import org.openqa.selenium.firefox.FirefoxDriver; public class Sign_up { public static void main(String[] args) throws InterruptedException { WebDriver driver=new FirefoxDriver(); //Creating Object of firefox driver. driver.navigate().to("https://accounts.google.com/signup?hl=en-GB"); //Navigating to web page. driver.findElement(By.id("FirstName")).sendKeys(""); //Entering First Name. WebElement TxtBoxContent = driver.findElement(By.id("errormsg_0_LastName")); //Object creation of web element. TxtBoxContent.getText(); //Fetching value of error message through "TxtBoxContent" object. Object obj= new Object(); //Creating New Object. obj=driver.findElement(By.i
Read more

SQL Injection.

Image
An SQL Injection can destroy your database. SQL in Web Pages When SQL is used to display data on a web page, it is common to let web users input their own search values. Since SQL statements are text only, it is easy, with a little piece of computer code, to dynamically change SQL statements to provide the user with selected data: Server Code txtUserId = getRequestString("UserId"); txtSQL = "SELECT * FROM Users WHERE UserId = " + txtUserId; The example above, creates a select statement by adding a variable (txtUserId) to a select string. The variable is fetched from the user input (Request) to the page. The rest of this chapter describes the potential dangers of using user input in SQL statements. SQL Injection SQL injection is a technique where malicious users can inject SQL commands into an SQL statement, via web page input. Injected SQL commands can alter SQL statement and compromise the security of a web application. SQL Injection B
Read more