创建表:
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;
}
@override
public boolean equals(Object obj){
final int prime=31;
int result=1;
result=prime*result+((id==null)?0:id.hashCode());
}
@Override
public 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;
}
@Override
public 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>