1,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="com.kkkliao.mapper.ProjectMapper">
<!-- 实现了StudentDao 的getAll方法 -->
<!-- id接口中的方法名 -->
<!-- 查询全部 -->
<select id="getAll" resultType="Project">
select * from project
</select>
<!-- id查询 -->
<select id="getById" resultType="Project" parameterType="int">
select * from project where id=#{id}
</select>
<!-- 增加 -->
<insert id="MyInsert" parameterType="Project">
INSERT INTO project(`projectName`) VALUES(#{projectName});
</insert>
<!-- 删除 -->
<delete id="DeleteId" parameterType="Project">
DELETE FROM project WHERE id=#{id}
</delete>
<!-- 更改 -->
<update id="MyUpdate" parameterType="Project">
UPDATE project SET `projectName`=#{projectName} where id=#{id}
</update>
</mapper>
2,接口中
package com.kkkliao.mapper;
import com.kkkliao.pojo.Project;
import java.util.List;
public interface ProjectMapper {
//1查询全部
List<Project> getAll();
//2Id查询
Project getById(int id);
//3增加
Integer MyInsert(Project p);
//4删
Integer DeleteId(int id);
//5改
Integer MyUpdate(Project p);
}
3,测试:
import com.kkkliao.mapper.ProjectMapper;
import com.kkkliao.pojo.Project;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
public class Test {
public static void main(String[] args) throws IOException {//抛出异常
InputStream is= Resources.getResourceAsStream("mybatis-config.xml");
SqlSession session=new SqlSessionFactoryBuilder().build(is).openSession(true);
ProjectMapper pm=session.getMapper(ProjectMapper.class);
//1查询全部
// List<Project> list=pm.getAll();
// for(int i=0; i<list.size(); i++){
// System.out.println(list.get(i).getProjectName());
// }
//2id查
// Project p=pm.getById(1);
// System.out.println(p.getProjectName());
//3增加
// Project p=new Project();
// p.setProjectName("zjk");
//int n=pm.MyInsert(p);
// if (n!=0){
// System.out.println("成功");
//}else {
// System.out.println("错误");
// }
//4删除
// int n=pm.DeleteId(1);
// if (n!=0){
// System.out.println("成功");
// }else {
// System.out.println("失败");
//}
//5更改
Project p=new Project();
p.setId(2);
p.setProjectName("sbzjk");
int n2=pm.MyUpdate(p);
if (n2!=0){
System.out.println("成功");
}else {
System.out.println("失败");
}
}
}
来自 廖万里的博客:廖万里