Alin Sinpalean posted a comment on discussion Open Discussion

Brenda, you can use Statement.addBatch() -- see https://docs.oracle.com/javase/8/docs/api/java/sql/Statement.html or search Google for "jdbc batch" -- to send multiple insert/update statements at once so you don't have to do repeated roundtrips. That being said I don't think that having a SQL Server instance publicly available on the internet is safe. So you might want to throw up a simple webapp in front of it.