public class CarDaoImpl implements CarDao{

   List<Car> car = new ArrayList<Car>();

   public static final String DATABASE_FILE = "\\program\\Eclipse\\Car\\kulso\\db\\car.db";

   public static final String DATABASE_List = "Select * From Car";

   public static final String DATABASE_ADD = "Insert Into Car (manufacture, type, year)"
   		+ "Values ( ? , ? , ?)";


   public CarDaoImpl(){
	   try {
		   Class.forName("org.sqlite.JDBC");
	   } catch (ClassNotFoundException e) {
		    System.out.println("Failed to load SQLite JDBC drv.");
		    e.printStackTrace();
		  }
   }

@Override
public boolean addCar(Car car) {
	 boolean rvsucces=false;
	 Connection conn=null;
	 PreparedStatement pst = null;

	 try{
		 conn= DriverManager.getConnection("jdbc:sqlite:"+DATABASE_FILE);
		 pst=conn.prepareStatement(DATABASE_ADD);

		 int index=1;
		 pst.setString(index++,car.getManufacture());
		 pst.setString(index++,car.getType());
		 pst.setInt(index++,car.getYear());
		 int rows=pst.executeUpdate();

		 if(rows == 1){
			 rvsucces = true;
		 }

	 } catch (SQLException e) {

		 e.printStackTrace();
	 }
	 finally {
		 try{
			 if(pst != null){
				 pst.close();
			 }
		 } catch(SQLException e){
			 e.printStackTrace();
		 }
		 try{
			 if(conn!=null){
				 conn.close();
			 }
		 }catch(SQLException e){
			 e.printStackTrace();
		 }

	 }
	return rvsucces;
}


@Override
public List<Car> getCars() {
	 Connection conn = null;
	 Statement st = null;
	 car.clear();

	 try{
	 conn = DriverManager.getConnection("jdbc:sqlite:" + DATABASE_FILE);
	 st = conn.createStatement();
	 ResultSet rs = st.executeQuery(DATABASE_List);

	while(rs.next()){
		System.out.println(rs.getInt("id"));
		System.out.println(rs.getString("manufacture"));
		System.out.println(rs.getString("type"));
		System.out.println(rs.getInt("year"));

	}


	 }catch (SQLException e) {
		e.printStackTrace();
	}

	return null;
}