Language Lap trinh JAVA Java is the language programming direction objects (as C + +) do Sun Microsystem output to the first hex niên 90 the ky 20. Program Việt using Java can be running on any hệ system that have installed your virtual Java (JVM - Java Virtual Machine). Máy virtual Java (JVM - Java Virtual Machine): One programs write by Java will be compile ra mã of the virtual Java (mã java bytecode) | Software Installation for Java Course NGUYEN Hong Quang FIT HUT Installed software Tomcat: User: admin Pass: admin MySQL User: root Pass: root Install Java Unzip Run Setting classpath for JDBC Driver class as a archive file: classpath=% classpath %;C:\mysql\ ; 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 Some commands in MySQL : DROP TABLE table_name Alter table student change score mark int 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; Create a connection to MySQL (1) Select a right mouse in the “Table” Window 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 MySQL – Front (1) Connect to MySQL host MySQL – Front (1) Object browser MySQL – Front (2) Create new database MySQL – Front (3) Create new table MySQL – Front (3) Create new table MySQL – Front (3) Query Test Tomcat on Vista (1) Test Tomcat on Vista (2) Configuration on Eclipse Windows Preferences Start Tomcat on Eclipse (1) Start Tomcat on Eclipse (2)
