Difference between revisions of "Connecting to Mysql"

import java.sql.*;
 
{
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
 
String userName = "<username>";
String passWord = "<password>";
String sql = "";
String url = "jdbc:mysql://localhost<dbname>";
 
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection(url,userName,passWorrd);
sql = "Put the sql query in here";
 
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
 
while ( rs.next())
                  {
                 // Do stuff
                  }