SJ9923J13

13. Design a and implement JDBC applications

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCExample {
{

try{
Class.forName("com.mysql.cj.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/
student","root","vaibhavi123");
}
catch(Exception e){
}
}
static final String DB_URL ="jdbc:mysql://localhost:3306/students";
static final String USER ="root";
static final String PASS ="vaibhavi123";
public static void main(String[] args) {
try(Connection con =DriverManager.getConnection(DB_URL, USER, PASS);

Statement stmt=con.createStatement();
){
String sql="CREATE DATABASE STUDENTS";
stmt.executeUpdate(sql);
System.out.println("Database created successfully...");
}
catch(SQLException e)
{
e.printStackTrace();
}

}
}