X-Received: by 10.66.15.134 with SMTP id x6mr1652649pac.42.1361261933399; Tue, 19 Feb 2013 00:18:53 -0800 (PST)
X-Received: by 10.50.187.133 with SMTP id fs5mr1855540igc.12.1361261933171; Tue, 19 Feb 2013 00:18:53 -0800 (PST)
Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!kc14no15334541pbb.1!news-out.google.com!ov8ni9pbb.1!nntp.google.com!su1no15357855pbb.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: comp.lang.java.programmer
Date: Tue, 19 Feb 2013 00:18:52 -0800 (PST)
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=49.244.92.253; posting-account=gG72xgoAAABeJEftPpSSTEb7zQSKks14
NNTP-Posting-Host: 49.244.92.253
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <9345656c-d843-4e20-a49a-df3b3fd7dfe5@googlegroups.com>
Subject: how to access connection object in another class?
From: xodepp shrestha <xodepp@gmail.com>
Injection-Date: Tue, 19 Feb 2013 08:18:53 +0000
Content-Type: text/plain; charset=ISO-8859-1
Xref: csiph.com comp.lang.java.programmer:22354

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);
    }
}