Connecting to Remote Data

[Steve Dyke]

I am trying to develope a web application. I need to get and post data to several AS400 files. I have created a connection class that works only on a specific file. How can I create a connection class that stores the connection to a variable. Then use this variable in classes that have SQL strings that interact with the AS400 files.

This is my connection class:

package com.ibm.drawinginquiry.rational;
 
import java.sql.*;
 
import com.ibm.as400.access.*;
 
public class LogOnConnection{

public LogOnConnection(){

AS400JDBCDataSource datasource = new AS400JDBCDataSource("gvas400");
    datasource.setUser("userid");
    datasource.setPassword("password");
try
 {
 
   Connection connection = datasource.getConnection();
   
   
}
 catch (SQLException se)
  {
 System.err.println("Exception creating the database connection: "+se);
 
 }
}
}    

I use the LogOnConnection conn = new LogOnConnection(); in a Servlet.

I need to be able to use the connection variable in the following:

package com.ibm.drawinginquiry.rational;
 
import java.sql.*;
 
import com.ibm.as400.access.*;
 

public class LogOnDataClass {

LogOnDataClass(){

    try{
String userfname = null;
String userlname = null;
 
String sql = "SELECT fname, lname FROM webprddt6.appusrprf1 WHERE usrid = 'SDE'";
 
Statement sment = conn.createStatement();
 
ResultSet rs = sment.executeQuery(sql);
 
if ( rs.next() ) {
  
 

userfname = rs.getString("fname"); /* the column index can also be used */
userlname = rs.getString("lname");
 
} else {
 

}
 
rs.close(); 
sment.close(); 
 
} catch ( SQLException se ) {
 
// 
System.err.println("Exception performing query: "+se);
 
}
}

}
 

    

However, I get a connot resolve on conn

[sathish kumar]

Where is the Conn object initialization inside the method.