package com.service;
import com.dao.StudentDao;
import com.entity.Student;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public class StudentService {
StudentDao studentDao = new StudentDao() ;
public boolean deleteById( int stuId){
boolean bool = false ;
try {
bool = studentDao.deleteById( stuId ) ;
} catch (SQLException e) {
e.printStackTrace();
}
return bool ;
}
public int updateStudent( Student student ){
int count = 0 ;
try {
count = studentDao.updateStudent( student ) ;
} catch (SQLException e) {
e.printStackTrace();
}
return count ;
}
public boolean save( Student student ){
boolean bool = false ;
try{
bool = studentDao.save( student ) ;
}catch ( SQLException e ){
e.printStackTrace();
}
return bool ;
}
public void printStudent( Student student ){
System.out.println("学号\t\t\t姓名\t\t\t年龄\t\t\t班级编号");
System.out.print(student.getStuId() + "\t\t");
System.out.print(student.getStuName() + "\t\t\t");
System.out.print(student.getStuAge() + "\t\t\t");
System.out.print(student.getCid() + "\n");
}
public Student loadById( int stuId ) {
Student student = new Student() ;
try {
student = studentDao.loadById(stuId);
}catch (SQLException e){
e.printStackTrace();
}
return student ;
}
public void printDetailInfo( List<Student> studentList){
System.out.println("学号\t\t\t姓名\t\t\t年龄\t\t\t班级编号");
for (Student student: studentList) {
System.out.print(student.getStuId() + "\t\t");
System.out.print(student.getStuName() + "\t\t\t");
System.out.print(student.getStuAge() + "\t\t\t");
System.out.print(student.getCid() + "\n");
}
}
public List<Student> loadAll(){
List<Student> studentList = null ;
try {
studentList = studentDao.loadAll() ;
} catch (SQLException e) {
e.printStackTrace();
}
return studentList ;
}
}