CREATE DATABASE IF NOT EXISTS `common_mapper`;
USE `common_mapper`;
drop table if exists `tabple_emp`;
CREATE TABLE `tabple_emp`(
`emp_id` INT NOT NULL AUTO_INCREMENT,
`emp_name` VARCHAR(500) NULL,
`emp_salary_apple` DOUBLE(15, 5) NULL,
`emp_age` INT NULL,
PRIMARY KEY (`emp_id`)
) ;
INSERT INTO `tabple_emp`(`emp_name`,`emp_salary_apple`,`emp_age`) VALUES('tom','1254.37','27');
INSERT INTO `tabple_emp`(`emp_name`,`emp_salary_apple`,`emp_age`) VALUES('jerry','6635.42','38');
INSERT INTO `tabple_emp`(`emp_name`,`emp_salary_apple`,`emp_age`) VALUES('bob','5560.11','40');
INSERT INTO `tabple_emp`(`emp_name`,`emp_salary_apple`,`emp_age`) VALUES('kate','2209.11','22');
INSERT INTO `tabple_emp`(`emp_name`,`emp_salary_apple`,`emp_age`) VALUES('justin','4203.15','30');
INSERT INTO `tabple_emp`(`emp_name`,`emp_salary_apple`,`emp_age`) VALUES('kangkang','4203.15','40');
SELECT * FROM `tabple_emp`;
mvn mybatis-generator:generate