Software Installation for Java Course
NGUYEN Hong Quang FIT HUT
Installed software
Tomcat:
User: admin Pass: admin
MySQL
User: root Pass: root
Unzip
Run
3
Install Java
Setting classpath for JDBC
Driver class as a archive file:
classpath=% classpath %;C:\mysql\ mysql connectorjava5.1.7bin.jar;
Driver class as a directory: classpath=% classpath %;C:\mysql\classes;
Copy class/zip/jar file into
directory “ext”
Install MySQL
Install MySQL : Step 1
Install MySQL : Step 2
Install MySQL : Step 3
Install MySQL : Step 4
Install MySQL : Step 5
Install MySQL : Step 6
Install MySQL : Step 7
Configuration of MySQL
Configuration of MySQL : step 1
Configuration of MySQL : step 2
Configuration of MySQL : step 3
Configuration of MySQL : step 4
Configuration of MySQL : step 5
Configuration of MySQL : step 6
Configuration of MySQL : step 7
Configuration of MySQL : step 8
Configuration of MySQL : step 9
Configuration of MySQL : step 10
Configuration of MySQL : step 11
Configuration of MySQL : step 12
Configuration of MySQL : step 13
Configuration of MySQL : step 14
Database Administation with MySQL
Display all databases installed in MYSQL :
Show databases;
Create a table
• CREATE TABLE table_name ( column_name1 type [modifiers]
[, column_name2 type [modifiers]] )
• Create table Student : CREATE TABLE student ( ID int(6) PRIMARY KEY, NAME varchar(30), ADDRESS varchar(30), PHONE varchar(10), score int(11), } ENGINE=InnoDB DEFAULT CHARSET=utf8
Database Administation with MySQL (1)
Create a database :
CREATE DATABASE TEMPDB;
Delete that database :
DROP DATABASE TEMPDB;
Use a database : USE TEMPDB;
Display tables in a database :
SHOW TABLES;
Database Administation with MySQL (2)
Display all databases installed in MYSQL :
Show databases;
Database Administation with MySQL (3)
Display all databases installed in MYSQL :
Create databases qlsv;
Database Administation with MySQL (4)
Display all databases installed in MYSQL :
use databases qlsv; show tables;
Database Administation with MySQL (5)
Display all databases installed in MYSQL :
create tables student;
Select a right mouse in the “Table” Window
Create a connection to MySQL (1)
Connecting DbEdit with MySQL (2)
Connecting DbEdit with MySQL (3)
Connecting DbEdit with MySQL (4)
Connecting DbEdit with MySQL (5)
Connecting DbEdit with MySQL (6)
Connecting DbEdit with MySQL
Input records with DbEdit
Connect to MySQL host
MySQL – Front (1)
Object browser
MySQL – Front (1)
Create new database
MySQL – Front (2)
Create new table
MySQL – Front (3)
Create new table
MySQL – Front (3)
Query
MySQL – Front (3)
Test Tomcat on Vista (1)
Test Tomcat on Vista (2)
Configuration on Eclipse
Windows
Preferen ces
