import org.apache.poi.xslf.usermodel.XMLSlideShow;

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;

public class DealDocument {

    protected String path = "data";
    /**
     * 创建文档
     *
     * @param name
     */
    public void createDocument(String name) {

        XMLSlideShow ppt = new XMLSlideShow();
        String fileName = this.path + File.separator + name;
        File file = new File(fileName);
        try {
            FileOutputStream out = new FileOutputStream(file);
            ppt.write(out);
            System.out.println("Presentation created successfully");
            out.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}

import java.io.*;
import java.net.URL;
import java.util.List;
import org.apache.poi.*;
public class Main {

    public static void main(String[] args) throws IOException{
        System.out.println("Hello World!");
        DealDocument dd = new DealDocument();
        dd.createDocument("example1.pptx");
    }
}

Hello World!
Presentation created successfully

　Exception in thread "main" java.lang.IncompatibleClassChangeError: Found class org.apache.poi.util.POILogger, but interface was expected

ClassLoader classloader = org.apache.poi.poifs.filesystem.POIFSFileSystem.class.getClassLoader();
URL res = classloader.getResource("org/apache/poi/poifs/filesystem/POIFSFileSystem.class");
String path = res.getPath();
System.out.println("POI Core came from " + path);

classloader = org.apache.poi.POIDocument.class.getClassLoader();
res = classloader.getResource("org/apache/poi/POIDocument.class");
path = res.getPath();
System.out.println("POI OOXML came from " + path);

classloader=org.apache.poi.hdgf.HDGFDiagram.class.getClassLoader();
res = classloader.getResource("org/apache/poi/hdgf/HDGFDiagram.class");
path = res.getPath();
System.out.println("POI Scratchpad came from " + path);

POI Core came from file:/C:/Program%20Files/Java/jdk1.8.0_151/jre/lib/ext/poi-3.17.jar!/org/apache/poi/poifs/filesystem/POIFSFileSystem.class
POI OOXML came from file:/C:/Program%20Files/Java/jdk1.8.0_151/jre/lib/ext/poi-3.17.jar!/org/apache/poi/POIDocument.class
POI Scratchpad came from file:/E:/java/project/ppt/ppttest/lib/poi-scratchpad-4.1.0.jar!/org/apache/poi/hdgf/HDGFDiagram.class

public void addNewSlide(String name){

        String fileName = this.path + File.separator + name;
        File file = new File(fileName);
        try {
            //opening an existing slide show
            FileInputStream in = new FileInputStream(file);
            XMLSlideShow ppt = new XMLSlideShow(in);
            //adding slides to the slodeshow
            XSLFSlide slide1= ppt.createSlide();
            XSLFSlide slide2 = ppt.createSlide();
            //saving the changes
            FileOutputStream out = new FileOutputStream(file);
            ppt.write(out);
            System.out.println("Presentation edited successfully");
            out.close();
        }catch (IOException e) {
            e.printStackTrace();
        }
}

DealDocument dd = new DealDocument();
dd.addNewSlide("tpl1.pptx");

Hello World!
Presentation edited successfully

import org.apache.poi.xslf.usermodel.*;
import java.awt.*;
import java.awt.geom.Rectangle2D;
import java.awt.image.BufferedImage;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;

public class ImageConvert {

    public void converter(String fileName) {
        BackRS rs = new BackRS();
        File file = new File(fileName);
        String name = file.getName();
        String filePath = file.getParent();
        try {
            FileInputStream in = new FileInputStream(file);
            XMLSlideShow ppt = new XMLSlideShow(in);
            Dimension pgsize = ppt.getPageSize();
            String saveImagePathName = filePath + File.separator + getFileNameNoEx(name)+"_JPG";
            File path = new File(saveImagePathName);
            if (!path.exists()) {
                path.mkdir();
            }
            Integer i = 0;
            BufferedImage img =null;
            for (XSLFSlide slide : ppt.getSlides()) {
                //解决乱码问题
                for(XSLFShape shape : slide.getShapes()){
                    if(shape instanceof XSLFTextShape) {
                        XSLFTextShape tsh = (XSLFTextShape)shape;
                        for(XSLFTextParagraph p : tsh){
                            for(XSLFTextRun r : p){
                                r.setFontFamily("宋体");
                            }
                        }
                    }
                }
                img = new BufferedImage(pgsize.width, pgsize.height, BufferedImage.TYPE_INT_RGB);
                Graphics2D graphics = img.createGraphics();
                graphics.setPaint(Color.white);
                graphics.fill(new Rectangle2D.Float(0, 0, pgsize.width, pgsize.height));
                slide.draw(graphics);
                FileOutputStream out = new FileOutputStream(path + File.separator + (i+1) + ".JPG");
                i++;
                javax.imageio.ImageIO.write(img, "PNG", out);
                out.close();
            }
            System.out.println("Image successfully converted.");
        } catch (Exception e) {
            System.out.println("error:"+e.getMessage());
        }
    }

    /**
     * 获取文件名，去除扩展名的
     */
    public String getFileNameNoEx(String filename) {
        if ((filename != null) && (filename.length() > 0)) {
            int dot = filename.lastIndexOf(''.'');
            if ((dot > -1) && (dot < (filename.length()))) {
                return filename.substring(0, dot);
            }
        }
        return filename;
    }
}

Dim ws As Worksheet
Set ws = ThisWorkbook.Sheets(1)
ws.Cells.Font.Bold = True

解决方法

Sheet sheet = wb.createSheet("test");
CellStyle cs = wb.createCellStyle();
Font f = wb.createFont();
f.setBoldweight(Font.BOLDWEIGHT_BOLD);
cs.setFont(f);
sheet.setDefaultColumnStyle(1,cs); //set bold for column 1

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:id="@+id/item_full"
    android:layout_width="match_parent"
    android:layout_height="wrap_content"
    android:background="#eff0f7"
    android:baselineAligned="false"
    android:orientation="vertical" >
    <RelativeLayout
        android:id="@+id/item_first_half"
        android:layout_width="match_parent"
        android:layout_height="36dp"
        android:orientation="vertical" >
        <View
            android:id="@+id/first_path"
            android:layout_width="4dp"
            android:layout_height="4dp"
            android:layout_marginLeft="40dp"
            android:layout_marginStart="40dp"
            android:background="@drawable/selector_car_action_path" />
        <ImageView
            android:id="@+id/im_car_direction_icon"
            android:layout_width="28dp"
            android:layout_height="28dp"
            android:layout_gravity="top"
            android:layout_marginLeft="28dp"
            android:layout_marginStart="28dp"
            android:layout_marginTop="4dp"
            android:background="@drawable/selector_car_action_background"
            android:padding="2dp"
            android:src="@drawable/selector_navi_icon_63" />
        <View
            android:id="@+id/second_path"
            android:layout_width="4dp"
            android:layout_height="4dp"
            android:layout_below="@id/im_car_direction_icon"
            android:layout_marginLeft="40dp"
            android:layout_marginStart="40dp"
            android:background="@drawable/selector_car_action_path" />
        <TextView
            android:id="@+id/tv_direction"
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            android:layout_centerVertical="true"
            android:layout_marginEnd="15dp"
            android:layout_marginLeft="68dp"
            android:layout_marginRight="15dp"
            android:layout_marginStart="68dp"
            android:singleLine="true"
            android:text=""
            android:textColor="@drawable/selector_car_route_turn_text"
            android:textSize="16sp" />
    </RelativeLayout>
    <RelativeLayout
        android:id="@+id/item_second_half"
        android:layout_width="match_parent"
        android:layout_height="32dp" >
        <View
            android:id="@+id/third_path"
            android:layout_width="4dp"
            android:layout_height="match_parent"
            android:layout_marginLeft="40dp"
            android:layout_marginStart="40dp"
            android:background="@drawable/selector_car_action_path" />
        <TextView
            android:id="@+id/tv_road_name"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_marginLeft="68dp"
            android:layout_marginStart="68dp"
            android:layout_marginTop="4dp"
            android:singleLine="true"
            android:text=""
            android:textColor="@drawable/selector_car_route_desc"
            android:textSize="16sp" />
        <TextView
            android:id="@+id/divider_for_road_and_distance"
            android:layout_width="wrap_content"
            android:layout_height="match_parent"
            android:layout_marginEnd="7dp"
            android:layout_marginLeft="7dp"
            android:layout_marginRight="7dp"
            android:layout_marginStart="7dp"
            android:layout_marginTop="4dp"
            android:layout_toEndOf="@id/tv_road_name"
            android:layout_toRightOf="@id/tv_road_name"
            android:singleLine="true"
            android:text="|"
            android:textColor="@drawable/selector_car_route_desc"
            android:textSize="16sp" />
        <TextView
            android:id="@+id/tv_ride_distance"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_marginEnd="15dp"
            android:layout_marginRight="15dp"
            android:layout_marginTop="4dp"
            android:layout_toEndOf="@id/divider_for_road_and_distance"
            android:layout_toRightOf="@id/divider_for_road_and_distance"
            android:singleLine="true"
            android:text=""
            android:textColor="@drawable/selector_car_route_desc"
            android:textSize="16sp" />
        <View
            android:layout_width="match_parent"
            android:layout_height="1px"
            android:layout_alignParentBottom="true"
            android:layout_marginEnd="15dp"
            android:layout_marginLeft="68dp"
            android:layout_marginRight="15dp"
            android:layout_marginStart="68dp"
            android:background="#dee1f0" />
    </RelativeLayout>
</LinearLayout>

<?xml version="1.0" encoding="utf-8"?>
<selector xmlns:android="http://schemas.android.com/apk/res/android">

    <item android:state_selected="true" android:color="@color/color_999999"/>
    <item android:state_selected="false" android:color="@color/color_333333"/>

</selector>

android.view.InflateException: Binary XML file line #106: Error inflating class <unkNown>
android.view.LayoutInflater.createView(LayoutInflater.java:606)
com.android.internal.policy.impl.PhoneLayoutInflater.onCreateView(PhoneLayoutInflater.java:56)
android.view.LayoutInflater.onCreateView(LayoutInflater.java:653)
android.view.LayoutInflater.createViewFromTag(LayoutInflater.java:678)
android.view.LayoutInflater.rInflate(LayoutInflater.java:739)
android.view.LayoutInflater.rInflate(LayoutInflater.java:742)
android.view.LayoutInflater.inflate(LayoutInflater.java:489)
android.view.LayoutInflater.inflate(LayoutInflater.java:396)
android.view.LayoutInflater.inflate(LayoutInflater.java:352)
com.tencent.map.ama.route.ui.view.e.<init>(CarRouteShowItem.java:78)
com.tencent.map.ama.route.ui.view.f.a(CarRouteShowView.java:100)
com.tencent.map.ama.route.ui.view.d.a(CarRouteDetailView.java:37)
com.tencent.map.ama.route.ui.MapStateCarRoute.e(MapStateCarRoute.java:418)
com.tencent.map.ama.route.ui.MapStateCarRoute$1.run(MapStateCarRoute.java:255)
android.os.Handler.handleCallback(Handler.java:605)
android.os.Handler.dispatchMessage(Handler.java:92)
android.os.Looper.loop(Looper.java:137)
android.app.ActivityThread.main(ActivityThread.java:4476)
java.lang.reflect.Method.invokeNative(Native Method)
java.lang.reflect.Method.invoke(Method.java:511)
com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:808)
com.android.internal.os.ZygoteInit.main(ZygoteInit.java:575)
dalvik.system.NativeStart.main(Native Method)
cause by:
java.lang.reflect.InvocationTargetException: null
java.lang.reflect.Constructor.constructNative(Native Method)
java.lang.reflect.Constructor.newInstance(Constructor.java:417)
android.view.LayoutInflater.createView(LayoutInflater.java:586)
com.android.internal.policy.impl.PhoneLayoutInflater.onCreateView(PhoneLayoutInflater.java:56)
android.view.LayoutInflater.onCreateView(LayoutInflater.java:653)
android.view.LayoutInflater.createViewFromTag(LayoutInflater.java:678)
android.view.LayoutInflater.rInflate(LayoutInflater.java:739)
android.view.LayoutInflater.rInflate(LayoutInflater.java:742)
android.view.LayoutInflater.inflate(LayoutInflater.java:489)
android.view.LayoutInflater.inflate(LayoutInflater.java:396)
android.view.LayoutInflater.inflate(LayoutInflater.java:352)
com.tencent.map.ama.route.ui.view.e.<init>(CarRouteShowItem.java:78)
com.tencent.map.ama.route.ui.view.f.a(CarRouteShowView.java:100)
com.tencent.map.ama.route.ui.view.d.a(CarRouteDetailView.java:37)
com.tencent.map.ama.route.ui.MapStateCarRoute.e(MapStateCarRoute.java:418)
com.tencent.map.ama.route.ui.MapStateCarRoute$1.run(MapStateCarRoute.java:255)
android.os.Handler.handleCallback(Handler.java:605)
android.os.Handler.dispatchMessage(Handler.java:92)
android.os.Looper.loop(Looper.java:137)
android.app.ActivityThread.main(ActivityThread.java:4476)
java.lang.reflect.Method.invokeNative(Native Method)
java.lang.reflect.Method.invoke(Method.java:511)
com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:808)
com.android.internal.os.ZygoteInit.main(ZygoteInit.java:575)
dalvik.system.NativeStart.main(Native Method)
cause by:
java.lang.UnsupportedOperationException: Can''t convert to dimension: type=0x12
android.content.res.TypedArray.getDimensionPixelSize(TypedArray.java:463)
android.view.View.<init>(View.java:2849)
android.widget.TextView.<init>(TextView.java:499)
android.widget.TextView.<init>(TextView.java:492)
java.lang.reflect.Constructor.constructNative(Native Method)
java.lang.reflect.Constructor.newInstance(Constructor.java:417)
android.view.LayoutInflater.createView(LayoutInflater.java:586)
com.android.internal.policy.impl.PhoneLayoutInflater.onCreateView(PhoneLayoutInflater.java:56)
android.view.LayoutInflater.onCreateView(LayoutInflater.java:653)
android.view.LayoutInflater.createViewFromTag(LayoutInflater.java:678)
android.view.LayoutInflater.rInflate(LayoutInflater.java:739)
android.view.LayoutInflater.rInflate(LayoutInflater.java:742)
android.view.LayoutInflater.inflate(LayoutInflater.java:489)
android.view.LayoutInflater.inflate(LayoutInflater.java:396)
android.view.LayoutInflater.inflate(LayoutInflater.java:352)
com.tencent.map.ama.route.ui.view.e.<init>(CarRouteShowItem.java:78)
com.tencent.map.ama.route.ui.view.f.a(CarRouteShowView.java:100)
com.tencent.map.ama.route.ui.view.d.a(CarRouteDetailView.java:37)
com.tencent.map.ama.route.ui.MapStateCarRoute.e(MapStateCarRoute.java:418)
com.tencent.map.ama.route.ui.MapStateCarRoute$1.run(MapStateCarRoute.java:255)
android.os.Handler.handleCallback(Handler.java:605)
android.os.Handler.dispatchMessage(Handler.java:92)
android.os.Looper.loop(Looper.java:137)
android.app.ActivityThread.main(ActivityThread.java:4476)
java.lang.reflect.Method.invokeNative(Native Method)
java.lang.reflect.Method.invoke(Method.java:511)
com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:808)
com.android.internal.os.ZygoteInit.main(ZygoteInit.java:575)
dalvik.system.NativeStart.main(Native Method)

