public Account findAccountByEamil(String email) {
Account account = null;
String sql = "";
Connection conn = DBConnection.getConnection();
try {
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, email);
ResultSet rSet = pstmt.executeQuery();
if (rSet.next()) {
account = new Account();
account.setAccountNo(rSet.getInt(""));
account.setEmail(rSet.getString(""));
account.setRegDate(rSet.getString(""));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
if (conn != null)
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return account;
}
public boolean removeAccount(Account account) {
String sql = "";
Connection conn = DBConnection.getConnection();
try {
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, account.getEmail());
pstmt.setString(2, account.getPasswd());
if (pstmt.executeUpdate() == 1) return true;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
if (conn != null)
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return false;
}