How To Access MySQL Database From Java Applications?

RSS
EMAIL
FACEBOOK
FACEBOOK
GOOGLE
GOOGLE
https://www.poftut.com/how-to-access-mysql-database-from-java-applications/
PINTEREST
PINTEREST
INSTAGRAM

Java is popular programming language generally used commercial and enterprise applications. MySql is popular database too which is used big service providers like Google, Facebook etc. Most of the applications generally uses data and needs to store this data in a relational database. MySQL is generally the first choice if we do not want to give money for license. In this tutorial we will look how to connect a Java applications into MySQL database in detail.

Create Context and DataSource

Jdbc MySql driver can be used to connect MySql database like below. Jdbc driver is by default provided by Java Development Kit or simply JDK.

  • new InitialContext() creates a context for us.

Configure MySql Database Connection

We will create a new data source named dataSource . This data source will be used to specify the database server , user name, password and other related database and connection settings.

  • We create MySql datasource
  • Then set MySql Server username and password to connect with setUser and setPassword .
  • We set MySql Server address or dns name with mysql.poftut.com

Connect and Query MySql Database

We will use created and established connection names conn . We will create a statement which will run over connection conn and return result set named rs . But keep in mind that after using these objects for security, performance and resource usage we need to close them properly which is generally implemented in close() function like below.

LEARN MORE  Django Session Variable and Seriliazation

  • We create real connection object and assign to conn
  • We create query statement into stmt
  • rs result set is populated with query executed by stmt
  • rs, stmt, conn are closed with close function to release resources

RSS
EMAIL
FACEBOOK
FACEBOOK
GOOGLE
GOOGLE
https://www.poftut.com/how-to-access-mysql-database-from-java-applications/
PINTEREST
PINTEREST
INSTAGRAM