Ibatis实现CRUD之二

来源：互联网发布：编程中文字体编辑：程序博客网时间：2024/05/21 08:41

转载请注明:来自http://blog.csdn.net/M_ChangGong/ 作者:张燕广

该篇主要编写bean和ibaits实现的DAO层代码。

在src下创建包com.zyg.ssi.bean,在该包下创建bean类Students，其代码如下：

package com.zyg.ssi.bean;public class Student {private Integer stuId;private String stuName;public Student() {}public Student(String stuName) {this.stuName = stuName;}public Integer getStuId() {return stuId;}public void setStuId(Integer stuId) {this.stuId = stuId;}public String getStuName() {return stuName;}public void setStuName(String stuName) {this.stuName = stuName;}@Overridepublic String toString() {String result = "学号："+this.stuId+",姓名："+this.stuName;return result;}}

在sqlmap-config.xml的配置中引用了Student的xml配置，在该包下创建Student.xml配置文件，其代码如下：

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd"><sqlMap><typeAlias alias="Student" type="com.zyg.ssi.bean.Student"/><resultMap id="Student" class="Student"> <result property="stuId" column="stuid"/> <result property="stuName" column="stuname"/> </resultMap> <select id="selectAllStudent" resultClass="Student">select * from student</select><select id="selectStudentById" parameterClass="int" resultClass="Student">select * from student where stuid=#sid#</select><delete id="delStudentById" parameterClass="int">delete from student where stuid=#id#</delete><insert id="insertStudent" parameterClass="Student"> insert into Student (stuid,stuname) values (#stuId#,#stuName#) </insert>   <update id="updateStudent" parameterClass="Student"> update Student set stuName=#stuName# where stuId=#stuId# </update> <select id="selectStudentByName" parameterClass="String" resultClass="Student">select stuId,stuName from student where stuName like '%$stuName$%'</select></sqlMap>

在sqlmap-config.xml的配置中引用了Student的xml配置，在该包下创建Student.xml配置文件，其代码如下：

在src下创建包com.zyg.ssi.dao，在该包下创建实现针对Student的CRUD操作的接口StudentDao，其代码如下：

package com.zyg.ssi.dao;import java.util.List;import com.zyg.ssi.bean.Student;public interface StudentDao {/** * 保存学生信息 * @param student */public void addStudent(Student student);/** * 根据学号删除学生信息 * @param studentId */public void delStudentById(int id);/** * 更新学生信息 * @param student */public void updateStudentById(Student student);/** * 根据学号获取学生信息 * @param studentId */public Student queryStudentById(int id);/** * 根据姓名获取学生信息 * @param studentId */public List<Student> queryStudentByName(String name);/** * 获取全部学生信息 * @param studentId */@SuppressWarnings("unchecked")public List<Student> queryAllStudents();}

在src下创建包com.zyg.ssi.dao.ibaits，在包下创建接口StudentDao的实现类StudentDaoImpl，其代码如下：

package com.zyg.ssi.dao.ibaits;import java.io.IOException;import java.io.Reader;import java.sql.SQLException;import java.util.List;import com.ibatis.sqlmap.client.SqlMapClient;import com.zyg.ssi.bean.Student;import com.zyg.ssi.dao.StudentDao;public class StudentDaoImpl implements StudentDao {private static SqlMapClient sqlMapClient = null;static{try {Reader reader = com.ibatis.common.resources.Resources.getResourceAsReader("sqlmap-config.xml");sqlMapClient = com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(reader);reader.close();} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();}}public void addStudent(Student student) {// TODO Auto-generated method stubtry {sqlMapClient.insert("insertStudent", student);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}public void addStudentBySequence(Student student) {// TODO Auto-generated method stub}public void delStudentById(int id) {try {sqlMapClient.delete("delStudentById", id);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}public List<Student> queryAllStudents() {// TODO Auto-generated method stubList<Student> stuList = null;try {stuList = sqlMapClient.queryForList("selectAllStudent");} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return stuList;}public Student queryStudentById(int id) {Student student=null;try {student = (Student)sqlMapClient.queryForObject("selectStudentById", id);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return student;}public List<Student> queryStudentByName(String name) {// TODO Auto-generated method stubList<Student> stuList = null;try {stuList = sqlMapClient.queryForList("selectStudentByName",name);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return stuList;}public void updateStudentById(Student student) {// TODO Auto-generated method stubtry {sqlMapClient.update("updateStudent", student);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}

至此，通过ORM框架iBaits实现的CRUD操作已完成，下一篇编写Junit测试类进行单元测试。