資源簡介
數(shù)據(jù)庫為SQL Server 2000,創(chuàng)建數(shù)據(jù)庫名為addressbook,同時創(chuàng)建名稱為addressbook的ODBC連接,使用查詢管理器導(dǎo)入RelationinfoTXL.sql。

代碼片段和文件信息
package?com.relationinfo.txl.dao;
import?com.relationinfo.txl.dto.*;
import?com.relationinfo.txl.exceptions.*;
import?java.sql.CallableStatement;
public?interface?FriendDao
{
/**?
?*?增加新記錄到?friend?table.
?*/
public?FriendPk?insert(Friend?dto)?throws?FriendDaoException;
/**?
?*?更新單筆記錄?friend?table.
?*/
public?void?update(FriendPk?pk?Friend?dto)?throws?FriendDaoException;
/**?
?*?Deletes?a?single?row?in?the?friend?table.
?*/
public?void?delete(FriendPk?pk)?throws?FriendDaoException;
/**?
?*?返回符合指定主鍵值的記錄.
?*/
public?Friend?findByPrimaryKey(FriendPk?pk)?throws?FriendDaoException;
/**?
?*?返回所有的記錄,滿足條件?‘xmjp?=?:xmjp‘.
?*/
public?Friend?findByPrimaryKey(String?xmjp)?throws?FriendDaoException;
/**?
?*?返回所有的記錄,滿足條件?‘‘.
?*/
public?Friend[]?findAll()?throws?FriendDaoException;
/**?
?*?返回所有的記錄,滿足條件?‘groupid?=?:groupid‘.
?*/
public?Friend[]?findByGroup1(String?groupid)?throws?FriendDaoException;
/**?
?*?返回所有的記錄,滿足條件?‘xmjp?=?:xmjp‘.
?*/
public?Friend[]?findWhereXmjpEquals(String?xmjp)?throws?FriendDaoException;
/**?
?*?返回所有的記錄,滿足條件?‘groupid?=?:groupid‘.
?*/
public?Friend[]?findWhereGroupidEquals(String?groupid)?throws?FriendDaoException;
/**?
?*?返回所有的記錄,滿足條件?‘name?=?:name‘.
?*/
public?Friend[]?findWhereNameEquals(String?name)?throws?FriendDaoException;
/**?
?*?返回所有的記錄,滿足條件?‘a(chǎn)ge?=?:age‘.
?*/
public?Friend[]?findWhereAgeEquals(String?age)?throws?FriendDaoException;
/**?
?*?返回所有的記錄,滿足條件?‘sex?=?:sex‘.
?*/
public?Friend[]?findWhereSexEquals(String?sex)?throws?FriendDaoException;
/**?
?*?返回所有的記錄,滿足條件?‘Professional?=?:professional‘.
?*/
public?Friend[]?findWhereProfessionalEquals(String?professional)?throws?FriendDaoException;
/**?
?*?返回所有的記錄,滿足條件?‘Scholarship?=?:scholarship‘.
?*/
public?Friend[]?findWhereScholarshipEquals(String?scholarship)?throws?FriendDaoException;
/**?
?*?返回所有的記錄,滿足條件?‘a(chǎn)ddress?=?:address‘.
?*/
public?Friend[]?findWhereAddressEquals(String?address)?throws?FriendDaoException;
/**?
?*?返回所有的記錄,滿足條件?‘email?=?:email‘.
?*/
public?Friend[]?findWhereEmailEquals(String?email)?throws?FriendDaoException;
/**?
?*?返回所有的記錄,滿足條件?‘phone?=?:phone‘.
?*/
public?Friend[]?findWherePhoneEquals(String?phone)?throws?FriendDaoException;
/**?
?*?返回所有的記錄,滿足條件?‘note?=?:note‘.
?*/
public?Friend[]?findWhereNoteEquals(String?note)?throws?FriendDaoException;
/**?
?*?設(shè)置?maxRows
?*/
public?void?setMaxRows(int?maxRows);
/**?
?*?獲得?maxRows
?*/
public?int?getMaxRows();
/**?
?*?Returns?all?rows?from?the?friend?table?that?match?the?specified?arbitrary?SQL?statement
?*/
public?Friend[]?findByDynamicSelect(String?sql?object[]?sqlParams)?throws?FriendDaoException;
/**?
?*?Returns?all?rows?from?the?friend?table?that?match?the?specified?arbitrary?SQL?statement
?*/
public?Friend[]?findByDynamicWhere(String?sql?object[]?sqlParams)?throws?FriendDaoException;
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
????......R???????546??2006-08-07?22:10??addressbook\.classpath
????......R???????856??2006-08-07?22:02??addressbook\.project
????......R???????388??2006-08-07?22:02??addressbook\.settings\.component
????......R???????330??2006-08-07?22:02??addressbook\.settings\org.eclipse.jdt.core.prefs
????......R???????364??2006-08-07?22:02??addressbook\.settings\org.eclipse.jst.common.project.facet.core.prefs
????......R???????269??2006-08-07?22:02??addressbook\.settings\org.eclipse.wst.common.project.facet.core.xm
????......R?????32784??2005-11-19?03:27??addressbook\RelationTXL.cdb
????......R?????33916??2005-09-19?05:01??addressbook\RelationTXL.cdm
????......R?????59249??2005-11-19?03:27??addressbook\RelationTXL.pdb
????......R?????59308??2005-09-19?05:01??addressbook\RelationTXL.pdm
????......R?????21241??2005-09-19?05:04??addressbook\RelationTxl.xm
????......R??????2639??2005-09-19?21:13??addressbook\RelationinfoTXL.sql
????......R??????1812??2006-08-07?22:08??addressbook\WebContent\Friend.jsp
????......R??????1559??2006-08-07?22:08??addressbook\WebContent\FriendEdit.jsp
????......R???????180??2006-08-07?22:08??addressbook\WebContent\FriendFindAll.jsp
????......R???????289??2006-08-07?22:08??addressbook\WebContent\FriendFindByGroup1.jsp
????......R???????291??2006-08-07?22:08??addressbook\WebContent\FriendFindByPrimaryKey.jsp
????......R???????309??2006-08-07?22:08??addressbook\WebContent\FriendFindWhereAddressEquals.jsp
????......R???????225??2006-08-07?22:08??addressbook\WebContent\FriendFindWhereAgeEquals.jsp
????......R???????301??2006-08-07?22:08??addressbook\WebContent\FriendFindWhereEmailEquals.jsp
????......R???????309??2006-08-07?22:08??addressbook\WebContent\FriendFindWhereGroupidEquals.jsp
????......R???????297??2006-08-07?22:08??addressbook\WebContent\FriendFindWhereNameEquals.jsp
????......R???????297??2006-08-07?22:08??addressbook\WebContent\FriendFindWhereNoteEquals.jsp
????......R???????301??2006-08-07?22:08??addressbook\WebContent\FriendFindWherePhoneEquals.jsp
????......R???????329??2006-08-07?22:08??addressbook\WebContent\FriendFindWhereProfessionalEquals.jsp
????......R???????325??2006-08-07?22:08??addressbook\WebContent\FriendFindWhereScholarshipEquals.jsp
????......R???????293??2006-08-07?22:08??addressbook\WebContent\FriendFindWhereSexEquals.jsp
????......R???????297??2006-08-07?22:08??addressbook\WebContent\FriendFindWhereXmjpEquals.jsp
????......R??????1246??2006-08-07?22:08??addressbook\WebContent\FriendResult.jsp
????......R??????1680??2006-08-07?22:08??addressbook\WebContent\FriendView.jsp
............此處省略203個文件信息
- 上一篇:pvr 查看工具
- 下一篇:Android之改進版貪吃蛇
評論
共有 條評論