Technical Education and IT Service Platform
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