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();
}
}
