JEE - JDBC Archives | Java-Success.com

Blog Archives

02: JDBC with MySQL, Datasource, and connection pool Tutorial

Step 1: pom.xml file with commons-dbcp2 for the connection pooling and abstraction layer for the datasource.

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com.mytutorial</groupId>
    <artifactId>simple-persistence</artifactId>
    <packaging>jar</packaging>
    <version>1.0-SNAPSHOT</version>
    <name>simple-persistence</name>
    <url>http://maven.apache.org</url>

    <properties>
        <maven.compiler.source>1.8</maven.compiler.source>
        <maven.compiler.target>1.8</maven.compiler.target>

…

12 FAQ JDBC interview Q&As

Q1. What are JDBC Statements? What are different types of statements? How can you create them? A1. A statement object is responsible for sending the SQL statements to the Database. Statement …

JDBC NamedParameterStatement versus PreparedStatement

Q. When will you use NamedParameterStatement over PreparedStatement?
A.

Reason 1: PreparedStatement uses anonymous parameters that are accessed by index, which is ok when you have 2 …

JDBC Overview Interview Questions and Answers

Q. What is JDBC? How do you connect to a database? A. JDBC stands for Java DataBase Connectivity. It is an API which provides easy connection to a wide range of …

Spring, JavaConfig (i.e @Configuration) & JDBC by example

Example #1 Wiring JDBC Datasource


@Configuration
@ImportResource("application.yml")
public class AppConfig
{
    @Autowired
    private Environment environment;

    @Bean
    public DriverManagerDataSource datasource() {
        DriverManagerDataSource ds = new DriverManagerDataSource();
        ds.setDriverClassName(environment.getRequiredProperty("spring.datasource.driver-class-name"));
        ds.setUrl(environment.getRequiredProperty("spring.datasource.url"));
        ds.setUsername(environment.getRequiredProperty("spring.datasource.username"));
        ds.setPassword(environment.getRequiredProperty("spring.datasource.password"));
        return ds;

…

Blog Archives

02: JDBC with MySQL, Datasource, and connection pool Tutorial

12 FAQ JDBC interview Q&As

JDBC NamedParameterStatement versus PreparedStatement

JDBC Overview Interview Questions and Answers

Spring, JavaConfig (i.e @Configuration) & JDBC by example

800+ Java Interview Q&As Menu

200+ Big Data Interview Q&As Menu

Overwhelmed by the number of Q&As?

Disclaimer