Mybatis教程____mybatis超详细入门列子

1.mybatis官方简介

官方地址:http://www.mybatis.org/mybatis-3/zh/getting-started.html

2.mybatis下载

下载地址:https://github.com/mybatis/mybatis-3/releases

3.mybatis环境搭建

3.1创建mybatis配置文件mybatis-config

<?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><settings><setting name="jdbcTypeForNull" value="NULL"/></settings>    <typeAliases>         <typeAlias alias="alias_frame_user" type="com.frame.user.entity.FRAME_USER"/>     </typeAliases>     <environments default="development">        <environment id="development">        <transactionManager type="JDBC"/>            <dataSource type="POOLED"><property name="driver" value="oracle.jdbc.driver.OracleDriver" /><property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:orcl" /><property name="username" value="oracle" /><property name="password" value="123456" />            </dataSource>        </environment>    </environments>        <mappers>        <mapper resource="com/frame/user/entity/FRAME_USER.xml"/>    </mappers></configuration>

3.2创建实体类

package com.frame.user.entity;import java.io.Serializable;/** * @author Administrator * 用户实体类 */public class FRAME_USER implements Serializable{/** * SERID */private static final long serialVersionUID = -6908476438878532829L;/** * generl po */private String USERID;                            private String USERNAME;                              private String USERPWD;                              private String CREATETIME;/** * encapsulation */public String getUSERID() {return USERID;}public void setUSERID(String uSERID) {USERID = uSERID;}public String getUSERNAME() {return USERNAME;}public void setUSERNAME(String uSERNAME) {USERNAME = uSERNAME;}public String getUSERPWD() {return USERPWD;}public void setUSERPWD(String uSERPWD) {USERPWD = uSERPWD;}public String getCREATETIME() {return CREATETIME;}public void setCREATETIME(String cREATETIME) {CREATETIME = cREATETIME;}@Overridepublic String toString() {return "FRAME_USER [USERID=" + USERID + ", USERNAME=" + USERNAME+ ", USERPWD=" + USERPWD + ", CREATETIME=" + CREATETIME + "]";}}

3.3创建映射文件

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapper PUBLIC "-//mybatis.org/DTD Mapper 3.0" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.frame.user.dao.UserDao"><resultMap id="frame_user_result" type="com.frame.user.entity.FRAME_USER"><id property="USERID" column="USERID"/><result property="USERNAME" column="USERNAME"/><result property="USERPWD" column="USERPWD"/><result property="CREATETIME" column="CREATETIME"/></resultMap><insert id="insertFrameUser" parameterType="alias_frame_user"> <![CDATA[insert into frame_user (USERID,USERNAME,USERPWD,CREATETIME)values(#{USERID},#{USERNAME},#{USERPWD},#{CREATETIME})]]></insert><select id="getFrameUser" resultMap="frame_user_result">select * from frame_user  where USERID = #{USERID}</select><update id="updateFrameUser" parameterType="alias_frame_user" >update frame_user set USERNAME=#{USERNAME},USERPWD=#{USERPWD} where USERID=#{USERID}</update><delete id="deleteFrameUser" parameterType="alias_frame_user">delete from frame_user where USERID=#{USERID}</delete><select id="findFrameUserList" parameterType="alias_frame_user" resultMap="frame_user_result">select * from frame_user  where 1=1 <if test="USERNAME != null and USERNAME !='' "> and USERNAME=#{USERNAME} </if> <if test="USERPWD !=null and USERPWD !='' "> and USERPWD=#{USERPWD} </if> <if test="USERID !=null and USERID !='' "> and USERID=#{USERID} </if> </select></mapper>

3.4创建dao层

package com.frame.user.dao;import java.util.List;import com.frame.user.entity.FRAME_USER;public interface UserDao {//新增用户public int insertFrameUser(FRAME_USER user);//查询public FRAME_USER getFrameUser(FRAME_USER user);//修改用户public int updateFrameUser(FRAME_USER user);//删除用户public int deleteFrameUser(FRAME_USER user);//获取集合public List<FRAME_USER> findFrameUserList(FRAME_USER user);}

3.5创建测试类

package com.frame.user.test;import java.io.IOException;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.frame.user.dao.UserDao;import com.frame.user.entity.FRAME_USER;public class Test {public static void main(String[] args) {String resource = "mybatis-config.xml";InputStream inputStream=null;try {inputStream = Resources.getResourceAsStream(resource);SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);SqlSession session= sqlSessionFactory.openSession();UserDao dao=session.getMapper(UserDao.class);//增加//FRAME_USER user = new FRAME_USER();//user.setUSERID("6");//user.setUSERNAME("巴德");//user.setUSERPWD("1321");//dao.insertFrameUser(user);//session.commit();//查询//FRAME_USER user2 = new FRAME_USER();//user2.setUSERID("6");//user2=dao.getFrameUser(user2);//System.out.println(user2);//修改                       //FRAME_USER user3 = new FRAME_USER();//user3.setUSERID("6");//user3.setUSERNAME("卡巴斯基");//user3.setUSERPWD("6666");//dao.updateFrameUser(user3);//session.commit();//删除//FRAME_USER user4 = new FRAME_USER();//user4.setUSERID("6");//int result= dao.deleteFrameUser(user4);//System.out.println("excute 状态:"+result);//session.commit();//获取集合FRAME_USER user5 = new FRAME_USER();user5.setUSERPWD("123");List<FRAME_USER> list=dao.findFrameUserList(user5);System.out.println("获取集合:"+list.get(0));} catch (IOException e) {e.printStackTrace();}}}

3.6yunxingjieguo

源码地址:http://pan.baidu.com/s/1hrTtxWC