Groups > comp.lang.java.programmer > #22354

how to access connection object in another class?

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> (permalink)
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

Show key headers only | View raw

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

Back to comp.lang.java.programmer | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

how to access connection object in another class? xodepp shrestha <xodepp@gmail.com> - 2013-02-19 00:18 -0800
  Re: how to access connection object in another class? Arved Sandstrom <asandstrom2@eastlink.ca> - 2013-02-19 04:48 -0400
  Re: how to access connection object in another class? jlp <jlp@jlp.com> - 2013-02-19 09:50 +0100
  Re: how to access connection object in another class? lipska the kat <"nospam at neversurrender dot co dot uk"> - 2013-02-19 09:18 +0000
  Re: how to access connection object in another class? markspace <markspace@nospam.nospam> - 2013-02-19 09:43 -0800
    Re: how to access connection object in another class? Lew <lewbloch@gmail.com> - 2013-02-19 11:39 -0800
  Re: how to access connection object in another class? Roedy Green <see_website@mindprod.com.invalid> - 2013-03-01 00:20 -0800

csiph-web