import org.beangle.orm.jdbc.Console;
import org.beangle.orm.hibernate.ConfigurationHelper;
import org.beangle.orm.hibernate.sql.UpdateBuilder;
public class DatabaseOperations {
public void updateUsername(String oldUsername, String newUsername) {
ConfigurationHelper helper = new ConfigurationHelper("hibernate.cfg.xml");
SessionFactory sessionFactory = helper.buildSessionFactory();
Session session = sessionFactory.openSession();
Transaction transaction = session.beginTransaction();
UpdateBuilder updateBuilder = new UpdateBuilder("User");
updateBuilder.set("username", newUsername);
updateBuilder.where("username = ?", oldUsername);
session.executeUpdate(updateBuilder.toQuery());
session.flush();
transaction.commit();
Console.showSql();
session.close();
sessionFactory.close();
}
}
