Yesterday, the database from the Web project that was written was replaced by MySQL SQL Server, and tried to reinstall MySQL yesterday, but it was not possible to install it for unknown reasons.
Uninstall MySQL, delete installation files, delete the registry, restart your computer. However, the installation is still unable to install, get is the MySQL installation pain point. The installation of SQLServer2008 was started yesterday afternoon, until now. There are some problems in the middle.
1. About dbo
If this thing is not a database administrator, or you do not want to go too deep to understand SQL Server, you can directly ignore.
I understand that it is a user concept that can still be consistent with the MySQL database access layer during the encoding process.
2. Questions about Database Connectivity
A.jar package using Maven seems to have some problems, I was directly downloaded and placed in Lib
B. Database using the SA user if the connection cannot be made, it is possible that the SA user login is disabled. Sign in with Windows authentication
After logging in, such as:
We will find that the SA user has a downward arrow below, double-clicked, such as:
Simply change disable to Enabled, then log back in to see such as:
We'll see that the downward arrow in SA is Gone (Appendix: 1 I note that the button to disconnect and reopen the connection. With them you don't have to re-manage the interface and open it every time.
In this way, the web system can be very good to connect the database.
3.jdbc.jar Download
https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774
4. About self-growing keywords in mysql and SQL Server
Sql server:
CREATE TABLE INT Identity (1,1PRIMARYKEY ,user_idVARCHAR( NULL);
Mysql:
CREATE TABLE INTEGER PRIMARY KEY Auto_increment,user_idVARCHAR(notNULL);
5.jdbc.jar The files I downloaded
Https://yunpan.cn/cxpEQPGwrEPqa (Extract code: c098)
Using-sqljdbc4.jar in SPRINGMVC