myBatis

1.创建工程

可以是java或者web过程2.编写config.xml 位于src下 文件名可以自定义

$$$$<?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> <properties resource="oracleConn.properties"></properties> <typeAliases> <typeAlias type="com.wsy.model.Emp" alias="emp"/> </typeAliases> <environments default="d"> <environment id="d"> <transactionManager type="JDBC"></transactionManager> <dataSource type="pooled"> <property name="driver" value="${jdbc.driver}"></property> <property name="url" value="${jdbc.url}"></property> <property name="username" value="${jdbc.username}"></property> <property name="password" value="${jdbc.password}"></property> </dataSource> </environment> </environments> <mappers> <mapper resource="com/wsy/mapper/empMapper.xml"/> </mappers></configuration>$$$$3.编写mapper.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="com.wsy.mapper"> <insert id="addEmp" parameterType="emp"> insert into emp values(#{deptid},#{empid},#{empname},#{salary}) </insert> <delete id="delEmp" parameterType="int"> delete from emp where empid=#{_int} </delete> <update id="updateEmp" parameterType="emp"> update emp set empname=#{empname},salary=#{salary} where empid=#{empid} </update> <select id="selectAll" resultType="emp"> select * from emp </select></mapper>$$$$4.java中调用$$$$package com.wsy.dao;import java.io.IOException;import java.util.ArrayList;import java.util.List;import org.apache.ibatis.session.SqlSession;import sun.text.resources.FormatData_ar_AE;import com.wsy.conn.Conn;import com.wsy.model.Emp;public class EmpDao { //增加 public static int insertEmp(Emp emp){ SqlSession session=null; try { session=Conn.getSqlSession(); int i=session.insert("com.wsy.mapper.addEmp", emp); session.commit(); return i; } catch (IOException e) { session.rollback(); e.printStackTrace(); return -1; }finally{ if(session!=null){ session.close(); } } } //删除 public static int delEmp(int empid){ SqlSession session=null; try { session=Conn.getSqlSession(); int i=session.delete("com.wsy.mapper.delEmp", empid); session.commit(); return i; } catch (IOException e) { e.printStackTrace(); return -1; }finally{ if(session!=null){ session.close(); } } } //修改 public static int updateEmp(Emp emp){ SqlSession session=null; try { session=Conn.getSqlSession(); int i= session.update("com.wsy.mapper.updateEmp",emp); session.commit(); return i; } catch (IOException e) { e.printStackTrace(); return -1; }finally{ if(session!=null){ session.close(); } } } //查询 public static List selectAll(){ SqlSession session=null; try { session=Conn.getSqlSession(); List list= session.selectList("com.wsy.mapper.selectAll"); session.commit(); return list; } catch (IOException e) { e.printStackTrace(); return null; }finally{ if(session!=null){ session.close(); } } } public static void main(String[] args) { //Emp emp=new Emp(); //emp.setDeptid(101); //emp.setEmpid(111); //emp.setEmpname("abama"); //emp.setSalary(20000); //insertEmp(emp); //delEmp(1015); Emp e=new Emp(); e.setEmpid(888); e.setEmpname("maozexi"); e.setSalary(5000); //updateEmp(e); List list=selectAll(); for(Object obj:list){ Emp emp=(Emp)obj; System.out.println(emp.getDeptid()+"---"+emp.getEmpid()+"---"+emp.getEmpname()+"---"+emp.getSalary()); } }}$$$$