JDBC简单写法

//Javabean。pojo
package com.dhcode.Bean;

import java.io.Serializable;

public class DOG implements Serializable{
	private int id;
	private String name;
	private int health;
	private int love;
	private String strain;
	
	public DOG() {
		super();
	}
	public DOG(int id,String name,int health,int love,String strain) {
		super();
		this.id = id;
		this.name = name;
		this.health = health;
		this.love = love;
		this.strain = strain;
		
	}
	public DOG(String name, int health , int love, String strain) {
		super();
		this.health = health;
		this.name = name;
		this.love = love;
		this.strain = strain;
		
	}
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public int getHealth() {
		return health;
	}
	public void setHealth(int health) {
		this.health = health;
	}
	public int getLove() {
		return love;
	}
	public void setLove(int love) {
		this.love = love;
	}
	public String getStrain() {
		return strain;
	}
	public void setStrain(String strain) {
		this.strain = strain;
	}
		
}

//声明
package com.dhcode.SM;

import java.util.List;

import com.dhcode.Bean.DOG;

public interface DogDAO {
	
		public void addDog(DOG dog);
		public int deleteDog(int id);
		public int updateDog(DOG dog);
		public List<DOG> getAllDog();
		public DOG getDogById(int id);
		public List<DOG> getDogBycondition(String name,String strain);
}

//实现impl
package com.dhcode.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util