Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();

String url="jdbc:microsoft:sqlserver://195.204.140.95:1433;DatabaseName=bemsdb";

String user="sa";

String password="cmbc";

Connection conn= DriverManager.getConnection(url,user,password);

Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

String sql="select * from bankclass";

ResultSet rs=stmt.executeQuery(sql);