| | |
|---|
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
|---|
| | | <mapper namespace="com.whyc.mapper.PowerInfMapper"> |
|---|
| | | <select id="getPowerList" resultType="com.whyc.pojo.db_station.PowerInf"> |
|---|
| | | select tb_power_inf.*,tb_station_inf.station_name |
|---|
| | | select tb_power_inf.power_id,tb_power_inf.power_name,tb_power_inf.station_id,tb_station_inf.station_name |
|---|
| | | from db_station.tb_power_inf,db_station.tb_station_inf |
|---|
| | | where tb_power_inf.station_id=tb_station_inf.station_id |
|---|
| | | order by tb_power_inf.num asc |
|---|
