Question

is it possible to create a sql file and java file on same platform on eclipse or net beans and connect without using local host and password etc connection

Answer 1

To connect Java application with the MySQL database, Driver class, Connection URL, Username, Password are necessary to establish the connection. The connection statement would be :

Connection con = DriverManager.getConnection("jdbc:mysql://servername/ipaddress:port_number/database_name",username,password);

Here, jdbc is the API, mysql is the database. In the servername you can use localhost or the ip address where mysql is running. But it is necessary to establish a connection between the java code and the required database to execute the DDL or DML or DCL statements in the application.

The sample example would be given below.

import java.sql.*;
class Mysql_connection{
public static void main(String args[]){
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://10.212.30.116:2443/ECE",root,Password1234);
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from Application");
while(rs.next())
System.out.println(rs.getInt(1)+" "+rs.getString(2));
con.close();
}
catch(Exception e){
System.out.println(e);
}
}
}