Error connecting to SQ Server from Java: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver -

i using code:

import java.sql.connection; import java.sql.drivermanager; import java.sql.resultset; import java.sql.statement;  public class connectmssqlserver {     public void dbconnect(string db_connect_string, string db_userid, string db_password)     {         try {             class.forname("com.microsoft.sqlserver.jdbc.sqlserverdriver");             connection conn = drivermanager.getconnection(db_connect_string, db_userid, db_password);             system.out.println("connected");             statement statement = conn.createstatement();             string querystring = "select * sysobjects type='u'";             resultset rs = statement.executequery(querystring);             while (rs.next()) {                 system.out.println(rs.getstring(1));             }         } catch (exception e) {             e.printstacktrace();         }     }      public static void main(string[] args)     {         connectmssqlserver connserver = new connectmssqlserver();         connserver.dbconnect("jdbc:sqlserver://c1a\\sql1a", "p", "g31les");     } } 

but error:

"c:\program files\java\jdk1.8.0_91\bin\java" -didea.launcher.port=7532 "-didea.launcher.bin.path=c:\program files (x86)\jetbrains\intellij idea community edition 2016.2\bin" -dfile.encoding=utf-8 -classpath "c:\program files\java\jdk1.8.0_91\jre\lib\charsets.jar;c:\program files\java\jdk1.8.0_91\jre\lib\deploy.jar;c:\program files\java\jdk1.8.0_91\jre\lib\ext\access-bridge-64.jar;c:\program files\java\jdk1.8.0_91\jre\lib\ext\cldrdata.jar;c:\program files\java\jdk1.8.0_91\jre\lib\ext\dnsns.jar;c:\program files\java\jdk1.8.0_91\jre\lib\ext\jaccess.jar;c:\program files\java\jdk1.8.0_91\jre\lib\ext\jfxrt.jar;c:\program files\java\jdk1.8.0_91\jre\lib\ext\localedata.jar;c:\program files\java\jdk1.8.0_91\jre\lib\ext\nashorn.jar;c:\program files\java\jdk1.8.0_91\jre\lib\ext\sunec.jar;c:\program files\java\jdk1.8.0_91\jre\lib\ext\sunjce_provider.jar;c:\program files\java\jdk1.8.0_91\jre\lib\ext\sunmscapi.jar;c:\program files\java\jdk1.8.0_91\jre\lib\ext\sunpkcs11.jar;c:\program files\java\jdk1.8.0_91\jre\lib\ext\zipfs.jar;c:\program files\java\jdk1.8.0_91\jre\lib\javaws.jar;c:\program files\java\jdk1.8.0_91\jre\lib\jce.jar;c:\program files\java\jdk1.8.0_91\jre\lib\jfr.jar;c:\program files\java\jdk1.8.0_91\jre\lib\jfxswt.jar;c:\program files\java\jdk1.8.0_91\jre\lib\jsse.jar;c:\program files\java\jdk1.8.0_91\jre\lib\management-agent.jar;c:\program files\java\jdk1.8.0_91\jre\lib\plugin.jar;c:\program files\java\jdk1.8.0_91\jre\lib\resources.jar;c:\program files\java\jdk1.8.0_91\jre\lib\rt.jar;c:\users\wmoscoso\desktop\saturnlittlebrother\out\production\saturnlittlebrother;c:\program files (x86)\jetbrains\intellij idea community edition 2016.2\lib\idea_rt.jar" com.intellij.rt.execution.application.appmain connectmssqlserver java.lang.classnotfoundexception: com.microsoft.sqlserver.jdbc.sqlserverdriver     @ java.net.urlclassloader.findclass(urlclassloader.java:381)     @ java.lang.classloader.loadclass(classloader.java:424)     @ sun.misc.launcher$appclassloader.loadclass(launcher.java:331)     @ java.lang.classloader.loadclass(classloader.java:357)     @ java.lang.class.forname0(native method)     @ java.lang.class.forname(class.java:264)     @ connectmssqlserver.dbconnect(connectmssqlserver.java:16)     @ connectmssqlserver.main(connectmssqlserver.java:33)     @ sun.reflect.nativemethodaccessorimpl.invoke0(native method)     @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:62)     @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43)     @ java.lang.reflect.method.invoke(method.java:498)     @ com.intellij.rt.execution.application.appmain.main(appmain.java:147)   process finished exit code 0 

i new java, point me in right direction? don't know how set class path is needed? why need that?

i got work. need download jar files jdbc connection microsoft website , added them project.