package com.dao;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.*;

import com.form.CarForm;

import com.tools.JDBConnection;

public class CarDao {

private JDBConnection connection = null;

public CarDao() {

connection = new JDBConnection();

}

public boolean operationCar(String sql) {

return connection.executeUpdate(sql);

}

public List queryCarList(String sign) {

List list = new ArrayList();

CarForm carForm = null;

String sql=null;

if(sign==null){

sql = "select * from tb_car order by id desc";

}else{

sql = "select * from tb_car where id not in (select car_id from tb_carlog)";

}

ResultSet rs = connection.executeQuery(sql);

try {

while (rs.next()) {

carForm = new CarForm();

carForm.setId(rs.getInt(1));

carForm.setUsername(rs.getString(2));

carForm.setUser_number(rs.getString(3));

carForm.setCar_number(rs.getString(4));

carForm.setTel(rs.getInt(5));

carForm.setAddress(rs.getString(6));

carForm.setCar_road(rs.getString(7));

carForm.setCar_content(rs.getString(8));

list.add(carForm);

}

} catch (SQLException e) {

e.printStackTrace();

}

return list;

}

public CarForm queryCarForm(String id) {

CarForm carForm = null;

String sql = "select * from tb_car where id=" + id + "";

ResultSet rs = connection.executeQuery(sql);

try {

while (rs.next()) {

carForm = new CarForm();

carForm.setId(rs.getInt(1));

carForm.setUsername(rs.getString(2));

carForm.setUser_number(rs.getString(3));

carForm.setCar_number(rs.getString(4));

carForm.setTel(rs.getInt(5));

carForm.setAddress(rs.getString(6));

carForm.setCar_road(rs.getString(7));

carForm.setCar_content(rs.getString(8));

}

} catch (SQLException e) {

e.printStackTrace();

}

return carForm;

}

}