excel 암호풀기
http://m.blog.naver.com/sindong14/220408019666
헐~ 이렇게 쉬울수가....2016까지 다 풀립니다. (테스트 완료)
http://m.blog.naver.com/sindong14/220408019666
헐~ 이렇게 쉬울수가....2016까지 다 풀립니다. (테스트 완료)
https://www.codeproject.com/Articles/13549/Using-Java-Classes-in-your-NET-Application
IKVM.NET is an open source implementation of Java for Mono /Microsoft .NET Framework and makes it possible both to develop .NET applications in Java, and to use existing Java APIs and libraries in applications written in any .NET language.
Suppose you have been asked to migrate an existing multi-tier application to .NET where the business layer is written in Java. Normally you would have no option but to recode and port the entire application to any .NET language (e.g. C#). However this is where IKVM.NET comes to the rescue.
IKVM.NET is an open source implementation of Java for Mono /Microsoft .NET Framework and makes it possible both to develop .NET applications in Java, and to use existing Java API's and libraries in applications written in any .NET language. It is written in C# and the executables, documentation and source code can be downloaded from here.
IKVM.NET consists of the following three main parts:
However before we get any further into this topic, let’s discuss about few of the main components of the IKVM.NET package which we would be using later in this article.
Now back to our problem of migrating the existing Java business classes so that they can be accessed by the newly proposed .NET application. We would also like to use the various existing Java API and libraries in our .NET application. Let’s start by doing just that.
Download the binary distribution from the sourceforge site and unzip the contents to C:\ikvm (or X:\ikvm where X is your drive). You would find the ikvm executables and DLLs in the C:\ikvm\bin directory. Open a command or shell window, cd to C:\ikvm\bin, and type ‘ikvm’.
If your system is operating correctly, you should see the following output:
usage: ikvm [-options] <class> [args...] (to execute a class) or ikvm -jar [-options] <jarfile> [args...] (to execute a jar file)
For Linux based systems, the setup is similar as above. This is all you need to do for running the demo application.
public class JavaToNet
{
public static void main(String[] args)
{
System.out.println("This is a demonstration Program which\n");
System.out.println("shows the conversion of Java class to\n");
System.out.println("a .NET dll\n");
}
public static double AddNumbers(double a,double b){
double c = 0;
c = a + b;
return c;
}
public static double SubNumbers(double a,double b){
double c = 0;
c = a - b;
return c;
}
public static double MulNumbers(double a,double b){
double c = 0;
c = a * b;
return c;
}
public static double DivNumbers(double a,double b){
double c = 0;
c = a / b;
return c;
}
}
Our Java class is very simple. It has four functions for add, subtract, multiply and divide that take two double values and return a result. Our objective is to access these functions through our C# application. Compile the above Java file to get the JavaToNet.class. We will use this Java class file to generate the .NET DLL to be referenced in our C# program.
Copy the above Java class file (JavaToNet.class) to the C:\ikvm\bin directory. Now run the following command:
This would create the JavaToNet.dll from the JavaToNet.class file. There are other command line option for ikvmc.exe. For example: ‘ikvmc –target:exe javaToNet.class
’ would create an EXE and not a DLL. You can get all the options by typing ‘ikvmc’ in the command line.
Start by creating a C# Windows application project.
Drag and drop controls into the form as shown:
Add the following DLLs as references to the project. Both DLLs are present in the C:\ikvm\bin folder.
Add the following code to the button click event of the ‘Calculate’ button:
private void btnCal_Click(object sender, System.EventArgs e)
{
if (rdAdd.Checked == true)
{
txtResult.Text = Convert.ToString(JavaToNet.AddNumbers
(Convert.ToDouble(txtNum1.Text),Convert.ToDouble(txtNum2.Text)));
}else if (rdSub.Checked ==true)
{
txtResult.Text = Convert.ToString(JavaToNet.SubNumbers
(Convert.ToDouble(txtNum1.Text),Convert.ToDouble(txtNum2.Text)));
}
else if (rdMul.Checked == true)
{
txtResult.Text = Convert.ToString(JavaToNet.MulNumbers
(Convert.ToDouble(txtNum1.Text),Convert.ToDouble(txtNum2.Text)));
}
else
{
txtResult.Text = Convert.ToString(JavaToNet.DivNumbers
(Convert.ToDouble(txtNum1.Text),Convert.ToDouble(txtNum2.Text)));
}
}
Add the following using
directive on the top of the *.cs file:
using TimeZone = java.util.TimeZone;
Add the following code to the button click event of the ‘Time Zone’ button.
private void btnTimeZone_Click(object sender, System.EventArgs e)
{
MessageBox.Show(TimeZone.getDefault().getDisplayName());
}
Compile and run the application. The C# application would now call the AddNumbers()
, SubNumbers()
, MulNumbers()
and DivNumbers()
functions present in the JavaToNet.dll and return the result.
Click on the ‘Time Zone’ button. The application accesses the java.util.TimeZone
class and displays the exact time zone of the place.
Since these methods had originally been written in Java, IKVM.NET provides us an easy and viable way to access those classes and methods from a .NET application. Similarly as shown above in the ‘Time Zone’ example, you can access most of the existing Java packages (e.g. java.io, java.util, etc.) and use them in your application.
However there are certain drawbacks. IKVM.NET, while still being actively developed, has limited support for AWT classes and hence porting Java GUI can be ruled out at present. Also some of the default Java classes are still being ported so you might not get all the functionalities you require. Also if your application depends on the exact Java class loading semantics, you might have to modify it to suit your needs.
This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
remote command 활성화
https://technet.microsoft.com/en-us/library/ff700227.aspx
get-service winrm
Start-Service winrm
get-service winrm
winrm s winrm/config/client '@{TrustedHosts="WIN-6S4NEPKTVUI"}'
winrm quickconfig
파일 / 새 원격 PowerShell 탭
인증 ...
PowerShell 책
http://www.reedbushey.com/86Windows%20Powershell%20Cookbook%203rd%20Edition.pdf
C# 으로 powershell 불러쓰기
https://blogs.msdn.microsoft.com/kebab/2014/04/28/executing-powershell-scripts-from-c/
sql parameter
http://sql-articles.com/articles/general/enable-disable-trace-flags-in-sql-server/
기본 쿼리
sql parameter 쿼리하기
[mon]: PS C:\Users\db\Documents> Get-ItemProperty -Path Registry::"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQLServer\Parameters"
파일 읽어서 반환하기
등등
using (PowerShell PowerShellInstance = PowerShell.Create())
{
string cmd = @"Get-Item -Path Registry::\'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server'";
PowerShellInstance.AddScript(cmd);
Console.WriteLine(cmd);
Collection<PSObject> PSOutput = PowerShellInstance.Invoke();
foreach (PSObject outputItem in PSOutput)
{
// if null object was dumped to the pipeline during the script then a null
// object may be present here. check for null to prevent potential NRE.
if (outputItem != null)
{
if (PowerShellInstance.Streams.Error.Count > 0)
{
Console.WriteLine("Error");
}
else
{
Console.WriteLine(outputItem.BaseObject.GetType().FullName);
Console.WriteLine(outputItem.BaseObject.ToString() + "\n");
if (outputItem.BaseObject is RegistryKey)
{
RegistryKey rk = outputItem.BaseObject as RegistryKey;
string[] valueNames = rk.GetValueNames();
foreach (string s in valueNames)
{
RegistryValueKind rvk = rk.GetValueKind(s);
switch (rvk)
{
case RegistryValueKind.MultiString:
string[] values = (string[])rk.GetValue(s);
Console.Write("\r\n {0} ({1}) =", s, rvk);
for (int i = 0; i < values.Length; i++)
{
if (i != 0) Console.Write(",");
Console.Write(" \"{0}\"", values[i]);
}
Console.WriteLine();
break;
case RegistryValueKind.Binary:
byte[] bytes = (byte[])rk.GetValue(s);
Console.Write("\r\n {0} ({1}) =", s, rvk);
for (int i = 0; i < bytes.Length; i++)
{
// Display each byte as two hexadecimal digits.
Console.Write(" {0:X2}", bytes[i]);
}
Console.WriteLine();
break;
default:
Console.WriteLine("\r\n {0} ({1}) = {2}", s, rvk, rk.GetValue(s));
break;
}
}
}
}
}
}
}