Connecting to Mysql - Revision history

George2 at 12:44, 24 February 2016

2016-02-24T12:44:45Z

2014-10-21T17:07:52Z

2014-10-19T13:38:21Z

2014-10-19T13:06:35Z

2014-10-19T13:00:22Z

2014-10-19T12:52:41Z

2014-10-19T12:51:33Z

2014-10-19T12:45:43Z

2014-10-19T12:45:29Z

2014-10-19T12:44:29Z

@@ Line 25: / Line 25: @@
                   System.out.println(Username + " " +Street);
+                   }
+///// note the above has to be in a try - catch section
 </source>

@@ Line 13: / Line 13: @@
 String url = "jdbc:mysql://localhost<dbname>";
-Class.forName("com.mysql.jdbc.Driver").newInstance();
+Class.forName("com.mysql.jdbc.Driver").newInstance();  /// Starting here must be in a try catch
 con = DriverManager.getConnection(url,userName,passWord);
 sql = "select username, street from <table>";  /// Example

@@ Line 14: / Line 14: @@
 Class.forName("com.mysql.jdbc.Driver").newInstance();
-con = DriverManager.getConnection(url,userName,passWorrd);
+con = DriverManager.getConnection(url,userName,passWord);
-sql = "Put the sql query in here";
+sql = "select username, street from <table>";  /// Example
-−
 stmt = con.createStatement();
 rs = stmt.executeQuery(sql);
@@ Line 22: / Line 21: @@
 while ( rs.next())
+                   {
-                  // Do stuff
+                  String Username = rs.getString("username");
+                   }
 </source>

@@ Line 8: / Line 8: @@
 ResultSet rs = null;
-String userName = "";
+String userName = "<username>";
-String passWord = "";
+String passWord = "<password>";
 String sql = "";
 String url = "jdbc:mysql://localhost<dbname>";

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