Example java code here - Revision history

George2 at 11:47, 5 February 2018

2018-02-05T11:47:35Z

George2 at 11:46, 5 February 2018

2018-02-05T11:46:48Z

George2 at 11:45, 5 February 2018

2018-02-05T11:45:57Z

George2: Created page with " mport java.sql.*; class MysqlCon{ public static void main(String args[]){ try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); Connection..."

2018-02-05T11:45:36Z

Created page with "<source lang="java"> mport java.sql.*; class MysqlCon{ public static void main(String args[]){ try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); Connection..."

New page

<source lang="java">
mport java.sql.*;

class MysqlCon{
public static void main(String args[]){
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con=DriverManager.getConnection("jdbc:sqlserver://192.168.56.111:1433;databaseName=georges_database","george","Oracleyemi1");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from mytable");

while(rs.next())
System.out.println(rs.getString(1)+" "+rs.getString(2) );
con.close();
}catch(Exception e){ System.out.println(e);}

}
}

</source>

← Older revision		Revision as of 11:47, 5 February 2018
Line 1:		Line 1:
		+	Sample code which connects to sql server 2012 database on ip address of 192.168.56.111<br>
		+
		+
	<source lang="java">		<source lang="java">
	import java.sql.*;		import java.sql.*;

@@ Line 6: / Line 6: @@
 try{
 Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
-Connection con=DriverManager.getConnection("jdbc:sqlserver://192.168.56.111:1433;databaseName=georges_database","george","Oracleyemi1");
+Connection con=DriverManager.getConnection("jdbc:sqlserver://192.168.56.111:1433;databaseName=georges_database","*****","******");
 Statement stmt=con.createStatement();
 ResultSet rs=stmt.executeQuery("select * from mytable");

@@ Line 1: / Line 1: @@
 <source lang="java">
-mport java.sql.*;
+import java.sql.*;
 class MysqlCon{