*/
public class DataBase {
    public static void main(String[] args) throws SQLException {
        DataBase db=new DataBase();
       // db.get_spl("0894957362","M106661");
         db.create_login();
    }


  /*  public String get_spl(String login,String service_id) throws SQLException {
        String spl_id="не найдено";
        try {
            //  String url = "jdbc:oracle:thin:FTEST/L6k6yDfL@10.4.0.32:1521:billft3";
            String dbURL = "jdbc:oracle:thin:@10.4.0.32:1521:billft3";
            String username = "FTEST";
            String password = "L6k6yDfL";
            Connection con = DriverManager.getConnection(dbURL, username, password);
                Statement stmt = con.createStatement();
                ResultSet rs = stmt.executeQuery("SELECT spl_id FROM inac.services_per_login  WHERE SPL_LOGIN='"+login+"' AND spl_service='"+service_id+"'");
                while (rs.next()) {
                    String str = rs.getString("spl_id") + ":" + rs.getString(1);
                    System.out.println("spl_id = " + str);
                    spl_id=rs.getString(1);
                }
                rs.close();
                stmt.close();
            con.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return spl_id;
    }*/

    private void create_login() throws SQLException {
        try {
            String dbURL = "jdbc:oracle:thin:@10.4.0.32:1521:billft3";
            String username = "FTEST";
            String password = "L6k6yDfL";
            Connection con = DriverManager.getConnection(dbURL, username, password);
            String query = "inac.new_abon_for_test(?); end";
            CallableStatement cstmt = con.prepareCall(query);
            cstmt.registerOutParameter(1, OracleTypes.VARCHAR);
            cstmt.execute();
            String result = cstmt.getString(1);
            } catch (Exception e) {
            e.printStackTrace();
        }
    }
}