尚硅谷之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;

....

}

int,double等在Java中都用包装类,因为mysql中的所有类型都可能是NULL,而Java只有引用数据类型才有NULL值

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;

...

}