Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- String driver = "org.gjt.mm.mysql.Driver";
- String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
- String url="jdbc:mysql://localhost/books?user=<user>&password=<password>";
- String url = "jdbc:microsoft:sqlserver://<server_name>:<1433>"
- con=DriverManager.getConnection(url);
- con=DriverManager.getConnection(url, usr, pwd );
- try{
- Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
- Connection conn = DriverManager.getConnection("jdbc:sqlserver://ipaddress:port;databaseName=schema_name","user","pass");
- PreparedStatement pps = conn.prepareStatement("SELECT * FROM table");
- ResultSet rs = pps.executeQuery();
- while(rs.next()){
- //do something
- System.out.println(rs.getString("some col"));
- }
- //close connection
- conn.close();
- }catch(Exception ex){
- // do something
- }
Add Comment
Please, Sign In to add comment