第一个mybatis

mybatis-3.2.2.jar                       核心jar

mysql-connector-java-5.1.10-bin.jar     数据库访问

asm-3.3.1.jar                           增强类

cglib-2.2.2.jar                         动态代理

commons-logging-1.1.1.jar               通用日志

javassist-3.17.1-GA.jar                 java助手

log4j-1.2.17.jar                        日志

slf4j-api-1.7.5.jar                     日志

slf4j-log4j12-1.7.5.jar                 日志

 

接下来映射器的配置

最后一步test方法的编写

 

文件目录

 

 

user类的编写

package mybatis.domain;

 

import lombok.Data;

 

 

public class user {

private Long id;

private String username;

private String password;

private Integer age;

 

public String getUsername() {

return username;

}

 

public void setUsername(String username) {

this.username = username;

}

 

public String getPassword() {

return password;

}

 

public void setPassword(String password) {

this.password = password;

}

 

public Integer getAge() {

return age;

}

 

public void setAge(Integer age) {

this.age = age;

}

 

@Override

public String toString() {

return "user{" +

"id=" + id +

", username='" + username + '\'' +

", password='" + password + '\'' +

", age=" + age +

'}';

}

}

 

 

 

 

mybatis.xml的编写

<?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="default">

<environment id="default">

<transactionManager type="JDBC"></transactionManager>

<dataSource type="POOLED">

<property name="driver" value="com.mysql.jdbc.Driver"></property>

<property name="url" value="jdbc:mysql://localhost:3306/mybatis"></property>

<property name="username" value="root"></property>

<property name="password" value="123456"></property>

</dataSource>

</environment>

</environments>

<mappers>

<mapper resource="mybatis/domain/usermapper.xml"></mapper>

</mappers>

</configuration>

 

 

 

 

 

usermapper的编写

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE mapper

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="mybatis.domain.usermapper">

<insert id="save" parameterType="mybatis.domain.user" keyColumn="id" keyProperty="id" useGeneratedKeys="true">

INSERT INTO user (username,password,age)VALUES (#{username},#{password},#{age})

</insert>

</mapper>

usertest方法的测试

package mybatis.test;

 

import mybatis.domain.user;

import org.apache.ibatis.io.Resources;

import org.apache.ibatis.session.SqlSession;

import org.apache.ibatis.session.SqlSessionFactory;

import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import org.junit.Test;

 

import java.io.IOException;

 

public class usertest {

@Test

public void test() throws IOException {

user u=new user();

u.setAge(17);

u.setUsername("小李子");

u.setPassword("123456");

SqlSessionFactory sf=new SqlSessionFactoryBuilder().build(Resources.getResourceAsStream("mybatis.xml"));

SqlSession session=sf.openSession();

session.insert("mybatis.domain.usermapper.save",u);

session.commit();

session.close();

System.out.println(u);

}

 

测试结果如下：

}