Hi,
I have one java file that contains sql connection code and the other is bean , where i want to create instance of sql connection class but it gives error i.e....
can not find symbol
symbol : class sqlconn
location: class dbbean.addlevelbean
where is problem???
----------------------------------
package dbbean;
import java.sql.*;
import javax.sql.*;
public class sqlconn
{
public sqlconn()
{
}
public Connection connectdb()
{
Connection conn = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc racle:thin:@10.100.212.244:1521 b","usr","pwd");
} catch (SQLException e) {
System.out.println(e.getMessage());
} catch (Exception e) {
System.out.println(e.getMessage());
}
return conn;
}
public void closedb(Connection connt,Statement stmnt)
{
if(connt!=null)
{
try {
connt.close();
} catch(Exception e) {
System.out.println(e.getMessage());
}
}
if(stmnt!=null)
{
try {
stmnt.close();
} catch(Exception e) {
System.out.println(e.getMessage());
}
}
}
}
////////////////// bean where i need an instance of sql conn.............
package dbbean;
import java.sql.*;
public class addlevelbean
{
private String name;
private String desc;
private Connection conn;
private PreparedStatement pstmt;
private ResultSet rs;
public addlevelbean()
{
try{
sqlconn sqlobj = new sqlconn();
}catch(Exception e){
System.out.println(e.getMessage());
}
}
}
I have one java file that contains sql connection code and the other is bean , where i want to create instance of sql connection class but it gives error i.e....
can not find symbol
symbol : class sqlconn
location: class dbbean.addlevelbean
where is problem???
----------------------------------
package dbbean;
import java.sql.*;
import javax.sql.*;
public class sqlconn
{
public sqlconn()
{
}
public Connection connectdb()
{
Connection conn = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc racle:thin:@10.100.212.244:1521 b","usr","pwd");
} catch (SQLException e) {
System.out.println(e.getMessage());
} catch (Exception e) {
System.out.println(e.getMessage());
}
return conn;
}
public void closedb(Connection connt,Statement stmnt)
{
if(connt!=null)
{
try {
connt.close();
} catch(Exception e) {
System.out.println(e.getMessage());
}
}
if(stmnt!=null)
{
try {
stmnt.close();
} catch(Exception e) {
System.out.println(e.getMessage());
}
}
}
}
////////////////// bean where i need an instance of sql conn.............
package dbbean;
import java.sql.*;
public class addlevelbean
{
private String name;
private String desc;
private Connection conn;
private PreparedStatement pstmt;
private ResultSet rs;
public addlevelbean()
{
try{
sqlconn sqlobj = new sqlconn();
}catch(Exception e){
System.out.println(e.getMessage());
}
}
}