accountsqlmapdao.java

来自「Java/J2EE框架Jdon-Framework系统的源代码」· Java 代码 · 共 56 行

/**
 * User: Clinton Begin
 * Date: Jul 13, 2003
 * Time: 7:20:13 PM
 */
package com.jdon.framework.samples.jpetstore.persistence.dao.sqlmapdao;

import java.sql.SQLException;
import java.util.List;

import com.ibatis.sqlmap.client.SqlMapExecutor;
import com.jdon.framework.samples.jpetstore.domain.Account;
import com.jdon.framework.samples.jpetstore.persistence.dao.SqlMapDaoTemplateFactory;
import com.jdon.framework.samples.jpetstore.persistence.dao.iface.AccountDao;

public class AccountSqlMapDao implements AccountDao {
 
  private SqlMapExecutor sqlMapDaoTemplate;
    
  public AccountSqlMapDao(SqlMapDaoTemplateFactory sqlMapDaoTemplateFactory) {
      sqlMapDaoTemplate = sqlMapDaoTemplateFactory.getSqlMapDaoTemp();
  }

  public Account getAccount(String username) throws SQLException{
    return (Account)sqlMapDaoTemplate.queryForObject("getAccountByUsername", username);
  }

  public List getUsernameList() throws SQLException{
    return sqlMapDaoTemplate.queryForList("getUsernameList", null);
  }

  public Account getAccount(String username, String password) throws SQLException{
    Account account = new Account();
    account.setUsername(username);
    account.setPassword(password);
    return (Account) sqlMapDaoTemplate.queryForObject("getAccountByUsernameAndPassword", account);
  }
 
  public void insertAccount(Account account) throws SQLException{
      sqlMapDaoTemplate.update("insertAccount", account);
      sqlMapDaoTemplate.update("insertProfile", account);
      sqlMapDaoTemplate.update("insertSignon", account);
  }

  public void updateAccount(Account account)throws SQLException {
      sqlMapDaoTemplate.update("updateAccount", account);
      sqlMapDaoTemplate.update("updateProfile", account);

    if (account.getPassword() != null && account.getPassword().length() > 0) {
        sqlMapDaoTemplate.update("updateSignon", account);
    }
  }


}