Hi,
I apologize because this topic is again n again asked on the forum,
but after reading the topics I was not able to get an answer to my
problem.
I am connecting to a server and trying to display an sql query on the
browser. Here is my server side code:
public class GreetingServiceImpl extends RemoteServiceServlet
implements
GreetingService {
private Connection conn = null;
private String status;
private String connString = "Initial value";
private String url = "jdbc:sqlserver:;database";
private String user = "";
private String pass = "";
public ResultSet rs;
public Statement stm;
ArrayList rowArray = new ArrayList();
String name;
public ArrayList greetServer(String input) {
String serverInfo = getServletContext().getServerInfo();
String userAgent =
getThreadLocalRequest().getHeader("User-Agent");
// String s1 = "Select * from Patient";
try {
Class.forName
("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
// conn = DriverManager.getConnection(url,user,pass);
conn = DriverManager.getConnection
("jdbc:sqlserver:;database","username","password");
connString = "We connected";
stm = conn.createStatement();
String query1;
rs = stm.executeQuery("select SourceTableName from
SourceTables");
while (rs.next()) {
rowArray.add(String.valueOf(rs.getInt(1)));
}
} catch (Exception e) { connString = e.getMessage();}
// if (conn != null)
// connString = "We connected";
// else
// connString = "We failed to connect";
return rowArray;
}
}
I am confused in the following areas:
1) My sql query contains 4 values (string) is while(rs.next()) loop
the correct way to copy into from ResultSet to Arraylist?
2) I have made my return type to Arraylist, so in the default gwt
application when the user clicks the send button would it show the
four values of my sql query or not?
If anyone has some tutorials over how to do this plz tell the links
that would be very helpful
thanks
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Web Toolkit" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Google-Web-Toolkit?hl=en
-~----------~----~----~----~------~----~------~--~---
