@Override
	public void updateScanPlan(ArrayList<Integer> list) {
		try{
    		if(prefetchConnectionURL != null&&userName!=null&&passWd!=null&&list!=null&&(list.size()!=0)){
	    		Connection conn = DriverManager.getConnection(prefetchConnectionURL,userName,passWd);
	    		String intList = "(";
	    		for(Iterator<Integer> it = list.iterator();it.hasNext();){
	    			intList = intList + it.next()+",";
	    		}
	    		intList = intList.substring(0,intList.length()-1);
	    		intList+=")";
	    		SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
	            String currentTime = df.format(new Date());
	    		PreparedStatement pstmt = conn.prepareStatement("update TB_SCANPLAN set fendibm = 0 where fdatetime <= ? and fid not in "+intList);
	    		pstmt.setString(1, currentTime);
		        pstmt.executeUpdate();
	            pstmt.close();
    		}
    	} catch(SQLException ex){
    		logger.log(Level.SEVERE, "update db:", ex);
    	}
	}