Establish jdbc connection with mysql database
import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class sales { public static void main(String[] args) throws SQLException, ClassNotFoundException { // TODO Auto-generated method stub String host="localhost"; String port="3306"; Connection con=DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/myoffice","root","password"); Statement s=con.createStatement(); ResultSet rs=s.executeQuery("Select * from employee where emp_id=105"); while(rs.next()) { System.out.println(rs.getString("first_name")); System.out.println(rs.getString("last_name")); } } }