单纯的简单的ibatis

架包：sqljdbc4.jar+ibatis-2.3.4.jar+junit4.jar

数据库简要说明：

数据库名：ibatisTest 用户名：sa 密码：yyy

字段有：id(int)，sname(varchar)，birth(Date)，score(float)

利用的是sqlserver2008

1.同一个包下：com.com

2.IbatisTest.java

package com.com;

import java.sql.Date;
import java.util.List;

import org.junit.Test;

public class IbatisTest {
    @Test
    public void IbatisTest() throws Exception
    {
        IStudentDAO iStudentDAO=new IStudentDAOImpl();
        //1.查询所有
        /*System.out.println("测试查询所有：");
        List<Student> students=iStudentDAO.selectAllStudent();
        for(Student student:students)
            System.out.println(student.toString());*/
        //2.插入
        /*Student student=new Student();
        student.setId(311);
        student.setSname("依依");
        student.setBirth(Date.valueOf("2013-5-5"));
        student.setScore(100);
        iStudentDAO.addStudent(student);*/
        //3.修改
        /*Student student=new Student();
        student.setId(161);
        student.setSname("依依");
        student.setBirth(Date.valueOf("2013-12-12"));
        iStudentDAO.updateStudent(student);*/
        //4.删除
        //iStudentDAO.deleteStudent(31);
        //5.依名字查询  =查询：sname=#sname# 模糊：'%$sname$%'
        /*List<Student> students=iStudentDAO.selectStudentByName("依依");
        for(Student student:students)
            System.out.println(student.toString());*/
        //6.依Id查询，这个中唯一的。
        System.out.println(iStudentDAO.selectStudentById(161));
    }

}

 

3.IStudentDAO.java

package com.com;

import java.util.List;
public interface IStudentDAO {
    public void addStudent(Student student);
    public void deleteStudent(int id);
    public void updateStudent(Student student);
    public List<Student> selectAllStudent();
    public List<Student> selectStudentByName(String sname);
    public Student selectStudentById(int id);
        
}

 

4.IStudentDAOImpl.java

package com.com;

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

import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;

public class IStudentDAOImpl implements IStudentDAO {
    private static SqlMapClient sqlMapClient=null;
    static{
        try {
            Reader reader=Resources.getResourceAsReader("com/com/SqlMapConfig.xml");
            sqlMapClient=SqlMapClientBuilder.buildSqlMapClient(reader);
            reader.close();
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        
    }



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

    public void deleteStudent(int id) {
        // TODO Auto-generated method stub
        try {
            sqlMapClient.delete("deleteStudent", id);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

    public void updateStudent(Student student) {
        // TODO Auto-generated method stub
        try {
            sqlMapClient.update("updateStudent", student);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

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

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

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

}

 

5.Student.java

package com.com;

import java.sql.Date;

public class Student {
    private int id=0;
    private String sname=null;
    private Date birth=null;
    private float score=0;
    
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getSname() {
        return sname;
    }
    public void setSname(String sname) {
        this.sname = sname;
    }
    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;
    }
    public String toString()
    {
        return("id="+id+"\tsname="+sname+"\tbirth="+birth+"\tscore="+score);
    }

}

 

6.SqlMapConfig.propertyies

7.SqlMapConfig.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 resource="com/com/SqlMapConfig.properties" />
    <transactionManager type="JDBC">
        <dataSource type="SIMPLE">
            <property name="JDBC.Driver" value="${driver}" />
            <property name="JDBC.ConnectionURL" value="${url}" />
            <property name="JDBC.Username" value="${username}" />
            <property name="JDBC.Password" value="${password}" />
        </dataSource>
    </transactionManager>

    <sqlMap resource="com/com/StudentSqlMap.xml"/>
</sqlMapConfig>

 

8.StudentSqlMap.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>
  <typeAlias alias="Student" type="com.com.Student"/>
  <insert id="addStudent" parameterClass="Student">
       insert into student(id,sname,birth,score)
       <!-- 这里不能#{id}#或#{id}，否则会出现no readable property-->
                    values(#id#,#sname#,#birth#,#score#)
  </insert>
  <update id="updateStudent" parameterClass="Student">
      update student 
      set sname=#sname#,birth=#birth#,score=#score#
      where id=#id#
  </update>
  
  <delete id="deleteStudent" parameterClass="int">
      delete from
      student
      where id=#id#
  </delete>
  <select id="selectAllStudent" resultClass="Student">
       select *
       from student
  </select>
  <select id="selectStudentByName" parameterClass="String" resultClass="Student">
        select *
        from student
        <!-- 相等查询：可以用sname=#sname# 模糊查询：'%$sname$%'-->
        where sname like '%$sname$%'
  </select>
  <select id="selectStudentById" parameterClass="int" resultClass="Student">
  <!-- resultClass="student"也可以，不区分大小写，但不可用别的 -->
         select *
         from student
         where id=#id#
  </select>
   
   
    
    
   
</sqlMap>