studentdao.java

fahirjgjkdfjkl 丰卡时间阿科技安分 发 啊啊啊啊啊

package com.bookshop.dao;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import com.bookshop.dto.Student;
import com.bookshop.util.DBManager;


public class StudentDAO {
	
	public List getStudent(int from,int to){
		List list=new ArrayList();
		Student student=null;
		ResultSet rs=null;
		try{
			PreparedStatement pstmt=DBManager.getConnection().prepareStatement("SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM graduate_student_tab ORDER BY ID) A WHERE ROWNUM <= ?)WHERE RN >= ?");
			pstmt.setInt(1,to);
			pstmt.setInt(2,from);
			rs=pstmt.executeQuery();
			while(rs.next()){
				student=new Student();
				student.setClassid(rs.getInt("classid"));
				student.setId(rs.getInt("id"));
				student.setSno(rs.getString("sno"));
				student.setName(rs.getString("name"));
				student.setSex(rs.getString("sex"));
				student.setCardid(rs.getString("cardid"));
				student.setBirthday(rs.getDate("birthday").toString());
				list.add(student);
				
			}
		}catch(SQLException e){e.printStackTrace();}
		return list;
	}
	
	public int getStudentMaxRow(){
		ResultSet rs=null;
		int maxRow=0;
		try{
			PreparedStatement pstmt=DBManager.getConnection().prepareStatement("select count(*) x from graduate_student_tab;");
			rs=pstmt.executeQuery();
			while(rs.next()){
				maxRow=rs.getInt("x");
			}
		}catch(SQLException e){e.printStackTrace();}
		return maxRow;
	}


}