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 ]