INSERT data into a database

From Progzoo

Insert a new row ('Andrew', 2753) into the table book.

The SQL statement is:

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

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,"Andrew");
      ps.setInt(2,2753);
      if (ps.execute()) System.out.println("Failed");
      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]

test text

[edit] See also

INSERT a batch of data into a database

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

<Progzoo Sections>

<Other>

Personal

Views

Toolbox

INSERT data into a database

From Progzoo

[edit] See also