如何在HSQLDB和C#.net之间建立连接? [英] How to form connection between HSQLDB and C# .net?

问题描述

如何在HSQLDB和C#.net之间建立连接?我已经看过SharpHSQL和H2Sharp，但无法连接HSQLDB.

How to form connection between HSQLDB and C# .net ? I have already looked at SharpHSQL and H2Sharp but not able to connect the HSQLDB.

推荐答案

基本步骤:

1. 下载 IKVM.NET 和

1. Download IKVM.NET and HyperSQL (=HSQLDB) driver.

使用IKVM.NET将HSQLDB Java驱动程序转换为.NET DLL，以创建 hsqldb.dll

Convert HSQLDB Java driver to .NET DLL using IKVM.NET to create a hsqldb.dll

向您的C#项目添加编译时依赖项:

Add compile time dependencies to your C# project:

• hsqldb.dll
  
• IKVM.OpenJDK.Core.dll
• IKVM.OpenJDK.Jdbc.dll
1. 在运行C#程序时添加运行时依赖项:
   
• IKVM.OpenJDK.Localedata.dll
  
• IKVM.OpenJDK.Text.dll
  
• IKVM.OpenJDK.Util.dll
  
• IKVM.Runtime.dll
  
1. 将连接字符串添加到您的app.config中:

<configuration>

  <connectionStrings>
    <add name="HyperSQL"
        connectionString="jdbc:hsqldb:hsql://localhost:9999/xdb;user=SA;password=;" />
  </connectionStrings>

  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6.1" />
  </startup>
</configuration>

1. C#代码:

using System;
using System.Configuration;
 
namespace HyperSQL
{
    class Program
    {
        readonly static string CONNECTION_STRING = ConfigurationManager.ConnectionStrings["HyperSQL"].ConnectionString;
        const string SQL = "SELECT * FROM customer";
 
        static void Main(string[] args)
        {
            java.sql.DriverManager.registerDriver(new org.hsqldb.jdbcDriver());
            using (java.sql.Connection conn = java.sql.DriverManager.getConnection(CONNECTION_STRING))
            {
                java.sql.PreparedStatement ps = conn.prepareStatement(SQL);
                using (java.sql.ResultSet rs = ps.executeQuery())
                {
                    while (rs.next())
                    {
                        Console.WriteLine($"ID={rs.getInt("id")}");
                        Console.WriteLine($"NAME={rs.getString("name")}");
                        Console.WriteLine($"AGE={rs.getInt("age")}");
                        Console.WriteLine($"ADDRESS={rs.getString("address")}");
                        Console.WriteLine($"SALARY={rs.getInt("salary")}");
 
                        Console.WriteLine("------------------");
                    }
                }
            }
 
            Console.ReadLine();
        }
    }
}

这里是我的详细教程如何从C#连接到HyperSQL

这篇关于如何在HSQLDB和C#.net之间建立连接?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！