INSERT data into a database

From Progzoo

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

The bit that runs the SQL statement is:

     PreparedStatement ps = myCon.prepareStatement(
          "INSERT INTO book VALUES (?,?)");
     ps.setString(1,"Andrew");
     ps.setInt(2,2753);
     if (ps.execute()) System.out.println("Failed");

The two questions marks ? in the SQL statement represent two parameters to the statement. Parameter 1 gets set to the string 'Andrew', parameter 2 gets set to the integer 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] [History] [Profile]

test text

<Progzoo Sections>

<Other>

Personal

Views

Toolbox

INSERT data into a database

From Progzoo

See also