Question

I made a java program in which users would be automatically inserted/selected lines into/from one mysql database, but could not modify any existing lines, tables, db, or privilages. I got myself a website and hosted it in 1and1.com, but sadly I found out that its a pain(impossible) to have multiple users for one database and to remotly connect to a database.

I was wondering what are my options here?
I suppose the first one would be to get another host that allows me to do this.
The only other option I can think of is that somehow I manage to send from java the information to my website, and then the website to connect to the database. (not an expert in php, html, or what ever i ahve to do (be by embbedding a browser on my GUI or by doing it under the hood).

这是我第一次尝试制定一个与在线数据库连接的方案,因此请浏览。

Note: program worked in localhost.
1&1 support useless.

Answer 1

几乎所有使用数据库的(网)应用程序,都与数据库连接,整个应用程序使用一个数据库。申请的每个用户都有不同的数据库用户,这是一个不常见的设计。

因此,您应配置一个数据库用户,该用户使用该数据库读取或写给数据库;该数据库用户独立于用户,并由所有用户共享。不应当从应用用户到数据库用户进行一对一的绘图。

原因不同。其中一项是可衡量的。大多数数据库无法同时处理数千条链接。如果你拥有一个能够同时使用数千个用户的网站,那么你不想有一个数据库链接,每个用户都有一个独特的用户名称。相反,你希望使用一个数据库链接库;只要网络用户之一需要采取行动进入数据库,就会重新使用该数据库中的联系。

友情链接