Advertisement
Guest User

Untitled

a guest
Nov 26th, 2016
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. @Override
  2. public String test() {
  3. String result = "";
  4. try {
  5. String url = "jdbc:sqlserver://localhost:1433;" +
  6. "databaseName=boodo;user=sa;password=sasa;";
  7. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  8. Connection conn = DriverManager.getConnection(url,"sa","sasa");
  9. Statement stmt = conn.createStatement();
  10. ResultSet rs;
  11.  
  12. rs = stmt.executeQuery("SELECT * FROM prueba");
  13.  
  14. while ( rs.next() ) {
  15. String name = rs.getString("name");
  16. String value = rs.getString("value");
  17. result += String.format("%s(%s)%n", name, value);
  18. }
  19. conn.close();
  20. } catch (Exception e) {
  21. System.err.println("Got an exception! ");
  22. System.err.println(e.getMessage());
  23. }
  24. return result;
  25. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement