mybatis基本搭建

1、先导入两个核心包mybatis-3.2.7.jar和mysql-connector-java-5.1.26.jar；

 

2、配置mybatis-confing.xml 主要是配置好数据库的driver、url、username数据库的用户名、password数据库密码

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/ssm"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>

主要引用的xml文件
<mappers>
<mapper resource="cn/mapper/User.xml"/>
</mappers>
</configuration>

 3、写好user类

ublic class User {
private int id;
private String name;
private String detail;
private int userId;

public int getId() {
return id;
}

public void setId(int id) {
this.id = id;
}

public String getName() {
return name;
}

public void setName(String name) {
this.name = name;
}

public String getDetail() {
return detail;
}

public void setDetail(String detail) {
this.detail = detail;
}

public int getUserId() {
return userId;
}

public void setUserId(int userId) {
this.userId = userId;
}

@Override
public String toString() {
return "User [id=" + id + ", name=" + name + ", detail=" + detail + ", userId=" + userId + "]";
}

}

4、配置mapper.xml文件，主要的是用xml写增删改查的语句

 

 5、测试数据：主要的四步

 

 数据库

create database ssm;

CREATE TABLE `ssm_book` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(111) DEFAULT NULL,
  `detail` varchar(256) DEFAULT NULL,
  `userId` int(22) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8