PRIMARY KEY CLUSTERED ([Id] ASC)CREATE TABLE [dbo].[DataAdditional] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[Alpha] INT NULL,
[Bravo] BIGINT NULL,
[Charlie] BIGINT NULL,
[Delta] INT NULL,
[Echo] INT NULL,
[Foxtrot] INT NULL,
[Golf] INT NULL,
[Hotel] NVARCHAR (MAX) NULL
-- , PRIMARY KEY CLUSTERED ([Id] ASC)
);DB dbA = new DB();
dbA.Id = 0;
db.ParentId = null;
DB dbB = new DB();
dbB.Id = 1;
dbB.ParentId = 0;
DB dbC = new DB();
dbC.Id = 2;
dbC.ParentId = 0;
DB dbD = new DB();
dbD.Id = 3;
dbD.ParentId = 2;dbA (id=0)
|---dbB (id=1)
|---dbC (id=2)
|---dbD (id=3)Match match = Regex.Match("https://vk.com/wall-307584833_1982089?reply=3438479", @"wall\-(\d+)_\d+\?reply\=(\d+)",
RegexOptions.IgnoreCase);
if (match.Success)
{
string wallId= match.Groups[1].Value;
string replyId= match.Groups[2].Value;
}public String getPrivateKeyAsXml(PublicKey publicKey, PrivateKey privateKey) throws Exception
{
KeyFactory kf = KeyFactory.getInstance("RSA");
RSAPublicKeySpec ksPublic = kf.getKeySpec(publicKey, RSAPublicKeySpec.class);
RSAPrivateKeySpec ksPrivate = kf.getKeySpec(privateKey, RSAPrivateKeySpec.class);
BigInteger n = ksPublic.getModulus();
BigInteger e = ksPublic.getPublicExponent();
BigInteger d = ksPrivate.getPrivateExponent();
BigInteger p = findFactor(e, d, n);
BigInteger q = n.divide(p);
if (p.compareTo(q) > 1) {
BigInteger t = p;
p = q;
q = t;
}
BigInteger dp = d.mod(p.subtract(BigInteger.ONE));
BigInteger dq = d.mod(q.subtract(BigInteger.ONE));
BigInteger inverseQ = q.modInverse(p);
String publicKeyAsXML = "<RSAKeyValue>" +
"<Modulus>" + convertToString(n) + "</Modulus>" +
"<Exponent>" + convertToString(e) + "</Exponent>" +
"<P>" + convertToString(p) + "</P>" +
"<Q>" + convertToString(q) + "</Q>" +
"<DP>" + convertToString(dp) + "</DP>" +
"<DQ>" + convertToString(dq) + "</DQ>" +
"<InverseQ>" + convertToString(inverseQ) + "</InverseQ>" +
"<D>" + convertToString(d) + "</D>" +
"</RSAKeyValue>";
Log.d(TAG, "getPrivateKeyAsXml: " + publicKeyAsXML);
return publicKeyAsXML;
}
private String convertToString(BigInteger n) {
return Base64.encodeToString(n.toByteArray(), Base64.NO_WRAP);
}