Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- String connectionUrl = "jdbc:sqlserver://localhost:1433;databaseName=BDProject [sa on db_accessadmin];user=sa;password=sa2012;";
- Connection con = null;
- Statement stmt = null;
- ResultSet rs = null;
- try {
- // Establish the connection.
- Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
- con = DriverManager.getConnection(connectionUrl);
- // Create and execute an SQL statement that returns some data.
- String SQL = "SELECT TOP 10 * FROM Person.Contact";
- stmt = con.createStatement();
- rs = stmt.executeQuery(SQL);
- // Iterate through the data in the result set and display it.
- while (rs.next()) {
- System.out.println(rs.getString(4) + " " + rs.getString(6));
- }
- }
- // Handle any errors that may have occurred.
- catch (Exception e) {
- e.printStackTrace();
- }
- finally {
- if (rs != null) try { rs.close(); } catch(Exception e) {}
- if (stmt != null) try { stmt.close(); } catch(Exception e) {}
- if (con != null) try { con.close(); } catch(Exception e) {}
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement