jdbc_statements.java

Statement stmt = conn.createStatement(
                           ResultSet.TYPE_SCROLL_INSENSITIVE,
                           ResultSet.CONCUR_UPDATABLE);

String sql = "SELECT id, name, age FROM students";
ResultSet rs = stmt.executeQuery(sql);

// update data in Result Set
rs.moveToInsertRow();
rs.updateInt("id",5);
rs.updateString("name","John");
rs.updateInt("age",21);
// insert row into database
rs.insertRow();

///////////////////

// no return procedure
{call procedureName(?,?,...)}
// procedure returns result
{? = call procedureName(?,?,...)}



CallableStatement cstmt = null;
try {
   String SQL = "{call getExampleName (?, ?)}";
   cstmt = conn.prepareCall (SQL);
   //. . .
}
catch (SQLException e) {
   //. . .
}
finally {
   cstmt.close();
}

/////////////////