八,项目开发实现步骤
(六)创建数据访问接口
- DAO: Data Acess Object -数据访问对象
- 系统有四张表: 't college、't status '、‘t_student与t_user表,对这四张表的操作就在相应的数据访问接口里进行规定,有四个数据访问接口:CollegeDao’、"StatusDao 、"StudentDao与UserDao。将这些接口放到net.hw.student.dao包里。
- 在net.xiaomi.student跟包里创建子包dao
1.创建学校数据访问接口
package net.xiaomi.student.dao;
import net.xiaomi.student.bean.College;
public interface CollegeDao {
College findById(int id);
int update(College college);
}
package net.xiaomi.student.dao;
import net.xiaomi.student.bean.College;
import net.xiaomi.student.bean.Status;
public interface StatusDao {
Status findById(int id);
int updata(Status status);
}
2.创建学生数据访问接口
package net.xiaomi.student.dao;
import net.xiaomi.student.bean.Student;
import java.util.List;
import java.util.Vector;
public interface StudentDao {
int insert(Student student);
int deleteById(String id);
int deleteByClass(String clazz);
int deleteByDepartment(String department);
int update(Student student);
Student findById(String id);
List<Student> findByName(String name);
List<Student> findByClass(String clazz);
List<Student> findByDepartment(String department);
List<Student> findAll();
Vector findRowsBySex();
Vector findRowsByClass();
Vector findRowsByDepartment();
}
3.创建用户数据访问接口
package net.xiaomi.student.dao;
import net.xiaomi.student.bean.User;
import java.util.List;
public interface UserDao {
int insert(User user);
int deleteById(int id);
int update(User user);
User findById(int id);
List<User> findAll();
User longin(String username,String password);
boolean isUsernameExisted(String username);
}