要使用注解的方式可以直接在接口上使用,这样就不用xml配置文件了
@Insert
public interface StudentDao {
@Insert("insert into student values(#{id},#{name},#{email},#{age})")
public int insertStudent(Student student);
}
@Delete
public interface StudentDao {
@Delete("delete from student where id=#{id}")
public int delete(int id);
}
@Update
@Update("update student set name=#{myname} where id=#{id}")
public int update(@Param("myname")String myname, @Param("id")int id);
@Select
@Select("select * from student where id =#{studentId};")
public Student selectStudentbyid(Integer id);
@Select("select * from student")
public List<Student> selectStudents();