I have the following code. On line 38 in method MakeConnection() I am trying to access some variable from method ReadIni()above but it tells me each one "is not accessible or is not a field". What does it want from me?
Rebecca
import java.io.*;
import java.sql.*;
import java.util.Properties;
class ConnectionMaker {
String database;
String user;
String password;
public void ReadIni() throws IOException{
File iniFile = new File("C:\\Documents and Settings\\rwitmer.NA\\Desktop\\eclipse\\workspace2\\Tree\\config.ini");
FileInputStream fis = new FileInputStream(iniFile);
Properties properties = new Properties();
properties.load(fis);
database = properties.getProperty("database");
user = properties.getProperty("user");
password = properties.getProperty("password");
System.out.println(database);
}
public ResultSet MakeConnection(String query) {
try {
ReadIni();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
ResultSet rs = null;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception ex) {
System.out.println("Exception: " + ex.getMessage());
}
try {
Statement stmt = null;
rs = null;
Connection conn = DriverManager.getConnection("jdbc:mysql:" + ReadIni().database + "?user=" + ReadIni().user + "&password" + ReadIni().password);
stmt = conn.createStatement();
rs = stmt.executeQuery(query);
} catch (SQLException ex) {
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}
return rs;
}
}
