Win a copy of Five Lines of Code this week in the OO, Patterns, UML and Refactoring forum!
    Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

accessing one class from other

 
Ranch Hand
Posts: 155
  • Mark post as helpful
  • send pies
  • Report post to moderator
i have made one package com.beans and put my two src files DBConnection.java and userInfoBean.java in that package.in the constructor of userInfobean class i m trying to create object of DBConnection class to establish database conncetion.
following error comes
---------- Java Compiler ----------
userInfoBean.java:185: cannot find symbol
symbol : variable DBConnection
location: class com.beans.userInfoBean
Connection tempCon = DBConnection.con;
^
userInfoBean.java:210: password is already defined in chkUser(java.lang.String,java.lang.String)
String password = getPassword();
^
userInfoBean.java:230: cannot find symbol
symbol : class DBConnection
location: class com.beans.userInfoBean
DBConnection db = new DBConnection();
^
userInfoBean.java:230: cannot find symbol
symbol : class DBConnection
location: class com.beans.userInfoBean
DBConnection db = new DBConnection();
^
4 errors
userInfobean.java
package com.beans;
//import com.beans.*;
import java.io.*;
import java.sql.*;
import oracle.jdbc.driver.*; /* Classes available in Classes12.jar file */
import oracle.jdbc.*; /* Classes available in Classes12.jar file */

public class userInfoBean
{


private String sid;
private String sname;
private int year;
private String address;
private String bdate;
private String phone;
private String email;
private String ssn;
private double gpa;
private String semcode;
private String fssn;
private String username;
private String password;




public void setSid(String sid)
{

this.sid=sid;
}

public String getSid()
{
return sid;
}
public void setYear(int year)
{

this.year=year;
}

public int getyear()
{
return year;
}
public void setSname(String sname)
{

this.sname=sname;
}

public String getSname()
{
return sname;
}






public void setAddress(String address)
{


this.address = address;
}
public String getAddress()
{


return address;
}

public void setEmail(String email)
{


this.email = email;
}
public String getEmail()
{


return email;
}public void setPhone(String phone)
{


this.phone = phone;
}
public String getphone()
{


return phone;
}
public void setFssn(String fssn)
{


this.fssn = fssn;
}
public String getFssn()
{


return fssn;
}

public void setBdate(String bdate)
{


this.bdate = bdate;
}
public String getBdate()
{


return bdate;
}
public void setSsn(String ssn)
{


this.ssn = ssn;
}
public String getSsn()
{


return ssn;
}
public void setUser(String username)
{


this.username = username;
}
public String getUser()
{


return username;
}public void setPassword(String password)
{


this.password = password;
}
public String getPassword()
{


return password;
}

public void setGpa(double gpa)
{

this.gpa=gpa;
}

public double getGpa()
{
return gpa;
}public void setSemcode(String semcode)
{

this.semcode=semcode;
}

public String getSemcode()
{
return semcode;
}

public void getStudentInfo(String sid)
{

Connection tempCon = DBConnection.con;
Statement stmt = tempCon.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM STUDENT where SID="+sid);
while(rs.next())
{
setSid(rs.getString("SID"));
setSname(rs.getString("SNAME"));
setYear(rs.getInt("YEAR"));
setAddress(rs.getString("ADDRESS"));
setBdate(rs.getString("BDATE"));
setPhone(rs.getString("PHONE"));
setEmail(rs.getString("EMAIL"));
setSsn(rs.getString("SSN"));
setGpa(rs.getDouble("GPA"));
setFssn(rs.getString("FSSN"));
setUser(rs.getString("USERNAME"));
setPassword(rs.getString("PASSWORD"));
setSemcode(rs.getString("SEMCODE"));
}
}

public boolean chkUser(String sid,String password)
{
getStudentInfo(sid);
String user = getUser();
String password = getPassword();
if(user.equals(sid) && password.equals(password))
{
return true;
}
else
{return false;}


}








public userInfoBean()
{
DBConnection db = new DBConnection();

}



}

----
DBConncetion.java
---
package com.beans;


import java.io.*;
import java.sql.*;
import oracle.jdbc.driver.*; /* Classes available in Classes12.jar file */
import oracle.jdbc.*; /* Classes available in Classes12.jar file */

public class DBConnection
{


static Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String classPath ;


DBConnection()
{


/*classPath = System.getProperty("java.class.path",".");
System.out.println("System Path is "+classPath);*/

try
{

// Load (and therefore register) the Oracle Driver
Class.forName("oracle.jdbc.driver.OracleDriver");

// Get a Connection to the database
//cssid
con = DriverManager.getConnection(
"jdbc racle:thin:@turing.cs.lamar.edu:1521:sidcs", "group07", "sholay"); // Replace group_name and password with your group username and password
// Create a Statement object
stmt = con.createStatement();

// Execute an SQL query, get a ResultSet
rs = stmt.executeQuery("SELECT SID FROM STUDENT");

while(rs.next())
{

System.out.println("Student ID"+"::"+ rs.getString("SID"));
}



}
catch(ClassNotFoundException e)
{
System.out.println("Couldn't load database driver: " + e.getMessage());
}
catch(SQLException e)
{
System.out.println("SQLException caught: " + e.getMessage());
System.out.println("stack trace");
e.printStackTrace();
}
catch(Exception e)
{
System.out.println("Exception Occurred");
e.printStackTrace();

}
finally
{
// Always close the database connection.

}// end of finally*/
}

public static void closeConnection()
{

try
{
if (con != null) con.close();
}
catch (SQLException ignored) { }

}




}


i am compiling from c:\project\com\beans directory...i don't know why its not allowing me to use the class that is in the same package and declared as public
[ April 06, 2005: Message edited by: Bear Bibeault ]
 
Marshal
Posts: 67418
173
Mac Mac OS X IntelliJ IDE jQuery Java
  • Mark post as helpful
  • send pies
  • Report post to moderator
bhavik, Please do not cross-post the same question in multiple forums. It wastes people's time when multiple redundant conversations take place.

This is not a JSP issue, but a basic Java compile issue and the Java forum is the correct place for such a question. Please continue any discussion of this topic
here.
 
She said she got a brazillian. I think owning people is wrong. That is how I learned ... tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic