public void dbConnect(String db_connect_string,
            String db_userid,
            String db_password) {
        try {
            Class.forName("net.sourceforge.jtds.jdbc.Driver");
            Connection conn = DriverManager.getConnection(db_connect_string, db_userid, db_password);
            System.out.println("connected");
            Statement statement = conn.createStatement();
            String query = "SELECT      DNOrPattern AS SDA, CalledPartyTransformationMask AS DirectoryNumber\n"
                    + "FROM	dbo.NumPlan \n"
                    + "Where tkPatternUsage = '3' and len(DNOrPattern) = 3";
            ResultSet rs = statement.executeQuery(query);
            while (rs.next()) {
                System.out.println(
                        "\t" + rs.getString("SDA")
                        + "\t" + rs.getString("DirectoryNumber"));
                dbInsert(rs.getString("SDA"), rs.getString("DirectoryNumber"));
            }
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
    }