Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

how to access connection object in another class?

Show all headers | 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