View mView = LayoutInflater.from(mContext).inflate(R.layout.car_route_detail_item,null);

public class CarRouteShowItem {

    private Context mContext;

    private View mView;

    public CarRouteShowItem(Context context) {
        mContext = context;

        // mView is used by caller 
        mView = LayoutInflater.from(mContext).inflate(R.layout.car_route_detail_item,null);

        // some view finds 
    }

        // some other methods related with specific logic
}

解决方法

android:layout_height="1px"

android:layout_height="1dp"

对Arrays.asList()返回的List进行操作之后报错Caused by: java.lang.UnsupportedOperationException

让我们来看一下Arrays.asList的源码:

/** * Returns a {@code List} of the objects in the specified array. The size of the * {@code List} cannot be modified, i.e. adding and removing are unsupported, but * the elements can be set. Setting an element modifies the underlying * array. * * @param array * the array. * @return a {@code List} of the elements of the specified array. */
    @SafeVarargs
    public static <T> List<T> asList(T... array) {
        return new ArrayList<T>(array);
    }

private static class ArrayList<E> extends AbstractList<E> implements
            List<E>, Serializable, RandomAccess {

        private static final long serialVersionUID = -2764017481108945198L;

        private final E[] a;

        ArrayList(E[] storage) {
            if (storage == null) {
                throw new NullPointerException("storage == null");
            }
            a = storage;
        }

        @Override
        public boolean contains(Object object) {
            if (object != null) {
                for (E element : a) {
                    if (object.equals(element)) {
                        return true;
                    }
                }
            } else {
                for (E element : a) {
                    if (element == null) {
                        return true;
                    }
                }
            }
            return false;
        }

        @Override
        public E get(int location) {
            try {
                return a[location];
            } catch (ArrayIndexOutOfBoundsException e) {
                throw java.util.ArrayList.throwIndexOutOfBoundsException(location, a.length);
            }
        }

        @Override
        public int indexOf(Object object) {
            if (object != null) {
                for (int i = 0; i < a.length; i++) {
                    if (object.equals(a[i])) {
                        return i;
                    }
                }
            } else {
                for (int i = 0; i < a.length; i++) {
                    if (a[i] == null) {
                        return i;
                    }
                }
            }
            return -1;
        }

        @Override
        public int lastIndexOf(Object object) {
            if (object != null) {
                for (int i = a.length - 1; i >= 0; i--) {
                    if (object.equals(a[i])) {
                        return i;
                    }
                }
            } else {
                for (int i = a.length - 1; i >= 0; i--) {
                    if (a[i] == null) {
                        return i;
                    }
                }
            }
            return -1;
        }

        @Override
        public E set(int location, E object) {
            E result = a[location];
            a[location] = object;
            return result;
        }

        @Override
        public int size() {
            return a.length;
        }

        @Override
        public Object[] toArray() {
            return a.clone();
        }

        @Override
        @SuppressWarnings({"unchecked", "SuspiciousSystemArraycopy"})
        public <T> T[] toArray(T[] contents) {
            int size = size();
            if (size > contents.length) {
                Class<?> ct = contents.getClass().getComponentType();
                contents = (T[]) Array.newInstance(ct, size);
            }
            System.arraycopy(a, 0, contents, 0, size);
            if (size < contents.length) {
                contents[size] = null;
            }
            return contents;
        }
    }

