Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public Connection getConexionBD(String bd) {
- System.out.println("en la clase conexionJDBC");
- String driver="";
- String connectString="";
- String user="";
- String password="";
- if(bd.equals("postgresql")){
- driver="org.postgresql.Driver";
- connectString="jdbc:postgresql://10.34.2.62:5432/GestionGarita";
- user="postgres";
- password="portalprodpostgres64";
- }
- if(bd.equals("sqlserver")){
- driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
- connectString="jdbc:sqlserver://10.34.2.83:1433;database=SincroBI;";
- user="USERSINCRO";
- password="sincrobi";
- }
- if(bd.equals("sqlserver_DWH_CPSAA")){
- driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
- connectString="jdbc:sqlserver://10.34.2.83:1433;database=DWH_CPSAA;";
- user="CPSAABI";
- password="cpsaabi";
- }
- Connection cn = null;
- try {
- Class.forName(driver);
- cn = DriverManager.getConnection(connectString, user, password);
- } catch (Exception e) {
- System.out.print("conexion incorrecta");
- System.out.println(e.getMessage());
- e.printStackTrace();
- }
- return cn;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement