mybatis 增删改查

架包

package hp.com;

import java.io.IOException;
import java.io.InputStream;


import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;


public class MyBatisText {
public static void main(String[] args) throws IOException {
//　该配置文件使用文件流的形式读入，通过mybatis的工具类Resources加载资源文件：
String resource = "hp/com/mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory =new SqlSessionFactoryBuilder().build(inputStream);
//从 SqlSessionFactory 中获取 SqlSession
SqlSession session=sqlSessionFactory.openSession();
        //连接 BlogMapper.xml 配置文件的路径 加里面的id  
   String statement = "hp.com.BlogMapper.selectBlog";  
   //查询
   user user= session.selectOne(statement,7); 
   //添加
//         user user = new user();  
//         user.setName("虎子");  
//         user.setPassword("20");  
   //要实现添加就需要调用  session.insert(statement,user)
//         session.insert(statement,user);
   //最后需要关闭
//         session.commit();
   //删除
  // user user= session.selectOne(statement,4); 
   
   //修改
//    user user=new user();
//    user.setId(6);
//    user.setName("东子");
//    user.setPassword("222");
   //要实现添加就需要调用  session.insert(statement,user)
//    session.insert(statement, user);
//最后需要关闭
//    session.commit();
   
System.out.println(user);
session.close();
}

}

BlogMapper.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="hp.com.BlogMapper">
  <select id="selectBlog" resultType="hp.com.user">
 <!--  delete from user where id=#{id}   -->
   select * from user where id=#{id}
<!--    insert into user(name,password) values(#{name},#{password})  -->
   <!--  update user set name=#{name},password=#{password} where id=#{id}   -->
  </select>
</mapper>

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>
  <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:///test"/>
        <property name="username" value="root"/>
        <property name="password" value="root"/>
      </dataSource>
    </environment>
  </environments>
  <mappers>
    <mapper resource="hp/com/BlogMapper.xml"/>
  </mappers>
</configuration>