mapper接口代码如下
package javacto.taobao.com;
import com.javacto.po.User;
import com.javacto.po.UserVo;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import java.util.List;
public interface UserMapper {
/**
* 根据用户ID来查询用户信息
* javacto.taobao.com
* @param id
* @return
*/
@Select("SELECT * FROM TUSER WHERE uid=${id }")
public User findById(@Param("id") int id);
/**
* 模糊查询
* @param uname
* @return
*/
@Select("SELECT * FROM TUSER WHERE uname LIKE concat(concat('%',#{uname}),'%')")
public List<User> findByName(String uname);
/**
* 查询所有
*javacto.ke.qq.com
* @return
*/
@Select("SELECT * FROM TUSER")
public List<User> findUserList();
/**
* 添加
* @param User
* @return
*/
@Insert("INSERT INTO TUSER(uname,upassword,usex,udate,uaddress,ustate)" +
" VALUES(#{uname},#{upassword},#{usex},NOW(),#{uaddress},0);")
public int insertUser(User user);
/**
* 删除
* @param id
* @return
*/
@Delete("DELETE FROM TUSER WHERE uid=${id}")
public int deleteUser(@Param(("id")) int id);
}
配置mappers
<mappers>
<!-- <mapper class="javacto.taobao.com.UserMapper"></mapper>-->
<!--或下面方式-->
<package name="javacto.taobao.com"/>
</mappers>
测试代如如下:
public class TestUserMapper {
//javacto.ke.qq.com
SqlSessionFactory sqlSessionFactory;
@Before
public void setUp() throws IOException {
String sqlMapConfig="SqlMapConfig.xml";
InputStream is = Resources.getResourceAsStream(sqlMapConfig);
sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);
}
//javacto.taobao.com
@Test
public void testfindById(){
SqlSession sqlSession = sqlSessionFactory.openSession();
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
User user=userMapper.findById(1);
System.out.println(user);
}
}