摘要：
在 resource mapper下建立 user.xml， <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org 阅读全文
摘要：
1张表，查2次，把2表分别名，作条件查询。 SELECT a.id,a.name ,b.name AS pname FROM tbl_test AS a ,tbl_test AS b WHERE a.pid = b.id AND a.id = 5; 阅读全文