mybatis mysql_mybatis+mysql入门例子

一、简介

MyBatis 是一款优秀的持久层框架，它支持定制化 SQL、存储过程以及高级映射。

二、入门使用

1.使用maven管理依赖

jar

org.mybatis

mybatis

3.4.1

mysql

mysql-connector-java

5.1.46

${project.artifactId}

src/main/java

false

src/main/resources

false

org.apache.maven.plugins

maven-compiler-plugin

1.8

1.8

org.apache.maven.plugins

maven-jar-plugin

3.0.2

target/classes/

true

true

lib/

com.wyh.Main

org.apache.maven.plugins

maven-dependency-plugin

2.10

copy-dependencies

package

copy-dependencies

${project.build.directory}/lib

org.apache.maven.plugins

maven-assembly-plugin

2.5.5

com.wyh.Main

jar-with-dependencies

make-assembly

package

single

2.在resources下创建application.xml和jdbc.properties

2.1 application.xml

/p>

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

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

2.2 jdbc.properties

jdbc_driver=com.mysql.jdbc.Driver

jdbc_url=jdbc\:mysql\://127.0.0.1:3306/stu?characterEncoding=utf-8&useSSL=true

jdbc_username=root

jdbc_password=123456

3.建立pojo的包，建立User实体类

public class User {

private Integer id;

private String name;

private String data;

public User() {

}

public Integer getId() {

return id;

}

public void setId(Integer id) {

this.id = id;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public String getData() {

return data;

}

public void setData(String data) {

this.data = data;

}

@Override

public String toString() {

return "User{" +

"id=" + id +

", name='" + name + '\'' +

", data='" + data + '\'' +

'}';

}

}

4.建立mapper包

4.1建立UserMapper接口

public interface UserMapper {

public User selectUserById(Integer userId);

public List selectUserAll();

public void insertUser(User user);

public void updateUser(User user);

}

4.2建立UserMapper.xml

/p>

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

SELECT * FROM student WHERE ID = #{id}

SELECT * FROM student

insert into student (id,name,data)

values (#{id},#{name},#{data})

update student

data = #{data ,jdbcType=CHAR}

,

name = #{name ,jdbcType=CHAR}

where id = #{id}

5.建立utils包，并建立UpdateDB类

public class UpdateDB {

public static void updateDB(User user) {

SqlSession session = null;

try {

// 读取配置信息

String resource = "application.xml";

InputStream inputStream = Resources.getResourceAsStream(resource);

SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();

// 选择不同的环境

String env = "product";

SqlSessionFactory factory = builder.build(inputStream,env);

// 产生SqlSession对象

session = factory.openSession();

System.out.println(session);

// 获取映射对象

UserMapper userMapper = session.getMapper(UserMapper.class);

// 获取id为1的账户

//User user = userMapper.selectUserById(1);

//System.out.println(user);

// 获取所有账户

List arrayList = userMapper.selectUserAll();

System.out.println("before:" + arrayList);

//更新数据

userMapper.updateUser(user);

session.commit();

// 获取所有账户

arrayList = userMapper.selectUserAll();

System.out.println("after"+arrayList);

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} finally {

if (session != null)

// 关闭连接

session.close();

}

}

}

6.测试程序

建立主类

public class Main {

public static void main(String[] args) {

User user = new User();

user.setId(1);

user.setName("zhangsan");

user.setData("100");

UpdateDB.updateDB(user);

}

}

运行测试，如下图

test.jpg