mybits学习1

合集 - 软件工程日报(64)

1.新学期目标2024-03-05 2.打卡2024-05-29 3.打卡22024-05-29 4.打卡32024-05-29 5.打卡 42024-05-29 6.打卡52024-06-13 7.打卡62024-06-13 8.打卡72024-06-16 9.打卡82024-06-16 10.打卡92024-06-16 11.打卡102024-06-16 12.结对作业（地铁查询项目）012024-06-16 13.结对作业（地铁项目）022024-06-16 14.结对作业（地铁项目）032024-06-16 15.结对作业（地铁项目）042024-06-16 16.结对作业（地铁项目）052024-06-16 17.结对作业（地铁项目）062024-06-16 18.结对作业（地铁项目）072024-06-16 19.结对作业（地铁项目）082024-06-16 20.结对作业（地铁项目）092024-06-16 21.结对作业（地铁项目）102024-06-16 22.结对作业（地铁项目）112024-06-16 23.结对作业（地铁项目）122024-06-16 24.结对作业（地铁项目）132024-06-16 25.结对作业（地铁项目）142024-06-16 26.五一冲刺（政策查询系统）12024-06-16 27.五一冲刺（政策查询系统）22024-06-16 28.政策查询系统（安卓）12024-06-16 29.政策查询系统（安卓）22024-06-16 30.政策查询系统（安卓）32024-06-16 31.政策查询系统（安卓）42024-06-16 32.政策查询系统（安卓）52024-06-16 33.政策查询系统（安卓）62024-06-16 34.政策查询系统（安卓）72024-06-16 35.JS开发2024-02-28 36.安卓app开发相关2024-02-28 37.第一次个人作业（安卓学习记录系统）012024-06-16 38.第一次个人作业（安卓学习记录系统）022024-06-16 39.第一次个人作业（安卓学习记录系统）032024-06-16 40.第一次个人作业（安卓学习记录系统）042024-06-16 41.第一次个人作业（安卓学习记录系统）052024-06-16 42.第一次个人作业（安卓学习记录系统）062024-06-16 43.第一次个人作业（安卓学习记录系统）072024-06-16 44.打卡112024-06-19 45.打卡122024-06-19 46.打卡132024-06-19 47.打卡142024-06-19 48.打卡152024-06-19 49.打卡162024-06-19 50.打卡172024-06-19 51.打卡182024-06-19 52.打卡192024-06-19 53.打卡202024-06-19 54.python学习2024-06-19 55.python学习22024-06-19 56.python学习32024-06-19 57.Javaweb2024-06-19 58.打卡212024-06-19 59.fragment学习和使用2024-06-19

60.mybits学习12024-06-19

61.mybits学习22024-06-19 62.mybits学习32024-06-19 63.课程总结2024-06-19 64.个人总结2024-06-19

所花时间（包括上课）：	2h
代码量（行）：	150左右
搏客量（篇）：	1
了解到的知识点：	mybits
备注（其他）：

private static SqlSessionFactory sqlSessionFactory;

static {

try {

String resource = "mybatis-config.xml";

InputStream inputStream = Resources.getResourceAsStream(resource);

sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

} catch (IOException e) {

throw new RuntimeException(e);

}

public static SqlSession getSqlSession()

{

return sqlSessionFactory.openSession();

}

privateintid;    private String StudentName;
    private String gender;
    private int age;
 
    public Student() {
    }
 
    public Student(int id, String studentName, String gender, int age) {
        this.id = id;
        StudentName = studentName;
        this.gender = gender;
        this.age = age;
    }
 
    public int getId() {
        return id;
    }
 
    public void setId(int id) {
        this.id = id;
    }
 
    public String getStudentName() {
        return StudentName;
    }
 
    public void setStudentName(String studentName) {
        StudentName = studentName;
    }
 
    public String getGender() {
        return gender;
    }
 
    public void setGender(String gender) {
        this.gender = gender;
    }
 
    public int getAge() {
        return age;
    }
 
    public void setAge(int age) {
        this.age = age;
    }
 
    @Override
    public String toString() {
        return "Student{" +
                "id=" + id +
                ", StudentName='" + StudentName + '\'' +
                ", gender='" + gender + '\'' +
                ", age=" + age +
                '}';
    }

package com.xx.dao;
import com.xx.pojo.Student;
import java.util.List;

public interface studentMapper {
    //查询全部学生
    List<Student> getAllStudents();
    //根据学号查找学生
    Student getStudentById(int id);
    //添加学生
    int addStudent(Student stu);
    //修改信息
    int updateStudent(Student stu);
    //删除学生信息
    int deleteStudent(int id);
}
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.xx.dao.studentMapper">
    <select id="getAllStudents" resultType="com.xx.pojo.Student" >
        select * from db_stu.student
    </select>
    <select id="getStudentById" resultType="com.xx.pojo.Student" parameterType="int">
        select * from db_stu.student where id =#{id}
    </select>
    <insert id="addStudent" parameterType="com.xx.pojo.Student">
        insert into db_stu.student(id,StudentName,gender,age) values(#{id},#{StudentName},#{gender},#{age})
    </insert>
    <update id="updateStudent" parameterType="com.xx.pojo.Student">
        update db_stu.student set StudentName=#{StudentName},gender=#{gender},age=#{age} where id=#{id};
    </update>
    <delete id="deleteStudent" parameterType="int">
        delete from db_stu.student where id =#{id};
    </delete>
</mapper>