Click here to watch in Youtube : https://www.youtube.com/watch?v=ZXGam4BP0DY
Click the below Image to Enlarge
JDBC DBCP DataSource - MySQL |
JDBC DBCP DataSource - MySQL |
JDBC DBCP DataSource - MySQL |
import javax.sql.DataSource; import org.apache.commons.dbcp2.BasicDataSource; public class DbcpBasicDataSource { public static DataSource getDbcpBasicDataSource() { BasicDataSource basicDataSource = new BasicDataSource(); try { basicDataSource.setUrl("jdbc:mysql://localhost:3306/world"); basicDataSource.setUsername("root"); basicDataSource.setPassword("root"); } catch( Exception e ) { e.printStackTrace(); } return basicDataSource; } }
import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import javax.sql.DataSource; public class JDBCDataSourceDemo { public static void main( String[] args ) { JDBCDataSourceDemo jdbcDataSourceDemo = new JDBCDataSourceDemo(); jdbcDataSourceDemo.getCityInformation(); } private void getCityInformation() { Connection connection = null; Statement stmt = null; /* * Get the dbcp2 BasicDataSource */ DataSource dataSource = DbcpBasicDataSource.getDbcpBasicDataSource(); try { /* * Get connection from the DataSource */ connection = dataSource.getConnection(); /* * Execute the Query */ stmt = connection.createStatement(); String sql = "select ID,Name,CountryCode,District,Population from city"; ResultSet rs = stmt.executeQuery(sql); /* * Iterate the ResultSet and get each row * Information. */ while( rs.next() ) { /* * Retrieve by column name */ int id = rs.getInt("ID"); String name = rs.getString("Name"); String countryCode = rs.getString("CountryCode"); String district = rs.getString("District"); int population = rs.getInt("Population"); /* * Display values */ System.out.print("ID: " + id); System.out.print(", Name: " + name); System.out.print(", CountryCode: " + countryCode); System.out.print(", District: " + district); System.out.println(", Population: " + population); } rs.close(); } catch( SQLException se ) { se.printStackTrace(); } catch( Exception e ) { e.printStackTrace(); } finally { /* * finally block used to close resources */ try { if( stmt != null ) { stmt.close(); } } catch( SQLException sqlException ) { sqlException.printStackTrace(); } try { if( connection != null ) { connection.close(); } } catch( SQLException sqlException ) { sqlException.printStackTrace(); } } } }
ID: 2, Name: Qandahar, CountryCode: AFG, District: Qandahar, Population: 237500 ID: 3, Name: Herat, CountryCode: AFG, District: Herat, Population: 100 ID: 4, Name: Mazar-e-Sharif, CountryCode: AFG, District: Balkh, Population: 127800 ID: 5, Name: Amsterdam, CountryCode: NLD, District: Noord-Holland, Population: 50000 ID: 6, Name: Rotterdam, CountryCode: NLD, District: Zuid-Holland, Population: 4000 ID: 7, Name: Haag, CountryCode: NLD, District: Zuid-Holland, Population: 440900 ID: 8, Name: Utrecht, CountryCode: NLD, District: Utrecht, Population: 234323 ID: 9, Name: Eindhoven, CountryCode: NLD, District: Noord-Brabant, Population: 201843 ID: 10, Name: Tilburg, CountryCode: NLD, District: Noord-Brabant, Population: 193238 ID: 11, Name: Groningen, CountryCode: NLD, District: Groningen, Population: 172701 --- ---
Environment Used
JDK version : 1.7.0_51
Mysql Server version : 5.6.19
To Download JDBCDataSourceDemo-DBCP-Mysql Project Click the below link
https://sites.google.com/site/javaee4321/jdbc/JDBCDataSourceDemo-DBCP-Mysql.zip?attredirects=0&d=1
External Links
http://commons.apache.org/proper/commons-dbcp/apidocs/org/apache/commons/dbcp2/BasicDataSource.html
http://commons.apache.org/
http://commons.apache.org/proper/commons-dbcp/download_dbcp.cgi
http://commons.apache.org/proper/commons-pool/download_pool.cgi
http://commons.apache.org/proper/commons-logging/download_logging.cgi
See also:
No comments:
Post a Comment