private void query() { String text = this.textField_query.getText().trim(); Vector<Vehicle> vehicles; Vector<Vector> datas; String departmentName = this.comboBox_query_choosebusiness.getSelectedItem().toString(); String sql = ""; MainFrame.getLoglabel().setText("查询车辆(" + departmentName + " " + text + ")"); logger.info("查询车辆(" + departmentName + " " + text + ")"); if (departmentName.equals("所有")) { sql = "select * from vehicle where vehicle_num = '" + text + "' or license_plate_number = '" + text + "' "; vehicles = vehicleblservice.getBySql(sql); datas = changeDatas(vehicles); setDatas(datas); refreshTable(); } else { sql = "select * from vehicle , department where (vehicle.department_id_fk=department.id ) " + " and (" + "department.department_name = '" + departmentName + "' )" + "and (vehicle_num = '" + text + "' or license_plate_number = '" + text + "' ) "; vehicles = vehicleblservice.getBySql(sql); datas = changeDatas(vehicles); setDatas(datas); refreshTable(); } }