12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
ADADADADAD
电脑知识 时间:2024-12-03 12:57:33
作者:文/会员上传
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
在MyBatis中处理数据库的枚举类型通常有两种方式:使用TypeHandler:MyBatis提供了TypeHandler接口,可以自定义处理数据库字段和Java对象之间的转换。可以实现自定义的TypeHandle
以下为本文的正文内容,内容仅供参考!本站为公益性网站,复制本文以及下载DOC文档全部免费。
在MyBatis中处理数据库的枚举类型通常有两种方式:
public class EnumTypeHandler<E extends Enum<E>> extends BaseTypeHandler<E> {private Class<E> type;public EnumTypeHandler(Class<E> type) {this.type = type;}@Overridepublic void setNonNullParameter(PreparedStatement ps, int i, E parameter, JdbcType jdbcType) throws SQLException {ps.setString(i, parameter.name());}@Overridepublic E getNullableResult(ResultSet rs, String columnName) throws SQLException {String value = rs.getString(columnName);return Enum.valueOf(type, value);}@Overridepublic E getNullableResult(ResultSet rs, int columnIndex) throws SQLException {String value = rs.getString(columnIndex);return Enum.valueOf(type, value);}@Overridepublic E getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {String value = cs.getString(columnIndex);return Enum.valueOf(type, value);}}
然后在MyBatis的配置文件中配置这个TypeHandler,例如:
<typeHandlers><typeHandler handler="com.example.EnumTypeHandler"/></typeHandlers>
public enum Status {ACTIVE("A"),INACTIVE("I");private String value;Status(String value) {this.value = value;}@Overridepublic String toString() {return this.value;}public static Status fromString(String value) {for (Status status : Status.values()) {if (status.value.equals(value)) {return status;}}throw new IllegalArgumentException("Invalid value for Status: " + value);}}
在Mapper接口中使用枚举类型:
public interface UserMapper {void insertUser(@Param("name") String name, @Param("status") Status status);User getUserByName(String name);}
在配置文件中使用枚举类型:
<insert id="insertUser" parameterType="map">INSERT INTO user (name, status) VALUES (#{name}, #{status})</insert>
11-20
11-19
11-20
11-20
11-20
11-19
11-20
11-20
11-19
11-20
11-19
11-19
11-19
11-19
11-19
11-19