索噶，原来返回的是Arrays类的静态内部类！这样能会报错也就正常咯。

解决方法

workBook.ActiveSheet.PageSetup

m_currentWorkBook.ActiveSheet.PageSetup.LeftFooter = str.ToString();

private bool SetBarcode(string text)
    {
            Excel._Worksheet sheet;
            sheet = (Excel._Worksheet)m_currentWorkbook.ActiveSheet;
            try
            {
                StringBuilder str = new StringBuilder();
                str.Append(@"&""IDAutomationHC39M,Regular""&22(");
                str.Append(text);
                str.Append(")");

                Excel.PageSetup setup;
                setup = sheet.PageSetup;
                try
                {
                    setup.LeftFooter = str.ToString();
                }
                finally
                {
                    RemoveReference(setup);
                    setup = null;
                }
            }
            finally
            {
                RemoveReference(sheet);
                sheet = null;
            }

            return true;

    }

private void RemoveReference(object o)
    {
        try
        {
            System.Runtime.InteropServices.Marshal.ReleaseComObject(o);
        }
        catch
        { }
        finally
        {
            o = null;
        }
    }

private List<DataTable> getMovieTables()
    {
        List<DataTable> movieTables = new List<DataTable>();
        var connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excelFilePath + ";Extended Properties=\"Excel 12.0;IMEX=1;HDR=NO;TypeGuessRows=0;ImportMixedTypes=Text\""; ;
        using (var conn = new OleDbConnection(connectionString))
        {
            conn.open();

            DaTarowCollection sheets = conn.GetoleDbSchemaTable(OleDbSchemaGuid.Tables,new object[] { null,null,"TABLE" }).Rows;

            foreach (DaTarow sheet in sheets)
            {

                using (var cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "SELECT * FROM [" + sheet["TABLE_NAME"].ToString() + "] ";

                    var adapter = new OleDbDataAdapter(cmd);
                    var ds = new DataSet();
                    try
                    {
                        adapter.Fill(ds);
                        movieTables.Add(ds.Tables[0]);
                    }
                    catch (Exception ex)
                    {
                        //Debug.WriteLine(ex.ToString());
                        continue;
                    }
                }
            }
        }
        return movieTables;
    }

