自增类型ID支持

来源：互联网发布：服装淘宝店从哪里进货编辑：程序博客网时间：2024/06/01 10:06

创建表：

create table Student(    id INT NOT NULL AUTO_INCREMENT,    //id不能为空且自动增加    name varchar(50),    PRIMARY KEY(id)    );

创建实体

public class Student implements Serializable{//定义属性private Integer id;private Stirng name;//无参构造器public Student(){}public Student(String name) {    super();    this.name=name;}public Integer getId(){    return id;}public void setId(Integer id){    this.id=id;}public String getName(){    return name;}public void setName(String name){    this.name=name;}@overridepublic boolean equals(Object obj){    final int prime=31;    int result=1;    result=prime*result+((id==null)?0:id.hashCode());}@Overridepublic boolean equals(Object obj){    if(this==obj)    return true;    if(obj==null)    return false;    if(getClass()!=obj.getClass())    return false;    Student other = (Student) obj;    if(id==null){        if(other.id!=null)        return false;        }else if(!id.equals(other.id))        return false;}@Overridepublic Stirng toStirng(){    return "Student [id="+id+",name="+name+"]";}}

创建Mapper接口
public interface StudentDao{
void saveStudent(Student student);
}

创建SQL

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper PUBLIC"-//ibatis.apache.org//DTD Mapper 3.0//EN""http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd"><mapper namespace="cn.tedu.note.dao.StudentDao">    <insert id="saveStudent"        userGeneratedKeys="true"        keyProperty="id"        parameterType="cn.tedu.note.entity.Student">        insert into             Student            (name)            values                (#{name}}        </insert></mapper>

0 0