Skip to content

Instantly share code, notes, and snippets.

@gaverdugo
Created November 29, 2016 02:16
Show Gist options
  • Save gaverdugo/a3ceb5b3ca22ae25d946916f879fcda6 to your computer and use it in GitHub Desktop.
Save gaverdugo/a3ceb5b3ca22ae25d946916f879fcda6 to your computer and use it in GitHub Desktop.
private void rentasBrowseActionPerformed(java.awt.event.ActionEvent evt) {
final String sql = "SELECT renta_id AS ID, "
+ "cliente_nombre AS Cliente, "
+ "vehiculo_id AS Vehiculo, "
+ "estado_renta_descripcion AS Estado, "
+ "renta_desde AS Desde, "
+ "renta_hasta AS Hasta, "
+ "renta_enviada_confirmacion AS Enviada, "
+ "renta_pagada AS Pagada FROM renta NATURAL JOIN vehiculo NATURAL join cliente NATURAL JOIN estado_renta";
try {
ResultSet rs = db.doQuery(sql);
JDBCTableAdapter modelo = new JDBCTableAdapter(rs, 4);
modelo.addTableModelListener(new VehiculosTableListener(db, "renta", "renta_id"));
TableBrowser browser = new TableBrowser("Rentas", modelo);
browser.setVisible(true);
this.desktopPane.add(browser);
} catch (SQLException ex) {
ex.printStackTrace(System.err);
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment