/* * 执行sql语句 */ public boolean changeDatabase(String sql) { boolean flag = false; Connection conn = commonDao.getSqlSession().getConnection(); Statement st = null; if (conn == null) { logger.error("获取数据库连接失败 !"); return false; } try { st = conn.createStatement(); st.execute(sql); int num = st.getUpdateCount(); flag = true; logger.info("更新记录数 : " + num); } catch (SQLException e) { logger.error(e.getMessage()); } finally { try { if (st != null) { st.close(); } } catch (SQLException e1) { Log.error(e1.getMessage()); } } return flag; }
/** @return List<Map<String, String>> [resId,localCode,localChannelId,operation] */ public List<Map<String, String>> getAutoSendCrawlResources() { List<Map<String, String>> list = null; Connection conn = null; PreparedStatement pst = null; ResultSet rs = null; String sql = " select a.res_id,b.local_code,b.local_channel_id,b.operation from twap_public_crawl_resource a,twap_public_channel_mapping_a b where a.channel_id = b.channel_id "; try { conn = JavaOracle.getConn(); pst = conn.prepareStatement(sql); rs = pst.executeQuery(); list = new ArrayList<Map<String, String>>(); Map<String, String> map = null; while (rs.next()) { map = new HashMap<String, String>(); map.put("resId", String.valueOf(rs.getLong("res_id"))); map.put("localCode", rs.getString("local_code")); map.put("localChannelId", rs.getString("local_channel_id")); map.put("operation", String.valueOf(rs.getInt("operation"))); list.add(map); } } catch (Exception e) { e.printStackTrace(); Log.error(e); } finally { close(conn, pst, rs); } return list; }
/** creating the list for generation to the report */ private void createReportItems() { try { csvRoutineColumnBuilder = getColumnBuilder(); csvRoutineColumnBuilder.buildDataSource(); } catch (Exception e) { Log.error("Error in " + this.getClass().getSimpleName() + ".createReportItems: ", e); add1LineErrorMessage("report.error.message.general.error"); } }
public void setRequestParameters(BaseActionForm dynaForm) { try { PropertyUtils.setProperty(dynaForm, "reportName", getReportNameForParameterPage()); PropertyUtils.setProperty(dynaForm, "useLowerDateRange", Boolean.TRUE); PropertyUtils.setProperty(dynaForm, "useUpperDateRange", Boolean.TRUE); // PropertyUtils.setProperty(dynaForm, "useProjectCode", Boolean.TRUE); // PropertyUtils.setProperty(dynaForm, "projectCodeList", getProjectList()); } catch (Exception e) { Log.error("Error in ExportRoutineByDate.setRequestParemeters: ", e); } }
// ---------------------------------------------------------- public ObjectId resolve(String revstr) { try { return repository.resolve(revstr); } catch (Exception e) { Log.error( "An error occurred when resolving the string " + revstr + " in the repository at " + repository.getDirectory(), e); return null; } }
// 连接CB private static Bucket connectionBucket(Bucket bucket) { try { bucket = connectionCouchBaseLocal(); // 本地CB } catch (Exception e) { while (true) { try { bucket = connectionCouchBaseLocal(); // 本地CB break; } catch (Exception ee) { Log.error(ee); } } } return bucket; }
public String takePhoto() { if (input != null) return "input"; try { int action = 1; int interval = 0; // 连续拍照时间 int saveType = 0; // 保存类型 int picSize = 2; // 画面大小 int quality = 0; // 画面品质 0- 10 int light = 0; // 亮度 0-255 int compare = 0; // 对比度 0-127 int stature = 0; // 饱和度 0-127 int grade = 0; // 色度 0-255 StringBuilder sb = new StringBuilder(); sb.append(channel) .append(";") .append(action) .append(";") .append(interval) .append(";") .append(saveType) .append(";") .append(picSize) .append(";") .append(quality) .append(";") .append(light) .append(";") .append(compare) .append(";") .append(stature) .append(";") .append(grade); TerminalCommand tc = new TerminalCommand(); tc.setCmdType(JT808Constants.CMD_TAKE_PHOTO); tc.setCmdData(sb.toString()); SendCommand(tc); return json(true, tc.getEntityId()); } catch (Exception ex) { Log.error(ex.getMessage(), ex); return json(false, ex.getMessage()); } }