温馨提示：
(1）数据是最重要的 (2）开发一层测试一层 (3）基础:登录
思维导图：
CategoryServiceTest
package com
.tuniu
.service
;
import com
.tuniu
.domain
.Category
;
import org
.junit
.Test
;
import java
.util
.List
;
public class CategoryServiceTest {
@Test
public void test01(){
CategoryService categoryService
= new CategoryService();
List
<Category> list
= categoryService
.findAll();
System
.out
.println(list
);
}
}
CategoryService
package com
.tuniu
.service
;
import com
.tuniu
.dao
.CategoryDao
;
import com
.tuniu
.domain
.Category
;
import com
.tuniu
.util
.MySessionUtils
;
import org
.apache
.ibatis
.session
.SqlSession
;
import java
.util
.List
;
public class CategoryService {
public List
<Category> findAll() {
SqlSession sqlsession
= MySessionUtils
.getSession();
CategoryDao mapper
= sqlsession
.getMapper(CategoryDao
.class);
List
<Category> result
= mapper
.findAll();
return result
;
}
}
##Category
package com
.tuniu
.domain
;
import java
.io
.Serializable
;
public class Category implements Serializable {
private int cid
;
private String cname
;
public Category() {
}
public Category(int cid
, String cname
) {
this.cid
= cid
;
this.cname
= cname
;
}
@Override
public String
toString() {
return "Category{" +
"cid=" + cid
+
", cname='" + cname
+ '\'' +
'}';
}
public int getCid() {
return cid
;
}
public void setCid(int cid
) {
this.cid
= cid
;
}
public String
getCname() {
return cname
;
}
public void setCname(String cname
) {
this.cname
= cname
;
}
}
CategoryDao
package com
.tuniu
.dao
;
import com
.tuniu
.domain
.Category
;
import java
.util
.List
;
public interface CategoryDao {
List
<Category> findAll();
}
CategoryDao.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.tuniu.dao.CategoryDao">
<select id="findAll" resultType="Category">
SELECT * FROM `tab_category` ORDER BY cid ASC
</select>
</mapper>
数据库表：
测试结果：
