Java persistence using MyBatis

Map interface methods to SQL statements with annotations in the MyBatis persistence framework. Create runtime mapper implementations via a factory, use JDBC for database access, and enable declarative caching.

Create a new Eclipse Maven project and add MyBatis, H2, and Lombok dependencies. Configure the Maven compiler plugin to set source and target to 1.8, then update the project.

Learn how to start the H2 database in server mode, run it as a Java application, connect via the H2 console at localhost:8082, and manage a customers table with scripts.

Create a Lombok-powered entity class that maps table columns to fields, auto-generating getters, setters, constructors, hash code, equals, and toString, with Eclipse setup for Lombok integration.

Configure the MyBatis API to connect to the underlying database by creating a boilerplate config under src/main/resources with a data source, and define a mapper interface for the customer deal.

Build a customer dao mapper interface in MyBatis, mapping CRUD methods with @Insert, @Select, @Update, @Delete and SQL to a Customer object, including auto-generated keys and city queries.

Create a final dao factory with a private constructor that exposes a static getCustomerDao method, which loads the mybatis config, builds a sql session factory, and returns a CustomerDao mapper.

Shows adding a new customer via the deal factory and customer deal interface, setting name, city, image, and phone, then committing or rolling back transactions in a spring mybatis context.

Learn to retrieve a customer by id with Java persistence using MyBatis, handling null results, and printing either the customer details or a no data message.

Update customer data by ID, change city to Dallas and the phone number, commit the transaction automatically, and verify the update by retrieving and printing before and after records.

Learn to implement soft delete with an active or discontinued flag in Java persistence using MyBatis, and perform safe hard deletes only after verifying existence.

Learn how to get all customers and get customers by city in java persistence using mybatis, returning a list and printing each customer's name and city.

Learn to fetch customers by city using MyBatis, declare a city variable, retrieve a list of customers, and handle empty results without extra JDBC code.