Ads

JDBC Connection for MongoDb and MSSQL

 MSSQL server-JDBC:

first we have to add mssql jdbc dependency

Class.forName("com.microsoft.mssql"); String username="sadnasjk"; string password="njasdnasf"; Connection connection=DriverManager.getConnection("jdbc:mssql://esw-usdn,databasenam=timeoff",username,password); Statement statement=connection.createStatement(); ResultSet set=statement.executeQuery("Select * from employees"); while(set.next()){ sysout(set.getString("username")); }

MongoDB:

Same here:we have to add Mongo java driver dependency

String uri="mongodb://usernam:password@localhost/databasename" MongoClient client=new MongoClient(new MongoClientURI(uri)); MongoDataBase database=client.getDataBase("timeoffPoloicy"); MongoCollection<Document> docu=database.getCollection("sangar"); for(Document dd:docu.find()){ sysout(dd.toJson()); }

Comments

Post a Comment

Popular posts from this blog

Rest Assured Api Automation

  1. What is Rest Assured, and why is it used? Answer: Rest Assured is a Java library used for testing RESTful APIs. It simplifies the process of sending HTTP requests, verifying responses, and automating API testing. Rest Assured provides a domain-specific language (DSL) for writing expressive tests, making it easier to test APIs without requiring extensive knowledge of HTTP. GEt method: RestAssured.BaseURI="https://jsonplaceholder.typicode.com/"; RequestSpecification reqSpec=RestAssured.given().accept(Contenttype.json).auth(). basicAuth("username","password").pathParam("sangar","kumar").header("Content-Type","application/json"); Response response=reqSpec.get("/sangar"); sysout(response.asString()); sysout(response.asPrettyString()); Assert.assertEquals(response.statusCode(),200,"Sangar bro"); Assert.assertTrue(response.statusMessage().contains("ok")); Post Method: Response response=Re...
Read more

Appium Notes

Image
  Appium is an open sourced mobile automation tool for testing navitive,hybrid,mobile app and browsers.. Appium internally uses WebDriver json wire protocol(which selenium does) to test the apps. Actually appium server acts as mediator between mobile application and Appium client libraries. Appium Client Libraries code is wrapping as json and sending to the appium server through json wire protocol.--->then appium server sending request to the mobile through UI Automator(kind of engine)--->automator response received by appium server and server sending response to the client libraries   Open image-20240905-071057.png Appium Architecture Appium is an open-source automation tool primarily designed for automating native, hybrid, and mobile web applications on iOS and Android platforms. Here's an overview of its architecture: Appium Server : Appium uses a client-server architecture. It listens for requests from clients (like Selenium WebDriver) and executes the commands on mo...
Read more

Jenkins Notes

  Continuous integration: once new commit is merged to the existing one, existing functionalities should not break.to ensure that for every commit, it is mandentory to run automated test for every new commit. this is called continuous integration.   New Item--->Free style project--->Enter name--->Free style---> General---> Description use custom workspace as project location---> Project is parameterised--->we can set the parameters and can be referred by %value% SourceCode--->Git along with credentials confuigured here--->once push done(this can be achieved by ngrok tunneling tool Build trigger--->usually we mention the schedule time data using cron time to configure automatic run. and we can set chain like depends on other project this will run Build steps-->we can add mvn test like command using windows batch command Post build actions-->we can configure email sending functions
Read more