- Spring JDBC Tutorial
- Spring JDBC - Home
- Spring JDBC - Overview
- Spring JDBC - Environment Setup
- Spring JDBC - Configure Data Source
- Spring JDBC - First Application
- Basic CRUD Examples
- Spring JDBC - Create Query
- Spring JDBC - Read Query
- Spring JDBC - Update Query
- Spring JDBC - Delete Query
- Advanced JDBC Examples
- Calling Stored Procedure
- Spring JDBC - Calling Stored Function
- Spring JDBC - Handling BLOB
- Spring JDBC - Handling CLOB
- Spring JDBC Batch Examples
- Spring JDBC - Batch Operation
- Objects Batch Operation
- Multiple Batches Operation
- Spring JDBC Objects
- Spring JDBC - JdbcTemplate
- PreparedStatementSetter
- Spring JDBC - ResultSetExtractor
- Spring JDBC - RowMapper
- NamedParameterJdbcTemplate
- Spring JDBC - SimpleJdbcInsert
- Spring JDBC - SimpleJdbcCall
- Spring JDBC - SqlQuery
- Spring JDBC - SqlUpdate
- Spring JDBC - StoredProcedure
- Spring JDBC Useful Resources
- Spring JDBC - Quick Guide
- Spring JDBC - Useful Resources
- Spring JDBC - Discussion
Spring JDBC - Configure Data Source
Let us create a database table Student in our database TEST. I assume you are working with MySQL database, if you work with any other database then you can change your DDL and SQL queries accordingly.
CREATE TABLE Student( ID INT NOT NULL AUTO_INCREMENT, NAME VARCHAR(20) NOT NULL, AGE INT NOT NULL, PRIMARY KEY (ID) );
Now we need to supply a DataSource to the JDBC Template so it can configure itself to get database access. You can configure the DataSource in the XML file with a piece of code shown as follows −
<bean id = "dataSource" class = "org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name = "driverClassName" value = "com.mysql.cj.jdbc.Driver"/> <property name = "url" value = "jdbc:mysql://localhost:3306/TEST"/> <property name = "username" value = "root"/> <property name = "password" value = "admin"/> </bean>
In the next chapter, we'll write the first application using the database configured.
Advertisements