MyBatis 学生管理系统：完整教程及代码示例

以下是一个简单的学生管理系统的MyBatis代码示例：\n\n1. 创建数据库表\n\n首先，我们需要创建一个名为"student"的数据库表，包含以下字段：\n- id: 学生ID，主键，自增\n- name: 学生姓名\n- age: 学生年龄\n- gender: 学生性别\n\n2. 创建实体类\n\n创建一个名为"Student"的Java实体类，定义与数据库表对应的字段和对应的getter和setter方法。\n\njava\npublic class Student {\n private int id;\n private String name;\n private int age;\n private String gender;\n\n // getter and setter methods\n}\n\n\n3. 创建Mapper接口\n\n创建一个名为"StudentMapper"的Mapper接口，定义与学生管理相关的数据库操作方法。\n\njava\npublic interface StudentMapper {\n void insert(Student student);\n void update(Student student);\n void delete(int id);\n Student getById(int id);\n List<Student> getAll();\n}\n\n\n4. 创建Mapper XML文件\n\n在resources目录下创建一个名为"StudentMapper.xml"的Mapper XML文件，定义与Mapper接口对应的SQL语句。\n\nxml\n<?xml version="1.0" encoding="UTF-8"?>\n<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"\n"http://mybatis.org/dtd/mybatis-3-mapper.dtd">\n<mapper namespace="com.example.mapper.StudentMapper">\n <insert id="insert" parameterType="com.example.entity.Student">\n INSERT INTO student (name, age, gender)\n VALUES (#{name}, #{age}, #{gender})\n </insert>\n\n <update id="update" parameterType="com.example.entity.Student">\n UPDATE student\n SET name = #{name}, age = #{age}, gender = #{gender}\n WHERE id = #{id}\n </update>\n\n <delete id="delete" parameterType="int">\n DELETE FROM student\n WHERE id = #{id}\n </delete>\n\n <select id="getById" resultType="com.example.entity.Student" parameterType="int">\n SELECT * FROM student\n WHERE id = #{id}\n </select>\n\n <select id="getAll" resultType="com.example.entity.Student">\n SELECT * FROM student\n </select>\n</mapper>\n\n\n5. 创建MyBatis配置文件\n\n在resources目录下创建一个名为"mybatis-config.xml"的MyBatis配置文件，配置数据库连接信息和Mapper XML文件的路径。\n\nxml\n<?xml version="1.0" encoding="UTF-8"?>\n<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"\n"http://mybatis.org/dtd/mybatis-3-config.dtd">\n<configuration>\n <environments default="development">\n <environment id="development">\n <transactionManager type="JDBC"/>\n <dataSource type="POOLED">\n <property name="driver" value="com.mysql.jdbc.Driver"/>\n <property name="url" value="jdbc:mysql://localhost:3306/mydatabase"/>\n <property name="username" value="root"/>\n <property name="password" value="password"/>\n </dataSource>\n </environment>\n </environments>\n <mappers>\n <mapper resource="com/example/mapper/StudentMapper.xml"/>\n </mappers>\n</configuration>\n\n\n6. 创建MyBatis工具类\n\n创建一个名为"MyBatisUtil"的工具类，用于初始化MyBatis配置并获取SqlSessionFactory和SqlSession对象。\n\njava\npublic class MyBatisUtil {\n private static SqlSessionFactory sqlSessionFactory;\n\n static {\n try {\n String resource = "mybatis-config.xml";\n InputStream inputStream = Resources.getResourceAsStream(resource);\n sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);\n } catch (IOException e) {\n e.printStackTrace();\n }\n }\n\n public static SqlSessionFactory getSqlSessionFactory() {\n return sqlSessionFactory;\n }\n\n public static SqlSession getSqlSession() {\n return sqlSessionFactory.openSession();\n }\n}\n\n\n7. 测试\n\n使用以上代码，可以进行学生管理的数据库操作。\n\njava\npublic class Main {\n public static void main(String[] args) {\n SqlSession sqlSession = MyBatisUtil.getSqlSession();\n StudentMapper studentMapper = sqlSession.getMapper(StudentMapper.class);\n\n // 插入学生信息\n Student student1 = new Student();\n student1.setName("张三");\n student1.setAge(18);\n student1.setGender("男");\n studentMapper.insert(student1);\n sqlSession.commit();\n\n // 更新学生信息\n Student student2 = studentMapper.getById(1);\n student2.setName("李四");\n studentMapper.update(student2);\n sqlSession.commit();\n\n // 删除学生信息\n studentMapper.delete(1);\n sqlSession.commit();\n\n // 查询所有学生信息\n List<Student> students = studentMapper.getAll();\n for (Student student : students) {\n System.out.println(student.getName());\n }\n\n sqlSession.close();\n }\n}\n\n\n以上代码示例了如何使用MyBatis进行学生信息的插入、更新、删除和查询操作。\n