import groovy.sql.sql

import spock.lang.*

class DatabaseDriven extends Specification {
  @Shared sql = sql.newInstance("jdbc:h2:mem:","org.h2.Driver")

  // normally an external database would be used,// and the test data wouldn't have to be inserted here
  def setupSpec() {
    sql.execute("create table maxdata (id int primary key,a int,b int,c int)")
    sql.execute("insert into maxdata values (1,3,7,7),(2,5,4,5),(3,9,9)")
  }

  def "maximum of two numbers"() {
    expect:
    Math.max(a,b) == c

    where:
    [a,b,c] << sql.rows("select a,c from maxdata")
  }
}

解决方法

new ExcelBuilder("customers.xls").eachLine([labels:true]) {
  new Person(name:"$firstname $lastname",address:address,telephone:phone).save()
}

   
   

 
    
    
 
    
    import
 
    
     java.io.File;


 
    
    import
 
    
     jxl.Cell;

 
    
    import
 
    
     jxl.Sheet;

 
    
    import
 
    
     jxl.Workbook;


 
    
    public
 
    
     
 
    
    class
 
    
     ReadFromExcel {
    
 
    
    public
 
    
     
 
    
    static
 
    
     
 
    
    void
 
    
     main(String args[]) {
        
 
    
    try
 
    
     {
            Workbook book 
 
    
    =
 
    
     Workbook.getWorkbook(
 
    
    new
 
    
     File(
 
    
    "
 
    
    read.xls
 
    
    "
 
    
    ));
            
 
    
    //
 
    
     获得第1个工作表对象
 
    
    

 
    
                Sheet sheet 
 
    
    =
 
    
     book.getSheet(
 
    
    0
 
    
    );
            
 
    
    //
 
    
     得到第1列第1行的单元格
 
    
    

 
    
                Cell cell1 
 
    
    =
 
    
     sheet.getCell(
 
    
    0
 
    
    , 
 
    
    0
 
    
    );
            
 
    
    //
 
    
     得到第2列第1行的单元格
 
    
    

 
    
                Cell cell2 
 
    
    =
 
    
     sheet.getCell(
 
    
    1
 
    
    , 
 
    
    0
 
    
    );
            
 
    
    int
 
    
     rows 
 
    
    =
 
    
     sheet.getRows();
            
 
    
    int
 
    
     counter 
 
    
    =
 
    
     
 
    
    0
 
    
    ;
            
 
    
    for
 
    
     (
 
    
    int
 
    
     i 
 
    
    =
 
    
     
 
    
    0
 
    
    ; i 
 
    
    <
 
    
     rows; i
 
    
    ++
 
    
    ) {
                cell1 
 
    
    =
 
    
     sheet.getCell(
 
    
    0
 
    
    , i);
                
 
    
    for
 
    
     (
 
    
    int
 
    
     j 
 
    
    =
 
    
     
 
    
    0
 
    
    ; j 
 
    
    <
 
    
     rows; j
 
    
    ++
 
    
    ) {
                    cell2 
 
    
    =
 
    
     sheet.getCell(
 
    
    1
 
    
    , j);
                    
 
    
    if
 
    
     (cell1.getContents().equals(cell2.getContents())) {
                        System.out.println(cell2.getContents());
                        counter
 
    
    ++
 
    
    ;
                    }
                }
            }
            System.out.println(
 
    
    "
 
    
    counter=
 
    
    "
 
    
     
 
    
    +
 
    
     counter);
            book.close();
        } 
 
    
    catch
 
    
     (Exception e) {
            System.out.println(e);
        }
    }
}

   
   

   
   

 
    
    
 
    
    import
 
    
     java.io.File;


 
    
    import
 
    
     jxl.Workbook;

 
    
    import
 
    
     jxl.write.Label;

 
    
    import
 
    
     jxl.write.WritableSheet;

 
    
    import
 
    
     jxl.write.WritableWorkbook;


 
    
    public
 
    
     
 
    
    class
 
    
     WriteToExcel {
    
 
    
    public
 
    
     
 
    
    static
 
    
     
 
    
    void
 
    
     main(String args[]) {
        
 
    
    try
 
    
     {
            WritableWorkbook wbook 
 
    
    =
 
    
     Workbook.createWorkbook(
 
    
    new
 
    
     File(
                    
 
    
    "
 
    
    write.xls
 
    
    "
 
    
    ));
            WritableSheet wsheet 
 
    
    =
 
    
     wbook.createSheet(
 
    
    "
 
    
     第一页 
 
    
    "
 
    
    , 
 
    
    0
 
    
    );
            
 
    
    //
 
    
    在第1行第1列添加“00”
 
    
    

 
    
                wsheet.addCell(
 
    
    new
 
    
     Label(
 
    
    0
 
    
    , 
 
    
    0
 
    
    , 
 
    
    "
 
    
    00
 
    
    "
 
    
    ));
            
 
    
    //
 
    
    在第1行第2列添加“10”
 
    
    

 
    
                wsheet.addCell(
 
    
    new
 
    
     Label(
 
    
    1
 
    
    , 
 
    
    0
 
    
    , 
 
    
    "
 
    
    10
 
    
    "
 
    
    ));
            wbook.write();
            wbook.close();
        } 
 
    
    catch
 
    
     (Exception e) {
            System.out.println(e);
        }
    }
}

   
   

   
   

 
    
    
 
    
    import
 
    
     java.io.File;


 
    
    import
 
    
     jxl.Cell;

 
    
    import
 
    
     jxl.Sheet;

 
    
    import
 
    
     jxl.Workbook;

 
    
    import
 
    
     jxl.write.Label;

 
    
    import
 
    
     jxl.write.WritableSheet;

 
    
    import
 
    
     jxl.write.WritableWorkbook;


 
    
    public
 
    
     
 
    
    class
 
    
     EqualMerge {
    
 
    
    public
 
    
     
 
    
    static
 
    
     
 
    
    void
 
    
     main(String args[]) {
        
 
    
    try
 
    
     {
            WritableWorkbook toBook 
 
    
    =
 
    
     Workbook.createWorkbook(
 
    
    new
 
    
     File(
                    
 
    
    "
 
    
    result.xls
 
    
    "
 
    
    ));
            WritableSheet toSheet 
 
    
    =
 
    
     toBook.createSheet(
 
    
    "
 
    
     第一页 
 
    
    "
 
    
    , 
 
    
    0
 
    
    );
            Workbook fromBook 
 
    
    =
 
    
     Workbook.getWorkbook(
 
    
    new
 
    
     File(
 
    
    "
 
    
    test.xls
 
    
    "
 
    
    ));
            Sheet sheet 
 
    
    =
 
    
     fromBook.getSheet(
 
    
    0
 
    
    );
            Cell cell1;
            Cell cell2;
            
 
    
    int
 
    
     rows 
 
    
    =
 
    
     sheet.getRows();
            
 
    
    int
 
    
     counter 
 
    
    =
 
    
     
 
    
    0
 
    
    ;
            
 
    
    for
 
    
     (
 
    
    int
 
    
     i 
 
    
    =
 
    
     
 
    
    0
 
    
    ; i 
 
    
    <
 
    
     rows; i
 
    
    ++
 
    
    ) {
                cell1 
 
    
    =
 
    
     sheet.getCell(
 
    
    0
 
    
    , i);
                
 
    
    for
 
    
     (
 
    
    int
 
    
     j 
 
    
    =
 
    
     
 
    
    0
 
    
    ; j 
 
    
    <
 
    
     rows; j
 
    
    ++
 
    
    ) {
                    cell2 
 
    
    =
 
    
     sheet.getCell(
 
    
    1
 
    
    , j);
                    
 
    
    if
 
    
     (cell1.getContents().equals(cell2.getContents())) {
                        System.out.println(cell2.getContents());
                        toSheet.addCell(
 
    
    new
 
    
     Label(
 
    
    0
 
    
    , counter, cell2
                                .getContents()));
                        counter
 
    
    ++
 
    
    ;
                    }
                }
            }
            toBook.write();
            fromBook.close();
            toBook.close();
        } 
 
    
    catch
 
    
     (Exception e) {
            System.out.println(e);
        }
    }
}

   
   

    package module.system.common;  
      
    import java.io.File;  
    import java.io.FileInputStream;  
    import java.io.FileNotFoundException;  
    import java.io.FileOutputStream;  
    import java.io.IOException;  
    import java.lang.reflect.Field;  
    import java.lang.reflect.Method;  
    import java.util.ArrayList;  
    import java.util.List;  
      
    import org.apache.poi.hssf.usermodel.hssfRow;  
    import org.apache.poi.hssf.usermodel.hssfSheet;  
    import org.apache.poi.hssf.usermodel.hssfWorkbook;  
    import org.apache.poi.poifs.filesystem.POIFSFileSystem;  
    import org.apache.poi.ss.usermodel.Cell;  
    import org.apache.poi.ss.usermodel.Row;  
    import org.apache.poi.ss.usermodel.Sheet;  
      
    /** 
     * 从excel读取数据/往excel中写入 excel有表头，表头每列的内容对应实体类的属性 
     *  
     * @author nagsh 
     *  
     */  
    public class ExcelManage {  
        private hssfWorkbook workbook = null;  
          
        /** 
         * 判断文件是否存在. 
         * @param fileDir  文件路径 
         * @return 
         */  
        public boolean fileExist(String fileDir){  
             boolean flag = false;  
             File file = new File(fileDir);  
             flag = file.exists();  
             return flag;  
        }  
        /** 
         * 判断文件的sheet是否存在. 
         * @param fileDir   文件路径 
         * @param sheetName  表格索引名 
         * @return 
         */  
        public boolean sheetExist(String fileDir,String sheetName){  
             boolean flag = false;  
             File file = new File(fileDir);  
             if(file.exists()){    //文件存在  
                //创建workbook  
                 try {  
                    workbook = new hssfWorkbook(new FileInputStream(file));  
                    //添加Worksheet（不添加sheet时生成的xls文件打开时会报错)  
                    hssfSheet sheet = workbook.getSheet(sheetName);    
                    if(sheet!=null)  
                        flag = true;  
                } catch (Exception e) {  
                    e.printstacktrace();  
                }   
                  
             }else{    //文件不存在  
                 flag = false;  
             }  
               
             return flag;  
        }  
        /** 
         * 创建新excel. 
         * @param fileDir  excel的路径 
         * @param sheetName 要创建的表格索引 
         * @param titleRow excel的第一行即表格头 
         */  
        public void createExcel(String fileDir,String sheetName,String titleRow[]){  
            //创建workbook  
            workbook = new hssfWorkbook();  
            //添加Worksheet（不添加sheet时生成的xls文件打开时会报错)  
            Sheet sheet1 = workbook.createSheet(sheetName);    
            //新建文件  
            FileOutputStream out = null;  
            try {  
                //添加表头  
                Row row = workbook.getSheet(sheetName).createRow(0);    //创建第一行    
                for(int i = 0;i < titleRow.length;i++){  
                    Cell cell = row.createCell(i);  
                    cell.setCellValue(titleRow[i]);  
                }  
                  
                out = new FileOutputStream(fileDir);  
                workbook.write(out);  
            } catch (Exception e) {  
                e.printstacktrace();  
            } finally {    
                try {    
                    out.close();    
                } catch (IOException e) {    
                    e.printstacktrace();  
                }    
            }    
          
      
        }  
        /** 
         * 删除文件. 
         * @param fileDir  文件路径 
         */  
        public boolean deleteExcel(String fileDir){  
            boolean flag = false;  
            File file = new File(fileDir);  
            // 判断目录或文件是否存在    
            if (!file.exists()) {  // 不存在返回 false    
                return flag;    
            } else {    
                // 判断是否为文件    
                if (file.isFile()) {  // 为文件时调用删除文件方法    
                    file.delete();  
                    flag = true;  
                }   
            }  
            return flag;  
        }  
        /** 
         * 往excel中写入(已存在的数据无法写入). 
         * @param fileDir    文件路径 
         * @param sheetName  表格索引 
         * @param object 
         */  
        public void writetoExcel(String fileDir,Object object){  
            //创建workbook  
            File file = new File(fileDir);  
            try {  
                workbook = new hssfWorkbook(new FileInputStream(file));  
            } catch (FileNotFoundException e) {  
                e.printstacktrace();  
            } catch (IOException e) {  
                e.printstacktrace();  
            }  
            //流  
            FileOutputStream out = null;  
            hssfSheet sheet = workbook.getSheet(sheetName);  
            // 获取表格的总行数  
            int rowCount = sheet.getLastRowNum() + 1; // 需要加一  
            // 获取表头的列数  
            int columnCount = sheet.getRow(0).getLastCellNum();  
            try {  
                Row row = sheet.createRow(rowCount);     //最新要添加的一行  
                //通过反射获得object的字段,对应表头插入  
                // 获取该对象的class对象  
                Class class_ = object.getClass();  
                // 获得表头行对象  
                hssfRow titleRow = sheet.getRow(0);  
                if(titleRow!=null){  
                    for (int columnIndex = 0; columnIndex < columnCount; columnIndex++) {  //遍历表头  
                        String title = titleRow.getCell(columnIndex).toString().trim().toString().trim();  
                        String UTitle = Character.toupperCase(title.charat(0))+ title.substring(1,title.length()); // 使其首字母大写;  
                        String methodName  = "get"+UTitle;  
                        Method method = class_.getDeclaredMethod(methodName); // 设置要执行的方法  
                        String data = method.invoke(object).toString(); // 执行该get方法,即要插入的数据  
                        Cell cell = row.createCell(columnIndex);  
                        cell.setCellValue(data);  
                    }  
                }  
      
                out = new FileOutputStream(fileDir);  
                workbook.write(out);  
            } catch (Exception e) {  
                e.printstacktrace();  
            } finally {    
                try {    
                    out.close();    
                } catch (IOException e) {    
                    e.printstacktrace();  
                }    
            }    
        }  
        /** 
         * 读取excel表中的数据. 
         *  
         * @param fileDir    文件路径    
         * @param sheetName 表格索引(EXCEL 是多表文档,所以需要输入表索引号，如sheet1) 
         * @param object   object 
         */  
        public List readFromExcel(String fileDir,Object object) {  
            //创建workbook  
            File file = new File(fileDir);  
            try {  
                workbook = new hssfWorkbook(new FileInputStream(file));  
            } catch (FileNotFoundException e) {  
                e.printstacktrace();  
            } catch (IOException e) {  
                e.printstacktrace();  
            }  
      
            List result = new ArrayList();  
            // 获取该对象的class对象  
            Class class_ = object.getClass();  
            // 获得该类的所有属性  
            Field[] fields = class_.getDeclaredFields();  
      
            // 读取excel数据  
            // 获得指定的excel表  
            hssfSheet sheet = workbook.getSheet(sheetName);  
            // 获取表格的总行数  
            int rowCount = sheet.getLastRowNum() + 1; // 需要加一  
            System.out.println("rowCount:"+rowCount);  
            if (rowCount < 1) {  
                return result;  
            }  
            // 获取表头的列数  
            int columnCount = sheet.getRow(0).getLastCellNum();  
            // 读取表头信息,确定需要用的方法名---set方法  
            // 用于存储方法名  
            String[] methodNames = new String[columnCount]; // 表头列数即为需要的set方法个数  
            // 用于存储属性类型  
            String[] fieldTypes = new String[columnCount];  
            // 获得表头行对象  
            hssfRow titleRow = sheet.getRow(0);  
            // 遍历  
            for (int columnIndex = 0; columnIndex < columnCount; columnIndex++) { // 遍历表头列  
                String data = titleRow.getCell(columnIndex).toString(); // 某一列的内容  
                String Udata = Character.toupperCase(data.charat(0))  
                        + data.substring(1,data.length()); // 使其首字母大写  
                methodNames[columnIndex] = "set" + Udata;  
                for (int i = 0; i < fields.length; i++) { // 遍历属性数组  
                    if (data.equals(fields[i].getName())) { // 属性与表头相等  
                        fieldTypes[columnIndex] = fields[i].getType().getName(); // 将属性类型放到数组中  
                    }  
                }  
            }  
            // 逐行读取数据 从1开始 忽略表头  
            for (int rowIndex = 1; rowIndex < rowCount; rowIndex++) {  
                // 获得行对象  
                hssfRow row = sheet.getRow(rowIndex);  
                if (row != null) {  
                    Object obj = null;  
                    // 实例化该泛型类的对象一个对象  
                    try {  
                        obj = class_.newInstance();  
                    } catch (Exception e1) {  
                        e1.printstacktrace();  
                    }  
      
                    // 获得本行中各单元格中的数据  
                    for (int columnIndex = 0; columnIndex < columnCount; columnIndex++) {  
                        String data = row.getCell(columnIndex).toString();  
                        // 获取要调用方法的方法名  
                        String methodName = methodNames[columnIndex];  
                        Method method = null;  
                        try {  
                            // 这部分可自己扩展  
                            if (fieldTypes[columnIndex].equals("java.lang.String")) {  
                                method = class_.getDeclaredMethod(methodName,String.class); // 设置要执行的方法--set方法参数为String  
                                method.invoke(obj,data); // 执行该方法  
                            } else if (fieldTypes[columnIndex].equals("int")) {  
                                method = class_.getDeclaredMethod(methodName,int.class); // 设置要执行的方法--set方法参数为int  
                                double data_double = Double.parseDouble(data);  
                                int data_int = (int) data_double;  
                                method.invoke(obj,data_int); // 执行该方法  
                            }  
                        } catch (Exception e) {  
                            e.printstacktrace();  
                        }  
                    }  
                    result.add(obj);  
                }  
            }  
            return result;  
        }  
          
          
        public static void main(String[] args) {  
            ExcelManage em = new ExcelManage();  
            //判断文件是否存在  
            System.out.println(em.fileExist("E:/test2.xls"));  
            //创建文件  
            String title[] = {"id","name","password"};  
            em.createExcel("E:/test2.xls","sheet1",title);  
            //判断sheet是否存在  
            System.out.println(em.sheetExist("E:/test2.xls","sheet1"));  
            //写入到excel  
            User user = new User();  
            user.setId(5);  
            user.setName("qwer");  
            user.setPassword("zxcv");  
            User user3 = new User();  
            user3.setId(6);  
            user3.setName("qwerwww");  
            user3.setPassword("zxcvwww");  
            em.writetoExcel("E:/test2.xls",user);  
            em.writetoExcel("E:/test2.xls",user3);  
            //读取excel  
            User user2 = new User();  
            List list = em.readFromExcel("E:/test2.xls",user2);  
            for (int i = 0; i < list.size(); i++) {  
                User newUser = (User) list.get(i);  
                System.out.println(newUser.getId() + " " + newUser.getName() + " "  
                        + newUser.getpassword());  
            }  
            //删除文件  
            //System.out.println(em.deleteExcel("E:/test2.xls"));  
        }  
      
    }  

    package module.system.common;  
      
    public class User {  
        private int id;  
        private String name;  
        private String password;  
      
        public int getId() {  
            return id;  
        }  
      
        public void setId(int id) {  
            this.id = id;  
        }  
      
        public String getName() {  
            return name;  
        }  
      
        public void setName(String name) {  
            this.name = name;  
        }  
      
        public String getpassword() {  
            return password;  
        }  
      
        public void setPassword(String password) {  
            this.password = password;  
        }  
      
    }  

