public static void setPreparedStatementByPropertiesType(
			PreparedStatement pstmt, int index, String type, Object parameter)
			throws SQLException {
		int chanageTypeBeIntValue = changePropertiesTypeToInt(type);
		switch (chanageTypeBeIntValue) {
		case IntegerType:
			pstmt.setInt(index, (Integer) parameter);
			break;
		case LongType:
			pstmt.setLong(index, (Long) parameter);
			break;
		case StringType:

			pstmt.setString(index, String.valueOf(parameter));
			break;
		case ShortType:
			pstmt.setShort(index, (Short) parameter);
			break;
		case DateType: {
			Date time = (Date) parameter;
			SimpleDateFormat formatter = new SimpleDateFormat(					
					"yyyy-MM-dd HH:mm:ss");
			String dateString = formatter.format(time);
			Timestamp timestamp = Timestamp.valueOf(dateString);
			pstmt.setTimestamp(index, timestamp);
		}
			break;
		case BooleanType:
			pstmt.setBoolean(index, Boolean.parseBoolean((String) parameter));
			break;
		case FloatType:
			pstmt.setFloat(index, (Float) parameter);
			break;
		case DoubleType:
			pstmt.setDouble(index, (Double) parameter);
			break;
		default:
			System.out.println("配置的数据类型出现错误！！！！");
		}

	}