connecting to the database
I USE JDCB
I use CONNECTION database to make connection
I create STATEMENT than I use statement to create query
And run the query and get the RESULT SET
Connection = import java.sql.Connection;
Driver manager = import java.sql.DriverManager;
Connection connection = DriverManager.getConnection(url, userName, passWord);
Connection String Syntax:
jdbc:DataBaseType"subprotocal:Host:port:SID
After succesfully created the connect next step is STATEMENT
import java.sql.Statement;
Statement statement = connection.createStatement();
-We use createStatement() method to create the statement from our connection.
-The result we get from this type of statement can only move from top to bottom,
not other way around
Once we have statement we can run the query and get the result to
ResultSet format
import java.sql.ResultSet;
We use the method executeQuery() to execute our queries
ResultSet result = statement.executeQuery("Select * from employees");
4.33
6
const mysql = require('mysql');
// First you need to create a connection to the database
// Be sure to replace 'user' and 'password' with the correct values
const con = mysql.createConnection({
host: 'localhost',
user: 'user',
password: 'password',
});
con.connect((err) => {
if(err){
console.log('Error connecting to Db');
return;
}
console.log('Connection established');
});
con.end((err) => {
// The connection is terminated gracefully
// Ensures all remaining queries are executed
// Then sends a quit packet to the MySQL server.
});
Thank you!
6
0
Are there any code examples left?
New code examples in category Javascript
-
Javascript 2023-04-21 22:52:36
-
Javascript 2022-03-27 22:25:20 javascript download string as file
-
Javascript 2022-03-27 21:40:22 sort numbers in array javascript
-
Javascript 2022-03-27 21:20:04 compare two arrays and return the difference javascript
-
Javascript 2022-03-27 21:15:02 javascript regex french phone number
-
Javascript 2022-03-27 21:05:03 cypress custom error message
-
Javascript 2022-03-27 21:00:05 create element javascript with id
-
Javascript 2022-03-27 20:40:57 feather icons react
-
Javascript 2022-03-27 20:20:01 how to make graphql request in axios
-
Javascript 2022-03-27 20:15:07 bootstrap validator password and confirm password