package com.ltt.dao.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.ltt.dao.StudentDao;
import com.ltt.model.Student;
import com.ltt.util.DataBase;
public class StudentDaoImpl implements StudentDao {
// 更新学生信息
public void updateStudent(Student stu) throws Exception {
Connection con = DataBase.getConnection();
String sql = "update student set name=?,grade=?,professional=?,gender=? where id=?";
PreparedStatement ps = con.prepareStatement(sql);
ps.setString(1, stu.getName());
ps.setInt(2, stu.getGrade());
ps.setString(3, stu.getProfessional());
ps.setString(4, stu.getGender());
ps.setString(5, stu.getId());
ps.executeUpdate();
con.close();
}
public List<Student> query() {
try {
Connection con = DataBase.getConnection();
String sql = "select id,name,grade,professional,gender from student";
PreparedStatement ps = con.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
return this.resultSetStudent(rs);
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
public Student load(String id) throws Exception {
Connection con = DataBase.getConnection();
String sql = "select * from student wh