java mysql statment参数设置通用方法

   /**
       * 预处理设置参数
       * @param prepStatement
       * @param param
       * @param i
       */
      private static void stateSetValue(PreparedStatement prepStatement, Object param, int i){
    	 try{
    		 if(param == null){
    			 throw new Exception("stateSetValue null:" + i);
    		 }
    		 
    		 if (param instanceof Integer) {
    		    int value = ((Integer) param).intValue();
    		    prepStatement.setInt(i, value);
    		   } else if (param instanceof String) {
    		    String s = (String) param;
    		    prepStatement.setString(i, s);
    		   } else if (param instanceof Double) {
    		    double d = ((Double) param).doubleValue();
    		    prepStatement.setDouble(i, d);
    		   } else if (param instanceof Float) {
    		    float f = ((Float) param).floatValue();
    		    prepStatement.setFloat(i, f);
    		   } else if (param instanceof Long) {
    		    long l = ((Long) param).longValue();
    		    prepStatement.setLong(i, l);
    		   } else if (param instanceof Boolean) {
    		    boolean b = ((Boolean) param).booleanValue();
    		    prepStatement.setBoolean(i, b);
    		   } else if (param instanceof Date) {
    		    prepStatement.setDate(i, (Date) param);
    		   }else{
    			   throw new Exception("param:" + param);
    		   }
    	 }catch (Exception e) {
			Utils.printError(e);
		}
      }