JDBC实现SQL的动态查询

第一步（创建一个类JdbcAdvanced）

我们先创建一个主方法main：

	public static void main(String[] args){
	
	}

第二步

然后创建一个Department类获取数据库departments的内容数据，如下：

package cm.hezy;
public class Department {

		private int departmentId;
		private String departmentName;
		private int location_id;
		public int getDepartmentId() {
			return departmentId;
		}
		public void setDepartmentId(int departmentId) {
			this.departmentId = departmentId;
		}
		public String getDepartmentName() {
			return departmentName;
		}
		public void setDepartmentName(String departmentName) {
			this.departmentName = departmentName;
		}
		public int getLocation_id() {
			return location_id;
		}
		public void setLocation_id(int location_id) {
			this.location_id = location_id;
		}
	}

第三步

创建一个查询方法

public List<Department>