Technical Education and IT Service Platform

Here are our Coding Problem Solution

Give Problem
and Output

Search Problems






📝 Problem Statement

How to establish a connection using JDBC with MySQL database.

Language: Java
Topic: JDBC

Code:

package databasepackage;
import java.sql.*;
public class DataConnectionTest {

public Connection cn;
public Statement stmt;
ResultSet rs;
public void connect()
{
try {
Class.forName("com.mysql.cj.jdbc.Driver");
}catch(ClassNotFoundException cnfe)
{
System.out.println(cnfe);
}

try {

cn = DriverManager.getConnection
("jdbc:mysql://localhost:3306/mca","root","Abc@123");

stmt = cn.createStatement();

rs=stmt.executeQuery("Select * from login");

while(rs.next())
{
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
}
}
catch(SQLException sqe)
{
System.out.println(sqe);
}
}

public static void main(String arg[])
{
DataConnectionTest dc = new DataConnectionTest();
dc.connect();
}
}

Input:

No input is required we will supply database name, user name and password in connection string.

Output:

Display records from the table Login