记录一下Erel的jRDC2的用法(连接SQL Server)

[bigluo]

基本用法示例里面都有，但有两个地方没提，我前后研究了两天才搞清楚，在这里列出来，仅供参考：
1. SQL Server 要开启TCP/IP服务，并且要打开1433端口
2. 配置文件 config.properties 里面不能有中文，因为java 9之前的版本，打开配置文件时，默认的编码问题，里面的中文读出来是乱码，解决方法就是要自己转
3. 连接配置大概就是这样，SQL Server里面的 mysert\SQLEXPRESS的实例名称，是不用输入的

DriverClass=net.sourceforge.jtds.jdbc.Driver
JdbcUrl=jdbc:jtds:sqlserver://localhost/my_db_name
User=my_username
Password=my_password

 

[aeric]

config.properties 里面不能有中文

为什么config.properties 里面有中文会造成错误？
中文评论应该是允许的。

 

[aeric]

也许你可以参考我的教程

[Installation Guide] [B4A] Supermarket, Restaurant, Pharmacy, Store Delivery

Disclaimer: I do not create/own the original project source code therefore please don't ask me to provide full support. I am just helping a member to make this project work. I do not get any money doing this so I am thinking to share it to other members too, who are happen to have purchased the...

www.b4x.com

 

[bigluo]

根据我的搜索，是这样的：

 .properties files are expected to be encoded in ISO 8859-1. One can use unicode escapes to specify other characters. There is also a tool available to do the conversion.

 

[aeric]

根据我的搜索，是这样的：

 .properties files are expected to be encoded in ISO 8859-1. One can use unicode escapes to specify other characters. There is also a tool available to do the conversion.

感谢分享这信息

 

[bigluo]

感谢分享这信息

老大，碰到难题了，可以帮忙看一下吗？谢谢！

help with jserver BasicAuthentication

when try to implement @Erel's basicauthentication: https://www.b4x.com/android/forum/threads/jserver-authentication.79720/ Sub AppStart (Args() As String) srv.Initialize("server") srv.Port = 51042 srv.AddFilter("/*", "BasicAuthenticationFilter", False) srv.AddHandler("/test/*"...

www.b4x.com