SQLServer2008

public class StudentDaoImpl implements StudentDao { @Override public void save(Student student) { String sql = "insert into student (name,age) values ('" + student.getName() + "'," + student.getAge() + ")"; DBManager.update(sql); } @Override public void delete(int id) { String sql = "delete from student where id=" + id; DBManager.update(sql); } @Override public void update(Student student) { String sql = "update student set name='" + student.getName() + "',age=" + student.getAge() + " where id=" + student.getId(); DBManager.update(sql); } @Override public void findStudentById(int id) { String sql = "select * from student where id=" + id; ResultSet rs = DBManager.query(sql); Student stu = null; try { while (rs.next()) { stu = new Student(); stu.setId(rs.getInt("id")); stu.setName(rs.getString("name")); stu.setAge(rs.getInt("age")); System.out.println(stu); } } catch (SQLException e) { e.printStackTrace(); } } @Override public void findStudentByName(String name) { String sql = "select * from student where name='" + name + "'"; ResultSet rs = DBManager.query(sql); Student stu = null; try { while (rs.next()) { stu = new Student(); stu.setId(rs.getInt("id")); stu.setName(rs.getString("name")); stu.setAge(rs.getInt("age")); System.out.println(stu); } } catch (SQLException e) { e.printStackTrace(); } } @Override public void findAllStudents() { String sql = "select * from student"; ResultSet rs = DBManager.query(sql); Student stu = null; try { while (rs.next()) { stu = new Student(); stu.setId(rs.getInt("id")); stu.setName(rs.getString("name")); stu.setAge(rs.getInt("age")); System.out.println(stu); } } catch (SQLException e) { e.printStackTrace(); } } @Override public void findStudentByPage(int pageSize, int pageNow) { String sql = " select top " + pageSize + " * from [demoDB].[dbo].[student] where [id] not in (select top " + pageSize * (pageNow - 1) + " id from [demoDB].[dbo].[student]) order by id asc"; ResultSet rs = DBManager.query(sql); Student stu = null; try { while (rs.next()) { stu = new Student(); stu.setId(rs.getInt("id")); stu.setName(rs.getString("name")); stu.setAge(rs.getInt("age")); System.out.println(stu); } } catch (SQLException e) { e.printStackTrace(); } } }