概述:例子为对教师信息进行增删改查。在举实例之前,需要再叙述一个规则,DAO--DataBase Access Object:数据库访问对象,用来对数据库中的表进行增删改查操作。使用时分为5步:(1)建表(2)建实体类(成员变量与表字段一一对应,并且符合JAVABEAN规范)(3)为每一个实体类创建接口(4)为每一个接口创建相应的实现类,在实现类中实现对表的操作(5)测试
工程内结构如图:
第一步:建表
第二步:创建实体类,成员变量与表字段一一对应
import java.io.Serializable;
public class Teacher implements Serializable {
private static final long serialVersionUID = 3453028117053184904L;
private Integer tid;
private String tname;
private Integer tage;
private Double tsalary;
public Teacher() {
super();
}
public Teacher(String tname, Integer tage, Double tsalary) {
super();
this.tname = tname;
this.tage = tage;
this.tsalary = tsalary;
}
public Teacher(Integer tid, String tname, Integer tage, Double tsalary) {
super();
this.tid = tid;
this.tname = tname;
this.tage = tage;
this.tsalary = tsalary;
}
public Integer getTid() {
return tid;
}
public void setTid(Integer tid) {
this.tid = tid;
}
public String getTname() {
return tname;
}
public void setTname(String tname) {
this.tname = tname;
}
public Integer getTage() {
return tage;
}
public void setTage(Integer tage) {
this.tage = tage;
}
public Double getTsalary() {
return tsalary;
}
public void setTsalary(Double tsalary) {
this.tsalary = tsalary;
}
@Override
public String toString() {
return "Teacher [tid=" + tid + ", tname=" + tname + ", tage=" + tage + ", tsalary=" + tsalary + "]";
}
}
第三步:为每一个实体类创建接口
import java.util.List;
import com.hyxy.teacher.entity.Teacher;
public interface ITeacherDAO {
/**
* 插入教师对象
*/
void saveTeacher(Teacher teacher);
/**
* 删除教师对象
*/
void deleteTeacher(Integer tid);
/**
* 寻找教师对象
*/
Teacher findTeacherByTid(Integer tid);
/**
* 修改教师对象
*/
void updateTeacher(Teacher teacher);
/**
* 遍历表中所有对象
*/
List<Teacher> findAllTeacher(String str);
/**
* 分页查询
*/
List<Teacher> findAllTeacherByPages(int page,int pageSize,String colume,String orderBy);
/**
* 获得总页数
*/
int getTotalPages(int pageSize);
}