spring Fetching JDBC Connection from DataSource

In a Spring application, JDBC connections can be fetched from a DataSource using the following steps:

1. Define a DataSource bean in the Spring application context. This can be done using the following XML configuration:

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    <property name="url" value="jdbc:mysql://localhost:3306/mydb"/>
    <property name="username" value="root"/>
    <property name="password" value="password"/>
</bean>

This configuration defines a DataSource bean that connects to a MySQL database with the specified URL, username, and password.

2. Inject the DataSource bean into the DAO classes that need to fetch JDBC connections. This can be done using the following XML configuration:

<bean id="myDao" class="com.example.MyDao">
    <property name="dataSource" ref="dataSource"/>
</bean>

This configuration defines a DAO bean that has a DataSource property named "dataSource" that is set to the previously defined "dataSource" bean.

3. Use the DataSource object to fetch a JDBC connection in the DAO methods that need to execute SQL queries. This can be done using the following code:

Connection conn = dataSource.getConnection();

This code fetches a JDBC connection from the DataSource object and assigns it to a Connection variable named "conn".

4. Use the Connection object to execute SQL queries. This can be done using the following code:

PreparedStatement stmt = conn.prepareStatement("SELECT * FROM my_table");
ResultSet rs = stmt.executeQuery();

This code uses the Connection object to prepare and execute a SELECT query on a database table named "my_table". The results are stored in a ResultSet object named "rs".

5. Close the Connection object when done. This can be done using the following code:

conn.close();

This code closes the JDBC connection and releases any resources associated with it. It is important to always close JDBC connections when done to avoid resource leaks and other issues