Re: how to access connection object in another class?

Here is the source code.
This is the code to connect the database.

package stundentrecord;

import java.sql.Connection;
import java.sql.DriverManager;

public class dbconnect {

     public void conect(){
   Connection con = null;
   String url = "jdbc:mysql://localhost:3306/";
   String db = "studentRecord";
   String driver = "com.mysql.jdbc.Driver";
   String user = "root";
   String pass = "";
   try {
   Class.forName(driver);
   con = DriverManager.getConnection(url + db, user, pass);
   if(con==null){
   System.out.println("Connection cannot be established");
   }

  // con.close();
   } catch (Exception e) {
   System.out.println(e);
   }
       }
}

AND HERE I WANT TO USE connection OBJECT BUT IT IS SHOWING ERROR.WHAT TO DO ??

if(source==login){
if(username!=null && password!=null){

     Connection conn= null;
     Statement stmt = null;
     dbconnect db = new dbconnect();

  String query = "SELECT * from userlogin";
  try{
  stmt=(Statement) conn.createStatement();
  ResultSet rs = stmt.executeQuery(query);
  while (rs.next())
       {
       String user = rs.getString("username");
       String pass=rs.getString("password");
       System.out.println("Welcome "+user);
       }
  }catch(SQLException ex){
  ex.getMessage();
  }
    StundentRecord SR = new StundentRecord();

     }else{
     JOptionPane.showMessageDialog(null,"Username or password field is empty","error !!",JOptionPane.ERROR_MESSAGE);
     }
}