实体映射文件:
----------------------------------------------------------------
<?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.ibatis.dao.IStudentDAO">
<select id="selectAllStudents" resultType="Student">
select * from student
</select>
<select id="selectStudentById" parameterType="int" resultType="Student">
select *
from student
where s_id = #{s_id}
</select>
<insert id="insertStudent" parameterType="Student">
insert into student(s_id,s_name,s_age)
values (#{s_id},#{s_name},#{s_age})
</insert>
<delete id="deleteStudentById" parameterType="int">
delete from student
where s_id = #{s_id}
</delete>
<update id="updateStudentById" parameterType="Student">
update student
set s_name = #{s_name},
s_age = #{s_age}
where s_id = #{s_id}
</update>
</mapper>
-------------------------------------------------
parameterType 传入参数类型
resultType 返回结果类型
-------------------------------------------------
调用:
public class IStudentDAOIbatisImpl implements IStudentDAO {
SqlSession sqlSession = null;
static SqlSessionFactory sf;
static{
Reader reader = null;
try {
reader = Resources.getResourceAsReader("com/ibatis/SqlMapConfig.xml");
} catch (IOException e) {
e.printStackTrace();
}
sf = new SqlSessionFactoryBuilder().build(reader);
}
public void addStudent(Student stu) {
try{
sqlSession = sf.openSession();
sqlSession.insert("insertStudent", stu);
sqlSession.commit();//这里一定要提交,不然数据进不去数据库中
}finally{
sqlSession.close();
}
}
public void addStudentBySequence(Student stu) {
}
public void deleteStudentById(int id) {
try{
sqlSession = sf.openSession();
int returnValue = sqlSession.delete("deleteStudentById", id);
System.out.println(returnValue);//受影响行数
sqlSession.commit();//这里一定要提交,不然数据进不去数据库中
}finally{
sqlSession.close();
}
}
public List<Student> queryAllStudents() {
List<Student> students;
try{
sqlSession = sf.openSession();
students = sqlSession.selectList("selectAllStudents");
}finally{
sqlSession.close();
}
return students;
}
public Student queryStudentById(int id) {
Student stu;
try{
sqlSession = sf.openSession();
stu = (Student)sqlSession.selectOne("selectStudentById",id);
}finally{
sqlSession.close();
}
return stu;
}
public List<Student> queryStudentsByName(String name) {
// TODO Auto-generated method stub
return null;
}
public void updateStudent(Student stu) {
try{
sqlSession = sf.openSession();
int returnValue = sqlSession.update("updateStudentById", stu);
sqlSession.commit();
System.out.println(returnValue);
}finally{
sqlSession.close();
}
}
}
分享到:
相关推荐
ibatis mybatis crud 完整代码
单纯使用Mybatis框架对数据库CRUD 增删改查操作,支持Junit测试
MyBatis CRUD操作Java,MyBatis,单元测试,MySql,Maven的CRUD操作这包含构建和运行MyBatisCRUD应用程序所需的一组指令。建设项目。先决条件设置了JDK 1.6.x或更高版本的Maven 2或更高版本的java_home和m2_home。...
SpringBoot+MybatisCRUD 整合案例 . 适合新手入门学习。
mybatis CRUD mybatis CRUD mybatis CRUD mybatis CRUD mybatis CRUD
2024最新MyBatis CRUD操作,动态SQL。HM
05实现mybatis简单crud功能demo05实现mybatis简单crud功能demo05实现mybatis简单crud功能demo05实现mybatis简单crud功能demo05实现mybatis简单crud功能demo05实现mybatis简单crud功能demo05实现mybatis简单crud功能...
ibatis mybatis 分页 crud 完整代码 如有不清楚的地方:可访问公司网站:www.meihuangkeji.com 进一步交流讨论。
第一个mybatis程序——CRUD,第一个mybatis程序——CRUD,
这个是我自己学习springmvc的时候写的一个demo 数据库是mysql,映射持久化用了mybatis
NULL 博文链接:https://zhaoshijie.iteye.com/blog/2003209
MyBatis 采用注解方式实现CRUD 参考博客:https://www.jianshu.com/p/74fbe5f1e610
mybatis中使用接口编程方式实现CRUD模板
springboot+mybatis+postman+crud(视频+源码) https://pan.baidu.com/s/1qYcFDow https://blog.csdn.net/linzhiqiang0316/article/details/78310884?locationNum=3&fps=1
mybatis基础CRUD案例
利用LayUI+MyBatis实现CRUD操作MySQL数据库 https://blog.csdn.net/qq_29001539/article/details/105613480 雁去雁归雁不散2020-04-19 14:49:17 LayUI+MyBatis实现CRUD操作 项目描述 前端页面采用Layui进行搭建,...
MyBatis-CRUD.zip
MyBatis基本CRUD与动态SQL(带log4j.properties)
Mybatis_CRUD