Summary of Java Connection SQL Server database issues

It's on the Internet. To set the SQL Server network configuration-"SQLExpress" protocol-"TCP/IP" in Server Configuration Manager I tried it.

I do not know whether to test the settings of the time to change what parameters to the whole good.

Now the configuration is Eclipse Photon Release (4.8.0) +sqlserver2008

parameter is

Jdbc. Driverclassname=com.microsoft.sqlserver.jdbc.sqlserverdriver
Jdbc.url=jdbc:sqlserver://127.0.0.1:1433;databasename=test;
Jdbc.username=sa
jdbc.password=****

After the JDBC individual jar packages are imported, the key Sqljdbc4.jar must be able to connect successfully.

The table name does not conflict with the keyword in the database, I used the user as the name of the table, pit me for one hours I can't find the problem.

Summary of Java Connection SQL Server database issues