基于iBatis的增删该查

iBatis是apache的一个开源项目，一个ORM的解决方案，特点：小巧，容易上手。  要不是需要太多复杂的功能，iBatis是能满足你的需求又足够灵活的最简单的解决方案。

 

iBatis是一种“半自动化”的ORM实现，   使用iBatis的准备工作：

1. 下载ibatis的jar包

2. 创建相对应的数据库与表

3. 建立好对应的项目，使用ibatis进行增删该查

下面就是一个基于ibatis的增删该查的小项目：model层bean

package com.lbx.model;

import java.util.Date;

public class Student {
	
	private int id;
	private String name;
	private Date birth;
	private float score;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public Date getBirth() {
		return birth;
	}
	public void setBirth(Date birth) {
		this.birth = birth;
	}
	public float getScore() {
		return score;
	}
	public void setScore(float score) {
		this.score = score;
	}
	
	
}

 与之对应的xml配置文件（Student.xml）

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE sqlMap      
    PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"      
    "http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sqlMap namespace="Student">

	<typeAlias alias="Student" type="com.lbx.model.Student" />

	<select id="selectAllStudents" resultClass="Student">
		select * from Student
	</select>
	<select id="selectStudentById" parameterClass="int" resultClass="Student">
		select * from Student where id=#id#
	</select>
	<select id="selectStudentByName" parameterClass="String" resultClass="Student">
		select * from Student where name=#name#
	</select>
	<insert id="insertStudent" parameterClass="Student">
		insert into Student(name,birth,score) values(#name#,#birth#,#score#)
	</insert>
	<delete id="deleteStudentById" parameterClass="int">
		delete from Student where id = #id#
	</delete>
	<update id="updateStudentById" parameterClass="Student">
		update Student set name=#name#,birth=#birth#,score=#score# where id=#id#
	</update>
	
</sqlMap>

  

 dao层

package com.lbx.dao;

import java.util.List;

import com.lbx.model.Student;

public interface StudentDao {
	public void addStudent(Student student);
	public void deleteStudentById(int id);
	public List<Student> findAllStudent();
	public void updateStudent(Student student);
	public List<Student> findStudentByName(String name);
	public Student findStudentById(int id);
	
}

 dao实现层

package com.lbx.dao.impl;

import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
import java.util.List;

import com.ibatis.sqlmap.client.SqlMapClient;
import com.lbx.dao.StudentDao;
import com.lbx.model.Student;

public class StudentDaoImpl implements StudentDao {
	
	private static SqlMapClient sqlMapClient = null;
	
	static {
		try {
			Reader reader = com.ibatis.common.resources.Resources
			.getResourceAsReader("SqlMapConfig.xml");
			sqlMapClient = com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(reader);
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public void addStudent(Student student) {
		try {
			sqlMapClient.insert("insertStudent", student);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public void deleteStudentById(int id) {
		try {
			//返回删除的行数
			int num = sqlMapClient.delete("deleteStudentById", id);
			System.out.println(num);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public List<Student> findAllStudent() {
		List<Student> students = null;
		try {
			students = sqlMapClient.queryForList("selectAllStudents");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return students;
	}

	public Student findStudentById(int id) {
		Student student = null;
		try {
			 student = (Student)sqlMapClient.queryForObject("selectStudentById" , id);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return student;
	}

	public List<Student> findStudentByName(String name) {
		List<Student> lists = null;
		try {
			lists = sqlMapClient.queryForList("selectStudentByName", name);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return lists;
	}

	public void updateStudent(Student student) {
		try {
			//影响到的行数
			int num = sqlMapClient.update("updateStudentById", student);
			System.out.println(num);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}

 SqlMapConfig.xml文件配置，相当于Hibernate中hibernate.config.xml配置文件的作用

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE sqlMapConfig      
    PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"      
    "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

<sqlMapConfig>
	<!-- 不使用properties文件的配置 -->
	
	<transactionManager type="JDBC">
		<dataSource type="SIMPLE">
			<property name="JDBC.Driver" value="com.mysql.jdbc.Driver"/>
			<property name="JDBC.ConnectionURL" value="jdbc:mysql://localhost:3306/testhib"/>
			<property name="JDBC.Username" value="root"/>
			<property name="JDBC.Password" value="root"/>
		</dataSource>
	</transactionManager>    
  
  <!-- List more here...
  <sqlMap resource="com/mydomain/data/Order.xml"/>
  <sqlMap resource="com/mydomain/data/Documents.xml"/>
  -->
	<!-- 引入配置文件
	<properties resource="jdbc.properties"/>  -->
	<!-- 使用JDBC的事务管理
	<transactionManager type="JDBC">   -->
		<!-- 使用简单的数据源 
		<dataSource type="SIMPLE">
			<property name="${jdbc.driverClassName}" value="JDBC.Driver"/>
			<property name="${jdbc.url}" value="JDBC.ConnectionURL"/>
			<property name="${jdbc.username}" value="JDBC.Username"/>
			<property name="${jdbc.password}" value="JDBC.Password"/>
		</dataSource>
	</transactionManager>  -->
	<sqlMap resource="com/lbx/model/Student.xml"/>
</sqlMapConfig>

 注意：要提供相应的jar，ibatis一个，连接数据库一个