ibatis3.0 增删改查 模糊查询 和 多个参数查询 demo
忙了三天，把ibatis3.0 进行了学习，下面是使用ibatis3.0 对数据库进行增删改查的操作，同时有模糊查询、按序列添加、多参数查询的操作，希望对大家有所帮助！
我马上就要用这个技术做项目了，还要加深掌握，愿与有志者一起加油！
SqlMapConfig.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configuration PUBLIC "-//ibatis.apache.org//DTD Config 3.0//EN" "http://ibatis.apache.org/dtd/ibatis-3-config.dtd"> <configuration>   <properties resource="com/yhte/config/SqlMap.properties"/>  <typeAliases>          <typeAlias type="com.yhte.bean.Student" alias="student"/>    </typeAliases>    <environments default="development"> <environment id="development"> <transactionManager type="JDBC"/> <dataSource type="POOLED"> <property name="driver" value="${driver}"/> <property name="url" value="${url}"/> <property name="username" value="${username}"/> <property name="password" value="${password}"/> </dataSource> </environment>  </environments>           <mappers>  <mapper resource="com/yhte/bean/Student.xml"/>  </mappers></configuration> 

Student.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN" "http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd"> <mapper namespace="bin">  <select id="selectAllStudent" resultType="student">     select *      from   student </select>      <select id="selectStudentById" parameterType="int" resultType="student">     select *      from   student     where  sid=#{sid} </select>   <select id="selectStudentBy23" parameterType="java.util.Map" resultType="student">     select *     from   student     where  sname=#{sname} and major=#{major} </select>  <!--注意 #sid#,#sname#,#major#,#birth#,#score#) 对应Student类中的get方法如getSid --> <insert id="insertStudent" parameterType="student">     insert into Student(sid,  sname,  major,  birth,  score)     values             (#{sid},#{sname},#{major},#{birth},#{score}) </insert>  <delete id="deleteStudent" parameterType="int">     delete     from    student     where   sid=#{sid} </delete>  <update id="updateStudent" parameterType="student">     update  student     set     sid=#{sid},     sname=#{sname},     major=#{major},     birth=#{birth},     score=#{score}     where   sid=#{sid} </update>  <select id="selectStudentByName" parameterType="String" resultType="student" >     select sid,sname,major,birth,score      from student     where sname like #{sname} </select>  <insert id="insertStudentBySequence" parameterType="student" >      <selectKey resultType="int" keyProperty="sid" order="BEFORE" >     select SEQ_student.nextVal      from dual     </selectKey>          insert into Student(sid, sname, birth, major, score)                     values(#{sid}, #{sname}, #{birth}, #{major}, #{score})      </insert> </mapper>

IbatisSessionFactory.java

package com.yhte.util;import java.io.Reader;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;public class IbatisSessionFactory { public SqlSessionFactory buildSqlSessionFactory() {           try {               String resource = "com/yhte/config/SqlMapConfig.xml";               Reader reader = Resources.getResourceAsReader(resource);               return new SqlSessionFactoryBuilder().build(reader);           } catch (Exception e) {               System.out.println("failed to build SqlSessionFactory");               e.printStackTrace();               return null;           }       }         public SqlSession getSession(){           return buildSqlSessionFactory().openSession();       }   }        

IStudentDAOImpl.java

package com.yhte.dao;import java.util.HashMap;import java.util.List;import java.util.Map;import org.apache.ibatis.session.SqlSession;import com.yhte.bean.Student;import com.yhte.util.IbatisSessionFactory;public class IStudentDAOImpl extends IbatisSessionFactory  implements IStudentDAO { public void addStudent(Student student) { SqlSession s = null;try {s = this.getSession();s.insert("insertStudent", student);s.commit();System.out.println("添加成功"); } catch (Exception e) {System.out.println("添加失败"); e.printStackTrace();}finally{if(s != null)s.close();}} public void addStudentBySequence(Student student) {SqlSession s = null;try {//1  获取sid//2  插入sids = this.getSession();s.insert("insertStudentBySequence", student);s.commit();System.out.println("按序列主键添加成功");//System.out.println("sid="+student.getSid());} catch (Exception e) {System.out.println("按序列主键添加失败");e.printStackTrace();}}public void deleteStudentById(int id) { SqlSession s = null;try {s = this.getSession();s.delete("deleteStudent", id);s.commit();System.out.println("删除成功"); } catch (Exception e) {System.out.println("删除失败");e.printStackTrace();}finally{if(s!=null) s.close();}}public List<Student> queryAllStudent()  { return this.getSession().selectList("bin.selectAllStudent");   }public Student queryStudentById(int id) {SqlSession s = null;Student student = null;try {s = this.getSession();student = (Student)s.selectOne("bin.selectStudentById", id);s.commit();System.out.println("按sid查询成功");} catch (Exception e) {System.out.println("按sid查询失败");e.printStackTrace();}return student;}public List<Student> queryStudentByName(String name) {SqlSession s = null;List<Student> studentList = null;try {s = this.getSession();studentList = s.selectList("selectStudentByName", name);System.out.println("模糊查询成功" );} catch (Exception e) {System.out.println("模糊查询失败");e.printStackTrace();}finally{s.close();}return studentList;}public void updateStudentById(Student student) {SqlSession s = null;try {s = this.getSession();s.update("updateStudent", student);s.commit();System.out.println("按sid更新成功");//this.getSession().update("updateStudent", student);//System.out.println(this.getSession().update("updateStudent", student));} catch (Exception e) {System.out.println("按sid更新失败");e.printStackTrace();}finally{if(s != null) s.close();}}public List<Student> queryStudentBy23(String sname, String major) {Map map = new HashMap();map.put("sname", sname);map.put("major", major);List<Student> studentList = null;SqlSession s =null;try {s = this.getSession();studentList = s.selectList("selectStudentBy23", map);System.out.println("按23查询成功");} catch (Exception e) {System.out.println("按23查询失败");e.printStackTrace();}finally{if(s != null) s.close();}return studentList;}}

curdemo.java

package com.yhte.test;import java.sql.Date;import com.yhte.bean.Student;import com.yhte.dao.IStudentDAO;import com.yhte.dao.IStudentDAOImpl;public class curdemo {/** * @param args */public static void main(String[] args) {IStudentDAO dao =  new IStudentDAOImpl();  //  dao.deleteStudentById(104);//view all/*for(Student student:dao.queryAllStudent()){System.out.println(student);}*/ //System.out.println(dao.queryStudentById(1));//add /*Student student = new Student();student.setSid(104);student.setSname("xuyissss");student.setMajor("gameffffff");student.setBirth(Date.valueOf("2008-02-03"));student.setScore(9);dao.addStudent(student);*///update      /*  Student student = new Student();student.setSid(103);student.setSname("xiaohuqq");student.setMajor("maoyi");student.setBirth(Date.valueOf("2009-02-03"));student.setScore(90);dao.updateStudentById(student);*///模糊查询/*for(Student student:dao.queryStudentByName("__ao%")){System.out.println(student);}*///addBySequence /*Student student = new Student();student.setSname("chaolin");student.setMajor("zejing");student.setBirth(Date.valueOf("2008-02-03"));student.setScore(9);dao.addStudentBySequence(student);*///按条件23查询//模糊查询for(Student student:dao.queryStudentBy23("chn","ze")){System.out.println(student);}}}