블로그 이미지
SQL Server VS. 석이 minsouk@hotmail.com MSSQL 쿼리성능 관련해 궁금한 사항이 있다면 언제나 누구나 TeamViewer + Line (네이버 japan 메신저) 에 minsouk1 추가 후 연락주세요~ 010-9967-0955 보미아빠

카테고리

보미아빠, 석이 (436)
밥벌이 (16)
싸이클 (1)
일상 (1)
Total192,291
Today1
Yesterday72

달력

« » 2017.06
        1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30  

공지사항

'2017/06'에 해당되는 글 5건

  1. 2017.06.29 excel 암호풀기
  2. 2017.06.14 ssms 에러
  3. 2017.06.12 json
  4. 2017.06.12 Using Java Classes in your .NET Application
  5. 2017.06.05 powershell

excel 암호풀기

분류없음 / 2017.06.29 17:38

http://m.blog.naver.com/sindong14/220408019666

헐~ 이렇게 쉬울수가....2016까지 다 풀립니다. (테스트 완료)

저작자 표시 비영리 변경 금지
신고
Posted by 보미아빠

ssms 에러

분류없음 / 2017.06.14 14:05

https://connect.microsoft.com/VisualStudio/feedback/details/1171345/exception-when-opening-editor

 

del %temp%

 

저작자 표시 비영리 변경 금지
신고
Posted by 보미아빠

json

분류없음 / 2017.06.12 13:41

http://devluna.blogspot.kr/2016/05/newtonsoftjson-c-net-json-parsing.html

http://www.csharpstudy.com/Data/Json-jsonnet.aspx

저작자 표시 비영리 변경 금지
신고
Posted by 보미아빠

 

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.
Is your email address OK? You are signed up for our newsletters but your email address is either unconfirmed, or has not been reconfirmed in a long time. Please click here to have a confirmation email sent so we can confirm your email address and start sending you newsletters again. Alternatively, you can update your subscriptions.

Introduction

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:

  1. A Java Virtual Machine implemented in .NET
  2. A .NET implementation of the Java class libraries
  3. Tools that enable Java and .NET interoperability

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.

  • IKVM.Runtime.dll: The VM runtime and all supporting code containing the byte code JIT compiler/verifier, object model remapping infrastructure and the managed .NET re-implementations of the native methods in Classpath. 
  • IKVM.GNU.Classpath.dll: Compiled version of GNU Classpath, the Free Software Foundation's implementation of the Java class libraries, plus some additional IKVM.NET specific code. 
  • ikvm.exe: Starter executable, comparable to java.exe ("dynamic mode").
  • ikvmc.exe: Static compiler. Used to compile Java classes and jars into a .NET assembly ("static mode").

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.

Setting Up IKVM.NET

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.

Our Demo Java Business Class (JavaToNet.java)

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.

Using IKVM.NET to Convert Java Class to .NET DLL

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.

Setting Up Your .NET Development Environment

  1. Start by creating a C# Windows application project. 

  2. Drag and drop controls into the form as shown:

  3. Add the following DLLs as references to the project. Both DLLs are present in the C:\ikvm\bin folder.

    • JavaToNet.dll
    • IKVM.GNU.Classpath.dll
  4. 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)));            
        }
    }
  5. Add the following using directive on the top of the *.cs file:

    using TimeZone = java.util.TimeZone;
  6. 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());
    }
  7. 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.

  8. Click on the ‘Time Zone’ button. The application accesses the java.util.TimeZone class and displays the exact time zone of the place.

Conclusion

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.

History

  • 03-25-06 Initial publication

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

저작자 표시 비영리 변경 금지
신고
Posted by 보미아빠

powershell

분류없음 / 2017.06.05 11:17

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/

 

 

 

기본 쿼리

https://msdn.microsoft.com/ko-kr/powershell/scripting/getting-started/cookbooks/working-with-registry-entries

 

 

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;
                                        }
                                    }
                                }

 

                            }
                        }
                       

                    }
                }
 

저작자 표시 비영리 변경 금지
신고
Posted by 보미아빠

최근에 달린 댓글

최근에 받은 트랙백

글 보관함