Skip to main content

how to connect mysql database in java using jdbc

The following code illustrate how to connect mysql database using jdbc . It is very simple go through it and nothing fancy in it!!!
package basics.in.java.blogspot.in;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class Main {
 
 private static final String USERNAME="root";
 private static final String PASSWORD="";
 private static final String CONN_STRING="jdbc:mysql://localhost/basicsinjavablogspot";
 

 public static void main(String[] args) throws ClassNotFoundException, SQLException {
  Class.forName("com.mysql.jdbc.Driver");
  Connection conn=null;
  try {
   conn= DriverManager.getConnection(CONN_STRING, USERNAME, PASSWORD);
            System.out.println("database connection successful");   
  } catch (SQLException e) {
   System.err.println("something went wrong in database connection");
   e.printStackTrace();
  }
  
  finally{
   if(conn!=null){
    conn.close();
   }
  }
  

 }

}

Comments

Post a Comment

Popular posts from this blog

Configuring Multiple Profiles in a Single YAML File for Spring Boot Application

Spring Boot provides a convenient way to configure application properties using YAML files. In a typical scenario, you might have different configurations for different environments such as development, testing, and production. Instead of maintaining multiple YAML files for each profile, you can configure multiple profiles within a single YAML file. This approach simplifies the configuration management process. Let's see how to achieve this. Step 1: Create a YAML Configuration File First, create a YAML file (e.g., application.yml ) in your Spring Boot project's resource directory. This file will contain the configuration properties for all the profiles you want to define. spring: profiles: active: dev logging: level: root: INFO com.example: DEBUG # Configuration for the 'dev' profile --- spring: profiles: dev database: url: jdbc:mysql://localhost:3306/devdb username: devuser password: devpassword # Co

A End to End ant Build xml snippet

A End to End ant Build xml snippet you could use for reference <?xml version="1.0" encoding="UTF-8"?> <project name="End to End Build" default="sendmail" basedir=".">     <target name="init">         <tstamp />         <property file="build.properties" />             <path id="classpath">             <pathelement path="${servlet.jar}" />             <pathelement path="${junit.jar}" />         </path>

How to use SQL Exception Methods in java

The following code shows the use of some sqlexception method package basics.in.java.blogspot.in; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class Main { private static final String USERNAME="root"; private static final String PASSWORD=""; private static final String CONN_STRING="jdbc:mysql://localhost/basicsinjavablogspot"; public static void main(String[] args) throws ClassNotFoundException, SQLException { Class.forName("com.mysql.jdbc.Driver"); Connection conn=null; Statement stmt=null; ResultSet rs=null; try { conn= DriverManager.getConnection(CONN_STRING, USERNAME, PASSWORD); System.out.println("database connection successful"); stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); rs=stmt.executeQuery("select stateId,