package com.test;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class DBConn {

    public static Connection getConn(String db){

        String driverName="";

        String dbURL="";

        String userName = "";

        String userPwd = "";

        if(db.equals("sqlServer")){

            driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

            dbURL = "jdbc:sqlserver://192.168.0.1:1444; DatabaseName=test";

            userName = "";

            userPwd = "";

        }else if(db.equals("oracle")){

            driverName = "oracle.jdbc.driver.OracleDriver";

            dbURL = "jdbc:oracle:thin:@192.168.0.1:1521:test";

            userName = "";

            userPwd = "";

        }else if(db.equals("mysql")){

            driverName = "com.mysql.jdbc.Driver";

            dbURL = "jdbc:mysql://192.168.0.1:3306/test";

            userName = "";

            userPwd = "";

        }

        Connection dbConn=null;

        try {

            Class.forName(driverName);

            dbConn = DriverManager.getConnection(dbURL, userName, userPwd);

        } catch (Exception e) {

            e.printStackTrace();

        }

        return dbConn;

    }

    public static void main(String[] args) {

        Connection dbConn =DBConn.getConn("oracle");

        System.out.println(dbConn);

        String sql = "select id from table";

        PreparedStatement ps;

        try {

            ps = dbConn.prepareStatement(sql);

            ResultSet rs = ps.executeQuery();

            while(rs.next())

                System.out.println(rs.getInt("id"));

        } catch (SQLException e) {

            e.printStackTrace();

        }

    }

}