StudentDao:
package com.iflytek.stumanager.dao;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.iflytek.stumanager.po.Student;
import com.iflytek.stumanager.util.DBUtil;
public class StudentDao {
public void saveStudent(Student student) {
String sql = "insert into student(id,name,age,address) value(?,?,?,?)";
PreparedStatement pst = DBUtil.getPreparedStatement(sql);
try {
pst.setInt(1, student.getId());
pst.setString(2, student.getName());
pst.setInt(3, student.getAge());
pst.setString(4,student.getAddress());
pst.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBUtil.closeDBResources();
}
}
public void updateStudent(Student student) {
String sql = "update student set name=?, age=?, address=? where id=?";
PreparedStatement pst = DBUtil.getPreparedStatement(sql