简单的mybatis例子，用idea写的

来源：互联网发布：vscode 设置语法高亮编辑：程序博客网时间：2024/05/21 11:04

用的是maven搭建

目录结构：

pom.xml

<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 http://maven.apache.org/maven-v4_0_0.xsd">  <modelVersion>4.0.0</modelVersion>  <groupId>com.wzl.mybatis</groupId>  <artifactId>mybatis</artifactId>  <packaging>war</packaging>  <version>1.0-SNAPSHOT</version>  <name>mybatis Maven Webapp</name>  <url>http://maven.apache.org</url>  <dependencies>    <dependency>      <groupId>junit</groupId>      <artifactId>junit</artifactId>      <version>3.8.1</version>      <scope>test</scope>    </dependency>    <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->    <dependency>      <groupId>org.mybatis</groupId>      <artifactId>mybatis</artifactId>      <version>3.0.3</version>    </dependency>    <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->    <dependency>      <groupId>mysql</groupId>      <artifactId>mysql-connector-java</artifactId>      <version>5.1.21</version>    </dependency>  </dependencies>  <build>    <finalName>mybatis</finalName>  </build></project>

configuration.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>    <typeAliases>        <typeAlias alias="User" type="entity.User" />    </typeAliases>    <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/mybatis?useUnicode=true&characterEncoding=utf8" />                <property name="username" value="root" />                <property name="password" value="bobo" />            </dataSource>        </environment>    </environments>    <mappers>        <mapper resource="mapper/User.xml" />    </mappers></configuration>

User.java

package entity;public class User {    private int id;    private String name;    private String pass;    private String sex;    public String getSex() {        return sex;    }    public void setSex(String sex) {        this.sex = sex;    }    public String getPass() {        return pass;    }    public void setPass(String pass) {        this.pass = pass;    }    public User() {    }    public User(int id, String name) {        this.id = id;        this.name = name;    }    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;    }    @Override    public String toString() {        return "User [id=" + id + ", name=" + name + "]";    }}

User.xml

<?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="entity.User">    <select id="selectUser" parameterType="int" resultType="User">        select * from `user` where id = #{id}    </select>    <delete id="deleteUser" parameterType="User">        delete from `user` where id=#{id}    </delete>    <update id="updateUser" parameterType="User">        UPDATE `user`        <set>            <if test="name != null">name=#{name},</if>            <if test="pass != null">name=#{pass},</if>            <if test="sex != null">name=#{sex}</if>        </set>        where id=#{id}    </update>    <!--useGeneratedKeys设置为"true"表明要MyBatis获取由数据库自动生成的主键；       keyProperty="id"指定把获取到的主键值注入到User的id属性-->    <insert id="insertUser" parameterType="User">        insert into `user` (id,`name`,pass,sex) value(#{id},#{name},#{pass},#{sex})    </insert></mapper>

Test.java

package dao;import entity.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 java.io.IOException;import java.io.Reader;/** * Created by Administrator on 2017/3/20. */public class Test {    public static void main(String[] args) throws IOException {        String resource = "configuration.xml";        Reader reader = Resources.getResourceAsReader(resource);        SqlSessionFactory ssf = new SqlSessionFactoryBuilder().build(reader);        SqlSession session = ssf.openSession();        try {            //查询            /*User user = (User) session.selectOne("selectUser", 1);            System.out.println(user);*/            //更新            /*User user=new User();            user.setName("拉拉");            user.setId(3);            session.update("updateUser",user);*/            //添加            User user=new User();            user.setId(5);            user.setName("wawwa");            user.setPass("qqqq");            user.setSex("qewe");            session.insert("insertUser",user);            //删除            /*User user=new User();            user.setId(2);            session.delete("deleteUser",user);*/            session.commit();        } catch (Exception e) {            e.printStackTrace();        } finally {            session.close();        }    }}

0 0