src/main/java/com/hwua/erhai/dao/impl/CarDaoImpl.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.hwua.erhai.dao.impl;

import com.hwua.erhai.dao.ICarDao;
import com.hwua.erhai.entity.Car;
import com.hwua.erhai.jdbc.ConnectionFactory;
import com.hwua.erhai.jdbc.JDBCTemplate;
import com.hwua.erhai.jdbc.PreparedStatementSetter;
import com.hwua.erhai.jdbc.ResultSetHandler;
import com.hwua.erhai.service.query.QueryCondition;
import sun.reflect.generics.reflectiveObjects.NotImplementedException;

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

public class CarDaoImpl extends JDBCTemplate implements ICarDao {



    @Override
    //查询全部汽车
    public List<Car> queryAllCars() {
        final List<Car> list = new ArrayList<>();
        
        String sql = "SELECT car.id,car.car_Number, b.id, b.name, car.model,car.color, cay.id, cay.name,"
                + "car.t_comments, car.price,car.rent,car.status, car.usable "
                + "FROM t_car car, t_brand b, t_category cay "
                + "WHERE car.brand_id = b.id AND car.category_id = cay.id "
                + "ORDER BY car.id";
        query(sql, null, new ResultSetHandler() {
            @Override
            public void handleRs(ResultSet rs) throws SQLException {
                while (rs.next()) {
                    Car car = new Car(
                            rs.getLong(1),
                            rs.getString(2),
                            rs.getInt(3),
                            rs.getString(4),
                            rs.getString(5),
                            rs.getString(6),
                            rs.getInt(7),
                            rs.getString(8),
                            rs.getString(9),
                            rs.getDouble(10),
                            rs.getDouble(11),
                            rs.getInt(12),
                            rs.getInt(13));
                    list.add(car);
                }
            }
        });
        return list;
    }