文章列表
select * from (SELECT rownum as rew,t1.SALT,to_char(t1.END_TIME,'yyyy-MM-dd HH24:MI:ss') as END_TIME,t1.DEICING_SALT,t1.DEPT_ID,t2.ORGNAME,RANK() OVER(PARTITION BY t1.DEPT_ID ORDER BY t1.END_TIME) as rank FROM SNOW_STATISTICS t1 left join SNOW_ORG t2 on t2.ORGCODE = t1.DEPT_ID where status = 1 ) wher ...
package com.yunfengtech.common;
import java.io.ByteArrayInputStream;
import java.io.File;
import java.io.FileOutputStream;
import org.apache.log4j.Logger;
import org.apache.poi.poifs.filesystem.DirectoryEntry;
import org.apache.poi.poifs.filesystem.DocumentEntry;
import org.apache.poi.poif ...
public List<RBean> queryFrozenWarnHistory(Connection conn, FrozenRequestEntity req) throws Exception {
// TODO Auto-generated method stub
PreparedStatement pst = null;
ResultSet rs = null;
RBean rBean = null;
ArrayList<RBean> queryFrozenWarnHistoryList = new ArrayList<R ...
$.ajax({
url:"../../stock",
data: $.toJSON(opts),
type:"post",
dataType:"json",
success:function(data) {
var result = data.result;
var reason = data.reason;
if("OK"==result){
if(data.itemList!=null){
if(data.item ...
function repuMapCallBack(tag){//鼠标停留1s才请求
setTimeout(function(){
var divId = tag.obj.divId;
var chartDiv = $("#"+divId);//相当document.getElementById(divId);
if(chartDiv.length == 0){
return;
}
drawTempLine(tag) ;
},1000);
}
<html>
...
一，基本概念
1，自定义对象。
根据JS的对象扩展机制，用户可以自定义JS对象，这与Java语言有类似的地方。
与自定义对象相对应的是JS标准对象，例如Date、Array、Math等等。
2，原型（prototype）
在JS中，这是一种创建对象属性和 ...
function Vector()
{
this.data = new Array();
this.add = Vector_add;
this.remove = Vector_remove;
this.elementAt = Vector_elementAt;
this.setElementAt = Vector_setElementAt;
this.insert = Vector_insert;
this.co ...
function Person() {
this.name;
this.setName = function(name) {
this.name = name;
};
this.getName = function() {
return this.name;
};
}
//创建一个Person对象
var p = new Person();
p.setName("Bruce");
alert(p.getName());
function aaa(){
var num=22.157456;
alert( Math.round(num*100)/100);
num.fix(2);//注意var 用Number转换
}
function predictWeather(obj,obj2){
var weather_time = [];
var weather_temp = [];
var delta = obj2;
var chart = obj;
//var chart = document.getElementById(chartdiv);
var echart = echarts.init(chart);
echart.showLoading({
text: '加载中...'
});
var opt ...
加法
select sysdate,add_months(sysdate,12) from dual; --加1年
select sysdate,add_months(sysdate,1) from dual; --加1月
select sysdate,to_char(sysdate+7,'yyyy-mm-dd HH24:MI:SS') from dual; --加1星期
select sysdate,to_char(sysdate+1,'yyyy-mm-dd HH24:MI:SS') from dual; --加1天
select sys ...
/**
* 添加预案关联
* @author ecy
*/
@Override
public void addPlanGroupMap(Connection conn,PlanInfo planInfo) throws Exception {
PreparedStatement pst = null;
String addPlanGroupMapByPersonSQL = "insert into SNOW_PLAN_PERSON_MAP (GROUP_ID,PERSON_ID) VALUES(?,?)";
pst = DBCo ...
/**
* 查询路段管理
* @author ecy
* @return
*/
@Override
public ArrayList<Road> queryRoadList(Connection conn, Road road) throws SQLException {
PreparedStatement pst = null;
ResultSet rs = null;
Road r = null;
ArrayList<Road> roadList = new ArrayList<Road>();
Stri ...
public static ArrayList<GroupReport> queryTaskRoadCode(String req){
TaskDao taskDao = DaoFactory.getInstance().getTaskDao();
Connection conn = DaoFactory.getInstance().getConnection();
ArrayList<GroupReport> taskRoadCodeList = null;
try {
taskRoadCodeList = taskDao. ...
<script>
var data=" { root: [ {name:'1',value:'0'}, {name:'6101',value:'北京市'}, {name:'6102',value:'天津市'}, {name:'6103',value:'上海市'}, {name:'6104',value:'重庆市'},{name:'6105',value:'渭南市'}, {name:'6106',value:'延安市'}, {name:'6107',value:'汉中市'}, {name:'6108',value:'榆林市'}, {name:'6109',value:'安康 ...