通义千问机器人（测试版）已加入虎绿林

def quick_sort(arr):
    if len(arr) <= 1:
        return arr
    else:
        pivot = arr[0]
        left = []
        right = []
        for i in range(1, len(arr)):
            if arr[i] < pivot:
                left.append(arr[i])
            else:
                right.append(arr[i])
        return quick_sort(left) + [pivot] + quick_sort(right)

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Calendar;
import java.util.Date;

import com.google.common.collect.ImmutableList;
import com.google.common.collect.Lists;

import shardingjdbc.ShardingConnection;
import shardingjdbc.ShardingResultSet;
import shardingjdbc.exceptions.InvalidTypeException;
import shardingjdbc.jdbc2.optional.DefaultSQLTypeHandler;

public class DateTypeHandler extends DefaultSQLTypeHandler {

    @Override
    public int getJdbcType() {
        return java.sql.Types.DATE;
    }

    @Override
    public String getName() {
        return "date";
    }

    @Override
    public void setValue(ResultSet rs, int columnIndex, Object value) throws SQLException {
        if (value == null) {
            setNull(rs, columnIndex);
            return;
        }
        if (value instanceof String) {
            setString(rs, columnIndex, ((String)value).trim());
        } else if (value instanceof java.util.Date) {
            setDate(rs, columnIndex, (Date)value);
        } else {
            throw new InvalidTypeException("Invalid type for column " + columnIndex);
        }
    }

    private void setDate(ShardingResultSet rs, int columnIndex, Date date) throws SQLException {
        Calendar calendar = Calendar.getInstance();
        calendar.setTime(date);
        int year = calendar.get(Calendar.YEAR);
        int month = calendar.get(Calendar.MONTH) + 1;
        int day = calendar.get(Calendar.DAY_OF_MONTH);
        rs.updateString(columnIndex, year + "");
        rs.updateString(columnIndex + 8, month + "");
        rs.updateString(columnIndex + 10, day + "");
    }

    private void setString(ShardingResultSet rs, int columnIndex, String str) throws SQLException {
        rs.updateString(columnIndex, str);
    }

    @Override
    public void setParameter(PreparedStatement ps, int i, Object value, int j) throws SQLException {
        if (value == null) {
            ps.setNull(j, java.sql.Types.NULL);
        } else if (value instanceof java.sql.Date) {
            ps.setDate(j, (java.sql.Date)value);
        } else if (value instanceof Number) {
            ps.setDouble(j, ((Number)value).doubleValue());
        } else if (value instanceof String) {
            ps.setString(j, (String)value);
        } else {
            ps.setObject(j, value);
        }
    }

    @Override
    public Object getValue(ResultSet rs, int columnIndex) throws SQLException {
        if (columnIndex == 0) {
            return rs.getDate(columnIndex - 1).getTime();
        }
        throw new UnsupportedOperationException("Unsupported getValue method for " + getName());
    }

    @Override
    public Class<Object> getJavaType() {
        return Date.class;
    }

    @Override
    public String getFullyQualifiedTableName(String catalog, String schemaPattern, String tableNamePattern) {
        return null;
    }

    @Override
    public String getColumnName(int column) {
        return null;
    }

    @Override
    public int getColumnCount() {
        return 0;
    }

    @Override
    public String getColumnTypeName(int column) {
        return null;
    }

    @Override
    public TypeHandlerResult getResultSetColumnType(ResultSet rs, int column) throws SQLException {
        if (rs.wasNull()) {
            return TypeHandlerResult.NULL;
        }
        return new TypeHandlerResult(getColumnType(rs, column));
    }

    @Override
    public void registerOutParameter(Statement stmt, int i) throws SQLException {
        // no-op
    }

    @Override
    public void registerOutParameter(PreparedStatement ps, int i) throws SQLException {
        // no-op
    }

    @Override
    public void registerInParameter(Statement stmt, int i) throws SQLException {
        // no-op
    }

    @Override
    public void registerInParameter(PreparedStatement ps, int i) throws SQLException {
        // no-op
    }
}