<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.artfess.sysConfig.persistence.dao.SysDataSourceDao">
	<resultMap id="SysDataSource" type="com.artfess.sysConfig.persistence.model.SysDataSource">
		<id property="id" column="id_" jdbcType="VARCHAR"/>
		<result property="name" column="name_" jdbcType="VARCHAR"/>
		<result property="alias" column="alias_" jdbcType="VARCHAR"/>
		<result property="classPath" column="class_path_" jdbcType="VARCHAR"/>
		<result property="dbType" column="db_type_" jdbcType="VARCHAR"/>
		<result property="settingJson" column="setting_json_" jdbcType="LONGVARCHAR"/>
		<result property="initOnStart" column="init_on_start_" jdbcType="NUMERIC"/>
		<result property="enabled" column="enabled_" jdbcType="NUMERIC"/>
		<result property="initMethod" column="init_method_" jdbcType="VARCHAR"/>
		<result property="closeMethod" column="close_method_" jdbcType="VARCHAR"/>
		<result property="type" column="type_" jdbcType="NUMERIC"/>
		<result property="createBy" column="create_by_" jdbcType="VARCHAR"/>
		<result property="createTime" column="create_time_" jdbcType="TIMESTAMP"/>
		<result property="createOrgId" column="create_org_id_" jdbcType="VARCHAR"/>
		<result property="updateBy" column="update_by_" jdbcType="VARCHAR"/>
		<result property="updateTime" column="update_time_" jdbcType="TIMESTAMP"/>
		
	</resultMap>
	
	<select id="getByAlias"   parameterType="java.lang.String" resultMap="SysDataSource">
		SELECT * FROM portal_sys_datasource 
		WHERE alias_=#{alias,jdbcType=VARCHAR}
	</select>
	
	
	
</mapper>