DateUtils.getRelativeDateTimeString(context,due,DateUtils.MINUTE_IN_MILLIS,DateUtils.WEEK_IN_MILLIS,0)

in 23 hours,6:18am

解决方法

DateUtils.getRelativeTimeSpanString(due,Now,DateUtils.SECOND_IN_MILLIS)

package liudeli.mynetwork01.utils;

import android.util.Log;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.Locale;
import java.util.TimeZone;

/**
 * @Author Liudeli
 * @Describe：时间相关工具类
 */
public class DateTimeAndroidUtil {

    private DateTimeAndroidUtil(){}

    /**
     * 枚举日期格式
     */
    public enum DatePattern{
        /**
         * 格式："yyyy-MM-dd HH:mm:ss"
         */
        ALL_TIME{public String getValue(){return "yyyy-MM-dd HH:mm:ss";}},
        /**
         * 格式："yyyy-MM"
         */
        ONLY_MONTH{public String getValue(){return "yyyy-MM";}},
        /**
         * 格式："yyyy-MM-dd"
         */
        ONLY_DAY{public String getValue(){return "yyyy-MM-dd";}},
        /**
         * 格式："yyyy-MM-dd HH"
         */
        ONLY_HOUR{public String getValue(){return "yyyy-MM-dd HH";}},
        /**
         * 格式："yyyy-MM-dd HH:mm"
         */
        ONLY_MINUTE{public String getValue(){return "yyyy-MM-dd HH:mm";}},
        /**
         * 格式："MM-dd"
         */
        ONLY_MONTH_DAY{public String getValue(){return "MM-dd";}},
        /**
         * 格式："MM-dd HH:mm"
         */
        ONLY_MONTH_SEC{public String getValue(){return "MM-dd HH:mm";}},
        /**
         * 格式："HH:mm:ss"
         */
        ONLY_TIME{public String getValue(){return "HH:mm:ss";}},
        /**
         * 格式："HH:mm"
         */
        ONLY_HOUR_MINUTE{public String getValue(){return "HH:mm";}};
        public abstract String getValue();
    }

    /**
     * 获取当前时间
     * @return    返回当前时间，格式2017-05-04    10:54:21
     */
    public static String getNowDate(DatePattern pattern){
        String dateString = null;
        Calendar calendar = Calendar.getInstance();
        Date dateNow = calendar.getTime();
        SimpleDateFormat sdf = new SimpleDateFormat(pattern.getValue(),Locale.CHINA);
        dateString = sdf.format(dateNow);
        return dateString;
    }

    /**
     * 将一个日期字符串转换成Data对象
     * @param dateString    日期字符串
     * @param pattern        转换格式
     * @return    返回转换后的日期对象
     */
    public static Date stringToDate(String dateString, DatePattern pattern){
        Date date = null;
        SimpleDateFormat sdf = new SimpleDateFormat(pattern.getValue(),Locale.CHINA);
        try {
            date = sdf.parse(dateString);
        } catch (ParseException e) {
            e.printStackTrace();
        }
        return date;
    }

    /**
     * 将date转换成字符串
     * @param date    日期
     * @param pattern    日期的目标格式
     * @return
     */
    public static String dateToString(Date date, DatePattern pattern){
        String string = "";
        SimpleDateFormat sdf = new SimpleDateFormat(pattern.getValue(), Locale.CHINA);
        string = sdf.format(date);
        return string;
    }

