Luego de tanto trabajar ya dimos con la respuesta de este asunto que agunos usuarios de nuestro sitio web han presentado. Si deseas compartir algún detalle no dudes en aportar tu comentario.
Ejemplo 1: conectividad de base de datos en php
<?php
///////////neha jaiswal//////////set variable/////////
$serve="localhost";
$user="root";
$password="";
$db="cart_system";///database name///create connection with db////
$conn=mysqli_connect($serve,$user,$password,$db);////check condition for connection fail or notif($conn)
echo "connection success";
else
echo "connection unsuccess";
?>
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");
¡Haz clic para puntuar esta entrada!
(Votos: 0 Promedio: 0)