大一下——实训06

package net.xzy.student.service.impl;

import net.xzy.student.bean.College;
import net.xzy.student.dao.CollegeDao;
import net.xzy.student.dao.impl.CollegeDaoImpl;
import net.xzy.student.service.CollegeService;

import java.sql.SQLException;

/**

• 功能：学校服务接口实现类

•  2019.6.19
  

*/

public class CollegeServiceImpl implements CollegeService {
/**
* 声明学校数据访问对象
*/
private CollegeDao collegeDao = new CollegeDaoImpl();

@Override
public College findCollegeById(int id) {
    return collegeDao.findById(id);
}

@Override
public int updateCollege(College college){
    return collegeDao.update(college);
}

}

TestCollegeServiceImpl

package net.xzy.student.test;

import net.xzy.student.bean.College;
import net.xzy.student.service.CollegeService;
import net.xzy.student.service.impl.CollegeServiceImpl;
import org.junit.jupiter.api.Test;

/**

• 功能：测试学校服务接口实现类

•  2019.6.19
  

*/
public class TestCollegeServiceImpl {
@Test
public void testFindCollegeById(){
CollegeService service = new CollegeServiceImpl();
College college = service.findCollegeById(1);
System.out.println(college);
}

@Test
public void testUpdateCollege(){
    CollegeService service = new CollegeServiceImpl();
    College college = service.findCollegeById(1);
    college.setPresident("孙阳1");
    college.setTelephone("111222");
    int count = service.updateCollege(college);
    if (count > 0) {
        System.out.println("恭喜，学校记录更新成功！");
        college = service.findCollegeById(1);
        System.out.println(college);
    } else {
        System.out.println("遗憾，学校记录更新失败！");
    }
}

}

StatusServiceImpl

package net.xzy.student.service.impl;

import net.xzy.student.bean.Status;
import net.xzy.student.dao.StatusDao;
import net.xzy.student.dao.impl.StatusDaoImpl;
import net.xzy.student.service.StatusService;

/**

• 功能：状态服务接口实现类

•  2019.6.19
  

*/

public class StatusServiceImpl implements StatusService {
/**
* 声明状态数据访问对象
*/
private StatusDao statusDao = new StatusDaoImpl();

@Override
public Status findStatusById(int id){
    return statusDao.findById(id);
}

@Override
public int updateStatus(Status status){
    return statusDao.update(status);
}

}

TestStatusServiceImpl
package net.xzy.student.test;

import net.xzy.student.bean.Status;
import net.xzy.student.service.StatusService;
import net.xzy.student.service.impl.StatusServiceImpl;
import org.junit.jupiter.api.Test;

/**

• 功能：测试状态服务接口实现类

•  2019.6.19
  

*/

public class TestStatusServiceImpl {
@Test
public void testFindStatusById(){
StatusService service = new StatusServiceImpl();
Status status = service.findStatusById(1);
System.out.println(status);
}

@Test
public void testUpateStatus(){
    StatusService service = new StatusServiceImpl();
    Status status = service.findStatusById(1);
    status.setAuthor("丐妹");
    status.setTelephone("1112222");
    int count = service.updateStatus(status);
    if (count > 0) {
        System.out.println("恭喜，状态记录更新成功！");
        status = service.findStatusById(1);
        System.out.println(status);
    } else {
        System.out.println("遗憾，状态记录更新失败！");
    }
}

}

StudentServiceImpl

package net.xzy.student.service.impl;

import net.xzy.student.bean.Student;
import net.xzy.student.dao.StudentDao;
import net.xzy.student.dao.impl.StudentDaoImpl;
import net.xzy.student.service.StudentService;

import java.util.List;
import java.util.Vector;

/**

• 功能：学生服务接口实现类

•   2019.6.19
  

/
public class StudentServiceImpl implements StudentService {
/*
* 声明学生数据访问对象
*/
private StudentDao studentDao = new StudentDaoImpl();

@Override
public int addStudent(Student student) {
    return studentDao.insert(student);
}

@Override
public int deleteStudentById(String id) {
    return studentDao.deleteById(id);
}

@Override
public int deleteStudentsByClass(String clazz) {
    return studentDao.deleteByClass(clazz);
}

@Override
public int deleteStudentsByDepartment(String department) {
    return studentDao.deleteByDepartment(department);
}

@Override
public List<Student> findAllStudents() {
    return studentDao.findAll();
}

@Override
public Vector findRowsByClass() {
    return studentDao.findRowsByClass();
}

@Override
public Vector findRowsByDepartment() {
    return studentDao.findRowsByDepartment();
}

@Override
public Vector findRowsBySex() {
    return studentDao.findRowsBySex();
}

@Override
public Student findStudentById(String id) {
    return studentDao.findById(id);
}

@Override
public List<Student> findStudentsByClass(String clazz) {
    return studentDao.findByClass(clazz);
}

@Override
public List<Student> findStudentsByDepartment(String department) {
    return studentDao.findByDepartment(department);
}

@Override
public List<Student> findStudentsByName(String name) {
    return studentDao.findByName(name);
}

@Override
public int updateStudent(Student student) {
    return studentDao.update(student);
}

}

TestStudentServiceImpl

package net.xzy.student.test;

import net.xzy.student.bean.Student;
import net.xzy.student.service.StudentService;
import net.xzy.student.service.impl.StudentServiceImpl;
import org.junit.jupiter.api.Test;

import java.util.List;

/**

• 功能：测试学生服务接口实现类
  */
  public class TestStudentServiceImpl {
  @Test
  public void testFindStudentByName(){
  StudentService service = new StudentServiceImpl();
  String name = “孙”;
  Liststudents = service.findStudentsByName(name);
  for(Student student:students){
  System.out.println(student);
  }
  }
  }

UserServiceImpl
package net.xzy.student.service.impl;

import java.util.List;

import net.xzy.student.bean.User;
import net.xzy.student.dao.UserDao;
import net.xzy.student.dao.impl.UserDaoImpl;
import net.xzy.student.service.UserService;

/**

• 功能：用户服务接口实现类

• 日期：2019年6月19日
  /
  public class UserServiceImpl implements UserService{
  /*

  • 声明用户数据访问对象
    */
    private UserDao userDao = new UserDaoImpl();

  @Override
  public int addUser(User user) {
  return userDao.insert(user);
  }

  @Override
  public int deleteUserById(int id) {
  return userDao.deleteById(id);
  }

  @Override
  public List findAllUsers() {
  return userDao.findAll();
  }

  @Override
  public User findUserById(int id) {
  return userDao.findById(id);
  }

  @Override
  public User login(String username, String password) {
  return userDao.login(username, password);
  }

  @Override
  public int updateUser(User user) {
  return userDao.update(user);
  }
  }

TestUserServiceImpl

package net.xzy.student.test;

import net.xzy.student.bean.User;
import net.xzy.student.service.UserService;
import net.xzy.student.service.impl.UserServiceImpl;
import org.junit.jupiter.api.Test;

/**

• 功能：测试用户服务接口实现类

•   2019.6.20
  

*/
public class TestUserServiceImpl {
@Test
public void testLogin(){
UserService service = new UserServiceImpl();
String username,password;

    username = "admin";
    password = "123456";

    User user = service.login(username,password);

    if (user != null) {
        System.out.println("恭喜，用户名和密码正确，登陆成功！");
    } else {
        System.out.println("遗憾，用户名和密码正确，登陆失败！");
    }
}

}