    /**
     * 获取指定日期周几
     * @param date    指定日期
     * @return
     * 返回值为： "周日", "周一", "周二", "周三", "周四", "周五", "周六"
     */
    public static String getWeekOfDate(Date date){
        String[] weekDays = { "周日", "周一", "周二", "周三", "周四", "周五", "周六" };
        Calendar calendar = Calendar.getInstance();
        calendar.setTime(date);
        int week = calendar.get(Calendar.DAY_OF_WEEK) - 1;
        if (week < 0)
            week = 0;
        return weekDays[week];
    }

    /**
     * 获取指定日期对应周几的序列
     * @param date    指定日期
     * @return    周一：1    周二：2    周三：3    周四：4    周五：5    周六：6    周日：7
     */
    public static int getIndexWeekOfDate(Date date){
        Calendar calendar = Calendar.getInstance();
        calendar.setTime(date);
        int index = calendar.get(Calendar.DAY_OF_WEEK);
        if(index == 1){
            return 7;
        }else{
            return --index;
        }
    }

    /**
     * 返回当前月份
     * @return
     */
    public static int getNowMonth(){
        Calendar calendar = Calendar.getInstance();
        return calendar.get(Calendar.MONTH) + 1;
    }

    /**
     * 获取当前月号
     * @return
     */
    public static int getNowDay(){
        Calendar calendar = Calendar.getInstance();
        return calendar.get(Calendar.DATE);
    }

    /**
     * 获取当前年份
     * @return
     */
    public static int getNowYear(){
        Calendar calendar = Calendar.getInstance();
        return calendar.get(Calendar.YEAR);
    }

    /**
     * 获取本月份的天数
     * @return
     */
    public static int getNowDaysOfMonth(){
        Calendar calendar = Calendar.getInstance();
        return daysOfMonth(calendar.get(Calendar.YEAR),calendar.get(Calendar.DATE) + 1);
    }

    /**
     * 获取指定月份的天数
     * @param year    年份
     * @param month    月份
     * @return    对应天数
     */
    public static int daysOfMonth(int year,int month){
        switch(month){
            case 1:
            case 3:
            case 5:
            case 7:
            case 8:
            case 10:
            case 12:
                return 31;
            case 4:
            case 6:
            case 9:
            case 11:
                return 30;
            case 2:
                if((year % 4 ==0 && year % 100 == 0) || year % 400 != 0){
                    return 29;
                }else{
                    return 28;
                }
            default:
                return -1;
        }
    }

    /**
     * 获取当前时间
     * @return
     */
    public static String getNowTime(){
        SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        Date date = new Date(System.currentTimeMillis());
        return simpleDateFormat.format(date);
    }

    /**
     * 获取当前时间
     * @return
     */
    public static String getThisTiem() {
        SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy年MM月dd日 HH:mm:ss");// HH:mm:ss
        // 获取当前时间
        Date date = new Date(System.currentTimeMillis());
        return simpleDateFormat.format(date);
    }

