Trying to correct methods to create paths using a database

[Iain Emsley]

I've been trying to put together some code which creates a list of folders and then populates the folder with a name from a database but I have not been able to link the two items together (which will form the full path).

  
testlistload ttl = new testlistload().getLists(listname)[code for getLists is at the bottom of the post]
for (lists:ttl){
addLists(lists);
}
private void addLists (String listname) throws CalFacadeException {
BwCalendar newcal = null;
CalSvcI svci = null;
DbListfind dlf = null;
try {
svci.open();
svci.beginTransaction();
svci.getCalendarsHandler().add(newcal, dlf.getBdCalShortPath());
svci.endTransaction();
} catch (Exception e) {
e.printStackTrace();
}svci.close();
  

I'm trying to get add lists to call to DbListfind's getBDCalShortPath() method (below

   
public String getBdCalShortPath() {
String calPath = "/users/mainfolder/shared/";
return calPath;
} 

This code then tries to use a DAO's getLists method to reach the database and return the list of names stored in it:

  
public class testlistload {
public String getLists(String listname) {
try {
Class.forName("com.mysql.jdbc.Driver"); //needs MySQL driver

} catch (Exception e) {
e.printStackTrace();
}
 

String url = "jdbc:mysql://host:3306/loginlist";
 
Statement stmt = null;
ResultSet rs = null;
Connection conn = null;

String lists = new String(listname);
try {
conn = DriverManager.getConnection(url, "user", "pword");
stmt = conn.createStatement();
rs = stmt.executeQuery("SELECT DISTINCT list FROM listname");

while (rs.next()) {
String db = rs.getString(1);
String[] newdb = db.split("\\.",2);
String list = newdb[0];
}
} catch (Exception e){
System.out.println("It fell over:" + e);
}
finally{
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}//end catch
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}//end catch
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}//end catch
}//finally
return lists;
}//public
}//end ListLoad  

The code retrieves the list names and the first part of the script I'm working on builds most of the path but I've not been able to link both parts together and would be grateful for any advice on correcting the methods to pass the data across.

[Francesco Bianchi]

Please,
be so nice to post indented code and, most of all, code which compiles (the first 2 lines cannot).