package com.cn.car;
import com.cn.car.CarsVo;
import com.cn.jdbc.JDBC_Connection;
import java.sql.*;
public class AddCar {
public void addCar(CarsVo carsVo) {
Connection conn = null;
PreparedStatement pstm = null;
ResultSet rs = null;
try {
conn = JDBC_Connection.getConnection();
String sql =
"insert into cars(id,carnumber,cartype,color,price,rentprice,deposit,isrenting,description) values(?,?,?,?,?,?,?,?,?)";
pstm = conn.prepareStatement(sql);
pstm.setInt(1, carsVo.getId());
pstm.setString(2, carsVo.getCarnumber());
pstm.setString(3, carsVo.getCartype());
pstm.setString(4, carsVo.getColor());
pstm.setDouble(5, carsVo.getPrice());
pstm.setDouble(6, carsVo.getRentprice());
pstm.setDouble(7, carsVo.getDeposit());
pstm.setInt(8, carsVo.getIsrenting());
pstm.setString(9, carsVo.getDescription());
pstm.executeUpdate();
System.out.println("添加成功!添加的内容如下:");
System.out.println();
} catch (Exception e) {
e.printStackTrace();
} finally {
JDBC_Connection.free(rs, conn, pstm);
}
}
}
创建驱动成功!
连接数据库成功!
添加成功!添加的内容如下:连接数据库成功!
com.microsoft.sqlserver.jdbc.SQLServerException: 没有为参数号 1 设置值。
import com.cn.car.CarsVo;
import com.cn.jdbc.JDBC_Connection;
import java.sql.*;
public class AddCar {
public void addCar(CarsVo carsVo) {
Connection conn = null;
PreparedStatement pstm = null;
ResultSet rs = null;
try {
conn = JDBC_Connection.getConnection();
String sql =
"insert into cars(id,carnumber,cartype,color,price,rentprice,deposit,isrenting,description) values(?,?,?,?,?,?,?,?,?)";
pstm = conn.prepareStatement(sql);
pstm.setInt(1, carsVo.getId());
pstm.setString(2, carsVo.getCarnumber());
pstm.setString(3, carsVo.getCartype());
pstm.setString(4, carsVo.getColor());
pstm.setDouble(5, carsVo.getPrice());
pstm.setDouble(6, carsVo.getRentprice());
pstm.setDouble(7, carsVo.getDeposit());
pstm.setInt(8, carsVo.getIsrenting());
pstm.setString(9, carsVo.getDescription());
pstm.executeUpdate();
System.out.println("添加成功!添加的内容如下:");
System.out.println();
} catch (Exception e) {
e.printStackTrace();
} finally {
JDBC_Connection.free(rs, conn, pstm);
}
}
}
创建驱动成功!
连接数据库成功!
添加成功!添加的内容如下:连接数据库成功!
com.microsoft.sqlserver.jdbc.SQLServerException: 没有为参数号 1 设置值。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货