import com.zaxxer.hikari.HikariDataSource;
HikariDataSource dataSource = new HikariDataSource();
dataSource.setJdbcUrl("jdbc:mysql://localhost:3306/mydb");
dataSource.setUsername("username");
dataSource.setPassword("password");
Connection connection = dataSource.getConnection();
// ...
connection.close();
import net.sf.ehcache.Cache;
import net.sf.ehcache.CacheManager;
import net.sf.ehcache.Element;
CacheManager cacheManager = CacheManager.create();
Cache cache = new Cache("myCache", 100, false, false, 3600, 3600);
cacheManager.addCache(cache);
String cacheKey = "queryKey";
Element element = cache.get(cacheKey);
if (element != null) {
Object result = element.getObjectValue();
} else {
// ...
cache.put(new Element(cacheKey, queryResult));
}
import java.util.concurrent.CompletableFuture;
import java.util.concurrent.ExecutorService;
import java.util.concurrent.Executors;
ExecutorService executorService = Executors.newCachedThreadPool();
CompletableFuture<Void> future = CompletableFuture.runAsync(() -> {
}, executorService);
// ...
CREATE INDEX idx_username ON users(username);
SELECT * FROM users WHERE username = 'admin';
ALTER TABLE users ADD COLUMN email VARCHAR(255) NOT NULL;
