package?daowen.bll;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.*;
import?daowen.data.jdbcex.*;
public?abstract?class?BLLbase?{

	/**
	?*?表名稱
	?*/
	private?String?tablename;

	
	public?String?getTablename（）?{
		return?tablename;
	}

	public?void?setTablename（String?tablename）?{
		this.tablename?=?tablename;
	}
	
	/***
	?*?
	?*?得到最大記錄
	?*?
	?*/
	public?int?getMaxIndex（）
	{
		DB?db=new?DB（）;
		String?SQL=String.format（“select?max（id）?from?%s“?tablename）;
		ResultSet??rs=null;
		int?index=0;
		rs=db.getResultSet（SQL）;
		try?{
			while（rs.next（））
			{
				index=rs.getInt（1）;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		finally
		{
			?if（rs!=null）
				try?{
					rs.close（）;
				}?catch?（SQLException?e）?{
					//?TODO?Auto-generated?catch?block
					e.printStackTrace（）;
				}
			?if（db!=null）
				?db.close（）;
		}
		return?index;
		
	}
	
	/**
	?*?得到所有用戶的記錄個數
	?*?@return
	?*/
	public?int?getTotalCount（）
	{
		int?totalcount=0;
		?String?SQL=String.format（“select?count（*）?from?%s“tablename）;
		?System.out.println（SQL）;
		?DB?db=new?DB（）;
		?ResultSet?rs=db.getResultSet（SQL）;
		?try?{
			while（rs.next（））
			?{
				totalcount=rs.getInt（1）;?
			?}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}finally{
			db.close（）;
		}
	??????return?totalcount;
	}
	
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????410??2009-04-13?22:33??shebeiguanli\.classpath

?????文件????????309??2009-04-11?01:56??shebeiguanli\.mymetadata

?????文件???????1230??2009-04-13?22:21??shebeiguanli\.project

?????文件????2293760??2009-04-21?23:34??shebeiguanli\db\shebeiguanli.mdf

?????文件?????573440??2009-04-21?23:34??shebeiguanli\db\shebeiguanli_log.LDF

?????文件???????1659??2009-04-21?23:22??shebeiguanli\db.sql

?????文件???????1502??2009-04-11?01:57??shebeiguanli\src\daowen\bll\BLLbase.java

?????文件????????914??2009-04-11?01:57??shebeiguanli\src\daowen\bll\Deparment.java

?????文件???????5487??2009-04-11?01:57??shebeiguanli\src\daowen\bll\DeparmentManager.java

?????文件???????1669??2009-03-29?02:04??shebeiguanli\src\daowen\bll\Employee.java

?????文件???????4839??2009-03-29?10:06??shebeiguanli\src\daowen\bll\EmployeeManager.java

?????文件????????841??2009-04-11?01:57??shebeiguanli\src\daowen\bll\Message.java

?????文件???????4546??2009-04-11?01:57??shebeiguanli\src\daowen\bll\MessageManager.java

?????文件???????1719??2009-04-11?01:57??shebeiguanli\src\daowen\bll\PageModel.java

?????文件???????1826??2009-04-20?21:32??shebeiguanli\src\daowen\bll\SheBei.java

?????文件???????1455??2009-04-20?23:30??shebeiguanli\src\daowen\bll\SheBeichuku.java

?????文件???????4844??2009-04-21?23:09??shebeiguanli\src\daowen\bll\SheBeichukuManager.java

?????文件???????5088??2009-04-20?22:04??shebeiguanli\src\daowen\bll\SheBeiManager.java

?????文件???????1321??2009-04-09?21:34??shebeiguanli\src\daowen\bll\User.java

?????文件???????6496??2009-04-13?10:43??shebeiguanli\src\daowen\bll\UserManager.java

?????文件???????3989??2009-04-13?22:34??shebeiguanli\src\daowen\data\jdbcex\DB.java

?????文件????????169??2009-04-11?01:57??shebeiguanli\src\daowen\util\PasswordNotCorrectException.java

?????文件???????5653??2009-04-11?01:57??shebeiguanli\src\daowen\util\Time.java

?????文件????????153??2009-04-11?01:57??shebeiguanli\src\daowen\util\UserNotFindException.java

?????文件????????668??2009-04-11?01:57??shebeiguanli\src\system\data\DataColumn.java

?????文件????????703??2009-04-11?01:57??shebeiguanli\src\system\data\DataRow.java

?????文件????????667??2009-04-11?01:57??shebeiguanli\src\system\data\DataTable.java

?????文件???????4991??2009-04-21?00:02??shebeiguanli\WebRoot\admin\?shebeiguzhangadd.jsp

?????文件???????3842??2009-03-28?20:48??shebeiguanli\WebRoot\admin\amcss.css

?????文件???????5798??2007-08-17?16:29??shebeiguanli\WebRoot\admin\css\oa.css

............此處省略123個文件信息