INSERT a batch of data into a database

From Progzoo

Insert new rows ('Andrew', 2753) and ('Gordon', 2754) into the table book.

The SQL statements are:

INSERT INTO book VALUES ('Andrew',2753);
INSERT INTO book VALUES ('Gordon',2754);

import java.sql.*;
public class Demo{
  public static void main(String[] args){
    Connection myCon;
    Statement myStmt;
    try{
      Class.forName("com.mysql.jdbc.Driver").newInstance();
      myCon = DriverManager.getConnection(
              "jdbc:mysql://127.0.0.1/scott",
              "scott","tiger");
      myStmt = myCon.createStatement();
      String sql =
         "CREATE TEMPORARY TABLE book "+
         "(name VARCHAR(20), tel INT);";
      if (myStmt.execute(sql)){
        System.out.println("Failed");
      }
      PreparedStatement ps = myCon.prepareStatement(
           "INSERT INTO book VALUES (?,?)");
      ps.setString(1,"Andrw");
      ps.setInt(2,2753);
      ps.addBatch();
      ps.setString(1,"Gordon");
      ps.setInt(2,2754);
      ps.addBatch();
      int[] r = ps.executeBatch();
      sql = "SELECT name, tel FROM book";
      ResultSet cursor = myStmt.executeQuery(sql);
      while (cursor.next()){
        System.out.println(cursor.getString("name")+"\t"+
                           cursor.getLong("tel"));
      }
      myCon.close();
    }
    catch (Exception sqlEx){
      System.err.println(sqlEx);
    }
  }
}

[Font] [Default] [Show] [Resize] [History] [Profile]

test text

Retrieved from "http://cs.progzoo.net/wiki/INSERT_a_batch_of_data_into_a_database"

<Progzoo Sections>

<Other>

Personal

Views

Toolbox

INSERT a batch of data into a database

From Progzoo