Java项目搭建之ibatis学习详解

本文的主要内容是简单介绍了ibatis和如何通过ibatis搭建java项目，包含了一个相关实例，需要的朋友可以参考下。

IBATIS简介

ibatis是 Apache的开源项目，一个ORM 解决方案，ibatis最大的特点就是小巧，上手很快。

使用 ibatis提供的ORM机制，对业务逻辑实现人员而言，面对的是纯粹的Java对象，这一层与通过Hibernate 实现ORM而言是基本一致的。

iBatis是一个基于SQL映射支持Java和·NET的持久层框架，相对Hibernate和ApacheOJB等“一站式”ORM解决方案而言，iBatis 是一种“半自动化”的ORM实现。

立即学习“Java免费学习笔记（深入）”；

一、JAR包依赖

ibatis-2.3.4.726.jar

mysql-connector-java-5.0.8-bin.jar

二、SqlMap.properties

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/test
username=root
password=root

三、SqlMapConfig.xml

PHP5 MySQL 编程入门

既有较为详细的PHP与MySQL基础知识介绍，也有大量针对不同应用的技术说明，并伴随了大量小而精的示例来加深读者的理解，便于通过实验来掌握知识并学会应用。令书以PHP开发者为核心，从环境搭建到系统开发，从局部技术点到项目全程把握，立体式介绍了PHP5+MySQL的技术要点以及丰富的延伸知识，可以让读者享受到提升开发能力的极速体验。

下载

四、Student.xml

	
	
	
	
	
		select * from student
	
	
	
		select * from student where id = #id#
	
	
	
		insert into Student(id,name,age,address) values(#id#,#name#,#age#,#address#)
		
		
			select @@identity as inserted
		
	
	
		delete from student where id = #id#
	
	
		delete from Student where id = #id#
	
	
		update student set name=#name#,age=#age#,address=#address# where id = #id#
	
	
	
		select * from student where name like '%$name$%'
	
	
	
	
	
		select * from student where name like '%$name$%' and age >= #age#
	
	
	
		
		
	
	
		select * from student where name like ? and age >= ?
	

五、JAVA代码

实体类：略

Dao：略

DaoImpl：

package com.ligang;
import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
public class StudentDaoImpl implements StudentDao {
	public static SqlMapClient sqlMapClient = null;
	static{
		try {
			Reader reader = Resources.getResourceAsReader("com/ligang/SqlMapConfig.xml");
			sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
	public List findAll() {
		List list = null;
		try {
			list = sqlMapClient.queryForList("findAll");
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return list;
	}
	public Student findByID(String id){
		Student student = null;
		try {
			 student = (Student) sqlMapClient.queryForObject("findByID", id);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return student;
	}
	public void addStudent(Student student){
		try {
			sqlMapClient.insert("insertStudent",student);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	public void deleteStudentByID(String id){
		try {
			sqlMapClient.delete("deleteStudentByID",id);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	public void deleteStudent(Student student){
		try {
			sqlMapClient.delete("deleteStudent",student);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	public void updateStudent(Student student){
		try {
			sqlMapClient.update("updateStudent", student);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	public List findByCon(String name){
		List stuList = new ArrayList();
		try {
			stuList = sqlMapClient.queryForList("selectByLike",name);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return stuList;
	}
	public List findByCon(Student student){
		List stuList = new ArrayList();
		try {
			stuList = sqlMapClient.queryForList("findByCon1",student);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return stuList;
	}
	public List findByCon(Map map){
		List stuList = new ArrayList();
		try {
			stuList = sqlMapClient.queryForList("findByCon2",map);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return stuList;
	}
}

总结