Impl测试类
一、TestUserDaoImpl
1、测试用户登录
2、测试对User表的更新
3、测试User表的插入
4、测试User表通过id删除user用户
5、测试User表通过username查找用户User
6、测试User表查找所有用户User
7、通过id查找用户
二、TestCategoryDaoImpl
1、通过id查找类别category
2、插入类别category
3、通过id删除类别category
4、更新类别category
5、查找全部类别category
三、TestProductDaoImpl
1、根据id查找产品product
2、插入产品信息product
@Test
public void testInsert(){
ProductDao productDao = new ProductDaoImpl();
Product product = new Product();
product.setId(5);
product.setName("信签纸");
product.setPrice(15);
product.setAddTime(new Date());
product.setCategoryId(3);
List<Product> products = productDao.findAll();
int flay = 0;
for (Product product1:products) {
if (product1.getName().equals(product.getName())) {
flay = 1;
break;
}
}
if (flay == 0){
int count = productDao.insert(product);
if (count > 0) {
System.out.println("插入成功!");
} else {
System.out.println("插入失败!");
}
}else {
System.out.println("有相同的名字插入失败!");
}
}
3、根据id删除产品信息product
4、更新产品信息product
5、查找所有产品信息products
6、根据类别ld查找产品信息product
四、TestOrderDaoImpl
1、根据id查找订单order
2、查找全部订单order
二、插入订单信息
@Test
public void testInsert(){
Order order = new Order();
order.setId(3);
order.setUsername("小本");
order.setTotalPrice(3000);
order.setTelephone("15974158745");
order.setDeliveryAddress("泸职院国际学院");
order.setOrderTime(new Date());
OrderDao orderDao = new OrderDaoImpl();
int flay = 0;
List<Order> orders = orderDao.findAll();
for (Order order1:orders){
if (order1.getUsername().equals(order.getUsername())){
flay =1;
break;
}
}
if (flay == 0){
int count = orderDao.insert(order);
if (count > 0) {
System.out.println("插入成功!");
} else {
System.out.println("插入失败!");
}
}else {
System.out.println("有相同的名字插入失败!");
}
}
3、根据id删除订单order
4、更新订单表order
5、输出全部订单order
hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/hr/
Service测试类
一、TestUserService
package net.lgs.shop.service;
import net.lgs.bean.User;
import net.lgs.dao.UserDao;
import net.lgs.dao.impl.UserDaoImpl;
import net.lgs.service.UserService;
import org.junit.Test;
import java.util.Date;
import java.util.List;
public class TestUserService {
@Test
public void testLogin(){
String username,password;
username = "admin";
password="12345";
UserService userService = new UserService();
User user = userService.login(username,password);
if (user != null){
System.out.println("登陆成功");
}else {
System.out.println("登录失败!");
}
}
@Test
public void testUpdateUser(){
UserService userService = new UserService();
User user = userService.findUserById(4);
user.setPassword("903213");
user.setTelephone("11411457890");
int count = userService.updateUser(user);
if (count > 0) {
System.out.println("更新成功!");
}else {
System.out.println("更新失败!");
}
}
@Test
public void testAddUser(){
UserService userService = new UserService();
User user = new User();
user.setId(5);
user.setUsername("涂文");
user.setPassword("123456");
user.setTelephone("13541817484");
user.setRegisterTime(new Date());
user.setPopedom(1);
List<User> users = userService.findAllUsers();
int flay = 0;
for (User user1:users) {
if (user1.getUsername().equals(user.getUsername())) {
flay = 1;
break;
}
}
if (flay == 0){
int count = userService.addUser(user);
if (count > 0) {
System.out.println("插入成功!");
} else {
System.out.println("插入失败!");
}
}else {
System.out.println("有相同的名字插入失败!");
}
}
@Test
public void testDeleteUserById(){
UserService userService = new UserService();
int index = 5;
int count = userService.deleteUserById(index);
if (count > 0) {
System.out.println("删除成功!");
}else {
System.out.println("删除失败!");
}
}
@Test
public void testFindUsersByUsername(){
UserService userService = new UserService();
String name = "admin";
List<User> users = userService.findUsersByUsername(name);
if (users.size() > 0){
for (User user:users){
System.out.println(user);
}
}else {
System.out.println("查询失败");
}
}
@Test
public void testFindAllUsers(){
UserService userService = new UserService();
List<User> users = userService.findAllUsers();
if (users.size()>0){
for (User user:users){
System.out.println(user);
}
}else {
System.out.println("查询失败");
}
}
}
实现效果:
二、TestCategoryService
package net.lgs.shop.service;
import net.lgs.bean.Category;
import net.lgs.dao.CategoryDao;
import net.lgs.dao.impl.CategoryDaoImpl;
import net.lgs.service.CategoryService;
import org.junit.Test;
import java.util.List;
public class TestCategoryService {
@Test
public void testAddCategory(){
Category category = new Category();
category.setId(5);
category.setName("AJ用品");
CategoryService categoryService = new CategoryService();
int flay = 0;
List<Category> categories = categoryService.findAllCategories();
for (Category category1:categories){
if(category1.getName().equals(category.getName())){
flay =1;
break;
}
}
if (flay == 0){
int count = categoryService.addCategory(category);
if (count > 0) {
System.out.println("插入成功!");
} else {
System.out.println("插入失败!");
}
}else {
System.out.println("插入失败!有相同的名称的");
}
}
@Test
public void testDeleteCategoryById(){
int Id = 5;
CategoryService categoryService = new CategoryService();
int count = categoryService.deleteCategoryById(Id);
if (count > 0) {
System.out.println("删除成功!");
} else {
System.out.println("删除失败!");
}
}
@Test
public void testUpdateCategory(){
CategoryService categoryService = new CategoryService();
Category category = categoryService.findCategoryById(2);
category.setName("AW用品");
int count = categoryService.updateCategory(category);
if (count > 0) {
System.out.println("更新成功!");
} else {
System.out.println("更新失败!");
}
}
@Test
public void testFindAllCategories(){
CategoryService categoryService = new CategoryService();
List<Category> categorys = categoryService.findAllCategories();
if (categorys.size() > 0){
for (Category category:categorys){
System.out.println(category);
}
}else {
System.out.println("没有订单");
}
}
}
实现效果:
三、TestProductService
package net.lgs.shop.service;
import net.lgs.bean.Product;
import net.lgs.dao.CategoryDao;
import net.lgs.dao.ProductDao;
import net.lgs.dao.impl.CategoryDaoImpl;
import net.lgs.dao.impl.ProductDaoImpl;
import net.lgs.service.CategoryService;
import net.lgs.service.ProductService;
import org.junit.Test;
import java.util.Date;
import java.util.List;
public class TestProductService {
@Test
public void testFindProductsByCategoryId(){
//创建商品数据访问对象
ProductService productService = new ProductService();
int categoryId = 5;
CategoryService categoryService = new CategoryService();
if (categoryService.findCategoryById(categoryId)!= null){
String categoryName = categoryService.findCategoryById(categoryId).getName();
List<Product> products = productService.findProductsByCategoryId(categoryId);
if (!products.isEmpty()){
for (Product product:products){
System.out.println(product);
}
}else {
System.out.println("["+categoryName+"]类别没有商品!");
}
}
}
@Test
public void testAddProduct(){
ProductService productService = new ProductService();
Product product = new Product();
product.setId(16);
product.setName("笔");
product.setPrice(15);
product.setAddTime(new Date());
product.setCategoryId(3);
List<Product> products = productService.findAllProducts();
int flay = 0;
for (Product product1:products) {
if (product1.getName().equals(product.getName())) {
flay = 1;
break;
}
}
if (flay == 0){
int count = productService.addProduct(product);
if (count > 0) {
System.out.println("插入成功!");
} else {
System.out.println("插入失败!");
}
}else {
System.out.println("有相同的名字插入失败!");
}
}
@Test
public void testDeleteProductById(){
int Id = 16;
ProductService productService = new ProductService();
int count = productService.deleteProductById(Id);
if (count > 0) {
System.out.println("删除成功!");
}else {
System.out.println("删除失败!");
}
}
@Test
public void testUpdateProduct(){
ProductService productService = new ProductService();
Product product = productService.findProductById(3);
product.setName("蓝颜墨水");
int count = productService.updateProduct(product);
if (count > 0) {
System.out.println("更新成功!");
}else {
System.out.println("更新失败!");
}
}
@Test
public void testFindAllProducts(){
ProductService productService = new ProductService();
List<Product> productDaos = productService.findAllProducts();
if (productDaos.size() > 0){
for (Product product:productDaos){
System.out.println(product);
}
}else {
System.out.println("查询失败!");
}
}
}
实现效果:
四、TestOrderService
package net.lgs.shop.service;
import net.lgs.bean.Order;
import net.lgs.dao.OrderDao;
import net.lgs.dao.impl.OrderDaoImpl;
import net.lgs.service.OrderService;
import org.junit.Test;
import java.util.Date;
import java.util.List;
public class TestOrderService {
@Test
public void testFindAllOrders(){
OrderService orderService = new OrderService();
List<Order> orders = orderService.findAllOrders();
if (orders.size() > 0){
for (Order order:orders){
System.out.println(order);
}
}else {
System.out.println("没有订单");
}
}
@Test
public void testAddOrder(){
Order order = new Order();
order.setId(3);
order.setUsername("小A");
order.setTotalPrice(3000);
order.setTelephone("15974158745");
order.setDeliveryAddress("泸职院国际学院");
order.setOrderTime(new Date());
OrderService orderService = new OrderService();
int flay = 0;
List<Order> orders = orderService.findAllOrders();
for (Order order1:orders){
if (order1.getUsername().equals(order.getUsername())){
flay =1;
break;
}
}
if (flay == 0){
int count = orderService.addOrder(order);
if (count > 0) {
System.out.println("插入成功!");
} else {
System.out.println("插入失败!");
}
}else {
System.out.println("有相同的名字插入失败!");
}
}
@Test
public void testDeleteOrderById(){
int id = 3;
OrderService orderService = new OrderService();
int count = orderService.deleteOrderById(id);
if (count > 0) {
System.out.println("删除成功!");
} else {
System.out.println("删除失败!");
}
}
@Test
public void testUpdateOrder(){
OrderService orderService = new OrderService();
Order order = orderService.findOrderById(4);
order.setUsername("小黄");
int count = orderService.updateOrder(order);
if (count > 0) {
System.out.println("更新成功!");
} else {
System.out.println("更新失败!");
}
}
@Test
public void testFindLast(){
OrderService orderService = new OrderService();
Order order = orderService.findLastOrder();
System.out.println(order);
}
}
实现效果: