Ejemplo de código de conexión de xampp al servidor de base de datos

Nuestros programadores estrellas agotaron sus provisiones de café, buscando a tiempo completo por la resolución, hasta que Ariana halló el arreglo en Beanstalk y ahora la comparte aquí.

Ejemplo 1: usando la base de datos mysql con php

<?php
$servername ="localhost";
$username ="yourusername";// For MYSQL the predifined username is root
$password ="yourpassword";// For MYSQL the predifined password is " "(blank)// Create connection
$conn = new mysqli($servername, $username, $password);// Check connectionif($conn->connect_error) 

    die("Connection failed: ". $conn->connect_error);


echo "Connected successfully";

?>

Ejemplo 2: cómo se conecta la base de datos

I USE JDCB
I use CONNECTION databaseto make connection
I create STATEMENT than I use statement tocreate 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");

Sección de Reseñas y Valoraciones

---

---

Utiliza Nuestro Buscador