package com.mstf.service.impl;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.mstf.bean.Info;
import com.mstf.bean.Page;
import com.mstf.service.InfoService;
import com.mstf.tx.PageConfig;
import com.mstf.util.DBUtil;

public class InfoServiceImpl extends DBUtil implements InfoService {

	@Override
	public List<Info> getAll() {
		List<Info> infoList = new ArrayList<Info> () ;
		String sql = "select * from INFO";
		rs = commonQuery(sql,null) ;
		Info info = null ;
		try {
			while(rs.next()) {
				info = new Info(rs.getInt("id"),rs.getString("name"),
						rs.getInt("age"),rs.getString("address"),
						rs.getString("birthday")) ;
				
				infoList.add(info) ;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			commonClose(conn, pstmt, rs) ;
		}
		return infoList;
	}

	@Override
	public List<Info> getAll(String name, int currentPage) {
		List<Info> infoList = new ArrayList<Info> () ;
		String sql = "select * from INFO where 1=1";
		if(name != null && !"".equals(name)) {
			sql += " and name like '%"+name+"%'" ;
		}
		sql += " limit ?,?" ;
		rs = commonQuery(sql,PageConfig.PAGESIZE*(currentPage-1),PageConfig.PAGESIZE) ;
		Info info = null ;
		try {
			while(rs.next()) {
				info = new Info(rs.getInt("id"),rs.getString("name"),
						rs.getInt("age"),rs.getString("address"),
						rs.getString("birthday")) ;
				
				infoList.add(info) ;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			commonClose(conn, pstmt, rs) ;
		}
		return infoList;
	}

	@Override
	public int getRowCount(String name) {
		int rowCount = 0 ;
		String sql = "select count(*) from INFO where 1=1";
		if(name != null && !"".equals(name)) {
			sql += " and name like '%"+name+"%'" ;
		}
		try {
			rs = commonQuery(sql,null) ;
			if(rs.next()) {
				rowCount = rs.getInt(1) ;
			}
		} catch (SQLException e) {
			
			e.printStackTrace();
		}finally {
			commonClose(conn, pstmt, rs) ;
		}
		return rowCount;
	}

	@Override
	public Page getPage(String name, int currentPage) {
		List<Info> list = getAll(name,currentPage);
		int rowCount = getRowCount(name);
		return new Page(PageConfig.PAGESIZE, currentPage, rowCount, list);
	}

}