// Programm 3-8:BSP_ROOT/meinewebapp/WEB-INF/classes/jdbcbasis/SimplePrepStatement.java 
import java.sql.*;
public class SimplePrepStatement {
  public SimplePrepStatement(String par) {
    try {
      Class.forName("oracle.jdbc.driver.OracleDriver");
      Connection c = DriverManager.getConnection(
                "jdbc:oracle:thin:@p30:1521:jdbcbuch", "system", "manager");
      String sql = "SELECT * FROM Personen WHERE nachname LIKE ?";
      PreparedStatement ps = c.prepareStatement(sql);
      ps.setString(1, par);
      ResultSet r = ps.executeQuery();
      while(r.next())
        System.out.println(r.getString("vorname")+ ", "+ r.getString("nachname"));
    }
    catch (Exception ex) {ex.printStackTrace();}
  }
  public static void main(String[] args) {
    new SimplePrepStatement(args.length == 0 ?  "%" : args[0] + "%");
  }
}