Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- PreparedStatement enviaConsultaEmision;
- PreparedStatement enviaConsultaMarca;
- PreparedStatement enviaConsultaTodos;
- final String consultaMarca = "select *from vehiculos where marca = ?;";
- final String consultaEmision = "select *from vehiculos where emisiones =< ?;";
- final String consultaTodos = "select *from vehiculos where marca = ? and emisiones <= ?;";
- ResultSet rs = null ;
- try {
- Connection conexion = DriverManager.getConnection("jdbc:mysql://localhost/vehiculos", "root", "");
- String marca=(String)marcas.getSelectedItem();
- String emision=(String)emisiones.getSelectedItem();
- if (!marca.equals("Todos") && emision.equals("Todos")) {
- enviaConsultaMarca=conexion.prepareStatement(consultaMarca);
- enviaConsultaMarca.setString(1, marca);
- rs=enviaConsultaMarca.executeQuery();
- //rs.close();
- }else if(marca.equals("Todos") && !emision.equals("Todos")){
- enviaConsultaEmision=conexion.prepareStatement(consultaEmision);
- enviaConsultaEmision.setString(1, emision);
- rs=enviaConsultaEmision.executeQuery();
- //rs.close();
- }else if (!marca.equals("Todos") && !emision.equals("Todos")) {
- enviaConsultaTodos=conexion.prepareStatement(consultaTodos);
- enviaConsultaTodos.setString(1, marca);
- enviaConsultaTodos.setString(2, emision);
- rs=enviaConsultaTodos.executeQuery();
- //rs.close();
- }
- conexion.close();
- }catch(SQLException ex) {ex.printStackTrace();}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement