package org.csu.myjpetstore.persistence.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import org.csu.myjpetstore.domain.Account;
import org.csu.myjpetstore.persistence.AccountDAO;
import org.csu.myjpetstore.persistence.DBUtil;
public class AccountDAOImpl implements AccountDAO{
@Override
public Account getAccountByUsername(String username) {
Account account = null;
try {
Connection connection= DBUtil.getConnection();
PreparedStatement preparedStatement = connection.prepareStatement(getAccountByUsernameString);
preparedStatement.setString(1, username);
ResultSet resultSet = preparedStatement.executeQuery();
if (resultSet.next()) {
account = new Account();
account.setUsername(resultSet.getString(1));
account.setEmail(resultSet.getString(2));
account.setFirstName(resultSet.getString(3));
account.setLastName(resultSet.getString(4));
account.setStatus(resultSet.getString(5));
account.setAddress1(resultSet.getString(6));
account.setAddress2(resultSet.getString(7));
account.setCity(resultSet.getString(8));
account.setState(resultSet.getString(9));
account.setZip(resultSet.getString(10));
account.setCountry(resultSet.getString(11));
account.setPhone(resultSet.getString(12));
account.setLanguagePreference(resultSet.getString(13));
account.setFavouriteCategoryId(resultSet.getString(14));
account.setListOption(resultSet.getBoolean(15));
account.setBannerOption(resultSet.getBoolean(16));
account.setBannerName(resultSet.getString(17));
}
DBUtil.closeResultSet(resultSet);
DBUtil.closePreparedStatement(preparedStatement);
DBUtil.closeConnection(connection);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return account;
}
@Override
public Account getAccountByUsernameAndPassword(Account account) {
// TODO Auto-generated method stub
Account account2 = null;
try {
Connection connection = DBUtil.getConnection();
PreparedStatement preparedStatement = connection.prepareStatement(getAccountByUsernameAndPasswordString);
preparedStatement.setString(1, account.getUsername());
preparedStatement.setString(2, account.getPassword());
ResultSet resultSet = preparedStatement.executeQuery();
if (resultSet.next()) {
account2 = new Account();
account2.setUsername(resultSet.getString(1));
account2.setEmail(resultSet.getString(2));
account2.setFirstName(resultSet.getString(3));
account2.setLastName(resultSet.getString(4));
account2.setStatus(resultSet.getString(5));
account2.setAddress1(resultSet.getString(6));
account2.setAddress2(resultSet.getString(7));
account2.setCity(resultSet.getString(8));
account2.setState(resultSet.getString(9));
account2.setZip(resultSet.getString(10));
account2.setCountry(resultSet.getString(11));
account2.setPhone(resultSet.getString(12));
account2.setLanguagePreference(resultSet.getString(13));
account2.setFavouriteCategoryId(resultSet.getString(14));
account2.setListOption(resultSet.getBoolean(15));
account2.setBannerOption(resultSet.getBoolean(16));
account2.setBannerName(resultSet.getString(17));
}
DBUtil.closeResultSet(resultSet);
DBUtil.closePreparedStatement(preparedStatement);
DBUtil.closeConnection(connection);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return account2;
}
@Override
public void insertAccount(Account account) {
try {
Connection connection = DBUtil.getConnection();
PreparedStatement preparedStatement = connection.prepareStatement(insertAccountString);
preparedStatement.setString(1, account.getEmail());
preparedStatement.setString(2, account.getFirstName());
preparedStatement.setString(3, account.getLastName());
preparedStatement.setString(4, account.getStatus());
preparedStatement.setString(5, account.getAddress1());
preparedStatement.setString(6, account.getAddress2());
preparedStatement.setString(7, account.getCity());
preparedStatement.setString(8, account.getState());
preparedStatement.setString(9, account.getZip());
preparedStatement.setString(10, account.getCountry());
preparedStatement.setString(11, account.getPhone());
preparedStatement.setString(12, account.getUsername());
preparedStatement.executeUpdate();
DBUtil.closePreparedStatement(preparedStatement);
DBUtil.closeConnection(connection);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
@Override
public void insertProfile(Account account) {
// TODO Auto-generated method stub
try {
Connection connection = DBUtil.getConnection();
PreparedStatement preparedStatement = connection.prepareStatement(insertProfileString);
preparedStatement.setString(1, account.getLanguagePreference());
preparedStatement.setString(2, account.getFavouriteCategoryId());
preparedStatement.setString(3, account.getUsername());
preparedStatement.executeUpdate();
DBUtil.closePreparedStatement(preparedStatement);
DBUtil.closeConnection(connection);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
@Override
public void insertSignon(Account account) {
// TODO Auto-generated method stub
try {
Connection connection = DBUtil.getConnection();
PreparedStatement preparedStatement = connection.prepareStatement(insertSignonString);
preparedStatement.setString(1, account.getPassword());
preparedStatement.setString(2, account.getUsername());
preparedStatement.executeUpdate();
DBUtil.closePreparedStatement(preparedStatement);
DBUtil.closeConnection(connection);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
@Override
public void updateAccount(Account account) {
// TODO Auto-generated method stub
try {
Connection connection = DBUtil.getConnection();
PreparedStatement preparedStatement = connection.prepareStatement(updateAccountString);
preparedStatement.setString(1, account.getEmail());
preparedStatement.setString(2, account.getFirstName());
preparedStatement.setString(3, account.getLastName());
preparedStatement.setString(4, account.getStatus());
preparedStatement.setString(5, account.getAddress1());
preparedStatement.setString(6, account.getAddress2());
preparedStatement.setString(7, account.getCity());
preparedStatement.setString(8, account.getState());
preparedStatement.setString(9, account.getZip());
preparedStatement.setString(10, account.getCountry());
preparedStatement.setString(11, account.getPhone());
preparedStatement.setString(12, account.getUsername());
preparedStatement.executeUpdate();
DBUtil.closePreparedStatement(preparedStatement);
DBUtil.closeConnection(connection);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
@Override
public void updateProfile(Account account) {
// TODO Auto-generated method stub
try {
Connection connection = DBUtil.getConnection();
PreparedStatement preparedStatement = connection.prepareStatement(updateProfileString);
preparedStatement.setString(1, account.getLanguagePreference());
preparedStatement.setString(2, account.getFavouriteCategoryId());
preparedStatement.setString(3, account.getUsername());
preparedStatement.executeUpdate();
DBUtil.closePreparedStatement(preparedStatement);
DBUtil.closeConnection(connection);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
@Override
public void updateSignon(Account account) {
// TODO
JpetStore用AJAX改进用户体验
5星 · 超过95%的资源 需积分: 5 185 浏览量
2014-12-22
12:43:14
上传
评论 4
收藏 1.19MB ZIP 举报 
JpetStore用AJAX改进用户体验 （167个子文件） 
Order.class 8KB AccountDAOImpl.class 7KB OrderDAOImpl.class 7KB ItemDAOImpl.class 6KB OrderService.class 4KB Cart.class 4KB Account.class 4KB Item.class 3KB ProductDAOImpl.class 3KB SignonActionServlet.class 3KB LineItemDAOImpl.class 3KB CategoryDAOImpl.class 3KB ContitueActionServlet.class 3KB AutoCompleteServlet.class 3KB CategoryService.class 3KB UpdateCartActionServlet.class 3KB AccountDAO.class 3KB LineItem.class 3KB CheckoutActionServlet.class 3KB CartViewServlet.class 2KB ConfirmShipAddressServlet.class 2KB CategoryViewServlet.class 2KB ProductViewServlet.class 2KB SequenceDAOImpl.class 2KB SearchProductServlet.class 2KB usernameIsExistServlet.class 2KB OrderDAO.class 2KB RemoveActionServlet.class 2KB ItemViewServlet.class 2KB DBUtil.class 2KB FloatWindowServlet.class 2KB AccountService.class 2KB CartItem.class 2KB SignoutActionServlet.class 2KB ItemDAO.class 2KB EditAccountFormServlet.class 1KB NewAccountFormServlet.class 1KB ConfirmOrderActionServlet.class 1KB SignonFormServlet.class 1KB Product.class 1KB CartIconServlet.class 1KB MainServlet.class 1KB Category.class 1KB Sequence.class 982B ProductDAO.class 897B LineItemDAO.class 658B CategoryDAO.class 609B SequenceDAO.class 521B .classpath 1KB org.eclipse.wst.common.component 492B org.eclipse.wst.jsdt.ui.superType.container 49B jpetstore.css 5KB
splash.gif 35KB fish2.gif 13KB lizard1.gif 13KB snake1.gif 13KB cat1.gif 12KB dog5.gif 12KB cat2.gif 12KB dog6.gif 12KB fish1.gif 12KB dog2.gif 12KB dog4.gif 12KB dog3.gif 12KB dog1.gif 12KB bird1.gif 12KB fish3.gif 11KB bird2.gif 11KB fish4.gif 11KB banner_cats.gif 7KB banner_reptiles.gif 6KB banner_fish.gif 6KB banner_birds.gif 6KB banner_dogs.gif 6KB logo-topbar.gif 4KB poweredby.gif 3KB reptiles_icon.gif 669B birds_icon.gif 471B dogs_icon.gif 468B fish_icon.gif 439B cats_icon.gif 408B sm_reptiles.gif 398B sm_dogs.gif 306B dogs.gif 306B sm_cats.gif 289B sm_fish.gif 271B fish.gif 271B sm_birds.gif 251B cart.gif 96B separator.gif 46B
index.html 479B
mysql-connector-java-5.1.29-bin.jar 856KB AccountDAOImpl.java 8KB Order.java 6KB OrderDAOImpl.java 6KB ItemDAOImpl.java 5KB Account.java 3KB ProductDAOImpl.java 3KB OrderService.java 3KB AccountDAO.java 3KB共 167 条
- 1
- 2
资源评论
zhaoyali19922015-05-24虽然很简单，还不错
有代码的堂吉诃德2018-06-18虽然很简单，还不错- qq_210958092015-06-17好像有jstl问题的样子
- ly25808282015-07-13用着还行，，做了ajax的
