DAO
unknown
plain_text
a year ago
1.2 kB
4
Indexable
public void updateProfile(Account a) { String query = "update Account\n" + "set fullname = ?, email = ?, phone = ?, address= ? where uID = ?"; DAO dao = new DAO(); try { conn = new DBContext().getConnection(); //mo ket noi toi sql ps = conn.prepareStatement(query);//nem cau lenh query sang sql ps.setString(1, a.getFullname()); ps.setString(2, a.getEmail()); ps.setInt(3, a.getPhone()); ps.setString(4, a.getAddress()); ps.setInt(5, a.getId()); ps.executeUpdate(); } catch (Exception e) { } } public void updatePassword(int accId, String newPassword) { String query = "update Account\n" + "set password = ? where uID = ?"; try { conn = new DBContext().getConnection(); //mo ket noi toi sql ps = conn.prepareStatement(query);//nem cau lenh query sang sql ps.setString(1, newPassword); ps.setInt(2, accId); ps.executeUpdate(); } catch (Exception e) { } }
Editor is loading...
Leave a Comment