1. Download and install Tomcat

Various download sites

Links:tomcat.apache.org/

Select the version you want to downloadHere is the Tomcat Chinese Website

Links:www.tomcat.org.cn/download

2. Download and install Eclipse

Links:www.jb51.net/softs/62206…

After the download and installation is complete, configure the Web interface as follows:Blog.csdn.net/xiakexiaohu…

3. Installation of MySQL

Do not use CMD window, better install mysql software such as SQLyog, or Navicat

②, about the database uninstall tutorial:Jingyan.baidu.com/article/f96…

③, about the database installation tutorial (before installing mysql, uninstall mysql before clean, otherwise there will be conflict, installation can not) :Jingyan.baidu.com/article/642…

④ Database installation package link (which contains the registration code) :

Links:Pan.baidu.com/s/1h2qp61gB…

Extraction code: 1WH7

Install the mysql server first, and then install the mysql client

Once installed, click test connection and there will be a successful popup, which means it is ok

4, about SQLServer installation tutorial

Links:Sqlserver2008 simplified Chinese version

Links:SQLServer installation tutorial

SQLServer to MySQL

SQLServer database file name suffix is MDF and LDF, mysql file name suffix is SQL

There are several conversion methods:

The first: SQLServer2008 software has its own conversion function, can be converted into SQL files

Import MDF and LDF to SQLServer2008, and then export tables and data to SQL files

Second: data transfer using NavICat

Select SQLServer as the source and mysql as the target. Data can be transferred only when the two databases are installed

Detailed tutorialwww.163.com/dy/article/…

The third kind: link:MYSQL > select * from SQLServer;

The fourth: use other methods, not a list, Baidu can search out.

MySQL (5.5-5.7); MySQL (5.5-5.7)

The MySQL version used in my project is 5.5-5.7. Some partners have MySQL version 8, which is incompatible (note that MySQL version 6 and 7 are not available).

Download jar package 8.0

Links:Pan.baidu.com/s/14SavHylf…Extraction code: EB13

Copy the JAR package to the web-INF –>lib file under the project

Example Modify the connection information of mysql configuration

① Before modification

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/second_hand_db? useUnicode=true&characterEncoding=UTF-8
jdbc.username=root
jdbc.password=123456
Copy the code

② replace the drive

. Com. Mysql. The JDBC Driver to com. Mysql. Cj). The JDBC Driver

3, the introduction of SSL security authentication

useSSL=false

Add a time zone

serverTimezone=UTC

⑤ after modification

jdbc.driverClassName=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/second_hand_db? useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=UTC
jdbc.username=root
jdbc.password=123456
Copy the code

You can also baidu by yourself