Inserting into a table (Example)

Presented below is a simple example of how to insert a row in a database table.

Code:

---

Statement stmt;
String sql;   
int rows;     

sql = "INSERT INTO tCust "
    + "(custId, custName, custAddr) "
    + "VALUES "
    + "('" + custId  + "',"
    + "('" + custName + "',"
    + "('" + custAddr + "')";

stmt = theConn.createStatement();
rows = stmt.executeUpdate(sql);
theConn.dbConn.commit();
stmt.close();

---