public static void updateStyle ( ASpatialDb database , Style style ) throws Exception { StringBuilder sbIn = new StringBuilder ( ) ; sbIn . append ( "update " ) . append ( PROPERTIESTABLE ) ; sbIn . append ( " set " ) ; // sbIn.append(NAME).append("='").append(style.name).append("' , "); sbIn . append ( SIZE ) . append ( "=?," ) ; sbIn . append ( FILLCOLOR ) . append ( "=?," ) ; sbIn . append ( STROKECOLOR ) . append ( "=?," ) ; sbIn . append ( FILLALPHA ) . append ( "=?," ) ; sbIn . append ( STROKEALPHA ) . append ( "=?," ) ; sbIn . append ( SHAPE ) . append ( "=?," ) ; sbIn . append ( WIDTH ) . append ( "=?," ) ; sbIn . append ( LABELSIZE ) . append ( "=?," ) ; sbIn . append ( LABELFIELD ) . append ( "=?," ) ; sbIn . append ( LABELVISIBLE ) . append ( "=?," ) ; sbIn . append ( ENABLED ) . append ( "=?," ) ; sbIn . append ( ORDER ) . append ( "=?," ) ; sbIn . append ( DASH ) . append ( "=?," ) ; sbIn . append ( MINZOOM ) . append ( "=?," ) ; sbIn . append ( MAXZOOM ) . append ( "=?," ) ; sbIn . append ( DECIMATION ) . append ( "=?," ) ; sbIn . append ( THEME ) . append ( "=?" ) ; sbIn . append ( " where " ) ; sbIn . append ( NAME ) ; sbIn . append ( "='" ) ; sbIn . append ( style . name ) ; sbIn . append ( "';" ) ; Object [ ] objects = { style . size , style . fillcolor , style . strokecolor , style . fillalpha , style . strokealpha , style . shape , style . width , style . labelsize , style . labelfield , style . labelvisible , style . enabled , style . order , style . dashPattern , style . minZoom , style . maxZoom , style . decimationFactor , style . getTheme ( ) } ; String updateQuery = sbIn . toString ( ) ; database . executeInsertUpdateDeletePreparedSql ( updateQuery , objects ) ; }
Update a style definition .