📄 memberdaoimpljdbc.java
字号:
* MemberActivateCode, MemberTempPassword, MemberMessageCount, MemberMessageOption, MemberPostsPerPage,
* MemberWarnCount, MemberVoteCount, MemberVoteTotalStars, MemberRewardPoints, MemberTitle,
* MemberTimeZone, MemberSignature, MemberAvatar, MemberSkin, MemberLanguage,
* MemberFirstname, MemberLastname, MemberGender, MemberBirthday, MemberAddress,
* MemberCity, MemberState, MemberCountry, MemberPhone, MemberMobile,
* MemberFax, MemberCareer, MemberHomepage, MemberYahoo, MemberAol,
* MemberIcq, MemberMsn, MemberCoolLink1, MemberCoolLink2
* Excluded columns: MemberID
*/
public void create(String memberName, String memberPassword, String memberFirstEmail,
String memberEmail, int memberEmailVisible, int memberNameVisible,
String memberFirstIP, String memberLastIP, int memberViewCount,
int memberPostCount, Timestamp memberCreationDate, Timestamp memberModifiedDate, Timestamp memberExpireDate,
Timestamp memberLastLogon, int memberOption, int memberStatus,
String memberActivateCode, String memberTempPassword, int memberMessageCount,
int memberMessageOption, int memberPostsPerPage, int memberWarnCount,
int memberVoteCount, int memberVoteTotalStars, int memberRewardPoints,
String memberTitle, double memberTimeZone, String memberSignature,
String memberAvatar, String memberSkin, String memberLanguage,
String memberFirstname, String memberLastname, int memberGender,
Date memberBirthday, String memberAddress, String memberCity,
String memberState, String memberCountry, String memberPhone,
String memberMobile, String memberFax, String memberCareer,
String memberHomepage, String memberYahoo, String memberAol,
String memberIcq, String memberMsn, String memberCoolLink1,
String memberCoolLink2)
throws CreateException, DatabaseException, DuplicateKeyException {
// @todo: Comment this try-catch block if the needed columns dont have attribute 'include'
// If this is the case, then it is highly recommended that you regenerate this method with the attribute 'include' turned on
try {
//Check if alternate key already exists
findByAlternateKey_MemberName(memberName);
//If so, then we have to throw an exception
throw new DuplicateKeyException("Alternate key already exists. Cannot create new Member with the same [MemberName] (" + memberName + ").");
} catch(ObjectNotFoundException e) {
//Otherwise we can go ahead
}
// @todo: Comment this try-catch block if the needed columns dont have attribute 'include'
// If this is the case, then it is highly recommended that you regenerate this method with the attribute 'include' turned on
try {
//Check if alternate key already exists
findByAlternateKey_MemberEmail(memberEmail);
//If so, then we have to throw an exception
throw new DuplicateKeyException("Alternate key already exists. Cannot create new Member with the same [MemberEmail] (" + memberEmail + ").");
} catch(ObjectNotFoundException e) {
//Otherwise we can go ahead
}
Connection connection = null;
PreparedStatement statement = null;
StringBuffer sql = new StringBuffer(512);
sql.append("INSERT INTO " + TABLE_NAME + " (MemberName, MemberPassword, MemberFirstEmail, MemberEmail, MemberEmailVisible, MemberNameVisible, MemberFirstIP, MemberLastIP, MemberViewCount, MemberPostCount, MemberCreationDate, MemberModifiedDate, MemberExpireDate, MemberLastLogon, MemberOption, MemberStatus, MemberActivateCode, MemberTempPassword, MemberMessageCount, MemberMessageOption, MemberPostsPerPage, MemberWarnCount, MemberVoteCount, MemberVoteTotalStars, MemberRewardPoints, MemberTitle, MemberTimeZone, MemberSignature, MemberAvatar, MemberSkin, MemberLanguage, MemberFirstname, MemberLastname, MemberGender, MemberBirthday, MemberAddress, MemberCity, MemberState, MemberCountry, MemberPhone, MemberMobile, MemberFax, MemberCareer, MemberHomepage, MemberYahoo, MemberAol, MemberIcq, MemberMsn, MemberCoolLink1, MemberCoolLink2)");
sql.append(" VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
try {
connection = DBUtils.getConnection();
statement = connection.prepareStatement(sql.toString());
statement.setString(1, memberName);
statement.setString(2, memberPassword);
statement.setString(3, memberFirstEmail);
statement.setString(4, memberEmail);
statement.setInt(5, memberEmailVisible);
statement.setInt(6, memberNameVisible);
statement.setString(7, memberFirstIP);
statement.setString(8, memberLastIP);
statement.setInt(9, memberViewCount);
statement.setInt(10, memberPostCount);
statement.setTimestamp(11, memberCreationDate);
statement.setTimestamp(12, memberModifiedDate);
statement.setTimestamp(13, memberExpireDate);
statement.setTimestamp(14, memberLastLogon);
statement.setInt(15, memberOption);
statement.setInt(16, memberStatus);
statement.setString(17, memberActivateCode);
statement.setString(18, memberTempPassword);
statement.setInt(19, memberMessageCount);
statement.setInt(20, memberMessageOption);
statement.setInt(21, memberPostsPerPage);
statement.setInt(22, memberWarnCount);
statement.setInt(23, memberVoteCount);
statement.setInt(24, memberVoteTotalStars);
statement.setInt(25, memberRewardPoints);
statement.setString(26, memberTitle);
statement.setDouble(27, memberTimeZone);
statement.setString(28, memberSignature);
statement.setString(29, memberAvatar);
statement.setString(30, memberSkin);
statement.setString(31, memberLanguage);
statement.setString(32, memberFirstname);
statement.setString(33, memberLastname);
statement.setInt(34, memberGender);
statement.setDate(35, memberBirthday);
statement.setString(36, memberAddress);
statement.setString(37, memberCity);
statement.setString(38, memberState);
statement.setString(39, memberCountry);
statement.setString(40, memberPhone);
statement.setString(41, memberMobile);
statement.setString(42, memberFax);
statement.setString(43, memberCareer);
statement.setString(44, memberHomepage);
statement.setString(45, memberYahoo);
statement.setString(46, memberAol);
statement.setString(47, memberIcq);
statement.setString(48, memberMsn);
statement.setString(49, memberCoolLink1);
statement.setString(50, memberCoolLink2);
if (statement.executeUpdate() != 1) {
throw new CreateException("Error adding a row into table 'Member'.");
}
m_dirty = true;
} catch(SQLException sqle) {
log.error("Sql Execution Error!", sqle);
throw new DatabaseException("Error executing SQL in MemberDAOImplJDBC.create.");
} finally {
DBUtils.closeStatement(statement);
DBUtils.closeConnection(connection);
}
}
/*
* Included columns: MemberEmailVisible, MemberNameVisible, MemberModifiedDate, MemberOption, MemberStatus,
* MemberMessageOption, MemberPostsPerPage, MemberTimeZone, MemberSkin, MemberLanguage,
* MemberFirstname, MemberLastname, MemberGender, MemberBirthday, MemberAddress,
* MemberCity, MemberState, MemberCountry, MemberPhone, MemberMobile,
* MemberFax, MemberCareer, MemberHomepage, MemberYahoo, MemberAol,
* MemberIcq, MemberMsn, MemberCoolLink1, MemberCoolLink2
* Excluded columns: MemberID, MemberName, MemberPassword, MemberFirstEmail, MemberEmail,
* MemberFirstIP, MemberLastIP, MemberViewCount, MemberPostCount, MemberCreationDate,
* MemberLastLogon, MemberActivateCode, MemberTempPassword, MemberMessageCount, MemberWarnCount,
* MemberVoteCount, MemberVoteTotalStars, MemberRewardPoints, MemberTitle, MemberSignature,
* MemberAvatar
*/
public void update(int memberID, // primary key
int memberEmailVisible, int memberNameVisible, Timestamp memberModifiedDate,
int memberOption, int memberStatus, int memberMessageOption,
int memberPostsPerPage, double memberTimeZone, String memberSkin,
String memberLanguage, String memberFirstname, String memberLastname,
int memberGender, Date memberBirthday, String memberAddress,
String memberCity, String memberState, String memberCountry,
String memberPhone, String memberMobile, String memberFax,
String memberCareer, String memberHomepage, String memberYahoo,
String memberAol, String memberIcq, String memberMsn,
String memberCoolLink1, String memberCoolLink2)
throws ObjectNotFoundException, DatabaseException {
Connection connection = null;
PreparedStatement statement = null;
StringBuffer sql = new StringBuffer(512);
sql.append("UPDATE " + TABLE_NAME + " SET MemberEmailVisible = ?, MemberNameVisible = ?, MemberModifiedDate = ?, MemberOption = ?, MemberStatus = ?, MemberMessageOption = ?, MemberPostsPerPage = ?, MemberTimeZone = ?, MemberSkin = ?, MemberLanguage = ?, MemberFirstname = ?, MemberLastname = ?, MemberGender = ?, MemberBirthday = ?, MemberAddress = ?, MemberCity = ?, MemberState = ?, MemberCountry = ?, MemberPhone = ?, MemberMobile = ?, MemberFax = ?, MemberCareer = ?, MemberHomepage = ?, MemberYahoo = ?, MemberAol = ?, MemberIcq = ?, MemberMsn = ?, MemberCoolLink1 = ?, MemberCoolLink2 = ?");
sql.append(" WHERE MemberID = ?");
try {
connection = DBUtils.getConnection();
statement = connection.prepareStatement(sql.toString());
// // column(s) to update
statement.setInt(1, memberEmailVisible);
statement.setInt(2, memberNameVisible);
statement.setTimestamp(3, memberModifiedDate);
statement.setInt(4, memberOption);
statement.setInt(5, memberStatus);
statement.setInt(6, memberMessageOption);
statement.setInt(7, memberPostsPerPage);
statement.setDouble(8, memberTimeZone);
statement.setString(9, memberSkin);
statement.setString(10, memberLanguage);
statement.setString(11, memberFirstname);
statement.setString(12, memberLastname);
statement.setInt(13, memberGender);
statement.setDate(14, memberBirthday);
statement.setString(15, memberAddress);
statement.setString(16, memberCity);
statement.setString(17, memberState);
statement.setString(18, memberCountry);
statement.setString(19, memberPhone);
statement.setString(20, memberMobile);
statement.setString(21, memberFax);
statement.setString(22, memberCareer);
statement.setString(23, memberHomepage);
statement.setString(24, memberYahoo);
statement.setString(25, memberAol);
statement.setString(26, memberIcq);
statement.setString(27, memberMsn);
statement.setString(28, memberCoolLink1);
statement.setString(29, memberCoolLink2);
// primary key column(s)
statement.setInt(30, memberID);
if (statement.executeUpdate() != 1) {
throw new ObjectNotFoundException("Cannot update table Member where primary key = (" + memberID + ").");
}
m_dirty = true;
} catch(SQLException sqle) {
log.error("Sql Execution Error!", sqle);
throw new DatabaseException("Error executing SQL in MemberDAOImplJDBC.update.");
} finally {
DBUtils.closeStatement(statement);
DBUtils.closeConnection(connection);
}
}
/*
* Included columns: MemberEmail
* Excluded columns: MemberID, MemberName, MemberPassword, MemberFirstEmail, MemberEmailVisible,
* MemberNameVisible, MemberFirstIP, MemberLastIP, MemberViewCount, MemberPostCount,
* MemberCreationDate, MemberModifiedDate, MemberLastLogon, MemberOption, MemberStatus,
* MemberActivateCode, MemberTempPassword, MemberMessageCount, MemberMessageOption, MemberPostsPerPage,
* MemberWarnCount, MemberVoteCount, MemberVoteTotalStars, MemberRewardPoints, MemberTitle,
* MemberTimeZone, MemberSignature, MemberAvatar, MemberSkin, MemberLanguage,
* MemberFirstname, MemberLastname, MemberGender, MemberBirthday, MemberAddress,
* MemberCity, MemberState, MemberCountry, MemberPhone, MemberMobile,
* MemberFax, MemberCareer, MemberHomepage, MemberYahoo, MemberAol,
* MemberIcq, MemberMsn, MemberCoolLink1, MemberCoolLink2
*/
public void updateEmail(int memberID, // primary key
String memberEmail)
throws ObjectNotFoundException, DatabaseException, DuplicateKeyException {
//@todo: use a more efficent method
MemberBean bean = getMember_forViewCurrentMember(memberID); // @todo: comment or delete this line if no alternate key are included
if ( !memberEmail.equals(bean.getMemberEmail()) ) {
// Member tries to change its alternate key <MemberEmail>, so we must check if it already exist
try {
findByAlternateKey_MemberEmail(memberEmail);
throw new DuplicateKeyException("Alternate key [MemberEmail] (" + memberEmail + ")already exists. Cannot update Member.");
} catch(ObjectNotFoundException e) {
//Otherwise we can go ahead
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -