# course

**Repository Path**: dream-flight/course

## Basic Information

- **Project Name**: course
- **Description**: 基于Spring Boot + Vue开发课程管理系统
- **Primary Language**: Unknown
- **License**: MulanPSL-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 1
- **Created**: 2021-11-25
- **Last Updated**: 2023-07-14

## Categories & Tags

**Categories**: Uncategorized

**Tags**: SpringCloud, SpringBoot, SSM

## README

```java
package com.zrkizzy.common.handler;

import com.zrkizzy.common.enums.DemoEnum;
import org.apache.ibatis.type.BaseTypeHandler;
import org.apache.ibatis.type.JdbcType;

import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Hashtable;

public class EnumHandler<E extends DemoEnum> extends BaseTypeHandler<E> {
    private Class<E> type;
    private final Hashtable<String, E> enums;

    public EnumHandler(Class<E> type) {
        this.type = type;
        E[] enums1 = type.getEnumConstants();

        enums = new Hashtable<String, E>();
        for (E e : enums1) {
            enums.put(e.getValue(), e);
        }

    }

    @Override
    public void setNonNullParameter(PreparedStatement ps, int i, E parameter, JdbcType jdbcType) throws SQLException {
        ps.setInt(i, parameter.ordinal());
    }

    @Override
    public E getNullableResult(ResultSet rs, String columnName) throws SQLException {
        String i = rs.getString(columnName);
        return enums.get(i);
    }

    @Override
    public E getNullableResult(ResultSet rs, int columnIndex) throws SQLException {
        int i = rs.getInt(columnIndex);
        return enums.get(i);
    }

    @Override
    public E getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
        int i = cs.getInt(columnIndex);
        return enums.get(i);
    }
}
```