StudentDao

package com.dao;

import com.entity.Student;
import com.zhenghong.database.DBManager;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class StudentDao extends DBManager {

public boolean deleteById( int stuId ) throws SQLException{
    String sql = "delete from   student where stuId = ?" ;
    Object[] obs = { stuId } ;
    Connection conn = this.openConnection() ;
    int count = this.update( conn , sql , obs) ;
    return count>0?true:false;
}

public int updateStudent( Student student ) throws SQLException{
    String sql = "update student set stuName = ? , stuAge = ? , cid = ? where stuId = ?" ;
    Object[] obs = { student.getStuName() , student.getStuAge() , student.getCid() , student.getStuId()} ;
    Connection conn = this.openConnection() ;
    int count = this.update( conn , sql , obs) ;
    return count ;
}

public boolean save( Student student ) throws SQLException{
    int count = 0 ;
    String sql = "insert into student values(?,?,?,?)" ;
    Object[] obs = { student.getStuId() , student.getStuName() , student.getStuAge() , student.getCid()} ;
    Connection conn = this.openConnection() ;
    count = this.update( conn , sql , obs) ;
    this.closeConnection( conn );
    return count>0?true:false;
}

public Student loadById( int stuId ) throws SQLException{
    Student student = new Student() ;
    String sql = "select * from student where stuId = ?" ;
    Object[] obs = {stuId} ;
    Connection conn = this.openConnection() ;

    ResultSet rs = this.query( conn , sql , obs) ;
    if (rs.next()){
        student.setStuId( rs.getInt(1) );
        student.setStuName( rs.getString(2) );
        student.setStuAge( rs.getInt(3) );
        student.setCid( rs.getInt(4) );
    }
    return student ;
}

public List<Student> loadAll() throws SQLException {
    String sql = "select * from student" ;
    Connection conn = this.openConnection() ;
    ResultSet rs = this.query( conn , sql , null) ;
    List<Student> studentList = new ArrayList<>() ;
    Student student = null ;
    while (rs.next()){
        student = new Student() ;
        student.setStuId( rs.getInt(1));
        student.setStuName( rs.getString(2));
        student.setStuAge( rs.getInt(3)) ;
        student.setCid( rs.getInt(4));
        studentList.add( student ) ;
    }
    return studentList ;
}

}