This week's giveaway is in the EJB and other Java EE Technologies forum. We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line! See this thread for details.
pls I'm retrieving data from two tables in Mysql and displaying them on a swing interface here is the class that handles the search based on parameters you enter into textfields when a button is clicked this is the event handler the problem is I don't get to see anything
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); connection = DriverManager.getConnection("Jdbc:Odbc:MyDataSource"); statement= connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); String Mysql = "select personID,sex,SiteCode,PreferredLanguage,Tribe,EducationLevel,StateOfOrigin,Service,rank,OccupationStatus,MaritalStatus,ResidenceAddress,SourceOfReferral,PhoneNumber from demographic,person where surname='sname' and othernames='oname' and yearbirth='yb'and person.PersonID=demographic.demographicID ";
//Mysql = Mysql + " (from person,demographic where surname='sname' and othernames='oname' and yearbirth='yb'and person.PersonID=demographic.demographicID)";