Java tutorial
/** * */ package com.its.core.local.hezhou.task; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import com.its.core.module.task.ATask; import com.its.core.util.DatabaseHelper; import com.its.core.util.DateHelper; import com.its.core.util.FileHelper; import com.its.core.util.ImageHelper; import com.its.core.util.StringHelper; import com.its.core.util.XMLProperties; /** * 2013-10-16 10:33:14 * @author GuoPing.Wu * Copyright: Xinoman Technologies CO.,LTD. */ public class ExportImageFilesReadTask extends ATask { private static final Log log = LogFactory.getLog(ExportImageFilesReadTask.class); private String imgSaveDir = null; private String httpPrefix = null; private String connDriverClass = null; private String connUrl = null; private String connUsername = null; private String connPassword = null; private String selecImageFileRecordSql = null; private String updateImageFileRecordSql = null; public static Map<String, String> DEVICE_MAP = new HashMap<String, String>(); public static Map<String, String> DIRECTION_MAP = new HashMap<String, String>(); public static Map<String, String> COLOR_MAP = new HashMap<String, String>(); static { DEVICE_MAP.put("192.168.5.241", "451100100004"); DEVICE_MAP.put("192.168.5.242", "451100100004"); DEVICE_MAP.put("192.168.5.243", "451100100004"); DEVICE_MAP.put("192.168.5.244", "451100100004"); DEVICE_MAP.put("192.168.5.245", "451100100004"); DEVICE_MAP.put("192.168.5.246", "451100100004"); DEVICE_MAP.put("192.168.5.247", "451100100004"); DEVICE_MAP.put("192.168.5.248", "451100100004"); DEVICE_MAP.put("192.168.5.249", "451100100004"); DEVICE_MAP.put("192.168.5.240", "451100100004"); DIRECTION_MAP.put("", "1"); DIRECTION_MAP.put("", "2"); DIRECTION_MAP.put("", "3"); DIRECTION_MAP.put("", "4"); COLOR_MAP.put("", "0"); COLOR_MAP.put("", "1"); COLOR_MAP.put("", "2"); COLOR_MAP.put("", "3"); COLOR_MAP.put("", "4"); COLOR_MAP.put("", "4"); } /* (non-Javadoc) * @see com.its.core.module.task.ATask#configureSpecificallyProperties(com.its.core.util.XMLProperties, java.lang.String, int) */ @Override public void configureSpecificallyProperties(XMLProperties props, String propertiesPrefix, int no) { this.imgSaveDir = props.getProperty(propertiesPrefix, no, "img_save_dir"); this.httpPrefix = props.getProperty(propertiesPrefix, no, "http_prefix"); this.connDriverClass = props.getProperty(propertiesPrefix, no, "connection.driver_class"); this.connUrl = props.getProperty(propertiesPrefix, no, "connection.url"); this.connUsername = props.getProperty(propertiesPrefix, no, "connection.username"); this.connPassword = props.getProperty(propertiesPrefix, no, "connection.password"); this.selecImageFileRecordSql = props.getProperty(propertiesPrefix, no, "sql.select_image_file_record"); this.updateImageFileRecordSql = props.getProperty(propertiesPrefix, no, "sql.update_image_file_record"); } private Connection getConnection() throws Exception { Connection conn = null; log.debug(this.getConnDriverClass()); Class.forName(this.getConnDriverClass()); log.debug("" + this.getConnUrl()); log.debug("USERNAME:" + this.getConnUsername() + "\tPASSWORD:" + this.getConnPassword()); conn = DriverManager.getConnection(this.getConnUrl(), this.getConnUsername(), this.getConnPassword()); return conn; } /* (non-Javadoc) * @see com.its.core.module.task.ATask#execute() */ @Override public void execute() { long startTime = System.currentTimeMillis(); Connection conn = null; try { conn = this.getConnection(); conn.setAutoCommit(false); } catch (Exception e) { log.error("" + e.getMessage(), e); return; } try { List<VehicelRecordBean> recordList = this.getExportRecordList(conn); int size = recordList.size(); log.debug("" + size + ""); if (size == 0) return; short currentExcelRow = 1; for (int i = 0; i < size; i++) { VehicelRecordBean record = (VehicelRecordBean) recordList.get(i); // this.updateRecordStatus(conn, record.getId()); String filePath = this.getImgSaveDir() + "/" + DEVICE_MAP.get(record.getDeviceIp()) + "/" + DateHelper.dateToString(record.getCatchTime(), "yyyyMMdd") + "/" + DateHelper.dateToString(record.getCatchTime(), "HH") + "/"; FileHelper.createDir(filePath); StringBuffer fileNameBuffer = new StringBuffer("X03"); fileNameBuffer.append("R").append(DEVICE_MAP.get(record.getDeviceIp())).append("D") .append(DIRECTION_MAP.get(record.getDirectionCode())).append("L") .append(record.getDrivewayNo()).append("I").append("000").append("V").append("000") .append("N").append((int) (Math.random() * (99999 - 10000)) + 10000).append("T") .append(DateHelper.dateToString(record.getCatchTime(), "yyyyMMddHHmmssSSS")); if (StringHelper.isNotEmpty(record.getPlate()) && !record.getPlate().equals("")) { fileNameBuffer.append("&").append(record.getPlate()).append("&") .append(COLOR_MAP.get(record.getPlateColorCode())); } fileNameBuffer.append("S11.JPG"); String fileName = fileNameBuffer.toString(); filePath += fileName; byte[] imageByte = ImageHelper.getImageBytes(this.getHttpPrefix() + record.getFeatureImagePath()); FileHelper.writeFile(imageByte, filePath); // log.info(""+filePath); conn.commit(); currentExcelRow++; } long currentTime = System.currentTimeMillis(); log.info("" + (currentExcelRow - 1) + " " + ((currentTime - startTime) / 1000F) + ""); } catch (Exception ex) { log.error("" + ex.getMessage(), ex); try { conn.commit(); } catch (Exception e) { } } finally { if (conn != null) { try { conn.close(); } catch (Exception ex3) { log.error(ex3); } } } } private List<VehicelRecordBean> getExportRecordList(Connection conn) throws Exception { List<VehicelRecordBean> recordList = new ArrayList<VehicelRecordBean>(); PreparedStatement preStatement = null; ResultSet rs = null; try { log.debug("" + this.getSelecImageFileRecordSql()); preStatement = conn.prepareStatement(this.getSelecImageFileRecordSql()); rs = preStatement.executeQuery(); while (rs.next()) { VehicelRecordBean record = new VehicelRecordBean(); record.setId(rs.getLong("ID")); record.setDeviceIp(rs.getString("DeviceIP")); record.setPlate(rs.getString("LicenseNumber")); record.setPlateColorCode(rs.getString("LicenseColor")); record.setDirectionCode(rs.getString("Direction")); record.setCatchTime(rs.getTimestamp("CatchDate")); record.setDrivewayNo(rs.getString("RoadId")); record.setSpeed(rs.getString("Speed")); record.setFeatureImagePath(rs.getString("ImagePath")); recordList.add(record); } } catch (Exception ex) { log.error(ex.getMessage(), ex); throw ex; } finally { DatabaseHelper.close(rs, preStatement); } return recordList; } private void updateRecordStatus(Connection conn, long id) throws Exception { PreparedStatement preStatement = null; try { log.debug(this.getUpdateImageFileRecordSql()); preStatement = conn.prepareStatement(this.getUpdateImageFileRecordSql()); preStatement.setLong(1, id); preStatement.executeUpdate(); } catch (Exception ex) { log.error(ex.getMessage(), ex); throw ex; } finally { DatabaseHelper.close(null, preStatement); } } /** * @return the httpPrefix */ public String getHttpPrefix() { return httpPrefix; } /** * @param httpPrefix the httpPrefix to set */ public void setHttpPrefix(String httpPrefix) { this.httpPrefix = httpPrefix; } /** * @return the imgSaveDir */ public String getImgSaveDir() { return imgSaveDir; } /** * @param imgSaveDir the imgSaveDir to set */ public void setImgSaveDir(String imgSaveDir) { this.imgSaveDir = imgSaveDir; } /** * @return the connDriverClass */ public String getConnDriverClass() { return connDriverClass; } /** * @param connDriverClass the connDriverClass to set */ public void setConnDriverClass(String connDriverClass) { this.connDriverClass = connDriverClass; } /** * @return the connUrl */ public String getConnUrl() { return connUrl; } /** * @param connUrl the connUrl to set */ public void setConnUrl(String connUrl) { this.connUrl = connUrl; } /** * @return the connUsername */ public String getConnUsername() { return connUsername; } /** * @param connUsername the connUsername to set */ public void setConnUsername(String connUsername) { this.connUsername = connUsername; } /** * @return the connPassword */ public String getConnPassword() { return connPassword; } /** * @param connPassword the connPassword to set */ public void setConnPassword(String connPassword) { this.connPassword = connPassword; } /** * @return the selecImageFileRecordSql */ public String getSelecImageFileRecordSql() { return selecImageFileRecordSql; } /** * @param selecImageFileRecordSql the selecImageFileRecordSql to set */ public void setSelecImageFileRecordSql(String selecImageFileRecordSql) { this.selecImageFileRecordSql = selecImageFileRecordSql; } /** * @return the updateImageFileRecordSql */ public String getUpdateImageFileRecordSql() { return updateImageFileRecordSql; } /** * @param updateImageFileRecordSql the updateImageFileRecordSql to set */ public void setUpdateImageFileRecordSql(String updateImageFileRecordSql) { this.updateImageFileRecordSql = updateImageFileRecordSql; } }