java -cp .:/app/jenkins/ojdbc6-11.2.0.1.0.jar QueryInterTestImpl
οnclick="add_win.after(initValues)()" //先执行add_win方法,再执行initValues方法
οnclick="setForbidTime.after(add_params)('gomewalletbankinfo/save.dhtml','save')"
mysql int11 位转日期 需要 乘以1000
1
Files.readLines(file, Charset.forName("utf-8"), new LineProcessor() { @Override public boolean processLine(String line) throws IOException { String[] messages = StringUtils.splitByWholeSeparatorPreserveAllTokens(line, ","); String[] socketLogicIds = StringUtils.splitByWholeSeparatorPreserveAllTokens(finalLogicId, ","); StringBuffer socketLogicIdValue = new StringBuffer(); for(int i=0;i<socketLogicIds.length;i++){ int index = Integer.parseInt(socketLogicIds[i]); socketLogicIdValue.append(messages[index].equalsIgnoreCase("null")?"":messages[index]); } StringBuffer socketLacCiIdKey = new StringBuffer(); int socketLacCiIdIndex = Integer.parseInt(finalLacCiId); socketLacCiIdKey.append(messages[socketLacCiIdIndex]); laciCacheDara.put(socketLacCiIdKey.toString(), socketLogicIdValue.toString()); return true; }
2 apache stringUtils String[] messages = StringUtils.splitByWholeSeparatorPreserveAllTokens(line, ","); StringUtils.isNotBlank(str)
guava strings Strings.isNullOrEmpty(processStr)
Introspector.decapitalize : Thus "FooBah" becomes "fooBah" and "X" becomes "x", but "URL" stays as "URL".
CollectionUtils.isEmpty(list); list为NULL也可以用
3 class.cast(object)
4 xStream转换xml 和 json
XStream xstream = new XStream(new DomDriver());
xstream.alias("file", FileConfig.class);
http://www.cnblogs.com/hoojo/archive/2011/04/22/2025197.html
5 URL confFileUrl = getClass().getResource(fileName);
6 apache dateUtil
Date date = new Date(); String aString = DateFormatUtils.format(date, "yyyy-MM-dd "); Date ddDate =DateUtils.addDays(date, -10);
String execDate ="20141210";
Date date = DateUtils.parseDate(execDate, new String[]{"yyyyMMdd"});
System.out.println(date);
String startDateStr = DateFormatUtils.format(date, "yyyy-MM-01 00:00:00");
System.out.println(startDateStr);
DateUtils.addDays(date, 2);
7 web工程out输出
private static final void out(String string, HttpServletResponse response) {
PrintWriter writer = null;
try {
response.setContentType("application/json; charset=UTF-8");
response.setCharacterEncoding("UTF-8");
response.setHeader("progma", "no-cache");
response.setHeader("Access-Control-Allow-Origin", "*");
response.setHeader("Cache-Control", "no-cache");
writer = response.getWriter();
writer.write(string);
} catch (IOException e) {
LOG.error("",e);
dataJson.put("status", "201");
out.print(dataJson);
} finally {
if (null != writer) {
writer.flush();
writer.close();
}
}
}
8 json to map
public static Map<String, Object> jsonToMap(String paramJson ){ Map<String, Object> paramsMap = new HashMap<String, Object>(); paramsMap = (Map<String, Object>) JSONObject.fromObject(paramJson); return paramsMap; }
9 str 判null或者""或者0
/** * 判断obj是否为空或者0 是返True * @param obj * @return */ private static Boolean isNullOrZero(Object obj) { Boolean flag = false; if(null !=obj){ String str = String.valueOf(obj); if (("0").equals(str) || "".equals(str)) { flag = true; } }else{ flag = true; } return flag; }
10 ORACLE 日期比较可直接传 Date date =new Date() 参数比较
public List getMtlCtrlProductNo(String campsegId,String channelId,Date beginDate,String count){ StringBuffer sql = new StringBuffer("SELECT PRODUCT_NO, COUNT(1) FROM MTL_CONTACT_ACTIVITY_RCT_LOG "); sql.append(" where CAMPSEG_ID = ? AND CHANNEL_ID = ? "); sql.append(" AND LOG_TIME >= ? "); sql.append(" GROUP BY PRODUCT_NO HAVING COUNT(1) >= ? "); List list = this.getJdbcTemplate().queryForList(sql.toString(),new Object[]{campsegId,channelId,beginDate,Integer.valueOf(count)}); return list; }
11 String filePath = ClassLoader.getSystemResource("config/ec/").getPath(); 当前class所在根目录下的config/ec/
filePath = filePath.substring(1, filePath.length()).replace("/", "\\");
12 java 转千分位 百分数
/** * 处理成千分位 * @param number * @param pattern ",###,###"||",###,###.00" * @return */ public static String parseMoney(String number,String pattern){ if(StringUtils.isEmpty(pattern)){ pattern = ",###,###"; } BigDecimal bd=new BigDecimal(number); DecimalFormat df=new DecimalFormat(pattern); return df.format(bd); } /** * 处理成百分数 * @param number * @return */ public static String parsePercent(String number){ double result=Double.valueOf(number); DecimalFormat df = new DecimalFormat("0.00%"); return df.format(result); }
DecimalFormat myformat =
new
DecimalFormat();
myformat.applyPattern(
"##,###"
);
amount =
new
BigDecimal(amount).divide(
new
BigDecimal(
100
)).toString();
amount = myformat.format(
new
BigDecimal(amount).setScale(
0
, RoundingMode.DOWN));
13 sql like 方法 B.CAMPSEG_ID like '%'|| ? ||'%' or B.CAMPSEG_NAME LIKE '%'|| ? ||'%'
14
public List<MtlBotherContactConfig> getMtlBotherContactConfigList() { StringBuffer sql = new StringBuffer("select * from MTL_BOTHER_CONTACT_CONFIG where CONTACT_CONTROL_FLAG <> 0 "); List<MtlBotherContactConfig> list = getJdbcTemplate().query(sql.toString(),new RowMapper(){ @Override public Object mapRow(ResultSet rs, int arg1) throws SQLException { MtlBotherContactConfig obj = new MtlBotherContactConfig(); obj.setAvoidBotherFlag(rs.getLong("AVOID_BOTHER_FLAG")); obj.setCampsegCityType(rs.getLong("CAMPSEG_CITY_TYPE")); obj.setCampsegTypeId(rs.getLong("CAMPSEG_TYPE_ID")); obj.setChannelId(rs.getString("CHANNEL_ID")); obj.setContactControlFlag(rs.getLong("CONTACT_CONTROL_FLAG")); obj.setParamDays(rs.getLong("PARAM_DAYS")); obj.setParamNum(rs.getLong("PARAM_NUM")); return obj; } }); return list; }
15 jdbc rowMapper
/** * 加载接触频次控制渠道配置规则 * @param sql * @param map */ private void loadChannelContactRuleConfig(String sql, final Map<String, Map<String,Object>> map) { JdbcTemplate jt = SpringContext.getBean("jdbcTemplate", JdbcTemplate.class); jt.query(sql, new RowMapper() { public Object mapRow(ResultSet rs, int rowNum) throws SQLException { String channelId = rs.getString("CHANNEL_ID"); String channelName = rs.getString("CHANNEL_NAME"); Integer userLevelControlFlag = rs.getInt("USER_LEVEL_CONTROL_FLAG");//此渠道是否接受用户级的接触频次控制:0:不受控制,1:受控制 Integer channelDayCount = rs.getInt("CHANNEL_DAY_COUNT");//每个用户在这个渠道每天最多可以接受多少次 Integer channelMonthCount = rs.getInt("CHANNEL_MONTH_COUNT");//每个用户在这个渠道每个月最多可以接受多少次 if (StringUtil.isNotEmpty(channelId)) { Map<String, Object> channelConfig = new HashMap<String,Object>(); channelConfig.put("channelId", channelId); channelConfig.put("channelName", channelName); channelConfig.put("userLevelControlFlag", userLevelControlFlag); channelConfig.put("channelDayCount", channelDayCount); channelConfig.put("channelMonthCount", channelMonthCount); map.put(channelId, channelConfig); } return null; } }); }
sql.append("SELECT * FROM USER");
return this.getJdbcTemplate().query(sql.toString(),
ParameterizedBeanPropertyRowMapper.newInstance(user.class));
///INSERT_MESSAGE_SQL = INSERT INTO BS_SMS_PUSH_R(ID,TASK_ID,CHANNEL_ID,MSISDN,SUBJECT,STATUS,SEND_COUNT,CREATE_TIME,UPDATE_TIME) VALUES
(:id,:taskId,:channelId,:productNo,:msg,:status,:sendCount,:createTime,:updateTime)
String sql = MpmConfigure.getInstance().getProperty("INSERT_MESSAGE_SQL");
SqlParameterSource[] params = SqlParameterSourceUtils.createBatch(msgList.toArray());
SimpleJdbcTemplate messageSimpleJdbcTemplate = SpringContext.getBean("messageSimpleJdbcTemplate", SimpleJdbcTemplate.class);
messageSimpleJdbcTemplate.batchUpdate(sql, params);