[找程序员代写推荐]myBatis 基础测试 增 删 改 查 用过hibrenate 之后，感觉很好理解

myBatis 基础测试 增 删 改 查 用过hibrenate 之后，感觉很好理解

免费下载: API:http://download.csdn.net/detail/liangrui1988/5988015

测试myelipse项目源码 sql 下载 http://download.csdn.net/detail/liangrui1988/5993881

sql 

| student | CREATE TABLE `student` (   `id` int(11) NOT NULL AUTO_INCREMENT,   `name` varchar(20) DEFAULT NULL,   `age` int(11) DEFAULT NULL,   `password` varchar(20) DEFAULT NULL,   PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 |

config.xml

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.2//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <environments default="development"> <environment id="development"> <transactionManager type="JDBC"/> <dataSource type="POOLED"> <property name="driver" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/ruiabc"/> <property name="username" value="root"/> <property name="password" value="rui"/> </dataSource> </environment> </environments>  <mappers> <mapper resource="accp/bean/Student.xml"/> </mappers> </configuration>

mapper.xml

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.2//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">  <mapper namespace="accp.dao"> <!--指定关系 --> <resultMap type="accp.bean.Student" id="stuMAP">  <result property="id" column="id" javaType="Integer" jdbcType="INTEGER"/>  <result property="name" column="name" javaType ="string" jdbcType="VARCHAR"/>  <result property="password" column="password" javaType ="string" jdbcType="VARCHAR"/>  <result column="age" property="age" javaType="Integer" jdbcType="INTEGER"/> </resultMap>   <select id="findStudentById" parameterType="int" resultType="accp.bean.Student"> select * from Student where id=#{id} </select>  <select id="selectAllStu" resultType="accp.bean.Student"> select * from student </select>  <insert id="addStudent" parameterType="accp.bean.Student"> INSERT INTO STUDENT(NAME,PASSWORD,AGE)   VALUES(#{name},#{password},#{age}) </insert>  <delete id="deleteStudent" parameterType="int"> delete from student where id=#{id} </delete>  <update id="updateStudent" parameterType="accp.bean.Student"> update student set name=#{name},password=#{password},age=#{age} where id=#{id} </update>  </mapper>

student.java

package accp.bean;  import java.io.Serializable;  public class Student implements Serializable {  private Integer id;  private String name;  private String password;  private Integer age;    public Student(){}    public Student(String name, String password, Integer age) {   this.name = name;   this.password = password;   this.age = age;  }    public Integer getId() {   return id;  }    public void setId(Integer id) {   this.id = id;  }  public String getName() {   return name;  }  public void setName(String name) {   this.name = name;  }  public String getPassword() {   return password;  }  public void setPassword(String password) {   this.password = password;  }  public Integer getAge() {   return age;  }  public void setAge(Integer age) {   this.age = age;  }    } 

dao 接口

package accp.dao;  import java.util.List;  import accp.bean.Student;  public interface Dao {    boolean addStudent(Student stu);    boolean updateStudent(Student stu);    boolean deleteStudent(Student stu);    boolean deleteStudent(int id);    boolean findStudent(Student stu);    Student findStudentById(int id);    List<Student> findAll();   } 

daoImp

package accp.dao.imp;   import java.util.List;  import org.apache.ibatis.session.SqlSession; import accp.bean.Student; import accp.dao.Dao; import accp.util.GetSession;  public class DaoImp implements Dao {         //取得sqlsession 在实际中是要把sqlsession放到一个操作下，不能共享  SqlSession sqlSession=GetSession.getInstans().getSqlSession();      @Override  public boolean addStudent(Student stu) {    /**       * 最好都这样做 安全的       */   int count=0;   try {   count= sqlSession.insert("accp.dao.addStudent", stu);    sqlSession.commit(true);   } catch (Exception e) {   sqlSession.rollback();   e.printStackTrace();   }finally{   //sqlSession.close();   }   return count<=0?false:true;  }   @Override  public boolean updateStudent(Student stu) {   int count=sqlSession.update("accp.dao.updateStudent", stu);   sqlSession.commit(true);   return count<=0?false:true;  }   @Override  public boolean deleteStudent(Student stu) {   // TODO Auto-generated method stub   return false;  }   @Override  public boolean deleteStudent(int id) {  int count= sqlSession.delete("accp.dao.deleteStudent",id);  sqlSession.commit(true);  return count<=0?false:true;  }   @Override  public boolean findStudent(Student stu) {   // TODO Auto-generated method stub   return false;  }   @Override  public Student findStudentById(int id) {   Student stu= sqlSession.selectOne("accp.dao.findStudentById",id);   return stu;  }   @Override  public List<Student> findAll() {   List<Student> stu=sqlSession.selectList("accp.dao.selectAllStu");   return stu;     }  } 

单例类: SqlSessionFactory

package accp.util;  import java.io.IOException; import java.io.Reader;  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 accp.bean.Student; import accp.dao.Dao; import accp.dao.imp.DaoImp; /**  * 单例  * @author liangrui  *  */ public class GetSession {    private static GetSession getSession=null;     //加载xml配制信息  private static SqlSessionFactory sqlSessionFactory=null;    private GetSession(){     String sr="Configurationss.xml";   //读取xml   Reader reader=null;   try {    reader=Resources.getResourceAsReader(sr);   } catch (IOException e) {    // TODO Auto-generated catch block    e.printStackTrace();   }   //构建工厂实例   sqlSessionFactory =new SqlSessionFactoryBuilder().build(reader);    System.out.println("hello....");   /**    * 如果存在XML配置文件的话，MyBatis将会自动查找和加载一个对等的XML文件（这种情况下，    * 基于类路径下的BlogMapper.class类的类名，那么BlogMapper.xml将会被加载）。    */    sqlSessionFactory.getConfiguration().addMapper(Dao.class);     }    //公有的获取方法  public  synchronized static GetSession getInstans(){   if(getSession==null){   getSession=new GetSession();   }   return getSession;  }    //获取 sqlSessionFactory 实例  public  static SqlSessionFactory getSqlSessionFactory(){   return sqlSessionFactory;  }    //get sqlsession  public static SqlSession getSqlSession(){   return sqlSessionFactory.openSession();  }    //close  public static void closeSqlSession(SqlSession se){   if(se!=null){   se.close();   }  } } 

Test:

package accp.test;  import java.util.List; import accp.bean.Student; import accp.dao.Dao; import accp.dao.imp.DaoImp;  public class TestMyBatis {    public static void main(String[] args) {   Dao dao=new DaoImp();//业务接口    //查询 根据id------------------------------------------------------------------  System.out.println("find: "+dao.findStudentById(1).getName());     //add------------------------------------------------------------------   //System.out.println("添加: "+dao.addStudent(new Student("hello","world",100)));    //delete------------------------------------------------------------------    //System.out.println(dao.deleteStudent(18));     //update------------------------------------------------------------------    /*Student stuUp= new Student("your","udser",33) ;   stuUp.setId(1);   System.out.println("update: "+dao.updateStudent(stuUp));*/    //select all------------------------------------------------------------   for(Student stu:dao.findAll()){   System.out.println(stu.getId()+":  "+stu.getName()+"  "+stu.getPassword()+"  "+stu.getAge());   }        } } 

自己不会写程序？找个程序代写吧-》》》