单纯的简单的mybatis无注解

同一个包下：com.com

数据库简要说明：

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

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

利用的是sqlserver2008

1.IStudentDAO.java

package com.com;

import java.util.List;

import org.apache.ibatis.annotations.Insert;
public interface IStudentDAO {
                        public void insert(Student student); //插入   
        public void update(Student student);//修改
        public void delete(String sname);//删除
        public int countAll();//计算总的条目数
        public List<Student> selectAll();//得到所有数据
        public Student findBySname(String sname);//依据单一字段查找
        
}

 

2.IStudentDAOTest.java

package com.com;
import java.io.Reader;
import java.text.SimpleDateFormat;
import java.util.Iterator;
import java.util.List;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;
public class IStudentDAOTest {
    @Test
    public void IStudentDAOTest()throws Exception
    {
        String resource = "com/com/mybatis-config.xml";
        Reader reader = Resources.getResourceAsReader(resource);
        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
        SqlSessionFactory factory = builder.build(reader);
        
       // factory.getConfiguration().addMapper(IStudentDAO.class);//利用注解要加上这句是注册，否则不用加
        SqlSession session = factory.openSession();
        IStudentDAO iStudentDAO = session.getMapper(IStudentDAO.class);
        
        //1.insert：
        //（错）不可为何不能让接口函数是public int insert(Student student);会出现如下
        //（错）org.apache.ibatis.binding.BindingException：
        //（错）映射法'com.com.IStudentDAO.insert试图从一种原始的返回类型（int）方法返回null。
        //（错）只能用void类型
        //上面的说法是错的，是我在mapper.xml中写错了，本来是<insert>,让我写成了<selcet>
        //经我验证可以用int也可以void。
        
        //但也可以知道用<select>来插入，那样就把接口中的函数定义为void型
        Student student=new Student();
        student.setId(17);
        student.setSname("xiaoming");
        student.setBirth(java.sql.Date.valueOf("2012-9-8"));
        student.setScore(89);
        iStudentDAO.insert(student);
        
        //2.update
        /*Student dStudent=new Student();
        dStudent.setSname("dada2");
        dStudent.setId(16);
        dStudent.setBirth(java.sql.Date.valueOf("2013-7-1"));
        dStudent.setScore(48);
        iStudentDAO.update(dStudent);*/
        
        //3.delete
        /*iStudentDAO.delete("dada2");*/
        
        //1.记录的条数：
        /*iStudentDAO.countAll();
        System.out.println("记录条数："+iStudentDAO.countAll()); */  
        //2.所有记录的列举：
        /*List<Student> students=iStudentDAO.selectAll();
        Iterator<Student> iter=students.iterator();
        while(iter.hasNext())
        {
            Student st=iter.next();
            //编号与数据库中的id不一样就会全为0，而不是具体的数字。
            System.out.println("编号："+st.getId()+"  学生名："+st.getSname()+"出生日期："+st.getBirth()+"成绩："+st.getScore());
        }*/
      //4.findBySname
       /* Student findStudent=iStudentDAO.findBySname("caocao");
        System.out.println(findStudent.getBirth());*/
        
        
        session.commit();
        session.close();
        
    }
    

}

 

3.Student.java

ackage 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;
    }
    

}

 

4.mybatis-config.properties

5.mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
   <properties resource="com/com/mybatis-config.properties"/>
    <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/com/StudentMapper.xml" />
    </mappers>
</configuration>

 

6.StudentMapper.xm

 

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
 "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> 
<mapper namespace="com.com.IStudentDAO">
   <select id="countAll" resultType="int">
        select count(*) c 
        from student;
   </select>
   <select id="selectAll" resultType="com.com.Student">
        select *
        from student 
        order by sname asc
   
   </select>
   
   <insert id="insert" parameterType="com.com.Student">
          insert into student(id,sname,birth,score)
                       values(#{id},#{sname},#{birth},#{score})
   </insert>
   
   <update id="update" parameterType="com.com.Student">
           update student 
           set sname=#{sname},birth=#{birth},score=#{score}
           where id=#{id}
   </update>
   
   <delete id="delete" parameterType="String">
           delete from student 
           where sname=#{sname}
   </delete>
   
   <select id="findBySname" parameterType="String" resultType="com.com.Student">
           select *
           from student
           where sname=#{sname}
   </select>
   
    
    
   
</mapper>