package com.ydy.entiy;
import java.io.Serializable;
public class Student implements Serializable{
/**
*
*/
private static final long serialVersionUID = 1L;
private int Id;
private String Name;
private int Age;
private String Gender;
public Student(String name, int age, String gender) {
super();
Name = name;
Age = age;
Gender = gender;
}
public Student(int id, String name, int age, String gender) {
super();
Id = id;
Name = name;
Age = age;
Gender = gender;
}
public String toString() {
return "Student [Id=" + Id + ", Name=" + Name + ", Age=" + Age + ", Gender=" + Gender + "]";
}
public int getId() {
return Id;
}
public void setId(int id) {
Id = id;
}
public String getName() {
return Name;
}
public void setName(String name) {
Name = name;
}
public int getAge() {
return Age;
}
public void setAge(int age) {
Age = age;
}
public String getGender() {
return Gender;
}
public void setGender(String gender) {
Gender = gender;
}
}
6.定义接口方法studentMapper.java
package com.ydy.mapper;
import java.util.List;
import com.ydy.entiy.Student;
public interface studentMapper {
/**
* 定义四个方法，增删改查，其中的增删改成功的话会返回1，查询的是所有，故使用List来接收
* @param student
* @return
* @throws Exception
*/
public int insertStudent(Student student)throws Exception;;
public int updateStudent(Student student)throws Exception;;
public List selectAllUser()throws Exception;;
public int deleteStudent(int id)throws Exception;;
}
7.创建SQL映射文件 studentMapper.xml
insert into student (Name,Age,Gender) values (#{Name},#{Age},#{Gender})
update student set Name=#{Name},Age=#{Age},Gender=#{Gender} where Id=#{Id}
delete from student where Id=#{Id}
