将数据库中所有数据都查询出来,这时候结果肯定不止一条,是一个List,使用方法如下:
查询:
Dao层里面:
@Mapper
public interface dataMangeDao {
List<pipenet> getpipenet();
}
Mapper里面:
<select id="getpipenet" resultType="java.util.List" >
select *
from pipenet
</select>
插入:
Dao层里面:
void insertRain(List<rain> rain);
Mapper层:
<insert id="insertRain" parameterType="java.util.List">
insert into rain values
<foreach collection="rain" item="item" index= "index" separator =",">
(#{item.rainName},#{item.startime},#{item.endtime},#{item.rainfall}, #{item.timeunit},#{item.rainunit},#{item.rainurl})
</foreach>
</insert>