Select Records Using Prepared Statement : Preparedstatement « Database « Java Tutorial






import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class Main {
  public static void main(String[] argv) throws Exception {
    int count = 0;
    Class.forName("com.mysql.jdbc.Driver");
    Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbctutorial",
        "root", "root");

    String sql = "SELECT title,year_made FROM product WHERE year_made >= ? AND year_made <= ?";
    PreparedStatement prest = con.prepareStatement(sql);
    prest.setInt(1, 2000);
    prest.setInt(2, 2009);
    ResultSet rs = prest.executeQuery();
    while (rs.next()) {
      String mov_name = rs.getString(1);
      int mov_year = rs.getInt(2);
      count++;
      System.out.println(mov_name + "\t" + "- " + mov_year);
    }
    System.out.println("Number of records: " + count);
    prest.close();
    con.close();
  }
}








20.13.Preparedstatement
20.13.1.Working with the Preparedstatement
20.13.2.Create a PreparedStatement object with two parameter markers
20.13.3.Check for a SQL Warning Using PreparedStatement
20.13.4.Create a Table Using PreparedStatement
20.13.5.Set the Number of Rows to Prefetch Using PreparedStatement
20.13.6.Use PreparedStatement.setAsciiStream()
20.13.7.Use PreparedStatement.setBigDecimal()
20.13.8.Use PreparedStatement.setBinaryStream()
20.13.9.Use PreparedStatement.setBoolean()
20.13.10.Use PreparedStatement's setByte(), setShort(), setInt(), and setLong()
20.13.11.Use PreparedStatement.setBytes()
20.13.12.Use PreparedStatement.setCharacterStream()
20.13.13.Set NULL
20.13.14.DELETE data in a table
20.13.15.Modify data in a table
20.13.16.Prepared Statement With Batch Update
20.13.17.Select Records Using Prepared Statement
20.13.18.Inserting Records using the Prepared Statement
20.13.19.Count Records using the Prepared Statement
20.13.20.Deleting Records using the Prepared Statement
20.13.21.Using the Prepared Statement Twice
20.13.22.Set string,ingeger,double and float example by using the Prepared Statement
20.13.23.Set byte, short and long data types by using the Prepared Statement
20.13.24.Prepared Statement Set Big Decimal
20.13.25.Set Date by using the Prepared Statement
20.13.26.Set Time by using the Prepared Statement
20.13.27.Set Timestamp by using the Prepared Statement
20.13.28.Rows affected when updating data in database table
20.13.29.Use PreparedStatement.setURL()