Conectar a bases de datos oracle, sqlLite, Sql Server 2008
Para conectar a SQL server 2008 la conexion es
protected synchronized void conectarSQLSERVER() {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn = DriverManager.getConnection(
"jdbc:sqlserver://SERVER : PUERTO; DatabaseName= MI_DB; "
+ "userName= MI_USUARIO ; password= MI_PASSWORD ");
return conn;
} catch (Exception ex) {
ex.printStackTrace();
}
}
Descargar Diver para jdk 5. Descarga
Descargar Diver para jdk 6. Descarga
Para conectar a SQL Lite la conexion es
protected synchronized void conectarSQLLITE() {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn = DriverManager.
getConnection("jdbc:sqlite:MI_DB");
return conn;
} catch (Exception ex) {
ex.printStackTrace();
}
}
Descargar Driver. Descarga
Para conectar a ORACLE la conexion es
protected synchronized void conectarORACLE() {
try {
Connection conn = DriverManager.getConnection(
"jdbc:oracle:thin:@SERVER:PUERTO : SID", "MY_USUARIO" , "MI_PASSWORD");
return conn;
} catch (Exception ex) {
ex.printStackTrace();
}
}
Descargar Driver. Descarga.
public static void main(String[] args) throws SQLException{
ejecutarSQL();
Integer salida=ejecutarStoredProcedure();
System.out.println(salida);
}
public static void ejecutarSQL() throws SQLException{
Connection conn=conectarORACLE();
Statement statement = conn.
ResultSet rs = stat.executeQuery("SELECT * FROM TABLA");
while (rs.next()) {
for(String campo:campos){
System.out.println(rs.getObject("CAMPO_1"));
}
}
rs.close();
conn.close();
}
public static Integer ejecutarStoredProcedure () throws SQLException{
Connection conn=conectarORACLE();
CallableStatement statement = conn.
prepareCall(" { call PROCEDIMIENTO_ALMACENADO ( ?,? )}");
this.statement.setInt("ID",1);
this.statement.registerOutParameter("SALIDA",java.sql.Types.INTEGER);
ResultSet rs = stat.executeQuery();
while (rs.next()) {
for(String campo:campos){
System.out.println(rs.getObject("CAMPO_1"));
}
}
rs.close();
conn.close();
return this.statement.getInt("SALIDA");
}
Comentarios
Publicar un comentario