Java Reference
In-Depth Information
java.sql.Statement
object that is obtained from the
java.sql.Connection
object. The following code excerpts demonstrate how to
perform each of the CRUD operations using JDBC:
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import
org.java8recipes.chapter13.recipe13_01.CreateConnection;
public class CrudOperations {
static CreateConnection createConn;
public static void main(String[] args) {
createConn = new CreateConnection();
performCreate();
performRead();
performUpdate();
performDelete();
System.out.println("-- Final State --");
performRead();
}
private static void performCreate(){
String sql = "INSERT INTO RECIPES VALUES(" +
"next value for recipes_seq, " +
"'13-4', " +
"'Performing CRUD Operations', " +
"'How to perform create, read,
update, delete functions', " +
"'Recipe Text')";
try (Connection conn = createConn.getConnection();
Statement stmt = conn.createStatement();)
{
