需要用到的包：（这里只是其中一个版本，其他的百度） mysql-connector-java-5.1.6-bin mybatis-3.2.2 先看项目目录： 配置文件mybatisconfig.xml: ?xml version=1.0 encoding=utf-8?!doctype configurationpublic -//mybatis.org//dtd config 3.0//enhttp:/
需要用到的包：（这里只是其中一个版本，其他的百度）
mysql-connector-java-5.1.6-bin
mybatis-3.2.2
先看项目目录：
配置文件mybatisconfig.xml:

实体类user.java:package com.miquan.mybatis.bean;public class user { private int id; private string username; private string password; public user(int id, string username, string password) { super(); this.id = id; this.username = username; this.password = password; } public int getid() { return id; } public void setid(int id) { this.id = id; } 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; }}
user.xml:
iuseroperation.java:package com.miquan.mybatis.inter;import java.util.list;import org.apache.ibatis.annotations.delete;import org.apache.ibatis.annotations.insert;import org.apache.ibatis.annotations.select;import org.apache.ibatis.annotations.update;import com.miquan.mybatis.bean.user;public interface iuseroperation { @select(select * from user where id = #{id}) public user selectbyid(int id); @select(select * from user where username = #{username}) public list selectusers(string username); @insert(insert into user values(null, #{username}, #{password})) public boolean adduser(user user); @delete(delete from user where id = #{id}) public boolean deluser(int id); @update(update user + set username = #{username}, + password = #{password} + where id = #{id}) public boolean updateuser(user user);}最后进行测试：test.java:
package com.miquan.mybatis.test;import java.io.inputstream;import java.util.list;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 com.miquan.mybatis.bean.user;import com.miquan.mybatis.inter.iuseroperation;public class test { static sqlsession session; public static void main(string[] args) { try { //获取session inputstream is = resources.getresourceasstream(mybatisconfig.xml); sqlsessionfactory sqlsessionfactory = new sqlsessionfactorybuilder().build(is); session = sqlsessionfactory.opensession(); //xml配置对应用法// user user = session.selectone(com.miquan.mybatis.bean.userdb.selectbyid, 1);// system.out.println(user.tostring()); //接口调用法 //////注意：insert、delete和update方法调用之后必须commit才能真正的改变数据 iuseroperation useroperation = session.getmapper(iuseroperation.class); //查// user user = useroperation.selectbyid(1);// system.out.println(user.tostring()); //查找list// list users = useroperation.selectusers(miquan);// system.out.println(users.size()); //增// user user = new user();// user.setusername(zhiquan);// user.setpassword(999);// useroperation.adduser(user);// session.commit(); //删// useroperation.deluser(7);// session.commit(); //改 user user = new user(8, qiantu, shaxppp); useroperation.updateuser(user); session.commit(); } catch (exception e) { e.printstacktrace(); } finally { try { session.close(); } catch (exception e) { e.printstacktrace(); } } }}简单的增删查改可以实现了。