Java统计当天的访问人数以及总的访问人数

package com.jie.java.phone;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class Java {

	public static void main(String args[]){

		Connection conn = null;
		PreparedStatement ps = null;
		PreparedStatement psl = null;
		ResultSet rs = null;
		ResultSet rsl = null;
	try {

		Class.forName("oracle.jdbc.driver.OracleDriver")
				.newInstance();
		conn = DriverManager.getConnection("jdbc:oracle:thin:@10.153.115.15:1521:ORCL","ming","tian");
		String sql = "select count(id) from (select * from (select *  from temporary  where trunc(createtime)=trunc(sysdate))  order by createtime desc)";
		ps = conn.prepareStatement(sql);
		String sqll="select count(id)  from temporary";
		psl = conn.prepareStatement(sqll);
	//	ps.executeUpdate();
	//	psl.executeUpdate();
		rs=ps.executeQuery();
		rsl=psl.executeQuery();

		while(rs!=null&&rs.next()){
			System.out.println("今天的人数："+rs.getInt(1));
		}
		while(rsl.next()){
			System.out.println("总的人数："+rsl.getInt(1));
		}
	} catch (Exception e) {
		e.printStackTrace();
	}finally{
		try{
		if(rs!=null){
			rs.close();
		}
		if(rsl!=null){
			rsl.close();
		}
		if(ps!=null){
			ps.close();
		}
		if(psl!=null){
			psl.close();
		}
		if(conn!=null){
			rsl.close();
		}
		}catch (Exception e) {
		e.printStackTrace();
		}
	}
	}


}