Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @Override
- public String test() {
- String result = "";
- try {
- String url = "jdbc:sqlserver://localhost:1433;" +
- "databaseName=boodo;user=sa;password=sasa;";
- Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
- Connection conn = DriverManager.getConnection(url,"sa","sasa");
- Statement stmt = conn.createStatement();
- ResultSet rs;
- rs = stmt.executeQuery("SELECT * FROM prueba");
- while ( rs.next() ) {
- String name = rs.getString("name");
- String value = rs.getString("value");
- result += String.format("%s(%s)%n", name, value);
- }
- conn.close();
- } catch (Exception e) {
- System.err.println("Got an exception! ");
- System.err.println(e.getMessage());
- }
- return result;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement