?? memberdaoimpljdbc.java
字號:
// @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, 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, memberLastLogon);
statement.setInt(14, memberOption);
statement.setInt(15, memberStatus);
statement.setString(16, memberActivateCode);
statement.setString(17, memberTempPassword);
statement.setInt(18, memberMessageCount);
statement.setInt(19, memberMessageOption);
statement.setInt(20, memberPostsPerPage);
statement.setInt(21, memberWarnCount);
statement.setInt(22, memberVoteCount);
statement.setInt(23, memberVoteTotalStars);
statement.setInt(24, memberRewardPoints);
statement.setString(25, memberTitle);
statement.setInt(26, memberTimeZone);
statement.setString(27, memberSignature);
statement.setString(28, memberAvatar);
statement.setString(29, memberSkin);
statement.setString(30, memberLanguage);
statement.setString(31, memberFirstname);
statement.setString(32, memberLastname);
statement.setInt(33, memberGender);
statement.setDate(34, memberBirthday);
statement.setString(35, memberAddress);
statement.setString(36, memberCity);
statement.setString(37, memberState);
statement.setString(38, memberCountry);
statement.setString(39, memberPhone);
statement.setString(40, memberMobile);
statement.setString(41, memberFax);
statement.setString(42, memberCareer);
statement.setString(43, memberHomepage);
statement.setString(44, memberYahoo);
statement.setString(45, memberAol);
statement.setString(46, memberIcq);
statement.setString(47, memberMsn);
statement.setString(48, memberCoolLink1);
statement.setString(49, 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, int 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.setInt(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
}
}
Connection connection = null;
PreparedStatement statement = null;
StringBuffer sql = new StringBuffer(512);
sql.append("UPDATE " + TABLE_NAME + " SET MemberEmail = ?");
sql.append(" WHERE MemberID = ?");
try {
connection = DBUtils.getConnection();
statement = connection.prepareStatement(sql.toString());
// // column(s) to update
statement.setString(1, memberEmail);
// primary key column(s)
statement.setInt(2, 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.updateEmail.");
} finally {
DBUtils.closeStatement(statement);
DBUtils.closeConnection(connection);
}
}
/*
* Included columns: MemberPassword
* Excluded columns: MemberID, MemberName, MemberFirstEmail, MemberEmail, MemberEmailVisible,
* MemberNameVisible, MemberFirstIP, MemberLastIP, MemberViewCount, MemberPostCount,
* MemberCreationDate, MemberModifiedDate, MemberLastLogon, MemberOption, MemberStatus,
* MemberActivateCode, MemberTempPassword, MemberMessageCount, MemberMessageOption, MemberPostsPerPage,
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -