Inserting a Row into a Database Table Using a Prepared Statement - Java JDBC

Java examples for JDBC:PreparedStatement

  1. HOME
  2. Java
  3. JDBC
  4. PreparedStatement

Description

Inserting a Row into a Database Table Using a Prepared Statement

Demo Code


import java.awt.Graphics;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.math.BigDecimal;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Time;
import java.sql.Timestamp;

public class Main {
  public void m() {

    Connection connection = null;
    try {/*from  w w  w. jav a  2s  .  c  o  m*/
      String sql = "INSERT INTO mysql_all_table(" + "col_boolean,"
          + "col_byte," + "col_short," + "col_int," + "col_long,"
          + "col_float," + "col_double," + "col_bigdecimal," + "col_string,"
          + "col_date," + "col_time," + "col_timestamp," + "col_asciistream,"
          + "col_binarystream," + "col_blob) "
          + "VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
      PreparedStatement pstmt = connection.prepareStatement(sql);

      // Set the values
      pstmt.setBoolean(1, true);
      pstmt.setByte(2, (byte) 123);
      pstmt.setShort(3, (short) 123);
      pstmt.setInt(4, 123);
      pstmt.setLong(5, 123L);
      pstmt.setFloat(6, 1.23F);
      pstmt.setDouble(7, 1.23D);
      pstmt.setBigDecimal(8, new BigDecimal(1.23));
      pstmt.setString(9, "a string");
      pstmt.setDate(10, new java.sql.Date(System.currentTimeMillis()));
      pstmt.setTime(11, new Time(System.currentTimeMillis()));
      pstmt.setTimestamp(12, new Timestamp(System.currentTimeMillis()));

      // Set the ascii stream
      File file = new File("infilename1");
      FileInputStream is = new FileInputStream(file);
      pstmt.setAsciiStream(13, is, (int) file.length());

      // Set the binary stream
      file = new File("infilename2");
      is = new FileInputStream(file);
      pstmt.setBinaryStream(14, is, (int) file.length());

      // Set the blob
      file = new File("infilename3");
      is = new FileInputStream(file);
      pstmt.setBinaryStream(15, is, (int) file.length());

      // Insert the row
      pstmt.executeUpdate();
    } catch (SQLException e) {
    } catch (FileNotFoundException e) {
    }
  }
}

Related Tutorials