代码拉取完成,页面将自动刷新
package com.zbdx.dao.impl;
import com.zbdx.dao.ICarDao;
import com.zbdx.domain.Car;
import com.zbdx.util.DruidUtil;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import java.sql.SQLException;
import java.util.List;
/**
* TODO 用户数据访问层实现类
*
* @author shengyuee
* @version 1.0
* 2024/9/10 15:03
*/
public class CarDaoImpl implements ICarDao {
private QueryRunner qr = new QueryRunner(DruidUtil.getDataSource());
/**
* 添加用户
*
* @param car
* @return
*/
@Override
public int insert(Car car) throws SQLException {
String sql = "INSERT INTO t_car VALUES(NULL,?,?,?,?,?)";
Object[] param = {car.getCarNum(),car.getDriver(),car.getTelephone(),car.getDayincome(),car.getRemark()};
int res = qr.update(sql,param);
return res;
}
/**
* 修改用户
*
* @param car
* @return
*/
@Override
public int update(Car car) throws SQLException {
String sql = "UPDATE t_car SET carNum=?,driver=?,telephone=?,dayincome=?,remark=? WHERE carid=?";
Object[] params = {car.getCarNum(),car.getDriver(),car.getTelephone(),car.getDayincome(),car.getRemark(),car.getCarid()};
int res = qr.update(sql, params);
return res;
}
/**
* 根据ID删除用户信息
*
* @param id
* @return
*/
@Override
public int deleteById(int id) throws SQLException {
String sql = "DELETE FROM t_car WHERE carid=?";
int res = qr.update(sql, id);
return res;
}
/**
* 根据Id查询用户
*
* @param id
* @return
*/
@Override
public Car selectById(int id) throws SQLException {
String sql = "SELECT * FROM t_car WHERE carid=?";
Car car = qr.query(sql, new BeanHandler<Car>(Car.class),id);
return car;
}
/**
* 查询所有
*
* @return
*/
@Override
public List<Car> selectAll() throws SQLException {
String sql = "SELECT * FROM t_car";
// 调用QueryRunner的query方法查询
List<Car> list = qr.query(sql, new BeanListHandler<Car>(Car.class));
return list;
}
}
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。