尚硅谷之JDBC
第6章DAO和增删改查通用方法
DAO:Data Access Object访问数据信息的类和接口,包括了对数据的CRUD(Create、Retrival、Update、Delete),而不包含任何业务相关的信息
作用:为了实现功能的模块化,更有利于代码的维护和升级。
1、练习
1.1表和JavaBean
|
public class Department { private Integer id; private String name; private String description; .... } |
|
public class Employee { private Integer eid; private String ename; private String tel; private String gender;//mysql中用char,在Java中也要用String private Double salary; private Double commissionPct; private Date birthday;//此处用String或Date private Date hiredate; private Integer jobId; private String email; private Integer mid; private String address; private String nativePlace; private Integer did; ... } |