jdbc查询语句的执行

由 SELECT 语句返回的行集合包括满足该语句的 WHERE 子句所列条件的所有行。由该语句返回完整的行集合叫做结果集。
一、定义实体类封装查询结果
1、创建Department实体类

package com.xzit.pojo;

import java.util.Date;

public class Department {

	private String deptno;
	private String deptName;
	private Date createTime;
	private String descs;
	
	public Department() {}
	
	public String getDeptno() {
		return deptno;
	}
	public void setDeptno(String deptno) {
		this.deptno = deptno;
	}
	public String getDeptName() {
		return deptName;
	}
	public void setDeptName(String deptName) {
		this.deptName = deptName;
	}
	public Date getCreateTime() {
		return createTime;
	}
	public void setCreateTime(Date createTime) {
		this.createTime = createTime;
	}
	public String getDescs() {
		return descs;
	}
	public void setDescs(String descs) {
		this.descs = descs;
	}
	
}

2、创建数据库访问类DepartmentDao
 

package com.xzit.dao;

import