Conector Java y Base de datos Oracle
Conexión de Java a Oracle para los que deseen:
Clase main:
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package proyectobd;
import java.io.*;
import java.sql.*;
import javax.swing.*;
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package proyectobd;
import java.io.*;
import java.sql.*;
import javax.swing.*;
/**
*
* @author Gherard
*/
public class Conector {
static Connection conn=null;
static Statement st=null;
static ResultSet rs=null;
*
* @author Gherard
*/
public class Conector {
static Connection conn=null;
static Statement st=null;
static ResultSet rs=null;
static String bd="BASE_DE_DATOS";
static String login="USER_ID";
static String password="PASSWD";
static String url="jdbc:oracle:thin:@IPSERVER:Puerto:BASE_DE_DATOS";
static String login="USER_ID";
static String password="PASSWD";
static String url="jdbc:oracle:thin:@IPSERVER:Puerto:BASE_DE_DATOS";
public static Connection Enlace(Connection conn)throws SQLException {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
conn=DriverManager.getConnection(url, login, password);
System.out.println("Se ha realizado la conexion");
}
catch(ClassNotFoundException e )
{
System.out.print("Clase no encontrada");
}
return conn;
}
conn=DriverManager.getConnection(url, login, password);
System.out.println("Se ha realizado la conexion");
}
catch(ClassNotFoundException e )
{
System.out.print("Clase no encontrada");
}
return conn;
}
public static Statement sta(Statement st)throws SQLException {
conn=Enlace(conn);
st=conn.createStatement();
return st;
}
conn=Enlace(conn);
st=conn.createStatement();
return st;
}
}
Comentarios
Publicar un comentario