package mysqlconnect;
import java.sql.*;
class TestConnection{
public static void main(String args[]){
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection(
"jdbc:mysql://db4fr.net/sumit1234","sumit1234","sumit1234");
// here db4fre.net/sumit1234 is server/database name, sumit1234 username and sumit1234password
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from test");
while(rs.next())
System.out.println(rs.getString(1)+" "+rs.getString(2)); //BE CAREFUL HERE . DIFFERENT FIELDS HAVE DIFFERENT datatype
//System.out.println("reached inside while");
con.close(); //Closing Connection
}catch(Exception e){ System.out.println(e);}
}
}
import java.sql.*;
class TestConnection{
public static void main(String args[]){
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection(
"jdbc:mysql://db4fr.net/sumit1234","sumit1234","sumit1234");
// here db4fre.net/sumit1234 is server/database name, sumit1234 username and sumit1234password
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from test");
while(rs.next())
System.out.println(rs.getString(1)+" "+rs.getString(2)); //BE CAREFUL HERE . DIFFERENT FIELDS HAVE DIFFERENT datatype
//System.out.println("reached inside while");
con.close(); //Closing Connection
}catch(Exception e){ System.out.println(e);}
}
}
'################OUTPUT##################################################
sumit raut
1 11
2 12
3 13
4 14
5 15
6 16
7 17
8 18
9 19
1 11
2 12
3 13
4 14
5 15
6 16
7 17
8 18
9 19
2000 2010
2001 2011
2002 2012
2003 2013
2004 2014
2005 2015
2006 2016
2007 2017
No comments:
Post a Comment