    /**
     * 获取时间戳
     *
     * @return 获取时间戳
     */
    public static String getTimeString() {
        SimpleDateFormat df = new SimpleDateFormat("yyyy年MM月dd日 HH:mm:ss");
        Calendar calendar = Calendar.getInstance();
        return df.format(calendar.getTime());
    }

    /**
     * 获取时间戳
     *
     * @return 获取时间戳
     */
    public static String getTimeString2() {
        SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        Calendar calendar = Calendar.getInstance();
        return df.format(calendar.getTime());
    }

    /**
     * 时间转换为时间戳
     * @param time:需要转换的时间
     * @return
     */
    public static String dateToStamp(String time)  {
        SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        Date date = null;
        try {
            date = simpleDateFormat.parse(time);
        } catch (ParseException e) {
            e.printStackTrace();
        }
        long ts = date.getTime();
        return String.valueOf(ts);
    }

    /**
     * 时间戳转换为字符串
     * @param time:时间戳
     * @return
     */
    public static String times(String time) {
        SimpleDateFormat sdr = new SimpleDateFormat("yyyy年MM月dd日 HH时mm分");
        @SuppressWarnings("unused")
        long lcc = Long.valueOf(time);
        int i = Integer.parseInt(time);
        String times = sdr.format(new Date(i * 1000L));
        return times;

    }
    /**
     *获取距现在某一小时的时刻
     * @param hour hour=-1为上一个小时，hour=1为下一个小时
     * @return
     */
    public static String getLongTime(int hour){
        Calendar c = Calendar.getInstance(); // 当时的日期和时间
        int h; // 需要更改的小时
        h = c.get(Calendar.HOUR_OF_DAY) - hour;
        c.set(Calendar.HOUR_OF_DAY, h);
        SimpleDateFormat df = new SimpleDateFormat("yyyy年MM月dd日 HH:mm:ss");
        Log.v("time",df.format(c.getTime()));
        return df.format(c.getTime());
    }
    /**
     * 比较时间大小
     * @param str1：要比较的时间
     * @param str2：要比较的时间
     * @return
     */
    public static boolean isDateOneBigger(String str1, String str2) {
        boolean isBigger = false;
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy年MM月dd日 HH:mm:ss");
        Date dt1 = null;
        Date dt2 = null;
        try {
            dt1 = sdf.parse(str1);
            dt2 = sdf.parse(str2);
        } catch (ParseException e) {
            e.printStackTrace();
        }
        if (dt1.getTime() > dt2.getTime()) {
            isBigger = true;
        } else if (dt1.getTime() < dt2.getTime()) {
            isBigger = false;
        }
        return isBigger;
    }

    /**
     * 当地时间 ---> UTC时间
     * @return
     */
    public static String Local2UTC(){
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        sdf.setTimeZone(TimeZone.getTimeZone("gmt"));
        String gmtTime = sdf.format(new Date());
        return gmtTime;
    }

    /**
     * UTC时间 ---> 当地时间
     * @param utcTime   UTC时间
     * @return
     */
    public static String utc2Local(String utcTime) {
        SimpleDateFormat utcFormater = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//UTC时间格式
        utcFormater.setTimeZone(TimeZone.getTimeZone("UTC"));
        Date gpsUTCDate = null;
        try {
            gpsUTCDate = utcFormater.parse(utcTime);
        } catch (ParseException e) {
            e.printStackTrace();
        }
        SimpleDateFormat localFormater = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//当地时间格式
        localFormater.setTimeZone(TimeZone.getDefault());
        String localTime = localFormater.format(gpsUTCDate.getTime());
        return localTime;
    }
}

解决方法

mMarker.setPosition(new LatLng(member.getLatitude(),member.getLongitude()));

01-13 18:52:38.118: E/AndroidRuntime(7605): FATAL EXCEPTION: IntentService[GCMIntentService-1041237551356-1]
    01-13 18:52:38.118: E/AndroidRuntime(7605): java.lang.IllegalStateException: Not on the main thread
    01-13 18:52:38.118: E/AndroidRuntime(7605):     at maps.am.r.b(UnkNown Source)
    01-13 18:52:38.118: E/AndroidRuntime(7605):     at maps.ar.d.b(UnkNown Source)
    01-13 18:52:38.118: E/AndroidRuntime(7605):     at maps.y.ae.addMarker(UnkNown Source)
    01-13 18:52:38.118: E/AndroidRuntime(7605):     at com.google.android.gms.maps.internal.IGoogleMapDelegate$Stub.onTransact(IGoogleMapDelegate.java:167)
    01-13 18:52:38.118: E/AndroidRuntime(7605):     at android.os.Binder.transact(Binder.java:279)
    01-13 18:52:38.118: E/AndroidRuntime(7605):     at com.google.android.gms.maps.internal.IGoogleMapDelegate$a$a.addMarker(UnkNown Source)
    01-13 18:52:38.118: E/AndroidRuntime(7605):     at com.google.android.gms.maps.GoogleMap.addMarker(UnkNown Source)
    01-13 18:52:38.118: E/AndroidRuntime(7605):     at com.example.MapViewActivity.showMember(MapViewActivity.java:529)
    01-13 18:52:38.118: E/AndroidRuntime(7605):     at com.example.MapViewActivity.updateMember(MapViewActivity.java:417)
    01-13 18:52:38.118: E/AndroidRuntime(7605):     at com.example.MapViewActivity.updateMembers(MapViewActivity.java:410)
    01-13 18:52:38.118: E/AndroidRuntime(7605):     at com.example.pushnotifications.GCMIntentService.onMessage(GCMIntentService.java:75)
    01-13 18:52:38.118: E/AndroidRuntime(7605):     at com.google.android.gcm.GCMBaseIntentService.onHandleIntent(GCMBaseIntentService.java:223)
    01-13 18:52:38.118: E/AndroidRuntime(7605):     at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:59)
    01-13 18:52:38.118: E/AndroidRuntime(7605):     at android.os.Handler.dispatchMessage(Handler.java:99)
    01-13 18:52:38.118: E/AndroidRuntime(7605):     at android.os.Looper.loop(Looper.java:130)
    01-13 18:52:38.118: E/AndroidRuntime(7605):     at android.os.HandlerThread.run(HandlerThread.java:60)

private Thread MarkerUpdater = new Thread(
    new Runnable() {
        public void run() {
            while(true) {
                updateMembers();
                try {
                    Thread.sleep(1000);
                } catch (InterruptedException e) {
                    // Todo Auto-generated catch block
                    e.printstacktrace();
                }
            }
        }
    });

解决方法

Handler handler = new Handler(Looper.getMainLooper());
handler.post(new Runnable(){ 
   // your UI code here 
}