package Bean;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class BookCount {
	
	int count = 0;
public int getBookCount()
{
	count = 0;
	Connection conn=new DBConn().getConn();
	
	Statement stmt = null;
	ResultSet sqlRst = null;

//	String sql = "select * from users where username = '" + username + "' and password = '" + password + "' and usertype = 'user'";
//	String sql = "select * from users where username = '" + username + "' and password = '" + password + "'";
	String sql = "select * from book";
	System.out.println(sql);

		try {
			 stmt = conn.createStatement();
			sqlRst=stmt.executeQuery(sql); //結(jié)果集對象 
			
			while(sqlRst.next())
			{
				count ++;
			}
			
			count ++;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally
		{
			if(sqlRst != null)
			{
				try {
					sqlRst.close();
					stmt.close();
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
		return count;
}	
}