数据库为SQL Server 2000,创建数据库名为addressbook,同时创建名称为addressbook的ODBC连接,使用查询管理器导入RelationinfoTXL.sql。
代码片段和文件信息
属性 大小 日期 时间 名称
----------- --------- ---------- ----- ----
......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.settingsorg.eclipse.jdt.core.prefs
......R 364 2006-08-07 22:02 addressbook.settingsorg.eclipse.jst.common.project.facet.core.prefs
......R 269 2006-08-07 22:02 addressbook.settingsorg.eclipse.wst.common.project.facet.core.xml
......R 32784 2005-11-19 03:27 addressbookRelationTXL.cdb
......R 33916 2005-09-19 05:01 addressbookRelationTXL.cdm
......R 59249 2005-11-19 03:27 addressbookRelationTXL.pdb
......R 59308 2005-09-19 05:01 addressbookRelationTXL.pdm
......R 21241 2005-09-19 05:04 addressbookRelationTxl.xml
......R 2639 2005-09-19 21:13 addressbookRelationinfoTXL.sql
......R 1812 2006-08-07 22:08 addressbookWebContentFriend.jsp
......R 1559 2006-08-07 22:08 addressbookWebContentFriendEdit.jsp
......R 180 2006-08-07 22:08 addressbookWebContentFriendFindAll.jsp
......R 289 2006-08-07 22:08 addressbookWebContentFriendFindByGroup1.jsp
......R 291 2006-08-07 22:08 addressbookWebContentFriendFindByPrimaryKey.jsp
......R 309 2006-08-07 22:08 addressbookWebContentFriendFindWhereAddressEquals.jsp
......R 225 2006-08-07 22:08 addressbookWebContentFriendFindWhereAgeEquals.jsp
......R 301 2006-08-07 22:08 addressbookWebContentFriendFindWhereEmailEquals.jsp
......R 309 2006-08-07 22:08 addressbookWebContentFriendFindWhereGroupidEquals.jsp
......R 297 2006-08-07 22:08 addressbookWebContentFriendFindWhereNameEquals.jsp
......R 297 2006-08-07 22:08 addressbookWebContentFriendFindWhereNoteEquals.jsp
......R 301 2006-08-07 22:08 addressbookWebContentFriendFindWherePhoneEquals.jsp
......R 329 2006-08-07 22:08 addressbookWebContentFriendFindWhereProfessionalEquals.jsp
......R 325 2006-08-07 22:08 addressbookWebContentFriendFindWhereScholarshipEquals.jsp
......R 293 2006-08-07 22:08 addressbookWebContentFriendFindWhereSexEquals.jsp
......R 297 2006-08-07 22:08 addressbookWebContentFriendFindWhereXmjpEquals.jsp
......R 1246 2006-08-07 22:08 addressbookWebContentFriendResult.jsp
......R 1680 2006-08-07 22:08 addressbookWebContentFriendView.jsp
............此处省略203个文件信息
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;
/**
* 返回所有的记录,满足条件 ‘age = :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;
/**
* 返回所有的记录,满足条件 ‘address = :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;
/**
* 设置 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.settingsorg.eclipse.jdt.core.prefs
......R 364 2006-08-07 22:02 addressbook.settingsorg.eclipse.jst.common.project.facet.core.prefs
......R 269 2006-08-07 22:02 addressbook.settingsorg.eclipse.wst.common.project.facet.core.xm
......R 32784 2005-11-19 03:27 addressbookRelationTXL.cdb
......R 33916 2005-09-19 05:01 addressbookRelationTXL.cdm
......R 59249 2005-11-19 03:27 addressbookRelationTXL.pdb
......R 59308 2005-09-19 05:01 addressbookRelationTXL.pdm
......R 21241 2005-09-19 05:04 addressbookRelationTxl.xm
......R 2639 2005-09-19 21:13 addressbookRelationinfoTXL.sql
......R 1812 2006-08-07 22:08 addressbookWebContentFriend.jsp
......R 1559 2006-08-07 22:08 addressbookWebContentFriendEdit.jsp
......R 180 2006-08-07 22:08 addressbookWebContentFriendFindAll.jsp
......R 289 2006-08-07 22:08 addressbookWebContentFriendFindByGroup1.jsp
......R 291 2006-08-07 22:08 addressbookWebContentFriendFindByPrimaryKey.jsp
......R 309 2006-08-07 22:08 addressbookWebContentFriendFindWhereAddressEquals.jsp
......R 225 2006-08-07 22:08 addressbookWebContentFriendFindWhereAgeEquals.jsp
......R 301 2006-08-07 22:08 addressbookWebContentFriendFindWhereEmailEquals.jsp
......R 309 2006-08-07 22:08 addressbookWebContentFriendFindWhereGroupidEquals.jsp
......R 297 2006-08-07 22:08 addressbookWebContentFriendFindWhereNameEquals.jsp
......R 297 2006-08-07 22:08 addressbookWebContentFriendFindWhereNoteEquals.jsp
......R 301 2006-08-07 22:08 addressbookWebContentFriendFindWherePhoneEquals.jsp
......R 329 2006-08-07 22:08 addressbookWebContentFriendFindWhereProfessionalEquals.jsp
......R 325 2006-08-07 22:08 addressbookWebContentFriendFindWhereScholarshipEquals.jsp
......R 293 2006-08-07 22:08 addressbookWebContentFriendFindWhereSexEquals.jsp
......R 297 2006-08-07 22:08 addressbookWebContentFriendFindWhereXmjpEquals.jsp
......R 1246 2006-08-07 22:08 addressbookWebContentFriendResult.jsp
......R 1680 2006-08-07 22:08 addressbookWebContentFriendView.jsp
............此处省略203个文件信息
版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容, 请发送邮件举报,一经查实,本站将立刻删除。
评论列表(条)