Using-sqljdbc4.jar in SPRINGMVC

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.