sdao.java

功能强大

package Dao;

import java.sql.*;
import java.util.*;

public class SDao extends BaseDao{
	int r=10;
	public List gets(int p){
		List list=new ArrayList();
		if(p>0){
			p=(p-1)*r;
		}
		String sql="select top "+2+" * from spt_values where [name] not in (select top "+p+" [name] from spt_values)";
		Connection con=null;
		Statement st=null;
		ResultSet rs=null;
		try {
			con=this.getConnection();
			st=con.createStatement();
			rs=st.executeQuery(sql);
			while(rs.next()){
				list.add(rs.getString("name"));
			}
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}finally{
			this.closeAll(con, st, rs);
		}
		return list;
	}
	
	public int getp(){
		int i=0;
		String sql="select count(*) from spt_values";
		Connection con=null;
		Statement st=null;
		ResultSet rs=null;
		try {
			con=this.getConnection();
			st=con.createStatement();
			rs=st.executeQuery(sql);
			while(rs.next()){
				int j=rs.getInt(1);
				i=j/r;
				if(j%r!=0){
					i++;
				}
			}
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}finally{
			this.closeAll(con, st, rs);
		}
		return i;
	}
	
	public static void main(String[] args) {
		SDao sDao=new SDao();
		System.out.println(sDao.getp());
		List list=sDao.gets(1);
		for (int i = 0; i < list.size(); i++) {
			System.out.println(list.get(i).toString());
		}
	}
}