mybatis进行增删改操作

       文件结构

     

        暂时可以不去考虑与Blog相关的类，可以只考虑对person表的增删改。

1. 定义person的破pojo类：Person.java

       

package pht.mybatis.pojo;import java.util.ArrayList;import java.util.List;public class Person {private String personid;private String name;private String age;private String address;private String sex;private List<Blog> blogs;  //这个可以先不去理会public String getPersonid() {return personid;}public void setPersonid(String personid) {this.personid = personid;}public String getName() {return name;}public void setName(String name) {this.name = name;}public String getAge() {return age;}public void setAge(String age) {this.age = age;}public String getAddress() {return address;}public void setAddress(String address) {this.address = address;}public String getSex() {return sex;}public void setSex(String sex) {this.sex = sex;}public List<Blog> getBlogs() {return blogs;}public void setBlogs(List<Blog> blogs) {this.blogs = blogs;}@Overridepublic String toString() {// TODO Auto-generated method stubreturn getName()+"---"+getAddress();}}

2. 定义映射接口PersonDao.java

 

package pht.mybatis.dao;import java.util.HashMap;import java.util.List;import pht.mybatis.pojo.Person;public interface Persondao {public Person getById(String cid);public List getAllperson();public void addPerson(Person person);public void updatePerson(Person person);public void deletePerson(String cid);}

 3. 创建PersonDao.xml

<?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="pht.mybatis.dao.Persondao"> <select id="getById" parameterType="java.lang.String" resultType="Person">   select * from person where personid=#{cid} </select>  <select id="getAllperson" resultType="Person">   select * from person </select><insert id="addPerson" parameterType="Person"  useGeneratedKeys="true" keyProperty="personid">  insert into person(name,age,address,sex) values(#{name},#{age},#{address},#{sex})</insert><update id="updatePerson" parameterType="Person"> update person set address=#{address} where personid=#{personid}</update><delete id="deletePerson" parameterType="java.lang.String">  delete from person where personid=#{cid}</delete></mapper>

  4. 总配置文件

<?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="config.properties"></properties><!-- 定义properties文件，该文件里有一些重要信息 --><settings><setting name="cacheEnabled" value="true" /><setting name="lazyLoadingEnabled" value="false"/><setting name="multipleResultSetsEnabled" value="true" /><setting name="useColumnLabel" value="true" /><setting name="useGeneratedKeys" value="false" /><setting name="defaultExecutorType" value="SIMPLE" /><setting name="defaultStatementTimeout" value="25000" /></settings><typeAliases><!--给实体类起一个别名 user --><typeAlias type="pht.mybatis.pojo.Person" alias="Person" /><typeAlias type="pht.mybatis.pojo.Blog" alias="Blog" /></typeAliases><environments default="development"><environment id="development"><transactionManager type="JDBC" /><dataSource type="POOLED"><property name="driver" value="${driver}" /><!-- ${}中的value取自properties文件中 --><property name="url" value="${url}" /><property name="username" value="${username}" /><property name="password" value="${password}" /></dataSource></environment></environments><mappers>    <mapper resource="pht/mybatis/dao/Persondao.xml" /><mapper resource="pht/mybatis/dao/BlogDao.xml" /></mappers>

5. 测试类MyBatisTest.java

package pht.mybatis.test;import java.io.IOException;import java.io.Reader;import java.util.HashMap;import java.util.Iterator;import java.util.List;import java.util.Map;import java.util.Properties;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 pht.mybatis.dao.*;import pht.mybatis.pojo.*;import pht.mybatis.sessionfactory.Sessionfactory;/** * myBatis数据库连接测试 *  */public class MyBatisTest {    private static SqlSession sqlSession;public static void main(String[] args) {sqlSession=Sessionfactory.SQLSESSIONFACTORY.getSessionFactory().openSession();MyBatisTest test=new MyBatisTest();try{   //这这里调用相应的方法  }catch (Exception e) {// TODO: handle exception}finally{sqlSession.close();}}public Person selectOne(String cid){Persondao persondao = sqlSession.getMapper(Persondao.class);Person p=persondao.getById(cid);System.out.println(p);return p;}   public List selectMany(){   Persondao persondao = sqlSession.getMapper(Persondao.class);   List persons=persondao.getAllperson();      for(Iterator it=persons.iterator();it.hasNext();){   Person p=(Person) it.next();   System.out.println(p);   }   return persons;   }      public void insetPerson(Person p){   Persondao persondao = sqlSession.getMapper(Persondao.class);   persondao.addPerson(p);   sqlSession.commit();      }public void updatePerson(){  Persondao persondao = sqlSession.getMapper(Persondao.class);  Person ps=persondao.getById("4");//先得到要修改的记录，再进行修改  ps.setAddress("CHINA");  persondao.updatePerson(ps);  sqlSession.commit();}public void deletePerson(String cid){  Persondao persondao = sqlSession.getMapper(Persondao.class);  persondao.deletePerson(cid);  sqlSession.commit();}}