Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Driver driver = new com.microsoft.sqlserver.jdbc.SQLServerDriver();
- DriverManager.registerDriver(driver);
- String URL = "jdbc:sqlserver://192.168.0.102\\MSSQLSERVER:1433;databaseName=SsuDB";
- String USER = "admin";
- String PASS = "admin";
- Connection conn = DriverManager.getConnection(URL, USER, PASS);
- PreparedStatement statement = conn.prepareStatement("SELECT * FROM Book");
- ResultSet rs = statement.executeQuery();
- while (rs.next()) {
- int id = rs.getInt("id");
- String title = rs.getString("title");
- System.out.println(id + "\t" + title);
- }
- conn.close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement