| | |
|---|
| | | |
|---|
| | | |
|---|
| | | <select id="getbreakerInf" resultType="com.whyc.pojo.db_ckpwrdev_inf.BreakerInf"> |
|---|
| | | select tb_breaker_inf.*,tb_gateway_inf.gateway_name from db_ckpwrdev_inf.tb_breaker_inf,db_ckpwrdev_inf.tb_gateway_inf |
|---|
| | | select tb_breaker_inf.*,tb_gateway_inf.gateway_name from db_ckpwrdev_inf.tb_breaker_inf |
|---|
| | | LEFT JOIN db_ckpwrdev_inf.tb_gateway_inf on tb_breaker_inf.gateway_id=tb_gateway_inf.gateway_id |
|---|
| | | <where> |
|---|
| | | tb_breaker_inf.gateway_id=tb_gateway_inf.gateway_id |
|---|
| | | 1=1 |
|---|
| | | <if test="breakerType!=null"> |
|---|
| | | and breaker_type=#{breakerType} |
|---|
| | | </if> |
|---|
