Īdd the project to the configuration environment, and click Finish There will be a Tomcat server, then click Apply and Close,Ĭlick the link, No servers are availble. Select Apache, as shown in the figure, click next toĪdd the installation path of Tomcat, and then click Finish toĪdd it. select the project path you just downloaded, and then click Finish Finish to Waiting list to refresh the Server AdapterĬlick to Directory.
, and then click FinishĬlick Install anyway to enter the following interface, then the check, and click Accept selected Related configuration before adding codeįinished loading, select Web,XML,Java EE and OSGi Enterprise Development all the files, and then click Next >Īnother point Next >, and then check I accept. See the link above for installation, and let's talk about configuration below. Insert into optcou (sid,cid ) values (100000000,100000003 ) ĭouble-click the newly created database to Insert data insert into student (spwd,sname ) values ( '1', '小一' ), ( '2', '小二' )
Sname varchar (20 ) ) AUTO_INCREMENT = 100000000 Ĭourse schedule: course number course name credits drop table if exists course Ĭourse selection table: student number course number results drop table if exists optcou įoreign key (sid ) references student (sid ) on delete cascade on update cascade,įoreign key (cid ) references course (cid ) on delete cascade on update cascade,
Student table: student ID password name drop table if exists student Right-click the newly created database, click New Query toĪdd the following SQL statements, and run them one by one. Right-click the connection name, create a new database, Open the MySQL service as an administrator,Įnter the connection name, password, and click OK. Navicat for MySQL v15 Chinese Enterprise Edition installation and activation tutorial (download attached). Tomcat9.0 installation tutorial Tomcat9.0 environment variable configuration tutorial. You need to install JDK before installing eclipse.Įclipse version selection and installation. It is the core of the entire Java including: Java runtime environment Jre, Java tools (javac/java/jdb, etc.) and Java basic class libraries (Java API, rt.jar, etc.). Java Development Kit is a product for Java developers. A website with installation tutorials and installation materials is attached for your reference for configuration and installation. There will not be repeated installations here. Some applications have already been installed and configured when learning Java. Student Achievement Query Web System-Function Overview. For an overview of its related functions, please refer to the link below: Connection problems (caused by differences in MySQL versions)Ĭreate a corresponding student score table in Mysql, and then JSP+Mysql make a simple student score query web system based on it. A web system for querying student scores based on JSP+Mysql.