Database Testing

.............................................................................
The database is used to store application data under the table format. It is used to store information of an application permanently using various database software tools.
Database Testing also checks that all field of the form element is inserting successfully or not. check the performance of an application during data communication, the security of an application from frontend to backend and we also check the SQL Injection problem.

SQL Injection is used to get database data without any permission using SQL parameters.

It is mostly managed by a database developer or technical testing team.

Database Software name:-
1 MYSQL
2 ORACLE
3 MS-SQL
4 SYBASE
5 IBM DB2
Database developers use SQL queries to test database-related operations, for example, if we have a registration page then we enter all details and check that these details are inserted in the database table.

Database testing also checks the complete content of the application is inserted on the database table.

We will also check the SQL injection problem on the database part from the application data.

The database is the most important part of software testing because if database testing will be failed then the complete application can be crashed.

Database table should contain all columns datatype and size relevant as per application forms.

Comments

Uncontrolled form input in React-JS

Uncontrolled form input in React-JS? If we want to take input from users without any separate event handling then we can uncontrolled the data binding technique. The uncontrolled input is similar to the traditional HTML form inputs. The DOM itself handles the form data. Here, the HTML elements maintain their own state that will be updated when the input value changes. To write an uncontrolled component, you need to use a ref to get form values from the DOM. In other words, there is no need to write an event handler for every state update. You can use a ref to access the input field value of the form from the DOM. Example of Uncontrolled Form Input:- import React from "react" ; export class Info extends React . Component { constructor ( props ) { super ( props ); this . fun = this . fun . bind ( this ); //event method binding this . input = React . createRef ();...

JSP Page design using Internal CSS

JSP is used to design the user interface of an application, CSS is used to provide set of properties. Jsp provide proper page template to create user interface of dynamic web application. We can write CSS using three different ways 1) inline CSS:- we will write CSS tag under HTML elements <div style="width:200px; height:100px; background-color:green;"></div> 2) Internal CSS:- we will write CSS under <style> block. <style type="text/css"> #abc { width:200px; height:100px; background-color:green; } </style> <div id="abc"></div> 3) External CSS:- we will write CSS to create a separate file and link it into HTML Web pages. create a separate file and named it style.css #abc { width:200px; height:100px; background-color:green; } go into Jsp page and link style.css <link href="style.css" type="text/css" rel="stylesheet" /> <div id="abc"> </div> Exam...

JDBC Database Connectivity using JSP and Servlet, Database connectivity on Java

JDBC Database Connectivity using JSP and Servlet, Database connectivity on Java JDBC:- JDBC means Java database connectivity, it is used to connect from the front-end(application server) to the back-end(database server) in the case of Java web application. The database provides a set of tables to store records and JDBC will work similarly to the bridge between the database table and application form. 1) Class.forName("drivername") // Manage Drive Class.formName("com.mysql.jdbc.Driver"); // MYSQL Class.forName ("oracle.jdbc.driver.OracleDriver"); //Oracle 2) Manage Connection String It establish connection from application server to database server, Java provide DriverManage class and getConnection that will return Connection object. Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/databasename","username","password"); 3) Manage Statement to...

Search This Blog