@Entity(tableName = "users")
public class User {
@Id
@Column(name = "id")
private int id;
@Column(name = "name")
private String name;
}
public class UserDao {
private static final String DB_URL = "jdbc:mysql://localhost:3306/mydb";
private static final String DB_USER = "root";
private static final String DB_PASSWORD = "password";
public void save(User user) {
try (Connection conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD)) {
conn.setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE);
conn.setAutoCommit(false);
try {
conn.commit();
} catch (Exception e) {
conn.rollback();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public class Main {
public static void main(String[] args) {
UserDao userDao = new UserDao();
User user = new User();
user.setId(1);
user.setName("Alice");
userDao.save(user);
}
}
