PrepStat.java

import java.sql.*;

/**
Demonstrate reuse of a prepared statement.
*/
public class PrepStat
{
    public static void main(String argv[])
    {
        // JDBC driver and DSN for the HSQLDB database server.
        String driver = "org.hsqldb.jdbcDriver";
        String dsn = "jdbc:hsqldb:hsql://localhost:9001";
        String q;
        Connection conn;
        PreparedStatement ps;
        Statement s;
        ResultSet rs;

        try {
            Class.forName(driver);
            conn = DriverManager.getConnection(dsn,"sa","");
            q = "UPDATE Bozo SET Value=? WHERE Name=?";
            ps = conn.prepareStatement(q);
            // Use our prepared statement to set Homey's value
            // to 'yellow'.
            ps.setString(2,"Homey");
            ps.setString(1,"yellow");
            ps.executeUpdate();
            // Now use the same statement to set Happy's
            // value to 'yellow'.  Note that we don't have
            // to set the 1st parameter again.
            ps.setString(2,"Happy");
            ps.executeUpdate();
            }
        catch (Exception e) {
            e.printStackTrace();
            }
    }
}