<?xml version="1.0" encoding="utf-8" ?><!DOCTYPEmapperPUBLIC"-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mappernamespace="com.star.dao.FriendLinkDao"><!--查询所有友链--><selectid="listFriendLink"resultType="com.star.entity.FriendLink">
select * from myblog.t_friend order by t_friend.create_time desc
</select><!--添加友链--><insertid="saveFriendLink"parameterType="com.star.entity.FriendLink">
insert into myblog.t_friend (blogname,blogaddress,pictureaddress,create_time)
values (#{blogname},#{blogaddress},#{pictureaddress},#{createTime})
</insert><!--根据网址查询友链--><selectid="getFriendLinkByBlogaddress"resultType="com.star.entity.FriendLink">
select * from myblog.t_friend f where f.blogaddress = #{blogaddress}
</select