1)MySQL中创建表
create table student ( id int(11) not null, name varchar(255) default null, email varchar(255) default null, age int(11) default null, primary key(id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
insert into student(id,name,email,age) values (1,"zhangsan","zhangsan@hotmail.com",20);
insert into student(id,name,email,age) values (2,"lisi","lisi@hotmail.com",18);
select id,name,email,age from student;
2)加入Maven的mybatis坐标,MySQL驱动的坐标。
2.1)打开Eclipse,创建一个maven project, mybatis-practice。
2.2)配置pom.xml文件,使其包含如下内容。然后右键pom.xml,Maven,update project。
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>practice</groupId>
<artifactId>mybatis</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>war</packaging>
<name>mybatis-practice</name>
<dependencies>
<dependency>
<grou