java - Access SQL Server 2008 R2 database from netbeans 8 -

i new java, , want make connection remote sql server 2008 r2 database (like 192.168.17.11) , load data it. please suggest alternative ways if know any.

first must have jdbc driver ms sql, have 2 jars (jtds-1.2.5.jar or sqljdbc4-2.0.jar), added classpath

second need create connection below:

string password="pass"; string driver= "net.sourceforge.jtds.jdbc.driver"; // sqljdbc4, use: com.microsoft.sqlserver.jdbc.sqlserverdriver string username="user"; string url="jdbc:jtds:sqlserver://serverip:port/dbname"; // sqljdbc4, use: jdbc:sqlserver://serverip:port;databasename=dbname class.forname(driver); connection conn = drivermanager.getconnection(url, username, password);  // use connection here // don't forget close connection