package?com.runwit.books.db;

import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.List;

import?com.runwit.books.model.AuthorModel;
import?com.runwit.common.db.baseDAO;
import?com.runwit.common.db.IParamBinding;
import?com.runwit.common.db.IRowMapper;

public?class?AuthorDAO?extends?baseDAO{
	
	public?void?save（final?AuthorModel?model）{
//		String?sql?=?“insert?into?authors?values（‘“+model.getFirstName（）+“‘‘“+model.getLastName（）+“‘）“;
//		super.updateBySql（sql）;
		String?sql?=?“insert?into?authors?values（???）“;
		super.updateBySql（sql?new?IParamBinding（）{
			public?void?bindParam（PreparedStatement?pstmt）?throws?SQLException?{
				pstmt.setString（1?model.getFirstName（））;
				pstmt.setString（2?model.getLastName（））;
			}
		}）;
	}
	
	public?void?update（AuthorModel?model）{
		String?sql?=?String
				.format（
						“update?authors?set?firstName=‘%s‘?lastName=‘%s‘?where?authorid=%d?“
						model.getFirstName（）?model.getLastName（）?model
								.getAuthorId（））;
		super.updateBySql（sql）;
	}
	
	public?void?delete（int?authorId）{
		updateBySql（“delete?from?authors?where?authorid=“+authorId）;
	}
	
	public?AuthorModel?get（int?authorId）{
		String?sql?=?“select?*?from?authors?where?authorId=“+authorId;
		List?models?=?queryBySql（sql?new?AuthorRowMapper（））;
		return?models.size（）?==?0???null?:?models.get（0）;
	}
	
	public?List?queryAll（）{
//		return?super.queryBySql（“select?*?from?authors“?new?IRowMapper（）?{
//			public?object?mappingRow（ResultSet?rs）?throws?SQLException?{
//				AuthorModel?model?=?new?AuthorModel（rs.getInt（“authorId“）?rs.getString（“firstName“）?rs.getString（“l(fā)astName“））;
//				return?model;
//			}
//		}）;
		return?queryBySql（“select?*?from?authors“?new?AuthorRowMapper（））;
	}
	
	class?AuthorRowMapper?implements?IRowMapper?{
		public?object?mappingRow（ResultSet?rs）?throws?SQLException?{
			AuthorModel?model?=?new?AuthorModel（rs.getInt（“authorId“）?rs
					.getString（“firstName“）?rs.getString（“l(fā)astName“））;
			return?model;
		}
	}
	

}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????626??2009-12-12?11:16??圖書管理系統(tǒng)\bms\.classpath

?????文件????????282??2009-12-13?21:40??圖書管理系統(tǒng)\bms\.mymetadata

?????文件???????1221??2008-08-16?16:42??圖書管理系統(tǒng)\bms\.project

?????文件????????136??2008-08-24?09:31??圖書管理系統(tǒng)\bms\.settings\org.eclipse.core.resources.prefs

?????文件????????629??2008-08-16?17:31??圖書管理系統(tǒng)\bms\.settings\org.eclipse.jdt.core.prefs

?????文件?????????99??2008-08-16?17:31??圖書管理系統(tǒng)\bms\.settings\org.eclipse.jdt.ui.prefs

?????文件???????2127??2008-08-17?11:09??圖書管理系統(tǒng)\bms\src\com\runwit\books\db\AuthorDAO.java

?????文件???????1802??2008-08-17?12:48??圖書管理系統(tǒng)\bms\src\com\runwit\books\db\PublisherDAO.java

?????文件???????8158??2008-08-22?10:41??圖書管理系統(tǒng)\bms\src\com\runwit\books\db\titleDAO.java

?????文件???????2776??2008-08-22?23:21??圖書管理系統(tǒng)\bms\src\com\runwit\books\db\UserDAO.java

?????文件????????832??2008-08-16?17:30??圖書管理系統(tǒng)\bms\src\com\runwit\books\model\AuthorModel.java

?????文件????????699??2008-08-17?12:44??圖書管理系統(tǒng)\bms\src\com\runwit\books\model\PublisherModel.java

?????文件???????2408??2008-08-17?20:48??圖書管理系統(tǒng)\bms\src\com\runwit\books\model\titleModel.java

?????文件????????904??2008-08-22?23:04??圖書管理系統(tǒng)\bms\src\com\runwit\books\model\UserModel.java

?????文件???????4373??2008-08-17?16:44??圖書管理系統(tǒng)\bms\src\com\runwit\common\db\baseDAO.java

?????文件???????2013??2009-12-13?21:50??圖書管理系統(tǒng)\bms\src\com\runwit\common\db\DbConnection.java

?????文件????????212??2008-08-17?16:38??圖書管理系統(tǒng)\bms\src\com\runwit\common\db\IConnectionCreator.java

?????文件????????214??2008-08-16?20:22??圖書管理系統(tǒng)\bms\src\com\runwit\common\db\IParamBinding.java

?????文件????????195??2008-08-16?19:58??圖書管理系統(tǒng)\bms\src\com\runwit\common\db\IRowMapper.java

?????文件???????2093??2008-08-21?16:25??圖書管理系統(tǒng)\bms\src\com\runwit\common\util\PageUtil.java

?????文件????????735??2008-08-22?23:16??圖書管理系統(tǒng)\bms\src\com\runwit\common\util\ParamUtil.java

?????文件????????514??2008-08-17?11:17??圖書管理系統(tǒng)\bms\src\log4j.properties

?????文件????????492??2009-12-12?11:17??圖書管理系統(tǒng)\bms\WebRoot\authors\add.jsp

?????文件????????255??2008-08-16?17:37??圖書管理系統(tǒng)\bms\WebRoot\authors\delete.jsp

?????文件???????3550??2009-12-13?21:44??圖書管理系統(tǒng)\bms\WebRoot\authors\index.jsp

?????文件???????1462??2009-12-13?21:44??圖書管理系統(tǒng)\bms\WebRoot\authors\modify.jsp

?????文件????????570??2008-08-17?12:04??圖書管理系統(tǒng)\bms\WebRoot\authors\update.jsp

?????文件???????5667??2009-12-13?21:43??圖書管理系統(tǒng)\bms\WebRoot\books\add.jsp

?????文件????????983??2008-08-21?12:17??圖書管理系統(tǒng)\bms\WebRoot\books\add_do.jsp

?????文件???????2030??2009-12-13?21:43??圖書管理系統(tǒng)\bms\WebRoot\books\bookdetails.jsp

............此處省略94個(gè)文件信息